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 5 Microsoft 1 day

Microsoft Excel Tables and Pivot Tables Course

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

Microsoft Excel Tables and Pivot Tables at a glance.

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

  • Building a PivotTable from a clean source table
  • Grouping, sorting and calculated fields
  • Slicers and timelines for a dashboard people can drive
  • Refreshing rather than rebuilding

Course overview.

Turning a long table into an answer — pivots, slicers, grouping and a dashboard that refreshes.

The 1 day works through 6 modules and 22 individual topics, from Getting started with PivotTables to Validating data entry. 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.

  • 6 modules
  • 22 topics
  • 1 day in the room
  • 1Getting started with PivotTables7 topics
    • Building PivotTable reports and changing them
    • Analysing figures with a PivotTable
    • Grouping field items to organise the data
    • Basing a PivotTable on an Excel Table
    • Seeing where PivotTable source data comes from
    • Sorting and filtering labels and values
    • Filtering further with Slicers and Timelines
  • 2Sorting and filtering table data3 topics
    • Sorting with AutoFilter buttons or the Sort dialog box
    • Setting up Custom filters for a specific view of the data
    • Adding subtotals to a filtered list
  • 3Excel Tables3 topics
    • How formatting and management work in an Excel Table
    • Filtering a table quickly with Slicers
    • Finding and removing duplicates with Conditional Formatting
  • 4Charting techniques2 topics
    • Building PivotCharts and adjusting them
    • Adding a secondary axis and trendlines
  • 5Outlining a worksheet2 topics
    • Summarising a large worksheet with the Outline feature
    • Showing only the totals you need
  • 6Validating data entry5 topics
    • Restricting what can be typed using Data Validation rules
    • Choosing validation settings that keep entries consistent
    • Writing input and error messages that guide users
    • Circling invalid entries and clearing the marks
    • Locking validated cells so the data stays intact

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 Tables and Pivot Tables 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 Tables and Pivot TablesThu 27 Aug 26Remote WestOnline$490Book
Excel Tables and Pivot TablesThu 27 Aug 26PerthIn person$490Book
Excel Tables and Pivot TablesWed 7 Oct 26BrisbaneIn person$490Book
Excel Tables and Pivot TablesWed 7 Oct 26Remote EastOnline$490Book
Excel Tables and Pivot TablesWed 7 Oct 26MelbourneIn person$490Sold out
Excel Tables and Pivot TablesTue 20 Oct 26Remote EastOnline$490Book
Excel Tables and Pivot TablesTue 20 Oct 26MelbourneIn person$490Book
Excel Tables and Pivot TablesFri 23 Oct 26Remote EastOnline$490Book
Excel Tables and Pivot TablesFri 23 Oct 26AdelaideIn person$490Book
Excel Tables and Pivot TablesWed 11 Nov 26MelbourneIn person$490Sold out
Excel Tables and Pivot TablesWed 11 Nov 26Remote EastOnline$490Book
Excel Tables and Pivot TablesFri 20 Nov 26AdelaideIn person$490Sold out
Excel Tables and Pivot TablesFri 20 Nov 26Remote EastOnline$490Book
Excel Tables and Pivot TablesWed 2 Dec 26Remote EastOnline$490Book
Excel Tables and Pivot TablesWed 2 Dec 26MelbourneIn person$490Sold out
Excel Tables and Pivot TablesWed 9 Dec 26MelbourneIn person$490Book
Excel Tables and Pivot TablesWed 9 Dec 26Remote EastOnline$490Book
Excel Tables and Pivot TablesThu 17 Dec 26Remote EastOnline$490Book
Excel Tables and Pivot TablesThu 17 Dec 26AdelaideIn person$490Sold out
Excel Tables and Pivot TablesFri 18 Dec 26Remote EastOnline$490Book
Excel Tables and Pivot TablesFri 18 Dec 26MelbourneIn person$490Book

By city

Microsoft Excel Tables and Pivot Tables 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 Advanced training in progress
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 Tables and Pivot Tables

4.76
from 34 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.

Andrew was a fantastic and engaging instructor. Delivered meaningful content and was adaptive when asked questions and troubleshooting for us. Learnt a lot and has definitely made me want to come back for further training

Andrea
2 December 2025

Andrew was great, very knowledgeable.

Tegan
2 December 2025

Andrew was a great trainer. All the information was fantastic, made sense, great pace and good amount of breaks so didn't get brain overload. I will be recommending this course to other colleagues.

India M.
2 December 2025

Streamline current workflow

Yuki
30 January 2026

Reinforcement of already existing knowledge

Natalie
30 January 2026

the worksheets already set up meant we can just go and do the actual work , saves valuable time. Also having access to the worksheet instructions and the file completed will help the self-learning we we go through the exercises in our own time

Danielle
13 May 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 Tables and Pivot Tables 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 Tables and Pivot Tables cost?
$490 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 Tables and Pivot Tables 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 Tables and Pivot Tables 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