All courses are available in-class or remotely. 
To attend remotely, select "Remote Online" as your location on book now.


In this Excel training, participants will explore advanced data management and analysis techniques. The course covers structured references, focusing on cell-based versus table-based references and table elements. Attendees will learn to create and manage named ranges for more dynamic spreadsheets. The session also includes dynamic array functions like UNIQUE, SORT, and XLOOKUP. PivotTables will be emphasized, with guidance on creating, customizing, and extracting insights from data sets. Finally, the training introduces advanced functions, including Date, Information, Math, Statistical, and Text functions, to handle various data analysis tasks proficiently.

This course introduces functions that require an Microsoft Office 365 version of excel. These tools have no equivalent in prior Excel Versions.

By the end of this course, participants will be able to:

  • Work confidently with structured references, tables, and named ranges
  • Apply dynamic array functions like FILTER, SORT, INDEX, and XLOOKUP
  • Create and customise PivotTables and PivotCharts with slicers and filters
  • Use a range of advanced functions for dates, text, statistics, and calculations

Prerequisite:

You should be confident with Excel basics and have completed the Beginner and Intermediate courses or have similar experience.

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Upcoming Courses

Remote East

Brisbane

Sydney

Melbourne

Canberra

Adelaide

Perth

Remote West

Remote East
Date
Course
City
Status
Mon 1 Sep 25
Mon
1
Sep
Excel Advanced
Remote East
Status: Scheduled
Scheduled
Thu 18 Sep 25
Thu
18
Sep
Excel Advanced
Remote East
Status: Scheduled
Scheduled
Tue 23 Sep 25
Tue
23
Sep
Excel Advanced
Remote East
Status: Confirmed
Confirmed
Wed 8 Oct 25
Wed
8
Oct
Excel Advanced
Remote East
Status: Confirmed
Confirmed
Thu 16 Oct 25
Thu
16
Oct
Excel Advanced
Remote East
Status: Scheduled
Scheduled
Fri 24 Oct 25
Fri
24
Oct
Excel Advanced
Remote East
Status: Confirmed
Confirmed
Thu 6 Nov 25
Thu
6
Nov
Excel Advanced
Remote East
Status: Scheduled
Scheduled
Mon 17 Nov 25
Mon
17
Nov
Excel Advanced
Remote East
Status: Scheduled
Scheduled
Thu 20 Nov 25
Thu
20
Nov
Excel Advanced
Remote East
Status: Scheduled
Scheduled
Fri 5 Dec 25
Fri
5
Dec
Excel Advanced
Remote East
Status: Scheduled
Scheduled
Brisbane
Date
Course
City
Status
Thu 18 Sep 25
Thu
18
Sep
Excel Advanced
Brisbane
Status: Scheduled
Scheduled
Tue 23 Sep 25
Tue
23
Sep
Excel Advanced
Brisbane
Status: Scheduled
Scheduled
Wed 8 Oct 25
Wed
8
Oct
Excel Advanced
Brisbane
Status: Scheduled
Scheduled
Thu 16 Oct 25
Thu
16
Oct
Excel Advanced
Brisbane
Status: Scheduled
Scheduled
Fri 24 Oct 25
Fri
24
Oct
Excel Advanced
Brisbane
Status: Scheduled
Scheduled
Thu 6 Nov 25
Thu
6
Nov
Excel Advanced
Brisbane
Status: Scheduled
Scheduled
Mon 17 Nov 25
Mon
17
Nov
Excel Advanced
Brisbane
Status: Scheduled
Scheduled
Fri 5 Dec 25
Fri
5
Dec
Excel Advanced
Brisbane
Status: Scheduled
Scheduled
Mon 15 Dec 25
Mon
15
Dec
Excel Advanced
Brisbane
Status: Scheduled
Scheduled
Sydney
Date
Course
City
Status
Mon 1 Sep 25
Mon
1
Sep
Excel Advanced
Sydney
Status: Scheduled
Scheduled
Thu 18 Sep 25
Thu
18
Sep
Excel Advanced
Sydney
Status: Scheduled
Scheduled
Tue 23 Sep 25
Tue
23
Sep
Excel Advanced
Sydney
Status: Scheduled
Scheduled
Wed 8 Oct 25
Wed
8
Oct
Excel Advanced
Sydney
Status: Confirmed
Confirmed
Thu 16 Oct 25
Thu
16
Oct
Excel Advanced
Sydney
Status: Scheduled
Scheduled
Fri 24 Oct 25
Fri
24
Oct
Excel Advanced
Sydney
Status: Scheduled
Scheduled
Thu 6 Nov 25
Thu
6
Nov
Excel Advanced
Sydney
Status: Scheduled
Scheduled
Mon 17 Nov 25
Mon
17
Nov
Excel Advanced
Sydney
Status: Scheduled
Scheduled
Fri 5 Dec 25
Fri
5
Dec
Excel Advanced
Sydney
Status: Scheduled
Scheduled
Mon 15 Dec 25
Mon
15
Dec
Excel Advanced
Sydney
Status: Scheduled
Scheduled
Melbourne
Date
Course
City
Status
Thu 18 Sep 25
Thu
18
Sep
Excel Advanced
Melbourne
Status: Scheduled
Scheduled
Tue 23 Sep 25
Tue
23
Sep
Excel Advanced
Melbourne
Status: Confirmed
Confirmed
Wed 8 Oct 25
Wed
8
Oct
Excel Advanced
Melbourne
Status: Scheduled
Scheduled
Thu 16 Oct 25
Thu
16
Oct
Excel Advanced
Melbourne
Status: Scheduled
Scheduled
Fri 24 Oct 25
Fri
24
Oct
Excel Advanced
Melbourne
Status: Scheduled
Scheduled
Thu 6 Nov 25
Thu
6
Nov
Excel Advanced
Melbourne
Status: Scheduled
Scheduled
Mon 17 Nov 25
Mon
17
Nov
Excel Advanced
Melbourne
Status: Scheduled
Scheduled
Fri 5 Dec 25
Fri
5
Dec
Excel Advanced
Melbourne
Status: Scheduled
Scheduled
Mon 15 Dec 25
Mon
15
Dec
Excel Advanced
Melbourne
Status: Scheduled
Scheduled
Canberra
Date
Course
City
Status
Thu 18 Sep 25
Thu
18
Sep
Excel Advanced
Canberra
Status: Scheduled
Scheduled
Tue 23 Sep 25
Tue
23
Sep
Excel Advanced
Canberra
Status: Scheduled
Scheduled
Wed 8 Oct 25
Wed
8
Oct
Excel Advanced
Canberra
Status: Scheduled
Scheduled
Fri 24 Oct 25
Fri
24
Oct
Excel Advanced
Canberra
Status: Scheduled
Scheduled
Thu 6 Nov 25
Thu
6
Nov
Excel Advanced
Canberra
Status: Scheduled
Scheduled
Thu 20 Nov 25
Thu
20
Nov
Excel Advanced
Canberra
Status: Scheduled
Scheduled
Fri 5 Dec 25
Fri
5
Dec
Excel Advanced
Canberra
Status: Scheduled
Scheduled
Mon 15 Dec 25
Mon
15
Dec
Excel Advanced
Canberra
Status: Scheduled
Scheduled
Adelaide
Date
Course
City
Status
Thu 18 Sep 25
Thu
18
Sep
Excel Advanced
Adelaide
Status: Scheduled
Scheduled
Tue 23 Sep 25
Tue
23
Sep
Excel Advanced
Adelaide
Status: Scheduled
Scheduled
Wed 8 Oct 25
Wed
8
Oct
Excel Advanced
Adelaide
Status: Scheduled
Scheduled
Thu 16 Oct 25
Thu
16
Oct
Excel Advanced
Adelaide
Status: Scheduled
Scheduled
Fri 24 Oct 25
Fri
24
Oct
Excel Advanced
Adelaide
Status: Scheduled
Scheduled
Mon 17 Nov 25
Mon
17
Nov
Excel Advanced
Adelaide
Status: Scheduled
Scheduled
Fri 5 Dec 25
Fri
5
Dec
Excel Advanced
Adelaide
Status: Scheduled
Scheduled
Mon 15 Dec 25
Mon
15
Dec
Excel Advanced
Adelaide
Status: Scheduled
Scheduled
Perth
Date
Course
City
Status
Wed 27 Aug 25
Wed
27
Aug
Excel Advanced
Perth
Status: Confirmed
Confirmed
Fri 12 Sep 25
Fri
12
Sep
Excel Advanced
Perth
Status: Scheduled
Scheduled
Mon 6 Oct 25
Mon
6
Oct
Excel Advanced
Perth
Status: Scheduled
Scheduled
Fri 17 Oct 25
Fri
17
Oct
Excel Advanced
Perth
Status: Scheduled
Scheduled
Thu 6 Nov 25
Thu
6
Nov
Excel Advanced
Perth
Status: Scheduled
Scheduled
Mon 17 Nov 25
Mon
17
Nov
Excel Advanced
Perth
Status: Scheduled
Scheduled
Fri 5 Dec 25
Fri
5
Dec
Excel Advanced
Perth
Status: Scheduled
Scheduled
Mon 15 Dec 25
Mon
15
Dec
Excel Advanced
Perth
Status: Scheduled
Scheduled
Remote West
Date
Course
City
Status
Wed 27 Aug 25
Wed
27
Aug
Excel Advanced
Remote West
Status: Confirmed
Confirmed
Fri 12 Sep 25
Fri
12
Sep
Excel Advanced
Remote West
Status: Scheduled
Scheduled
Mon 6 Oct 25
Mon
6
Oct
Excel Advanced
Remote West
Status: Scheduled
Scheduled
Fri 17 Oct 25
Fri
17
Oct
Excel Advanced
Remote West
Status: Scheduled
Scheduled
Thu 6 Nov 25
Thu
6
Nov
Excel Advanced
Remote West
Status: Scheduled
Scheduled
Mon 17 Nov 25
Mon
17
Nov
Excel Advanced
Remote West
Status: Scheduled
Scheduled
Fri 5 Dec 25
Fri
5
Dec
Excel Advanced
Remote West
Status: Scheduled
Scheduled
Mon 15 Dec 25
Mon
15
Dec
Excel Advanced
Remote West
Status: Scheduled
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Excel Training Courses

