VBA Training Courses

VBA Training Courses

VBA is a very powerful programming language, however the majority of Microsoft Excel users do not even know of its existence.

By equipping your staff with the necessary knowledge and resources, they will be able to compile their own VBA macros within the organisation increasing productivity daily and driving profits.

We can cater for small to large groups and can deliver courses within your organisation. See below on the different training courses we have on offer.

We have more courses in the pipeline which will focus on topics such as Report Generation, Graphing and Emailing using VBA Macros.

Contact us today to find out more information.

Responsive image
VBA Fundamentals

Course Duration: (1 day)

Course Description: This course covers basic concepts in VBA and also contains interactive and practical examples. It is intended for users who have none or little experience in VBA. Participants are given a VBA assignment at the end to consolidate all learning.

Course Agenda:

  • What are Macros?
  • Recording a Macro
  • Macro Efficiency
  • Comments
  • Creating a Run Macro Button
  • Declaring & Initialising Variables
  • Message Boxes
  • Cells Statement
  • If-Then-Else Statement
  • Counters
  • Strings
  • Boolean Logic
  • Loops
  • VBA Assignment