Level 1
Excel Beginner
Building a spreadsheet that does not fall over: cell references, basic formulas, formatting and printing something readable.
$385ex GSTLearn more
Level 6
Microsoft
3 hours
Microsoft Excel Macro Mastery Course
Microsoft Excel Macro Mastery at a glance.
- Duration
- 3 hours, 9:00am – 12:30pm
- Price
- $352 per person, ex GST — purchase orders welcome
- Delivery
- In person, or live online with a facilitator
- Where
- Adelaide, Brisbane, Canberra, Melbourne, Perth and Sydney — or online
- Prerequisite
- Excel Advanced
- Class size
- Small — everyone practises out loud more than once
- You take away
- A printed workbook, exercise files, and your own notes
- In-house
- Available for teams of four or more, at your office or ours
What you'll learn.
- Recording a macro, and reading what it wrote
- The Visual Basic editor without fear
- Variables, loops and conditions
- Buttons, error handling and sharing macros safely
Course overview.
Recording, editing and writing enough VBA to automate the parts of the job nobody should be doing by hand.
The 3 hours works through 6 modules and 17 individual topics, from Getting set up for macros to Consolidating data with a macro. Each module is taught then practised — you do the thing rather than watch it done — on our exercise files, and on your own where you are able to bring them.
Groups are kept small enough that everyone gets hands on the keyboard, and the facilitator is in the room the whole time rather than dropping in. You leave with the workbook, the exercise files and notes in your own words.
Full course outline.
Every module we cover, and the topics inside each one. This is the same outline as the downloadable PDF — expand a module to see what sits under it.
-
1Getting set up for macros2 topics
- Macro security and switching on the Developer tab
- Setting macro options in Trust Center Settings
-
2Recording, saving and running a macro3 topics
- Automating a task with the macro recorder
- Saving a workbook in a macro-enabled format
- Running a recorded macro in Excel
-
3Editing a macro4 topics
- Opening the Module Sheet and reading the VBA
- Tweaking a macro's code for simple changes
- Giving a macro a keyboard shortcut
- Basic edits to longer macros
-
4Attaching macros to objects3 topics
- Putting macro buttons on the Ribbon
- Linking macros to form controls and worksheet shapes
- Attaching a macro at workbook level
-
5Consolidation reports2 topics
- Consolidating by position with SUM, AVERAGE and other functions
- How macros can automate data consolidation
-
6Consolidating data with a macro3 topics
- Recording a consolidation macro and editing it
- Building SUM and AVERAGE consolidations with your own changes
- Running a macro from a shape
Who it is for.
Confident users who now maintain something other people depend on — and want to stop it breaking.
How it runs.
A half day, roughly 9am to 12:30pm, with a facilitator in the room the whole time. You get a workstation each with the software installed, in a CBD training room in any of the six capitals, or live online on your own computer.
Dates
Upcoming Dates
The next scheduled Microsoft Excel Macro Mastery dates, soonest first. If none of these work, tell us the city and we will let you know when the next block is released.
By city
Microsoft Excel Macro Mastery in your city
Venue, transport and the dates running there.
The rest of the category
All Microsoft Excel levels Other Microsoft Excel Levels
Level 2
Excel Intermediate
Functions worth knowing, sorting and filtering properly, tables, and charts that say something.
$410ex GSTLearn more
Level 3
Excel Advanced
Lookups, nested logic, named ranges, data validation, and auditing a workbook you did not build.
$415ex GSTLearn more
Reviews
What people said about Microsoft Excel Macro Mastery
Wizard courses run on the shared Nexacu schedule, so these are reviews of this course from people who sat it. Collected by Nexacu after the course and published as written.
Great presenter. Clear explanations with lots of little tricks and tips added in
Meredith
30 April 2025
Thanks Greg, that was a great course. It was at a good pace which made it nice and easy to follow along. Thanks for all the tips and tricks. Looking forward to creating macros with a little more understanding of them!
Francesca
30 April 2025
He is really helpful. He taught me lots of technics for Macros and Excel that will help me out in my future career. It was really a good session for a beginner.
Rafat
22 August 2025
Clear explanations of Macro including how to create, modify and utilise it. Really good training session to join and will start to use macro in my workplace.
Max
29 September 2025
very clear and provided good explanation
Will
3 December 2025
the trainer was very informative and I took a lot out of the session
Quinn
3 December 2025
Source: nexacu.com.au, read 27 August 2026. How feedback is collected.
Questions
Questions People Ask About This Course
Anything not answered here, call 1300 886 190 and ask a person.
How long is the Microsoft Excel Macro Mastery course?
It runs for 3 hours, 9:00am – 12:30pm, with a facilitator in the room the whole time. Nothing is pre-recorded and there is no platform to log into afterwards.
How much does Microsoft Excel Macro Mastery cost?
$352 per person, excluding GST. That covers the course, the workbook and exercise files and the room. If four or more people from one organisation need it, an in-house day usually works out cheaper — tell us the numbers and we will price both.
Do I need any experience before this course?
Yes — this level assumes Excel Advanced, or equivalent experience picked up on the job. If you are not sure, tell us what you already do and we will place you honestly, including telling you to book the level below.
Can I do Microsoft Excel Macro Mastery online instead of in a classroom?
Yes. Every date marked “Live online” runs over video with the same facilitator and the same practice, in breakout groups rather than a room. You use the software on your own machine, so you leave with it set up the way you actually work.
Which cities do you run Microsoft Excel Macro Mastery in?
Adelaide, Brisbane, Canberra, Melbourne, Perth and Sydney, plus live online. Every venue is a CBD training room with a workstation for each person. If your city and date are not paired on the schedule above, ask — dates are released in blocks.
Which Excel level should I book?
Work from what people already do rather than how long they have used it. The full course outline above shows exactly what this course covers, and the Microsoft Excel page lists every level in order. Still unsure? Call 1300 886 190 and describe a normal Tuesday.
Whole team on the same level? Run it in-house.
Your files, your templates, your workflow — the same course, taught against your own material.