book a course

Our Training

Build the confidence and skills you need to succeed with our practical professional development and IT courses, led by expert trainers with ongoing support.
See all courses

Explore our courses

IT & Digital Skills

Professional Development

PD Training

Build confidence, leadership, and workplace skills with our practical professional development courses. Delivered in Perth or live online, with expert trainers and ongoing support included.

read more

Explore our programs

Communication

Leadership

Project Management

Qualifications

Advance your career with nationally recognised qualifications and practical training. Delivered in Perth or live online, with expert trainers and ongoing support.
Learn More

Explore our Qualificationss

Microsoft Excel VBA

Microsoft Excel new logo with Microsoft Partner written on it.
Free Post-course Support
100% Quality
Guarantee
Interactive
Learning
eCertificate of Attendance

Microsoft Excel VBA

In Person

This course is available as a private group session or 1-on-1 training only. Enquire today to learn more!

Location: Training can be delivered at our Perth CBD training centre, at your site or virtually for added convenience
Duration: Two consecutive days

Our Perth CBD venue is easy to access by public transport.

Course Overview

Course Overview

Develop the skills to automate processes and build advanced Excel skills with our Microsoft Excel VBA Course. This practical course teaches you how to use Visual Basic for Applications (VBA) to create, edit, and manage macros, streamline repetitive tasks, and design efficient, customised spreadsheets for real-world business use. With practical exercises and real-world examples, you’ll gain the confidence to automate workflows, improve productivity, and create scalable Excel tools that deliver immediate value in the workplace.

 

Dates

No upcoming dates available.

Book a course

This course is available as a private group session or 1-on-1 training only. Enquire today to learn more!

Course Information

Course Content

Introduction To Macros

  • What is a Macro
  • Recording a Macro
  • Running a recorded Macro
  • Attach Macro to Toolbar, menu or spreadsheet object
  • Edit a Macro

Functions

  • Use VBA to write User defined Functions
  • Test User Defined Functions
  • Access User Defined Functions

Visual Basic Concepts

  • Working with Objects, Properties and Methods
  • Defining variables, constants and data types

VBA Language Structure

  • IF…Then….Else
  • Do….Loop, For…..Next
  • Using built-in functions
  • Defining Sub Procedures
  • Working with arrays

VBA Testing

  • Debugging Visual Basic Code
  • Using the step tool
  • Adding watches to variables
  • Handling errors and error values

Create Dialog Boxes

  • Dialog Box design tools
  • Dialog Box objects
  • Using Dialog controls

Advanced VBA Tools

  • Accessing and communicating with other applications
  • Create automatic procedures
  • Add-in Applications

On completion of this course, participants will be able to use the Visual Basic programming language to develop high-level macros.

Completion (or equivalent knowledge) of the Excel Advanced course is required.  Exposure to computer programming is desirable.

“Fantastic course that was understandable and catered to our skill level” – Leon from Rio Tinto

“I thoroughly enjoyed this two-day course. I would recommend it to others who want to learn VBA as it was plentiful with information. The quality of the facilities and staff organisation was also excellent” – Jesse from Rio Tinto

“Closely working with the instructor made it much easier to comprehend the more difficult areas” – Johno from Dept. of Education

“The best feature of this course was the in-depth explanation. I would highly recommend ATI-Mirage” – Ellen from Rio Tinto

“The course was well illustrated and its terminologies well explained. Overall, an excellent experience” – Ling Ing from Horizon Power

“An excellent well-paced course. The best feature was the hands-on learning and use of examples” – Marek from Rio Tinto

“Practical examples and useful exercises that included things we would be likely to use at work” – Gary from FMG

“The best feature of this course was the ability of the computers to write code so we could practise the skills we learnt” – Kevin from Synergy

FAQs

No FAQs found.