Microsoft Excel Training - Expert

Become an Excel Expert using the Power Platform

Supercharge your Excel skills and learn multiple ways to boost productivity!

Learn how to work with large data sources, transform & clean your data using Power Query and create an advanced data model in Power Pivot. Take advantage of Microsoft Excel’s cloud automation, Office Scripts and use the Power Platform to further automate your spreadsheet both in the cloud and on your desktop. You will also be introduced to Power BI and see how quickly you can turn your data into actionable insights with just a few clicks. Click here for our detailed course outline.

Courses available in-class or remotely. To attend remotely, select "Remote Online" as your location when booking.

Microsoft Excel Training - Expert

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

$475
10 max
1 day
$475
10 max
1 day
$475
10 max
1 day
$475
10 max
1 day
$475
10 max
1 day
$475
10 max
1 day
$475
10 max
1 day
$475
10 max
1 day
$475
10 max
1 day

Remote East

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Remote West

Upcoming Courses:
Remote East
Date
Course
City
Status
Fri 26 Jul 24
Fri
26
Jul
Excel Expert
Remote East
Status: Few Seats
Few Seats
Mon 29 Jul 24
Mon
29
Jul
Excel Expert
Remote East
Status: Few Seats
Few Seats
Tue 30 Jul 24
Tue
30
Jul
Excel Expert
Remote East
Status: Few Seats
Few Seats
Mon 5 Aug 24
Mon
5
Aug
Excel Expert
Remote East
Status: Confirmed
Confirmed
Tue 10 Sep 24
Tue
10
Sep
Excel Expert
Remote East
Status: Confirmed
Confirmed
Tue 17 Sep 24
Tue
17
Sep
Excel Expert
Remote East
Status: Confirmed
Confirmed
Wed 18 Sep 24
Wed
18
Sep
Excel Expert
Remote East
Status: Confirmed
Confirmed
Fri 20 Sep 24
Fri
20
Sep
Excel Expert
Remote East
Status: Few Seats
Few Seats
Mon 4 Nov 24
Mon
4
Nov
Excel Expert
Remote East
Status: Scheduled
Scheduled
Wed 13 Nov 24
Wed
13
Nov
Excel Expert
Remote East
Status: Scheduled
Scheduled
Brisbane
Date
Course
City
Status
Fri 26 Jul 24
Fri
26
Jul
Excel Expert
Brisbane
Status: Confirmed
Confirmed
Tue 17 Sep 24
Tue
17
Sep
Excel Expert
Brisbane
Status: Confirmed
Confirmed
Wed 13 Nov 24
Wed
13
Nov
Excel Expert
Brisbane
Status: Scheduled
Scheduled
Sydney
Date
Course
City
Status
Tue 30 Jul 24
Tue
30
Jul
Excel Expert
Sydney
Status: Sold Out
Sold Out
Tue 17 Sep 24
Tue
17
Sep
Excel Expert
Sydney
Status: Few Seats
Few Seats
Wed 13 Nov 24
Wed
13
Nov
Excel Expert
Sydney
Status: Scheduled
Scheduled
Parramatta
Date
Course
City
Status
Mon 5 Aug 24
Mon
5
Aug
Excel Expert
Parramatta
Status: Confirmed
Confirmed
Tue 10 Sep 24
Tue
10
Sep
Excel Expert
Parramatta
Status: Scheduled
Scheduled
Mon 4 Nov 24
Mon
4
Nov
Excel Expert
Parramatta
Status: Scheduled
Scheduled
Thu 14 Nov 24
Thu
14
Nov
Excel Expert
Parramatta
Status: Scheduled
Scheduled
Fri 13 Dec 24
Fri
13
Dec
Excel Expert
Parramatta
Status: Scheduled
Scheduled
Melbourne
Date
Course
City
Status
Fri 26 Jul 24
Fri
26
Jul
Excel Expert
Melbourne
Status: Few Seats
Few Seats
Wed 18 Sep 24
Wed
18
Sep
Excel Expert
Melbourne
Status: Confirmed
Confirmed
Thu 14 Nov 24
Thu
14
Nov
Excel Expert
Melbourne
Status: Scheduled
Scheduled
Canberra
Date
Course
City
Status
Fri 26 Jul 24
Fri
26
Jul
Excel Expert
Canberra
Status: Confirmed
Confirmed
Fri 20 Sep 24
Fri
20
Sep
Excel Expert
Canberra
Status: Few Seats
Few Seats
Fri 15 Nov 24
Fri
15
Nov
Excel Expert
Canberra
Status: Scheduled
Scheduled
Adelaide
Date
Course
City
Status
Mon 29 Jul 24
Mon
29
Jul
Excel Expert
Adelaide
Status: Confirmed
Confirmed
Tue 17 Sep 24
Tue
17
Sep
Excel Expert
Adelaide
Status: Few Seats
Few Seats
Fri 15 Nov 24
Fri
15
Nov
Excel Expert
Adelaide
Status: Scheduled
Scheduled
Perth
Date
Course
City
Status
Wed 11 Sep 24
Wed
11
Sep
Excel Expert
Perth
Status: Confirmed
Confirmed
Thu 24 Oct 24
Thu
24
Oct
Excel Expert
Perth
Status: Scheduled
Scheduled
Fri 13 Dec 24
Fri
13
Dec
Excel Expert
Perth
Status: Scheduled
Scheduled
Remote West
Date
Course
City
Status
Wed 11 Sep 24
Wed
11
Sep
Excel Expert
Remote West
Status: Confirmed
Confirmed
Thu 24 Oct 24
Thu
24
Oct
Excel Expert
Remote West
Status: Scheduled
Scheduled
Fri 13 Dec 24
Fri
13
Dec
Excel Expert
Remote West
Status: Scheduled
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Excel Expert Course Details

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

