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.


Course Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDF
Upcoming Courses
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
Excel Training Courses

Learn how to analyse, share and manage your day-to-day data using Excel spreadsheets on our one-day course.

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

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

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

Become a Microsoft Excel certified. Attend our Nexacu Excel courses, choose to sit the Excel Specialist or Excel Expert exam and get Microsoft Certified.
$1,430
inc GST
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
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 PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFContact 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
-
Excel Training in Brisbane
View Dates -
Excel Training in Melbourne
View Dates -
Excel Training in Sydney
View Dates -
Excel Training in Adelaide
View Dates -
Excel Training in Perth
View Dates -
Excel Training in Parramatta
View Dates -
Excel Training in Canberra
View Dates -
Excel Training in Remote Online
View Dates
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
-
Excel Training in Brisbane
View Dates -
Excel Training in Melbourne
View Dates -
Excel Training in Sydney
View Dates -
Excel Training in Adelaide
View Dates -
Excel Training in Perth
View Dates -
Excel Training in Parramatta
View Dates -
Excel Training in Canberra
View Dates -
Excel Training in Remote Online
View Dates
Locations In-Person & Online
Find the nearest location and date that works for you
-
80K+
Students
-
76K+
4 & 5 Star Reviews
-
4.7/5
Google Reviews
-
1.3K+
Businesses Trust Nexacu
Step by Step Courseware
Custom workbook included with a step by step exercises



Free Refresher
Resit your course for free within 6 Months