Microsoft Excel VBA (2007, 2010 or 2013)

Who should attend?

This course is suitable for anyone who has attended the advanced Excel course or has a very good knowledge of Excel functions. If you’re new to Excel, this is not the course to start with.

Course Aims & Objectives

The purpose of this course is to give delegates the confidence in using the essential features of Visual Basic for Applications in Excel.

By the end of this course delegates will be able to:

  • Gain the skills needed to speed up repetitive tasks
  • Write VBA code to handle complex procedures
  • Check VBA code for errors

Course Outline

  • What is a Macro?
  • The Visual Basic Editor Window
  • Understanding Code
  • Working with Variables
  • Interacting with the User
  • Loops and Conditional Constructs
  • Checking for Errors
  • Working with Files and Folders
  • Working with Userforms
  • Triggering Macros with Events
  • Custom Functions

Certification

Certificates of attendance will be awarded to delegates upon completion of the course.

Duration

2 days

Location

We can offer courses on company premises for a maximum of 8 delegates or upcoming open courses in your local area.

View as PDF

Share this Course