Excel Expert Course Details

Price
$475
Duration
1 day
Time
9am - 4pm ( approx )
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
microsoft_gold

Excel Expert Course Details

Price
$475
Duration
1 day
Time
9am - 4pm ( approx )
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
microsoft_gold

Excel Expert Course Details

Price
$475
Duration
1 day
Time
9am - 4pm ( approx )
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
microsoft_gold

Excel Expert Course Details

Price
$475
Duration
1 day
Time
9am - 4pm ( approx )
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
microsoft_gold

Excel Expert Course Details

Price
$475
Duration
1 day
Time
9am - 4pm ( approx )
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
microsoft_gold

Excel Expert Course Details

Price
$475
Duration
1 day
Time
9am - 4pm ( approx )
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
microsoft_gold

Excel Expert Course Details

Price
$475
Duration
1 day
Time
9am - 4pm ( approx )
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
microsoft_gold

Excel Expert Course Details

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

Excel Course Outlines

Course Rating
Microsoft Excel Training Courses

4.75 5 Microsoft Excel Training Courses
4.75 out of 5
24511 Student Reviews

Contact Us


What do I need to know to attend?

This course is aimed at experienced Excel users who want to learn more about handling data in Power Query and building automations into their models.

Excel Expert Learning Outcomes

You will learn how to:

  • Work effectively with large datasets in Excel
  • Transform and Clean your data in Power Query
  • Create data relationships
  • Create customised calculations in Power Pivot
  • Use Office Scripts for automation
  • Create workflows with Power Automate
  • Create visualisations of your model in Power BI
  • How to connect Excel and Power BI data
  • Understand when to choose Excel or Power BI

Excel Expert Course Content

  • Introduction
  • Course Overview

 

  • Open Power Query
  • Open Power Query
  • Configure Power Query
  • Add Power Pivot
  • Modify the Quick Access Toolbar
  • Configure Power Query

 

  • Get Data
  • Import Data from
  • CSV File
  • Excel Table, List, Pivoted data
  • Folder
  • PDF File
  • Type in the Data
  • Load the Data to Excel

 

  • Transform Data
  • Applied Steps
  • Deleting Applied Steps
  • Adding Applied Steps
  • Editing Data using
  • Fill Down
  • Trim
  • Replace Values
  • Filters
  • Modify the filter manually
  • Format
  • Removing Errors
  • Unpivoting Data

 

  • Working with Columns
  • Deleting Columns
  • Renaming Columns
  • Adding Columns
  • Standard & Custom Date Columns
  • Renaming Applied Steps
  • Create a Conditional Column

 

  • Working with Queries
  • Grouping Queries: Creating Query Groups
  • Appending Queries
  • Append Queries
  • View the loaded Queries
  • Rename Queries
  • Reloading the Queries
  • View the re-loaded Queries
  • Stop a single data load
  • Stop multiple data loads
  • Extended exercise - Macro

 

  • Power Pivot
  • Data Model
  • Add Tables to a Data Model
  • Arrange the Data Model
  • Connect the Data Model using Create
  • Connect the Data Model using Manage
  • Connect the Data Model using Click & Drag
  • Pivot Table
  • Pivot Table from Excel
  • Pivot Table from Power Pivot
  • Measure in Power Pivot
  • Sum in DAX
  • Pivot table for Measures
  • Measure with Filter

 

  • Data Types
  • Standard Data Types
  • Stock Data Type
  • Uploading Stock Data Type
  • Displaying Extra Data
  • Custom Data Type - Get Data
  • Custom Data Type - Transform Department Data Custom
  • Data Type - Transform Countries Data
  • Custom Data Type - Merge Data
  • Create Custom Data Type
  • Create Custom Report
  •  Extend the Custom Report

 

  • Office Script
  • Load file into Onedrive
  • Office Script
  • Before you record a script
  • Start recording
  • Edit the Script
  • Rename the Script
  • Change the Chart Title
  • Script a Dynamic Range
  • Script a Loop
  • Power Automate Online
  • Open Power Automate
  • Start Power Automate & select trigger
  • Add an Action
  • Add a second Action
  • Check the Flow
  • Test the Flow

 

  • Power Automate Desktop
  • The Setup 104
  • Start Desktop from Online
  • Working with Excel
  • Launch Excel Action
  • Read from Excel Action
  • Create new List Action
  • Write to Excel worksheet Action
  • Working with the Browser
  • Get the Converter Page
  • Looping Through Currencies
  • Create a For Each Action
  • Retrieving the rates
  • Using the recorder
  • Edit the recording
  • Copy Actions
  • Save value to a list Action
  • Running the PAD
  • Run the Actions
  • Finding the bug

Contact Us

Why Nexacu?

Valued by Individuals

4.72 / 5
Over 71460 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us