Course Icon Excel Beginner

Learn how to manage, analyse and share everyday data using Excel spreadsheets. Perfect for new users or those looking to build a solid foundation.

download course pdf
Price: $385 $430
Course Icon Excel Intermediate

Take your Excel skills to the next level with complex formulas, conditional formatting, PivotTables, data validation and more.

download course pdf
Price: $410 $460
Course Icon Excel Expert

Become a power user with advanced data wrangling, automation and integration using Excel and the Power Platform.

download course pdf
Price: $475 $530
Course Icon Excel Tables and Pivot Tables

Learn to build powerful reports with PivotTables, data consolidation and visualisation techniques in just one day.

download course pdf
Price: $490 $540
Course Icon Excel Macro Mastery

Automate your workflow with Excel macros. Learn to record, edit and run simple macros to boost efficiency and save time.

download course pdf
Price: $352 $390
MO-201 Excel Certification

Prepare for the MO-201 Microsoft Excel Certification. Showcase your skills, gain confidence and boost your career with globally recognised credentials.

Price: 

$1,430
inc GST

Advanced Excel Course Content

Expand All | Collapse All

Structured References

Cell-based vs table-based references

Table elements

Structured reference for a row

Structured reference for a Range

Structured reference for Table Totals

Union operator (,)

Named Ranges

