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 4
Microsoft
1 day
Microsoft Excel Expert Course
Microsoft Excel Expert at a glance.
- Duration
- 1 day, 9:00am – 4:00pm
- Price
- $475 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.
- Loading data into Power Query from Excel
- Cleaning and reshaping columns
- Managing and refreshing queries
- Building a data model with Power Pivot
Course overview.
Power Query and Power Pivot inside Excel — clean the data once, refresh it forever, and model it properly.
The 1 day works through 8 modules and 64 individual topics, from Course introduction to Data types in Excel. 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.
-
1Course introduction1 topic
- What the day covers
-
2Setting up Power Query4 topics
- Opening Power Query
- Configuring Power Query
- Turning on Power Pivot
- Adjusting the Quick Access Toolbar
-
3Getting data in7 topics
- Sources you can import from
- A CSV file
- Excel table, list or pivoted data
- A folder of files
- A PDF file
- Data typed in by hand
- Loading the data into Excel
-
4Transforming data12 topics
- The Applied Steps list
- Removing an applied step
- Inserting an applied step
- Ways to edit data
- Fill Down
- Trim
- Replace Values
- Applying filters
- Editing a filter by hand
- Format
- Clearing errors
- Reshaping data with Unpivot
-
5Columns6 topics
- Removing columns
- Giving columns new names
- Creating extra columns
- Standard and custom date columns
- Renaming an applied step
- Building a conditional column
-
6Managing queries10 topics
- Grouping queries into query groups
- Combining queries by appending
- The Append Queries command
- Seeing which queries have loaded
- Renaming a query
- Refreshing the queries
- Checking the reloaded queries
- Stopping one data load
- Stopping several data loads at once
- Extended exercise – macro
-
7Power Pivot13 topics
- The Data Model
- Adding tables to a Data Model
- Laying out the Data Model
- Relating tables with Create
- Relating tables with Manage
- Relating tables by click and drag
- The Pivot Table
- A Pivot Table built in Excel
- A Pivot Table built from Power Pivot
- Creating a measure in Power Pivot
- Using Sum in DAX
- A Pivot Table for measures
- A measure with a filter
-
8Data types in Excel11 topics
- The standard data types
- The Stock data type
- Loading the Stock data type
- Showing extra data fields
- Custom data type – get the data
- Custom data type – transform department data custom
- Data type – transform countries data
- Custom data type – merge the data
- Creating the custom data type
- Building a custom report
- Extending the custom report
Who it is for.
Advanced Excel users who rebuild the same report by hand every month.
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 Expert dates, soonest first. If none of these work, tell us the city and we will let you know when the next block is released.
| Level | Date | Location | Delivery | Price | |
|---|---|---|---|---|---|
| Excel Expert | Fri 28 Aug 26 | Remote East | Online | $475 | Book |
| Excel Expert | Fri 28 Aug 26 | Brisbane | In person | $475 | Book |
| Excel Expert | Fri 28 Aug 26 | Melbourne | In person | $475 | Book |
| Excel Expert | Mon 31 Aug 26 | Remote East | Online | $475 | Book |
| Excel Expert | Mon 31 Aug 26 | Adelaide | In person | $475 | Book |
| Excel Expert | Mon 7 Sep 26 | Canberra | In person | $475 | Book |
| Excel Expert | Mon 7 Sep 26 | Remote East | Online | $475 | Book |
| Excel Expert | Thu 10 Sep 26 | Remote West | Online | $475 | Book |
| Excel Expert | Thu 10 Sep 26 | Perth | In person | $475 | Book |
| Excel Expert | Fri 11 Sep 26 | Remote East | Online | $475 | Book |
| Excel Expert | Fri 11 Sep 26 | Brisbane | In person | $475 | Book |
| Excel Expert | Fri 11 Sep 26 | Melbourne | In person | $475 | Book |
| Excel Expert | Fri 25 Sep 26 | Brisbane | In person | $475 | Book |
| Excel Expert | Fri 25 Sep 26 | Remote East | Online | $475 | Book |
| Excel Expert | Fri 25 Sep 26 | Melbourne | In person | $475 | Book |
| Excel Expert | Tue 20 Oct 26 | Adelaide | In person | $475 | Book |
| Excel Expert | Tue 20 Oct 26 | Remote East | Online | $475 | Book |
| Excel Expert | Tue 27 Oct 26 | Melbourne | In person | $475 | Sold out |
| Excel Expert | Tue 27 Oct 26 | Remote East | Online | $475 | Book |
| Excel Expert | Fri 27 Nov 26 | Melbourne | In person | $475 | Book |
| Excel Expert | Fri 27 Nov 26 | Remote East | Online | $475 | Book |
| Excel Expert | Fri 27 Nov 26 | Adelaide | In person | $475 | Book |
By city
Microsoft Excel Expert 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 Expert
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.
Lots of varied and helpful tips
Amy
31 July 2026
Magda takes her time to explain all aspects of the steps and why we are doing what we are doing. Very well presented.
Lauren
7 August 2026
Learned alot but need to practice to master what we learn today. The Power Pivot is great and I need to practice to master this.
Rose
13 August 2026
The content of the course is very helpful.
Jennifer
13 August 2026
Being aware that data can be pulled together from various sources and presented according to organisational and personal needs.
Jennifer
13 August 2026
The fact that I can be able to use Power Pivot for excel and to move all the boxes so all different relations and links are connected.
Angelyn
13 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.
How long is the Microsoft Excel Expert 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 Expert cost?
$475 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 Expert 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 Expert 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.