Microsoft Visual Basics for Applications (VBA) Excel

PET002098

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.


Next steps


Course dates and fees
Start date Location Duration Member
+VAT
Non-member
+VAT
Availability  
1 October 2019 Portsmouth 2 days £663.00 £780.00 Spaces Book
1 October 2019
  • Location: Portsmouth
  • Duration: 2 days
  • Member +VAT: £663.00
  • Non-member +VAT: £780.00
  • Availability: Spaces
Book

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