Course Category Icon

Microsoft Excel Training - Advanced

Reach new heights with Excel Advanced Training

4.75
(25633)

Reach new heights with Excel Advanced Training

4.75
(25633)

Microsoft Excel Training - Advanced

Reach new heights with Excel Advanced Training

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


In this course you will be taught how to create complex formulas, utilise a wide range of functions, and develop dynamic charts and reports. In addition, you'll learn how to automate repetitive tasks using Macros, and gain a practical understanding of data analysis tools such as Solver, data linking, Pivot Charts, and controls. Our comprehensive course outline is provided below, so you can have a clear idea of what to expect from the course. By the end of the course, you'll have acquired the skills and knowledge necessary to work confidently with Excel at an advanced level.

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 7
79 George Street
Parramatta NSW 2150

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

We currently have no public courses scheduled. Please contact us to register your interest.

Brisbane

We currently have no public courses scheduled. Please contact us to register your interest.

Sydney

We currently have no public courses scheduled. Please contact us to register your interest.

Melbourne

We currently have no public courses scheduled. Please contact us to register your interest.

Canberra

We currently have no public courses scheduled. Please contact us to register your interest.

Adelaide

We currently have no public courses scheduled. Please contact us to register your interest.

Perth

We currently have no public courses scheduled. Please contact us to register your interest.

Remote West

We currently have no public courses scheduled. Please contact us to register your interest.

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 analyse, share and manage your day-to-day data using Excel spreadsheets on our one-day course.

download course pdf
Price: $385 $430
View Course
4.70
(2974)
Course Icon Excel Intermediate

Learn to create complex formulae, use functions, conditional formatting, pivot tables, data validation and more.

download course pdf
Price: $410 $460
View Course
4.70
(7167)
Course Icon Excel Advanced

Learn to automate tasks with Macros, understand the data analysis tools in Solver, Pivot Charts and controls. Sharpen your advanced excel skills. 

download course pdf
Price: $415 $460
View Course
4.72
(5476)
Course Icon Excel Expert

Become an Excel super user and take your data wrangling and automation to the next level with Excel & the Power Platform.

download course pdf
Price: $475 $530
View Course
4.73
(1624)
MO-201 Excel Certification

Become a Microsoft Excel certified. Attend our Nexacu Excel courses, choose to sit the Excel Specialist or Excel Expert exam and get Microsoft Certified.

Price: 

$1,430
inc GST

Excel Advanced Course Content

Expand All | Collapse All
  • Protecting Data
  • Understanding Data Protection
  • Providing Total Access to Cells
  • Protecting a Worksheet
  • Working With a Protected Worksheet
  • Protecting Data (cont.)
  • Disabling Worksheet Protection
  • Providing Restricted Access to Cells
  • Password Protecting a Workbook
  • Opening a Password Protected Workbook
  • Removing a Password From a Workbook
  • Lookup Functions
  • Understanding Data Lookup Functions
  • Using VLOOKUP
  • Using VLOOKUP for Exact Matches
  • Using INDEX
  • Using Match
  • Using XLOOKUP
  • Formula Auditing
  • Understanding Tracing Precedents
  • Understanding Tracing Dependents
  • Tracing Precedents and Dependents
  • Showing Formulas and Cell Arguments
  • Common Error Messages
  • Formula Auditing (cont.)
  • Understanding Error Checking
  • Checking for Errors
  • Tracing Errors
  • Evaluating Formulas
  • Using the Watch Window
  • Working With Circular References
  • Importing and Exporting
  • Understanding Data Importing
  • Understanding Text File Formats
  • Importing Tab Delimited Text
  • PivotTables
  • Understanding Pivot Tables
  • Recommended Pivot Tables
  • Creating Your Own PivotTable
  • Defining the PivotTable Structure
  • Filtering a PivotTable
  • Clearing a Report Filter
  • PivotTables (cont.)
  • Switching PivotTable Fields
  • Formatting a PivotTable
  • Understanding Slicers
  • Creating Slicers
  • Inserting a Timeline Filter
  • PivotTable Features
  • Using Compound Fields
  • Counting in a PivotTable
  • Formatting PivotTable Values
  • Working With PivotTable Grand Totals
  • Working With PivotTable Subtotals
  • Finding the Percentage of Total
  • Finding the Difference From
  • PivotTable Features (cont.)
  • Grouping in PivotTable Reports
  • Creating Running Totals
  • Creating Calculated Fields
  • Providing Custom Names
  • Creating Calculated Items
  • PivotTable Options
  • Sorting in a PivotTable
  • PivotCharts
  • Inserting a PivotChart
  • Defining the PivotChart Structure
  • Changing the PivotChart Type
  • Using the PivotChart Filter
  • Field Buttons
  • Moving PivotCharts to Chart Sheets
  • Recorded Macros
  • Understanding Excel Macros
  • Setting Macro Security
  • Saving a Document as Macro Enabled
  • Recording a Simple Macro
  • Running a Recorded Macro
  • Relative Cell References
  • Running a Macro With Relative References
  • Viewing a Macro
  • Recorded Macros (cont.)
  • Editing a Macro
  • Deleting a Macro
  • Copying a Macro
  • Assigning a Macro to Toolbar
  • Running a Macro from Toolbar
  • Assigning a Macro to Ribbon
  • Assigning a Shortcut to a Macro
  • Supplementary Content 
  • Dynamic Array Functions
  • Referencing Tables and Pivot Tables
  • Get & Transform (Power Query)
  • Scenarios
  • Solver
  • Data Tables
  • Lookup Functions
  • Supplementary Content 
  • Maths Functions
  • Importing and Exporting
  • Data Consolidation
  • Summarising and Subtotalling
  • Grouping and Outlining
  • Recorder Workshop
  • Controls
  • Information Functions

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 7
79 George Street
Parramatta NSW 2150

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

Try our short skills test and find out

which course is right for you.

skills test icon

 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

Why Nexacu?

Books Icon

Step by Step Courseware

Custom workbook included with a step by step exercises

Why grid 2
Why grid 3
Why grid 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

Valued by Individuals