Microsoft Visual Basics for Applications (VBA) Excel

PET002098

Greater output through automation in Excel using VBA

Who is it for?

Intermediate to advanced users of Excel who are looking to build automated intelligent interfaces with interactive features to manage and present information.

Business benefits
  • Increased 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