Wizard Corporate Training is part of Nexacu — Microsoft and Adobe courses run on the shared Nexacu schedule, so you get every date in every capital. See the schedule

1300 886 190
Level 3 Microsoft 1 day

Microsoft Excel Advanced Course

9:00am – 4:00pm Six capitals or live online Prerequisite: Excel Intermediate

Microsoft Excel Advanced at a glance.

Duration
1 day, 9:00am – 4:00pm
Price
$415 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 Intermediate
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.

  • VLOOKUP and XLOOKUP, and when each one breaks
  • Nested logic without losing track of the brackets
  • Named ranges and data validation
  • Auditing a workbook somebody else built

Course overview.

Lookups, nested logic, named ranges, data validation, and auditing a workbook you did not build.

The 1 day works through 8 modules and 52 individual topics, from Structured references to Summary and integration. 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.

  • 8 modules
  • 52 topics
  • 1 day in the room
  • 1Structured references6 topics
    • Cell-based references compared with table-based
    • The table elements
    • Referencing a row
    • Referencing a range
    • Referencing table totals
    • The union operator (,)
  • 2Named ranges11 topics
    • Creating a named range
    • Naming a range from the Name Box
    • Naming ranges with Create from Selection
    • Giving tables names
    • Ranges built for data validation
    • Editing named ranges – single cell
    • Editing named ranges – a range of cells
    • Tracking down where a name is used
    • Deleting a named range
    • Putting names into a formula
    • Listing all the range names
  • 3Dynamic array functions5 topics
    • The Function Arguments dialogue box
    • The UNIQUE function
    • Sorting with SORT
    • The FILTER function
    • Picking columns with CHOOSECOLS
  • 4Lookups with INDEX and MATCH6 topics
    • The INDEX function
    • Putting XMATCH to work
    • The search mode argument
    • The MATCH function [LEGACY FUNCTION]
    • Pairing MATCH with INDEX [LEGACY FUNCTION]
    • Nesting MATCH within INDEX
  • 5Lookups with CHOOSE, SWITCH and XLOOKUP2 topics
    • CHOOSE compared with SWITCH
    • Looking up values with XLOOKUP
  • 6PivotTables and PivotCharts14 topics
    • Building a PivotTable
    • Pulling data out of a PivotTable
    • Applying filters to a PivotTable
    • Switching the calculation used
    • Building PivotCharts
    • Adding slicers
    • The Timeline filter
    • The Show Values As options
    • Grouping the data
    • Report layout in a PivotTable
    • Controlling totals in a PivotTable
    • Adding calculations to a PivotTable
    • Splitting out Report Filter Pages
    • Refreshing the PivotTable
  • 7Advanced functions4 topics
    • Functions for dates
    • The information functions
    • Maths and statistics functions
    • Functions for text (OPTIONAL)
  • 8Summary and integration4 topics
    • Putting lookup functions to work on real tasks
    • Pairing array formulas with named ranges
    • Feeding structured data into PivotTables
    • Good habits for advanced Excel work

Who it is for.

Confident users who now maintain something other people depend on — and want to stop it breaking.

How it runs.

One day, roughly 9am to 4pm, 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 Advanced dates, soonest first. If none of these work, tell us the city and we will let you know when the next block is released.

