-
- Setting Macro Security Levels
Recording A Simple Macro Running A Recorded Macro Relative Cell References Running A Macro With Relative Cell References Viewing A Macro Module Modifying A Recorded Macro
Overview
Unlock the full programming potential of Excel with our VBA for Excel training course! This course is designed to empower you with the ability to automate tasks, create custom functions, and enhance Excel’s functionality using Visual Basic for Applications (VBA).
Whether you want to streamline repetitive processes, build dynamic tools, or integrate Excel with other applications, this course provides the knowledge and skills to harness VBA effectively. Perfect for professionals seeking to optimize their workflows or elevate their Excel expertise, this training will transform the way you work with data and productivity tools.
Microsoft Excel VBA training course in Melbourne and across Australia. We can come to you for Face-to-face Excel training or you can join us online for Live online Excel training courses.
Detailed Course Outline
- Preparing Data For An Application
- Recording A Summation Macro
- Recording Consolidations
- Recording Divisional Macros
- Testing Macros
- Creating Objects To Run Macros
- Assigning A Macro To An Object
- Opening And Closing The Editor
- Working With The Project Explorer
- Working With The Properties Window
- Working With The Work Area
- Working With A Code Module
- Running Procedures From The Editor
- Setting Breakpoints In The Editor
- Stepping Through A Procedure
- VBA Terminology
- Accessing The Excel Object Model
- Using The Immediate Window
- Working With Object Collections
- Setting Property Values
- Working With Worksheets
- Using The Object Browser
- Programming With The Object Browser
- Creating A Command Procedure
- Making Sense Of IntelliSense
- Using The Edit Toolbar
- Commenting Statements
- Indenting Code
- Bookmarking In Procedures
- Creating And Using Variables
- Implicit & Explicit Declarations
- The Scope Of Variables
- Procedure Level Scoping
- Module Level Scoping
- Passing Variables By Reference
- Passing Variables By Value
- Data Types
- Declaring Data Types
- Using Arrays
- Application Methods And Properties
- Workbook Methods And Properties
- Viewing Excel And The Editor Together
- Using Workbook Objects
- Worksheet Methods And Properties
- Using Worksheet Objects
- Range Methods And Properties
- Using Range Objects
- Project – Using Objects In Procedures
- The MsgBox Function
- Sending Messages To The User
- InputBox Techniques
- Using The InputBox Function
- Using The InputBox Method
- The IF Statement
- Using IF For Single Conditions
- Using IF For Multiple Conditions
- The FOR NEXT Statement
- Looping With Known Or Specified Iterations
- The DO LOOP Statement
- Looping With Unknown Iterations
- Programming Techniques Quick Reference
- Creating A Custom Form
- Adding Text Boxes To A Form
- Changing Text Box Control Properties
- Adding Label Controls To A Form
- Adding A Combo Box Control
- Adding Option Buttons
- Adding Command Buttons
- Running A Custom Form
- Initialising A Form Closing A Form
- Project – Transferring Data From A Form
- Running Form Procedures
- Running A Form From A Procedure
- Debug Errors
- Error Traps
- Dealing with Errors
- Prevent Errors
- Programming Automatic Procedures
- Running Automatic Procedures
- Automatically Starting A Workbook
Course prerequisites
Previous experience using Microsoft Excel at an Advanced level is an essential prerequisite for this course.
Inclusions
Instructor - led Training
Menual & Files
Unlimited Free Support
Many professionals spend hours manually updating spreadsheets. That eats into productivity and often leads to errors. It’s frustrating and unnecessary when you can automate key tasks instead.
At Blank Page (Aust) Pty Ltd, we offer a practical, hands-on Microsoft Excel VBA training course that helps professionals simplify their workflows and work smarter. This Microsoft Excel VBA programming course is built on our over 30 years of experience training thousands across Australia.
From finance analysts to admin teams, anyone who touches Excel can benefit from learning how to automate, customise, and speed up their spreadsheets without being a programmer.
The Microsoft Excel VBA course we provide is not a generic tutorial or a pre-recorded video. It is structured with real working professionals in mind, packed with useful examples, clear walkthroughs, and helpful resources.
Here’s what you’ll get:
- A structured course covering VBA for Microsoft Excel training from the ground up, including working with variables, loops, logical functions, event triggers, and automation tools used in real-world Excel applications.
- Downloadable practice files matched to course modules are designed to reinforce key techniques and help learners implement them in their day-to-day Excel tasks without overthinking it.
- A manual with all examples, instructions, and notes used during training, great for in-session learning and handy when you need to refresh something down the track.
- Access to our unlimited helpdesk support, giving you continued support as you start using your new Excel VBA programming skills on the job.
You’ll finish the course with hands-on confidence in how to write and apply macros, automate reporting, and make your Excel sheets work harder, all using VBA.
We don’t believe in throwing theory at people. Our training is designed to help real professionals get real work done and we do that by making it as accessible, useful, and practical as possible.
Here’s why thousands across Australia train with us:
-
Flexible Learning Options
Attend online or face-to-face, whatever suits your location, team size, or workday. We deliver the same quality course in both formats without compromise on detail or experience.
-
Over 30 Years of Training Expertise
Our company came into existence in 2008, but we’ve delivered Excel and VBA training to government, business, and individual clients for a long time. We know how to make technical skills feel practical and not overwhelming.
-
Courses Built Around Practical Goals
Each VBA for Excel training course is designed to meet actual training outcomes. Whether it’s speeding up reporting, cleaning up raw data, or automating manual entry, we help you solve your own Excel headaches.
-
Trainers Who Know the Job
Our facilitators understand how Excel is used in real workplaces. They don’t just teach VBA, they explain it in plain English, help troubleshoot live examples, and make the logic behind it easier to follow.
If you’re ready to stop wasting hours on manual tasks and start automating your Excel work, our VBA for Microsoft Excel training course is the right step.
You don’t need to be a coder. You just need the right guidance, and that’s exactly what we provide.
Join Blank Page (Aust) Pty Ltd for smart, structured, and effective Microsoft Excel VBA training that actually makes a difference in how you work.
Book your course today!
What does the Excel VBA training course teach?
The course teaches how to use VBA and macros to automate repetitive tasks in Excel, from recording and editing macros, to writing and debugging VBA code, to creating user-forms, custom functions, and automating workflows across multiple workbooks and sheets. It covers the Excel object model, variables, control structures, error handling, and how to build interactive tools inside Excel.
Microsoft Excel VBA Training Courses
Who should attend the Excel VBA course?
This training is ideal for intermediate to advanced Excel users, such as data analysts, financial officers, administrators, or power-users, who want to streamline data processing, reduce manual work, and build custom Excel solutions. No prior programming experience is required, though familiarity with basic Excel functions, formulas, and worksheets is recommended.
Microsoft Excel VBA Training Courses
What kinds of tasks can I automate using skills learned in the course?
With VBA, you can automate formatting, data entry, reporting, data consolidation across multiple sheets or workbooks, generating and emailing reports, creating user-driven forms for easier data input, and even connecting Excel to external data sources, saving considerable time and reducing manual errors.
Microsoft Excel VBA Training Courses
Do I need special software or version of Excel for the course?
Yes, you’ll need a desktop version of Excel (for example Excel 2016, 2019, 2021, or Excel 365) because the VBA editor and macro tools are only available in the desktop apps (not in web-based Excel).
Microsoft Excel VBA Training Courses
How long is a typical Excel VBA course and what level does it start at?
Many VBA training courses run over approximately 2 days (or equivalent in hours) for beginners to reach competency. They usually start at a fundamental level, explaining how to record and run macros, then advance to writing and editing code, working with multiple sheets, custom functions, user forms, and basic automation workflows.
Microsoft Excel VBA Training Courses
What are the main benefits of completing the Excel VBA course?
- Time savings & efficiency: VBA can dramatically reduce repetitive work, transforming manual multi-step tasks into click-of-a-button automation.
- Improved accuracy & consistency: Automated scripts perform tasks the same way every time, reducing errors from manual data entry or repetitive work.
- Custom Excel tools & workflows: You can build tailored tools inside Excel to match business needs, for example, custom data entry forms, specialized reports, complex calculations, and repeatable data-processing pipelines not possible with standard Excel functions.
Microsoft Excel VBA Training Courses
Microsoft Excel VBA Training Courses
Related Courses
-
Intermediate$375 - Advanced Level 2$395
- Fundamentals$375
- Advanced$395
Course Details
Duration 2 days
Level Advanced
Private Sessions
Book a private session for 1 to 12 of your employees. Courses can be customised to suit your learning needs.
Public Sessions
Join a public course session conducted LIVE ONLINE via Microsoft Teams.
Detailed Course Outline
-
- Setting Macro Security Levels
Recording A Simple Macro Running A Recorded Macro Relative Cell References Running A Macro With Relative Cell References Viewing A Macro Module Modifying A Recorded Macro
- Preparing Data For An Application
- Recording A Summation Macro
- Recording Consolidations
- Recording Divisional Macros
- Testing Macros
- Creating Objects To Run Macros
- Assigning A Macro To An Object
- Opening And Closing The Editor
- Working With The Project Explorer
- Working With The Properties Window
- Working With The Work Area
- Working With A Code Module
- Running Procedures From The Editor
- Setting Breakpoints In The Editor
- Stepping Through A Procedure
- VBA Terminology
- Accessing The Excel Object Model
- Using The Immediate Window
- Working With Object Collections
- Setting Property Values
- Working With Worksheets
- Using The Object Browser
- Programming With The Object Browser
- Creating A Command Procedure
- Making Sense Of IntelliSense
- Using The Edit Toolbar
- Commenting Statements
- Indenting Code
- Bookmarking In Procedures
- Creating And Using Variables
- Implicit & Explicit Declarations
- The Scope Of Variables
- Procedure Level Scoping
- Module Level Scoping
- Passing Variables By Reference
- Passing Variables By Value
- Data Types
- Declaring Data Types
- Using Arrays
- Application Methods And Properties
- Workbook Methods And Properties
- Viewing Excel And The Editor Together
- Using Workbook Objects
- Worksheet Methods And Properties
- Using Worksheet Objects
- Range Methods And Properties
- Using Range Objects
- Project – Using Objects In Procedures
- The MsgBox Function
- Sending Messages To The User
- InputBox Techniques
- Using The InputBox Function
- Using The InputBox Method
- The IF Statement
- Using IF For Single Conditions
- Using IF For Multiple Conditions
- The FOR NEXT Statement
- Looping With Known Or Specified Iterations
- The DO LOOP Statement
- Looping With Unknown Iterations
- Programming Techniques Quick Reference
- Creating A Custom Form
- Adding Text Boxes To A Form
- Changing Text Box Control Properties
- Adding Label Controls To A Form
- Adding A Combo Box Control
- Adding Option Buttons
- Adding Command Buttons
- Running A Custom Form
- Initialising A Form Closing A Form
- Project – Transferring Data From A Form
- Running Form Procedures
- Running A Form From A Procedure
- Debug Errors
- Error Traps
- Dealing with Errors
- Prevent Errors
- Programming Automatic Procedures
- Running Automatic Procedures
- Automatically Starting A Workbook
Course prerequisites
Previous experience using Microsoft Excel at an Advanced level is an essential prerequisite for this course.
Inclusions
Instructor - led Training
Menual & Files
Unlimited Free Support
Many professionals spend hours manually updating spreadsheets. That eats into productivity and often leads to errors. It’s frustrating and unnecessary when you can automate key tasks instead.
At Blank Page (Aust) Pty Ltd, we offer a practical, hands-on Microsoft Excel VBA training course that helps professionals simplify their workflows and work smarter. This Microsoft Excel VBA programming course is built on our over 30 years of experience training thousands across Australia.
From finance analysts to admin teams, anyone who touches Excel can benefit from learning how to automate, customise, and speed up their spreadsheets without being a programmer.
The Microsoft Excel VBA course we provide is not a generic tutorial or a pre-recorded video. It is structured with real working professionals in mind, packed with useful examples, clear walkthroughs, and helpful resources.
Here’s what you’ll get:
- A structured course covering VBA for Microsoft Excel training from the ground up, including working with variables, loops, logical functions, event triggers, and automation tools used in real-world Excel applications.
- Downloadable practice files matched to course modules are designed to reinforce key techniques and help learners implement them in their day-to-day Excel tasks without overthinking it.
- A manual with all examples, instructions, and notes used during training, great for in-session learning and handy when you need to refresh something down the track.
- Access to our unlimited helpdesk support, giving you continued support as you start using your new Excel VBA programming skills on the job.
You’ll finish the course with hands-on confidence in how to write and apply macros, automate reporting, and make your Excel sheets work harder, all using VBA.
We don’t believe in throwing theory at people. Our training is designed to help real professionals get real work done and we do that by making it as accessible, useful, and practical as possible.
Here’s why thousands across Australia train with us:
-
Flexible Learning Options
Attend online or face-to-face, whatever suits your location, team size, or workday. We deliver the same quality course in both formats without compromise on detail or experience.
-
Over 30 Years of Training Expertise
Our company came into existence in 2008, but we’ve delivered Excel and VBA training to government, business, and individual clients for a long time. We know how to make technical skills feel practical and not overwhelming.
-
Courses Built Around Practical Goals
Each VBA for Excel training course is designed to meet actual training outcomes. Whether it’s speeding up reporting, cleaning up raw data, or automating manual entry, we help you solve your own Excel headaches.
-
Trainers Who Know the Job
Our facilitators understand how Excel is used in real workplaces. They don’t just teach VBA, they explain it in plain English, help troubleshoot live examples, and make the logic behind it easier to follow.
If you’re ready to stop wasting hours on manual tasks and start automating your Excel work, our VBA for Microsoft Excel training course is the right step.
You don’t need to be a coder. You just need the right guidance, and that’s exactly what we provide.
Join Blank Page (Aust) Pty Ltd for smart, structured, and effective Microsoft Excel VBA training that actually makes a difference in how you work.
Book your course today!
What does the Excel VBA training course teach?
The course teaches how to use VBA and macros to automate repetitive tasks in Excel, from recording and editing macros, to writing and debugging VBA code, to creating user-forms, custom functions, and automating workflows across multiple workbooks and sheets. It covers the Excel object model, variables, control structures, error handling, and how to build interactive tools inside Excel.
Microsoft Excel VBA Training Courses
Who should attend the Excel VBA course?
This training is ideal for intermediate to advanced Excel users, such as data analysts, financial officers, administrators, or power-users, who want to streamline data processing, reduce manual work, and build custom Excel solutions. No prior programming experience is required, though familiarity with basic Excel functions, formulas, and worksheets is recommended.
Microsoft Excel VBA Training Courses
What kinds of tasks can I automate using skills learned in the course?
With VBA, you can automate formatting, data entry, reporting, data consolidation across multiple sheets or workbooks, generating and emailing reports, creating user-driven forms for easier data input, and even connecting Excel to external data sources, saving considerable time and reducing manual errors.
Microsoft Excel VBA Training Courses
Do I need special software or version of Excel for the course?
Yes, you’ll need a desktop version of Excel (for example Excel 2016, 2019, 2021, or Excel 365) because the VBA editor and macro tools are only available in the desktop apps (not in web-based Excel).
Microsoft Excel VBA Training Courses
How long is a typical Excel VBA course and what level does it start at?
Many VBA training courses run over approximately 2 days (or equivalent in hours) for beginners to reach competency. They usually start at a fundamental level, explaining how to record and run macros, then advance to writing and editing code, working with multiple sheets, custom functions, user forms, and basic automation workflows.
Microsoft Excel VBA Training Courses
What are the main benefits of completing the Excel VBA course?
- Time savings & efficiency: VBA can dramatically reduce repetitive work, transforming manual multi-step tasks into click-of-a-button automation.
- Improved accuracy & consistency: Automated scripts perform tasks the same way every time, reducing errors from manual data entry or repetitive work.
- Custom Excel tools & workflows: You can build tailored tools inside Excel to match business needs, for example, custom data entry forms, specialized reports, complex calculations, and repeatable data-processing pipelines not possible with standard Excel functions.
Microsoft Excel VBA Training Courses
Microsoft Excel VBA Training Courses
Related Courses
- Advanced$395
- Advanced Level 2$395
- Intermediate$375
- Fundamentals$375