Creating Named ranges

Creating Named ranges using the Name Box

Creating Named ranges using the Create from Selection

Applying names to Tables

Creating Ranges for Data Validation

Editing named ranges – Single Cell

Editing named ranges - Range

Finding where named ranges are used

Deleting named ranges

Using names in a formula

Display a list of range names

Dynamic Array Functions

Function Arguments Dialogue Box

UNIQUE Function

SORT

FILTER Function

CHOOSECOLS

LOOKUP: INDEX MATCH

INDEX Function

Using XMATCH

SEARCH Mode

MATCH Function [LEGACY FUNCTION]

Using MATCH and INDEX together [LEGACY FUNCTION]

Nesting the MATCH and INDEX Functions

LOOKUP: CHOOSE SWITCH XLOOKUP

CHOOSE vs SWITCH

XLOOKUP

PivotTables

Creating Pivot Tables

Extracting data from the PivotTable

Filtering the PivotTable

Changing the calculation in the PivotTable

Creating PivotCharts

Adding Slicers

The Timeline Filter

Show Values As

Grouping Data

Report Layout in Pivot Tables

Totals in a Pivot Table

Calculations in a PivotTable

Report Filter Pages

Refresh the PivotTable

Advanced Functions

Date Functions

Information Functions

Maths and Statistical Functions