LevelDateLocationDeliveryPrice
Excel AdvancedThu 27 Aug 26BrisbaneIn person$415Book
Excel AdvancedThu 27 Aug 26Remote EastOnline$415Book
Excel AdvancedThu 27 Aug 26MelbourneIn person$415Book
Excel AdvancedThu 3 Sep 26Remote WestOnline$415Book
Excel AdvancedThu 3 Sep 26PerthIn person$415Book
Excel AdvancedFri 4 Sep 26SydneyIn person$415Book
Excel AdvancedFri 4 Sep 26AdelaideIn person$415Book
Excel AdvancedFri 4 Sep 26CanberraIn person$415Book
Excel AdvancedFri 4 Sep 26BrisbaneIn person$415Book
Excel AdvancedFri 4 Sep 26MelbourneIn person$415Book
Excel AdvancedFri 4 Sep 26Remote EastOnline$415Book
Excel AdvancedWed 9 Sep 26Remote EastOnline$415Book
Excel AdvancedWed 9 Sep 26SydneyIn person$415Book
Excel AdvancedThu 10 Sep 26Remote EastOnline$415Book
Excel AdvancedThu 10 Sep 26CanberraIn person$415Book
Excel AdvancedWed 16 Sep 26PerthIn person$415Book
Excel AdvancedWed 16 Sep 26Remote WestOnline$415Book
Excel AdvancedFri 18 Sep 26Remote EastOnline$415Book
Excel AdvancedFri 18 Sep 26CanberraIn person$415Book
Excel AdvancedFri 18 Sep 26SydneyIn person$415Book
Excel AdvancedFri 18 Sep 26AdelaideIn person$415Book
Excel AdvancedFri 18 Sep 26BrisbaneIn person$415Book
Excel AdvancedFri 18 Sep 26MelbourneIn person$415Book
Excel AdvancedWed 23 Sep 26Remote EastOnline$415Book
Excel AdvancedWed 23 Sep 26BrisbaneIn person$415Book
Excel AdvancedFri 25 Sep 26MelbourneIn person$415Book
Excel AdvancedFri 25 Sep 26Remote EastOnline$415Book
Excel AdvancedWed 7 Oct 26Remote EastOnline$415Book
Excel AdvancedWed 7 Oct 26SydneyIn person$415Book
Excel AdvancedWed 7 Oct 26BrisbaneIn person$415Book
Excel AdvancedTue 13 Oct 26AdelaideIn person$415Book
Excel AdvancedTue 13 Oct 26MelbourneIn person$415Book
Excel AdvancedTue 13 Oct 26Remote EastOnline$415Book
Excel AdvancedWed 14 Oct 26Remote EastOnline$415Book
Excel AdvancedWed 14 Oct 26BrisbaneIn person$415Book
Excel AdvancedTue 20 Oct 26MelbourneIn person$415Book
Excel AdvancedWed 21 Oct 26SydneyIn person$415Book
Excel AdvancedWed 21 Oct 26CanberraIn person$415Book
Excel AdvancedWed 21 Oct 26BrisbaneIn person$415Book
Excel AdvancedMon 26 Oct 26SydneyIn person$415Book
Excel AdvancedTue 27 Oct 26MelbourneIn person$415Book
Excel AdvancedFri 30 Oct 26BrisbaneIn person$415Book
Excel AdvancedFri 30 Oct 26SydneyIn person$415Book
Excel AdvancedThu 5 Nov 26BrisbaneIn person$415Book
Excel AdvancedThu 5 Nov 26SydneyIn person$415Book
Excel AdvancedTue 10 Nov 26SydneyIn person$415Book
Excel AdvancedTue 10 Nov 26BrisbaneIn person$415Book
Excel AdvancedFri 13 Nov 26SydneyIn person$415Book
Excel AdvancedWed 18 Nov 26MelbourneIn person$415Book
Excel AdvancedWed 25 Nov 26MelbourneIn person$415Book
Excel AdvancedWed 25 Nov 26AdelaideIn person$415Book
Excel AdvancedWed 16 Dec 26MelbourneIn person$415Book
Excel AdvancedWed 16 Dec 26AdelaideIn person$415Sold out
Excel AdvancedFri 18 Dec 26CanberraIn person$415Book

By city

Microsoft Excel Advanced in your city

Venue, transport and the dates running there.

Sydney training Melbourne training Brisbane training Perth training Adelaide training Canberra training Live online
The rest of the category

Other Microsoft Excel Levels

All Microsoft Excel levels
Microsoft Excel Beginner training in progress
Level 1

Excel Beginner

Building a spreadsheet that does not fall over: cell references, basic formulas, formatting and printing something readable.

$385ex GSTLearn more
Microsoft Excel Intermediate training in progress
Level 2

Excel Intermediate

Functions worth knowing, sorting and filtering properly, tables, and charts that say something.

$410ex GSTLearn more
Microsoft Excel Expert training in progress
Level 4

Excel Expert

Power Query and Power Pivot inside Excel — clean the data once, refresh it forever, and model it properly.

$475ex GSTLearn more
Reviews

What people said about Microsoft Excel Advanced

4.73
from 5046 reviews collected by Nexacu

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.

Love all the shortcuts and ability to ask questions outside the planned syllabus.

Kristy
14 August 2026

Pivot Tables was interesting but need to practice more to fully understand.

Rose
14 August 2026

All the information provided in the training is valuable. Especially for some who is new to excel on how to deal with large data.

Jennifer
14 August 2026

Pivot tables, Different types of Lookups & when to use them, Formulars and Calculate fields

Jennifer
14 August 2026

I learnt how to use the Dynamic Array Functions: Use # to use for a dynamic result. I also find it interesting to do Filter based on state, with and, Filter with or. Look up Match and Choose and Switch is very helpful indeed as I will use it in my day-to-day work.

Angelyn
14 August 2026

pivot tables and sumifs and count ifs

Ari
21 August 2026

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.

Ask a question
How long is the Microsoft Excel Advanced course?
It runs for 1 day, 9:00am – 4:00pm, 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 Advanced cost?
$415 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 Intermediate, 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 Advanced 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 Advanced 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.

How in-house works Call 1300 886 190