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
Upcoming Courses:
Remote East
Date
Course
City
Status
Brisbane
Sydney
Parramatta
Date
Course
City
Status
Melbourne
Canberra
Date
Course
City
Status
Adelaide
Date
Course
City
Status
Perth
Date
Course
City
Status
Remote West
Date
Course
City
Status
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
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Excel Expert Course Details
Price
$475
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
Excel Expert Course Details
Price
$475
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
Excel Expert Course Details
Price
$475
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
Excel Expert Course Details
Price
$475
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
Excel Expert Course Details
Price
$475
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
Excel Expert Course Details
Price
$475
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
Excel Expert Course Details
Price
$475
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
Excel Expert Course Details
Price
$475
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
Excel Course Outlines
-
-
-
-
-
-
-
MO-201 Excel Certification
Other Courses
Other Courses
Course Rating
Excel City Pages
Skills Test
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
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
phone
email
enquiry
