merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

Programming Microsoft Excel with VBA

Vantage Training Limited
Course summary
1 day
165 GBP excl. VAT
English
Open / Scheduled
Next available date: Enquire for more information - Nottingham
Course Dates
Altrincham
Enquire for more information  (English)
165 GBP
Nottingham
Enquire for more information  (English)
165 GBP

Course description

Programming Microsoft Excel with VBA

This course will enable you to use Excel Visual Basic for Applications (VBA) to automate and customise spreadsheets. Were appropriate your own work requirements may be used as course examples.

Suitability - Who should attend?

It is assumed that you will be familiar with a wide range of Excel features, in addition to being a competent Microsoft Windows user.

Outcome / Qualification etc.

At the end of this course you will be able to:

  • Appreciate the benefits of using Visual Basic (VBA) macros.
  • Record, run and edit basic Excel macros.
  • Interpret and edit VBA code.
  • Apply programming techniques such as conditional branching and loops to your macros.
  • Acquisit user data and display messages.
  • Create User Forms to manage complex user input.

Training Course Content

  • Introducing Macros
  • VBA (Macro) Basics
  • Cell Referencing
  • Editing VBA Program Code
  • Extending Control
  • User Forms
  • Troubleshooting Problems

About provider

Vantage Training Limited

Nationwide Software Training

Vantage Training formed as a limited company back in 1995, although the two directors, Gill Lewis and Brian Roberts, had been working together for some years at this point. By the time vtl was formed, long term contracts had been...


Read more and show all courses with this provider

Contact info

Vantage Training Limited

The Wharf, Trent Lane, East Bridgford
NG13 8PF Nottingham

 Show phone number
www.facebook.com


Reviews

There are no reviews available yet.

U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Similar Courses