Microsoft Visual Basics for Applications (VBA) Excel


Greater output through automation in Excel

Who is it for?

Intermediate to Advanced users of Excel who need to create automated intelligent interfaces with interactive features, to manage and present information

Business benefits
  • Increase productivity through streamlined internal procedures
  • Consistent quality of executed tasks
  • Efficient analysis of large datasets
Course overview
  • Programming basics, structures and statements
  • The naming and types of variables
  • Using parameters with lifetimes and scope
  • Recording VBA and using macros
  • Basic form design, form handling and events
  • Error handling, trapping errors and debugging techniques
  • Development of modular code and test plans

Sponsored option

This course is available as a company sponsored event, delivered at a location, date and time which is mutually agreed. The fees for this event vary depending on the location, number attending and the level of training required and the degree of customisation. Please contact us to discuss your requirements.

On demand course available

This course is available on demand and dates are available on application, please contact us to discuss your requirements.

Next steps

Group discounts are available for this course

Take advantage of these discounts when booking this course;

  • 5% off for 2-3 people
  • 8% off for 4-5 people
  • 12% off for 6 or more people
« All Corporate Courses courses

Our Courses and Services