All courses available in-class and remotely.

Excel Training Nexacu

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

Excel Training Nexacu

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

$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day
$440
10 max
1 day

Remote

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Upcoming Courses:
Remote Online
Date
Course
City
Status
Wed 29 Jun 22
Wed
29
Jun
Excel Expert
Remote Online
Status: Confirmed
Confirmed
Fri 8 Jul 22
Fri
8
Jul
Excel Expert
Remote Online
Status: Few Seats
Few Seats
Wed 27 Jul 22
Wed
27
Jul
Excel Expert
Remote Online
Status: Confirmed
Confirmed
Thu 28 Jul 22
Thu
28
Jul
Excel Expert
Remote Online
Status: Confirmed
Confirmed
Tue 30 Aug 22
Tue
30
Aug
Excel Expert
Remote Online
Status: Confirmed
Confirmed
Thu 29 Sep 22
Thu
29
Sep
Excel Expert
Remote Online
Status: Confirmed
Confirmed
Fri 14 Oct 22
Fri
14
Oct
Excel Expert
Remote Online
Status: Scheduled
Scheduled
Mon 17 Oct 22
Mon
17
Oct
Excel Expert
Remote Online
Status: Confirmed
Confirmed
Mon 28 Nov 22
Mon
28
Nov
Excel Expert
Remote Online
Status: Scheduled
Scheduled
Brisbane
Date
Course
City
Status
Fri 8 Jul 22
Fri
8
Jul
Excel Expert
Brisbane
Status: Confirmed
Confirmed
Thu 28 Jul 22
Thu
28
Jul
Excel Expert
Brisbane
Status: Scheduled
Scheduled
Tue 30 Aug 22
Tue
30
Aug
Excel Expert
Brisbane
Status: Scheduled
Scheduled
Thu 29 Sep 22
Thu
29
Sep
Excel Expert
Brisbane
Status: Scheduled
Scheduled
Mon 17 Oct 22
Mon
17
Oct
Excel Expert
Brisbane
Status: Scheduled
Scheduled
Mon 28 Nov 22
Mon
28
Nov
Excel Expert
Brisbane
Status: Scheduled
Scheduled
Sydney
Date
Course
City
Status
Thu 28 Jul 22
Thu
28
Jul
Excel Expert
Sydney
Status: Confirmed
Confirmed
Tue 30 Aug 22
Tue
30
Aug
Excel Expert
Sydney
Status: Scheduled
Scheduled
Thu 29 Sep 22
Thu
29
Sep
Excel Expert
Sydney
Status: Scheduled
Scheduled
Mon 17 Oct 22
Mon
17
Oct
Excel Expert
Sydney
Status: Scheduled
Scheduled
Mon 28 Nov 22
Mon
28
Nov
Excel Expert
Sydney
Status: Scheduled
Scheduled
Parramatta
Date
Course
City
Status
Wed 27 Jul 22
Wed
27
Jul
Excel Expert
Parramatta
Status: Scheduled
Scheduled
Fri 14 Oct 22
Fri
14
Oct
Excel Expert
Parramatta
Status: Scheduled
Scheduled
Melbourne
Date
Course
City
Status
Fri 8 Jul 22
Fri
8
Jul
Excel Expert
Melbourne
Status: Confirmed
Confirmed
Tue 30 Aug 22
Tue
30
Aug
Excel Expert
Melbourne
Status: Confirmed
Confirmed
Thu 29 Sep 22
Thu
29
Sep
Excel Expert
Melbourne
Status: Scheduled
Scheduled
Mon 17 Oct 22
Mon
17
Oct
Excel Expert
Melbourne
Status: Scheduled
Scheduled
Mon 28 Nov 22
Mon
28
Nov
Excel Expert
Melbourne
Status: Scheduled
Scheduled
Canberra
Date
Course
City
Status
Thu 28 Jul 22
Thu
28
Jul
Excel Expert
Canberra
Status: Confirmed
Confirmed
Fri 14 Oct 22
Fri
14
Oct
Excel Expert
Canberra
Status: Scheduled
Scheduled
Adelaide
Date
Course
City
Status
Wed 27 Jul 22
Wed
27
Jul
Excel Expert
Adelaide
Status: Scheduled
Scheduled
Fri 14 Oct 22
Fri
14
Oct
Excel Expert
Adelaide
Status: Scheduled
Scheduled
Perth
Date
Course
City
Status
Wed 29 Jun 22
Wed
29
Jun
Excel Expert
Perth
Status: Confirmed
Confirmed
Mon 11 Jul 22
Mon
11
Jul
Excel Expert
Perth
Status: Scheduled
Scheduled
Thu 4 Aug 22
Thu
4
Aug
Excel Expert
Perth
Status: Sold Out
Sold Out
Fri 5 Aug 22
Fri
5
Aug
Excel Expert
Perth
Status: Sold Out
Sold Out
Mon 5 Sep 22
Mon
5
Sep
Excel Expert
Perth
Status: Scheduled
Scheduled
Fri 14 Oct 22
Fri
14
Oct
Excel Expert
Perth
Status: Scheduled
Scheduled
Fri 4 Nov 22
Fri
4
Nov
Excel Expert
Perth
Status: Scheduled
Scheduled
Thu 8 Dec 22
Thu
8
Dec
Excel Expert
Perth
Status: Scheduled
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Excel Expert Course Details

Price
$440
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
$440
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 10
333 Adelaide Street
Brisbane QLD 4000
microsoft_gold

Excel Expert Course Details

Price
$440
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 10
100 Walker Street
North Sydney NSW 2060
microsoft_gold

Excel Expert Course Details

Price
$440
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
$440
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 3
466 Little Lonsdale St
Melbourne VIC 3000
microsoft_gold

Excel Expert Course Details

Price
$440
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
Ethos House
Level 1
28 Ainslie Place
Canberra ACT 2601
microsoft_gold

Excel Expert Course Details

Price
$440
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 3
97 Pirie Street
Adelaide SA 5000
microsoft_gold

Excel Expert Course Details

Price
$440
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 4
220 St Georges Tce
Perth WA 6000
microsoft_gold

Excel Course Outlines

Other Courses
Microsoft Power BI Training Courses
Microsoft Office 365 Training Courses
Excel Specialist Training Courses
Microsoft Project Training Courses
R Programming Training Courses
Python Training Courses
Power Apps Training Courses
SQL Training Courses
SharePoint Training Courses
Microsoft Teams Training Courses
Power Automate Training Courses
Microsoft Visio Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Other Courses
Course Rating
Microsoft Excel Training Courses

4.75 5 Microsoft Excel Training Courses
4.75 out of 5
14622 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

What is Remote Training?

Valued by Individuals

4.75 / 5
Over 14622 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us