TEXT Functions (OPTIONAL)

Summary & Integration

Applying lookup functions in real-world scenarios

Combining array formulas with named ranges

Integrating PivotTables with structured data

Best practices for advanced Excel use

Frequently Asked Questions

Will the Excel course content be relevant for the workplace?

Absolutely! Our expertise lies in delivering hands-on training exercises that are applicable to all kinds of workplaces. We cover essential elements in our basic Excel course online such as formula introduction, pivot tables, charting, and more. Moreover, we are happy to discuss advanced online Excel courses and incorporate specific examples tailored to your workplace tasks, ensuring that you receive relevant and practical training. Everyone excels with the right skillset brought to the workplace. Reach out to us to learn more about our training programs.

Which courses are available if I am working from home?

Currently, all of our Public Courses are available to be delivered remotely. Book any course as normal and you will receive login details and instructions the evening before your course. Our Microsoft Excel courses are taught in such a way that attending remotely or in person will leave you with the skills and knowledge to drive efficiency gains.

What is remote Training?

Remote training at Nexacu means our team of experienced trainers will deliver your training virtually. Students can access our usual classroom training courses via video conferencing, ask questions, participate in discussions, and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions. Our Excel courses are all offered remotely. 

How many students are typically in a Nexacu Excel Training Course?

While this varies from session to session, we typically have 5-8 students in an Excel course. We cap our classes at 10 students. This is to ensure the quality of training remains high and that all students can ask questions and engage in discussion.

I previously attended a course with Excel Consulting, will the training be similar?

Yes, we rebranded from Excel Consulting in October 2019. The business quickly outgrew its original name. Our new brand Nexacu better reflects our direction, continued innovation, and commitment to delivering next-level learning. We have always refined and continue to update our courses but retain our excellent trainers and deliver the same high-quality content. Nexacu is the leading Australian provider in training excel. 

Where is the training held?

We are a national training company with offices in 7 cities around Australia; Melbourne, Sydney, Brisbane, Perth, Adelaide, Parramatta, and Canberra. You can also find us by typing this in your search bar: 'excel training course near me.' We also deliver Excel skills training in the workplace nationwide as well as offering remote training.

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$415 $460
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

skills test nexacu

Skills Test

Try our short skills test and find out which course is right for you.

 skills test

 

Contact Us

Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Related Training Courses

Course Icon Excel Beginner

Learn how to manage, analyse and share everyday data using Excel spreadsheets. Perfect for new users or those looking to build a solid foundation.

download course pdf
Price: $385 $430
Course Icon Excel Intermediate

Take your Excel skills to the next level with complex formulas, conditional formatting, PivotTables, data validation and more.

download course pdf
Price: $410 $460
Course Icon Excel Expert

Become a power user with advanced data wrangling, automation and integration using Excel and the Power Platform.

download course pdf
Price: $475 $530
Course Icon Excel Tables and Pivot Tables

Learn to build powerful reports with PivotTables, data consolidation and visualisation techniques in just one day.

download course pdf
Price: $490 $540
Course Icon Excel Macro Mastery

Automate your workflow with Excel macros. Learn to record, edit and run simple macros to boost efficiency and save time.

download course pdf
Price: $352 $390
MO-201 Excel Certification

Prepare for the MO-201 Microsoft Excel Certification. Showcase your skills, gain confidence and boost your career with globally recognised credentials.

Price: 

$1,430
inc GST

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Trusted Nationwide by Leading Organisations

at Nexacu, we're proud to be the trusted training partner for hundreds of leading organisations accross Australia and New Zealand. From government departments to top corporates, we help teams upskill and succeed everyday

  • 400+ companies rely on Nexacu for team training
  • Trusted by federal, state, and local government agencies
  • Delivering training across 9 countries

Why Nexacu?

Books Icon

Step by Step Courseware

Custom workbook included with a step by step exercises

Facility Image 2
Facility Image 3
Facility Image 1

Refresh Icon

Free Refresher

Resit your course for free within 6 Months

More than 1,300 Business trust Nexacu

Trusted by Business

Procured by Government

Procured by Goverment

Reviews Not Found

Valued by Individuals