IE Warning
Your browser is out of date!

This website uses the latest web technologies so it requires an up-to-date, fast browser!
Try Firefox or Chrome!
Back to top
Twitter Logo
LinkedIn Logo Google+ Logo
Telephone: 023 9270 4041

Microsoft Excel LogoMicrosoft Excel VBA Training Course

Course Objectives

This three day course Microsoft Excel programming with VBA is for advanced Excel users who wish to increase functionality of their workbooks with VBA. Users will learn how to code with Microsoft Excel VBA beginning with the macro recorder and ending with fully functional coding examples of Excel VBA to take back to the workplace.

Course Modules

The following modules will be will be covered on the course.

  1. Macro Recorder
  2. Accessible Macros
  3. Visual Basic Editor (VBE)
  4. Variables and Constants
  5. User Defined Functions (UDFs)
  6. VBA Components
  7. Looping Data
  8. Worksheets and Workbooks
  9. Error Handling
  10. User Forms
  11. File Management
  12. Presenting Data

Target Audience

This course is intended for users with an advanced knowledge of Microsoft Excel.

Course Reviews

Brilliant course, one to one training. I have gained so much from my 3 days with Tracie at Technical IT Training. I will be back in the future.
James McTurk - Johnson Controls International