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 2
Microsoft
1 day
Microsoft Excel Intermediate Course
Microsoft Excel Intermediate at a glance.
- Duration
- 1 day, 9:00am – 4:00pm
- Price
- $410 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 Beginner
- 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.
- Functions worth knowing: IF, COUNTIF, SUMIF and TEXT
- Sorting and filtering properly, including on tables
- Excel Tables, and why they beat a plain range
- Charts that answer a question rather than decorate
Course overview.
Functions worth knowing, sorting and filtering properly, tables, and charts that say something.
The 1 day works through 12 modules and 73 individual topics, from Cell references and names to Custom number formats. 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.
-
1Cell references and names8 topics
- How relative references behave
- What absolute references do
- Building mixed references
- Putting references to work in formulas
- What a named range gives you
- Creating and maintaining named ranges
- Using names to keep formulas clear and quick
- Referring to other worksheets and workbooks
-
2Logic in formulas5 topics
- Setting conditions with IF
- Flipping a test with NOT
- Applying XOR logic
- Writing formulas that make decisions
- Returning different results by criteria
-
3VLOOKUP5 topics
- How a lookup works
- Writing a VLOOKUP formula
- Exact match or approximate match
- Fixing common VLOOKUP errors
- Making lookups reliable with absolute references
-
4Data validation6 topics
- What data validation controls
- Limiting entries by data type
- Building drop down lists
- Writing your own validation rules
- Adding input messages and error alerts
- Keeping data clean as it is entered
-
5Workbook and sheet protection6 topics
- How workbook and sheet protection works
- Setting which cells stay locked
- Turning on worksheet protection
- Locking the workbook structure
- Adding a password
- Managing permissions and blocking unauthorised changes
-
6Dates and times in formulas6 topics
- How Excel stores dates and times
- Switching between date and time formats
- Working out durations
- Putting TODAY and NOW to use
- Adding timestamps
- Automating analysis that depends on dates
-
7Nested functions6 topics
- What nesting means
- Sketching out a nested function
- Putting one IF inside another
- Mixing logical and lookup functions
- Building longer formulas one step at a time
- Checking and fixing nested functions
-
8Conditional formatting and number formats6 topics
- What conditional formatting does
- Highlighting values with rules
- Showing trends with data bars and colour scales
- Reading data at a glance with icon sets
- Choosing number formats that read well
- Formats for dates, currency, percentages and decimals
-
9Charts6 topics
- Picking a chart type that suits the data
- Building a chart from your data
- Adjusting chart elements
- Adding titles, labels and legends
- Formatting the axes and series
- Tidying a chart up for presentation
-
10Excel tables6 topics
- What an Excel table gives you
- Turning a range into a table
- Applying a table style
- Sorting and filtering inside a table
- Using table features to analyse data
- Table formulas and structured references
-
11Building PivotTables7 topics
- What a PivotTable does
- Building a PivotTable from source data
- Placing fields in rows, columns, values and filters
- Sorting and filtering the results
- Formatting a PivotTable so it reads clearly
- Refreshing a PivotTable when the data changes
- Spotting trends and patterns with PivotTables
-
12Custom number formats6 topics
- How custom number formats are built
- Writing your own number formats
- Handling currency, percentages and large values
- Custom formats for dates and times
- Showing text alongside numbers
- Making financial and operational reports easier to read
Who it is for.
People who are comfortable with the basics and have hit the ceiling of what they worked out for themselves.
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 Intermediate 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 Intermediate | Thu 27 Aug 26 | Remote East | Online | $410 | Book |
| Excel Intermediate | Thu 27 Aug 26 | Remote East | Online | $410 | Book |
| Excel Intermediate | Thu 27 Aug 26 | Adelaide | In person | $410 | Book |
| Excel Intermediate | Thu 27 Aug 26 | Canberra | In person | $410 | Book |
| Excel Intermediate | Tue 1 Sep 26 | Remote West | Online | $410 | Book |
| Excel Intermediate | Tue 1 Sep 26 | Perth | In person | $410 | Book |
| Excel Intermediate | Tue 1 Sep 26 | Brisbane | In person | $410 | Book |
| Excel Intermediate | Tue 1 Sep 26 | Remote East | Online | $410 | Book |
| Excel Intermediate | Wed 2 Sep 26 | Adelaide | In person | $410 | Book |
| Excel Intermediate | Wed 2 Sep 26 | Remote East | Online | $410 | Book |
| Excel Intermediate | Mon 7 Sep 26 | Remote East | Online | $410 | Book |
| Excel Intermediate | Mon 7 Sep 26 | Melbourne | In person | $410 | Book |
| Excel Intermediate | Tue 8 Sep 26 | Sydney | In person | $410 | Book |
| Excel Intermediate | Tue 8 Sep 26 | Remote West | Online | $410 | Book |
| Excel Intermediate | Tue 8 Sep 26 | Perth | In person | $410 | Book |
| Excel Intermediate | Tue 8 Sep 26 | Brisbane | In person | $410 | Book |
| Excel Intermediate | Tue 8 Sep 26 | Adelaide | In person | $410 | Book |
| Excel Intermediate | Tue 8 Sep 26 | Remote East | Online | $410 | Book |
| Excel Intermediate | Wed 9 Sep 26 | Canberra | In person | $410 | Book |
| Excel Intermediate | Mon 14 Sep 26 | Melbourne | In person | $410 | Book |
| Excel Intermediate | Mon 14 Sep 26 | Canberra | In person | $410 | Book |
| Excel Intermediate | Mon 14 Sep 26 | Remote East | Online | $410 | Book |
| Excel Intermediate | Tue 15 Sep 26 | Sydney | In person | $410 | Book |
| Excel Intermediate | Tue 15 Sep 26 | Perth | In person | $410 | Book |
| Excel Intermediate | Tue 15 Sep 26 | Brisbane | In person | $410 | Book |
| Excel Intermediate | Tue 15 Sep 26 | Adelaide | In person | $410 | Book |
| Excel Intermediate | Tue 15 Sep 26 | Remote West | Online | $410 | Book |
| Excel Intermediate | Tue 15 Sep 26 | Remote East | Online | $410 | Book |
| Excel Intermediate | Wed 16 Sep 26 | Melbourne | In person | $410 | Book |
| Excel Intermediate | Wed 16 Sep 26 | Remote East | Online | $410 | Book |
| Excel Intermediate | Thu 17 Sep 26 | Adelaide | In person | $410 | Book |
| Excel Intermediate | Thu 17 Sep 26 | Remote East | Online | $410 | Book |
| Excel Intermediate | Mon 21 Sep 26 | Canberra | In person | $410 | Book |
| Excel Intermediate | Tue 22 Sep 26 | Perth | In person | $410 | Book |
| Excel Intermediate | Tue 22 Sep 26 | Remote West | Online | $410 | Book |
| Excel Intermediate | Tue 22 Sep 26 | Brisbane | In person | $410 | Book |
| Excel Intermediate | Tue 22 Sep 26 | Sydney | In person | $410 | Book |
| Excel Intermediate | Mon 28 Sep 26 | Melbourne | In person | $410 | Book |
| Excel Intermediate | Mon 28 Sep 26 | Adelaide | In person | $410 | Book |
| Excel Intermediate | Mon 28 Sep 26 | Canberra | In person | $410 | Book |
| Excel Intermediate | Tue 29 Sep 26 | Perth | In person | $410 | Book |
| Excel Intermediate | Tue 29 Sep 26 | Remote West | Online | $410 | Book |
| Excel Intermediate | Tue 29 Sep 26 | Brisbane | In person | $410 | Book |
| Excel Intermediate | Tue 29 Sep 26 | Sydney | In person | $410 | Book |
| Excel Intermediate | Tue 6 Oct 26 | Perth | In person | $410 | Book |
| Excel Intermediate | Tue 6 Oct 26 | Remote West | Online | $410 | Book |
| Excel Intermediate | Wed 7 Oct 26 | Melbourne | In person | $410 | Book |
| Excel Intermediate | Wed 7 Oct 26 | Adelaide | In person | $410 | Book |
| Excel Intermediate | Fri 9 Oct 26 | Sydney | In person | $410 | Book |
| Excel Intermediate | Fri 9 Oct 26 | Brisbane | In person | $410 | Book |
| Excel Intermediate | Fri 9 Oct 26 | Canberra | In person | $410 | Book |
| Excel Intermediate | Mon 12 Oct 26 | Canberra | In person | $410 | Book |
| Excel Intermediate | Tue 13 Oct 26 | Sydney | In person | $410 | Book |
| Excel Intermediate | Tue 13 Oct 26 | Brisbane | In person | $410 | Book |
| Excel Intermediate | Wed 14 Oct 26 | Remote West | Online | $410 | Book |
| Excel Intermediate | Wed 14 Oct 26 | Perth | In person | $410 | Book |
| Excel Intermediate | Wed 14 Oct 26 | Melbourne | In person | $410 | Book |
| Excel Intermediate | Wed 14 Oct 26 | Adelaide | In person | $410 | Book |
| Excel Intermediate | Fri 16 Oct 26 | Brisbane | In person | $410 | Book |
| Excel Intermediate | Fri 16 Oct 26 | Canberra | In person | $410 | Book |
By city
Microsoft Excel Intermediate in your city
Venue, transport and the dates running there.
The rest of the category
All Microsoft Excel levels Other Microsoft Excel Levels
Level 3
Excel Advanced
Lookups, nested logic, named ranges, data validation, and auditing a workbook you did not build.
$415ex GSTLearn more
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 Intermediate
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 session with Ben
Andrew
26 August 2026
Helped with formulas
Modesty
26 August 2026
Learnt so many new shortcuts and an easier way to complete my work.
Isabelle
26 August 2026
Practical examples, worked through slowly and thoroughly, in a forum where we felt welcome to ask questions
Patricia
26 August 2026
The checking in to make sure everyone was on the same page
Liz
27 August 2026
All of it
Shelley
27 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 Intermediate 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 Intermediate cost?
$410 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 Beginner, 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 Intermediate 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 Intermediate 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.