Full star Half star Star PDF
Specialist · 1 Day · $385 incl GST

Excel for Data Analysis

A one-day Excel data analysis course for advanced Excel users: import and clean data with Power Query, build data models in Power Pivot, write DAX measures and map data with 3D Maps. $385 incl GST, 6 CPD hours, up to 10 students, Online Live or in North Sydney and Melbourne.
4.85 / 5 from 264 student reviews Classroom · Online Live Australia wide

About the Excel for Data Analysis Course

Excel for Data Analysis is a one-day course that brings business intelligence tools into your Excel workbooks. You'll use Power Query (Get and Transform) to import and clean data from Excel files, text files, folders, Access databases and the web, build a data model with relationships in Power Pivot, write DAX calculations, and report on the results with PivotTables, visualisations and 3D Maps. It builds on the skills taught in Excel Advanced, is one of our specialist Excel courses, and lays the groundwork for Power BI training.

Who should do this course?

This course is for advanced Excel users who want to bring business intelligence tools into their workbooks, combine and clean data from several sources, and report on it with visualisation tools.

After this course, you'll be able to:

  • ▪ Analyse data from multiple sources to support informed decisions
  • ▪ Import data from Excel files, text files, folders, Access databases and the web with Power Query (Get and Transform)
  • ▪ Clean and transform data in Power Query, including splitting, merging, filtering and unpivoting columns
  • ▪ Load data into the Power Pivot data model and create table relationships
  • ▪ Organise data in Power Pivot with hierarchies, sorting and hidden columns
  • ▪ Explain when to use Power Query and when to use Power Pivot
  • ▪ Create calculated columns and measures with DAX, including RELATED, SUMX, CALCULATE and FILTER
  • ▪ Calculate year-to-date and month-to-date results with DAX time intelligence
  • ▪ Report on your data model with PivotTables, PivotCharts, slicers and timelines
  • ▪ Map your data and play tours with 3D Maps

Prerequisites

This course assumes you have completed Excel Advanced or have equivalent skills.

Excel for Data Analysis Course Details

$385 incl GST per person
  • Duration1 Day
  • CPD Hours6 hours
  • LevelSpecialist
  • Class Size10 max · 5 avg
  • Study modesClassroom or Online Live
  • Times 9.00am to 5.00pm approx Classroom (local time) or Online Live (AEST/AEDT)

Pay Later available ?

Class Dates

Excel Data Analysis Course Dates

November 2026
23
Nov
Mon · 23 Nov 26
Online Live · Instructor-led
December 2026
10
Dec
Thu · 10 Dec 26
Online Live · Instructor-led
17
Dec
Thu · 17 Dec 26
Online Live · Instructor-led
January 2027
13
Jan
Wed · 13 Jan 27
Online Live · Instructor-led
21
Jan
Thu · 21 Jan 27
Online Live · Instructor-led
29
Jan
Fri · 29 Jan 27
Online Live · Instructor-led
February 2027
09
Feb
Tue · 09 Feb 27
Online Live · Instructor-led
26
Feb
Fri · 26 Feb 27
Online Live · Instructor-led
March 2027
10
Mar
Wed · 10 Mar 27
Online Live · Instructor-led
23
Mar
Tue · 23 Mar 27
Online Live · Instructor-led
April 2027
08
Apr
Thu · 08 Apr 27
Online Live · Instructor-led
20
Apr
Tue · 20 Apr 27
Online Live · Instructor-led
May 2027
07
May
Fri · 07 May 27
Online Live · Instructor-led
18
May
Tue · 18 May 27
Online Live · Instructor-led
31
May
Mon · 31 May 27
Online Live · Instructor-led
June 2027
11
Jun
Fri · 11 Jun 27
Online Live · Instructor-led
23
Jun
Wed · 23 Jun 27
Online Live · Instructor-led
No dates match your selected filter

Looking for Excel for Data Analysis dates?

There are currently no scheduled dates matching your selected filter, but we'd love to assist. Get in touch with our team to discuss your individual training needs or corporate group requirements, and we'll explore available options with you.

Bundle & Save

Training Packages

You save $385 3 courses · 3 days

Microsoft Training Package

Book any two one-day Microsoft Office courses and receive a third one-day course free.
$770 incl GST
Value $1,155 · save $385

Pay later available ?

Course Content

Excel Data Analysis Course Content

Unit 1: Introduction to Get and Transform

  • Link External Data to Power Query
  • Understand the Power Query Editor
  • Use the Query Settings
  • Apply Query Options
  • Import Data into the Data Model
  • Edit an Existing Query

Unit 2: Importing Data with Power Query

  • Understand the Database Query Editor
  • Review Data Downloaded from a Database
  • Import Data from Text Files
  • Import Data from a Folder
  • Import Data from Excel Files
  • Work with Data from the Current Workbook
  • Import Data from an Access Database
  • Import Data from the Web

Unit 3: Transforming Data in Power Query

  • Name Columns
  • Remove Columns
  • Split Columns
  • Merge Columns
  • Set Column Data Types
  • Filter Rows
  • Filter Row Ranges
  • Remove Duplicate Values
  • Filter Out Rows with Errors
  • Sort Columns
  • Change Values in a Table
  • Use Text Transformations
  • Use Fill Up and Fill Down to Replace Missing Values
  • Aggregate Values
  • Calculate Values in Custom Columns
  • Duplicate Columns
  • Unpivot Columns to Rows
  • Merge Queries

Unit 4: Importing Data into Power Pivot

  • Load Data from a Server Database
  • Preview and Filter a Table
  • Write Queries to Select Data from a Database
  • Load Views from a Database
  • Load Tables from an Access Database
  • Load Data from Text Files
  • Load Data from Excel Files
  • Load Data from an Excel Table

Unit 5: Data Model Relationships

  • Create Table Relationships (Joins)
  • Manage Relationships
  • View Relationships

Unit 6: Transforming Data in Power Pivot

  • Rename Tables
  • Delete Tables
  • Move a Table
  • Freeze and Unfreeze Columns
  • Hide Columns
  • Filter Columns
  • Sort Columns
  • Sort a Column Based on Another Column
  • Hide Tables
  • Create a Hierarchy
  • Alter Table Behaviour

Unit 7: Power Query and Power Pivot Compared

  • Understand the Difference between Power Query and Power Pivot

Unit 8: DAX Calculated Columns

  • Create a Concatenated Column
  • Create a Calculated Column
  • Use the RELATED Function
  • Complete a Practice Task
  • Create a Hierarchy
  • Calculate across Tables
  • Use the RELATEDTABLE and COUNTROWS Functions
  • Use the IF and ISBLANK Functions

Unit 9: DAX Measures and Metrics

  • Create a Count Measure
  • Create Measures across Multiple Tables
  • Use the SUMX Function
  • Filter with the CALCULATE Function
  • Use the FILTER Function

Unit 10: DAX Time Intelligence Calculations

  • Create a Calendar Table
  • Create Calendar Values
  • Calculate Year-to-Date Sales
  • Calculate Month-to-Date Sales

Unit 11: Reporting on the Data Model

  • Create a PivotTable from the Data Model
  • Use Measures in a PivotTable
  • Create a PivotChart from the Data Model
  • Filter Reports with Slicers and Timelines

Unit 12: 3D Maps

  • Open 3D Maps
  • Add Geocodes to a 3D Map
  • Navigate a 3D Map
  • Add Values to a 3D Map
  • Add Categories to a 3D Map
  • Add a Time Dimension to a 3D Map
  • Filter a 3D Map
  • Play a Tour
Excel Advanced Course
Excel Advanced
(4.82 out of 5)
$385.00
Learn More
Power BI Essentials Course
Power BI Essentials
(4.85 out of 5)
$396.00
Learn More
Power BI Report Design Course
Power BI Report Design
(4.87 out of 5)
$495.00
Learn More
Power BI Advanced Course
Power BI Advanced
(4.89 out of 5)
$990.00
Learn More
Student Reviews

What students say about this course

(5.0)
28 October, 2026

Very good. Well presented, easy to follow with the ability to ask questions. I hope that the guide is as good as the course so I can go back over all that we learned today.

Jo P
(5.0)
19 October, 2026

Great Course. Was very interactive and the instructor was amazing. He was very clear and easy to understand. It was very good to learn with him.

Fay S
(4.2)
09 September, 2026

The instructor was very informative and kept bringing practical examples into the course. He was very clear and precise with how he explained the contents of the course.

DARWIN W
(5.0)
09 September, 2026

Wow I have learnt so much about Excel from this course. I can use this on a daily basis. Thankyou so much Adam.

Michelle O
(4.9)
11 August, 2026

3-D Map is cool to see, but probably not very useful every day, perhaps that course time could be used for more relevant items. Otherwise, really great course, great pace. Thanks!

Laraine W
(5.0)
15 July, 2026

it was very detailed and engaging with easy to learn steps for someone who has barely used data analytics in excel

Arno
(5.0)
15 July, 2026

Adam was great, although he jumps very quickly from part to part and although he checks on people, this is something that needs to be done more throughout the session. I'll be re-doing the course couple of times more to really get this properly under my belt.

David C
(5.0)
29 June, 2026

The course was very useful and teacher provided knowledge and practical experience and skills very usefully. Thank you very much teacher.

Jimmy D
(5.0)
03 June, 2026

This is such an amazing course. I am really appreciative of the recommendation prior to taking the Power BI course. Sean is simply amazing.

Theresa A
(4.7)
20 May, 2026

Adam was very thorough well versed on the topics covered. He was able to answer all questions that got asked.

Anonymous
(5.0)
08 May, 2026

Adam was very clear and well spoken. His enthusiasm and knowledge meant I remained engaged the whole time. The demonstrations were easy to follow and the pace of the course is perfect.

Kaylee W
(4.8)
08 May, 2026

This is an excellent introductory course that provides a strong foundation in the fundamentals of Data Analytics. The content is well-structured and easy to follow, making it ideal for beginners looking to build a solid base. What truly stood out was learning alongside Adam, his patience, clarity, and willingness to answer every question thoughtfully made the entire experience even more enjoyable. He created a supportive learning environment and ensured everyone kept up with confidence. Overall, a highly engaging and rewarding course. I thoroughly enjoyed it!

Rishi J
(5.0)
30 March, 2026

Great help! Ran through everything all clearly. Used great examples to run through and show many ways to analyze, view and dissect data.

Phoebe T
(5.0)
03 March, 2026

I really like the idea with your courses that we can go and have a play and then come back and redo the course again if needed. Adam is such a great presenter :)

Ronda G
(5.0)
03 March, 2026

Thank you to Adam for a very engaging course! Great pace, interesting exercises and held my attention. :)

Jen
Read all course reviews
Common Questions

Frequently asked questions

Who is the Excel for Data Analysis course for?

Excel for Data Analysis is for advanced Excel users who work with large data sets from several sources and want to combine, clean, model and report on them in Excel. It assumes you have completed Excel Advanced or have equivalent skills.

What is the difference between Power Query and Power Pivot?

Power Query (Get and Transform) brings data into Excel and cleans it: importing from files, folders, databases and the web, then splitting, merging, filtering and reshaping it. Power Pivot then models that data: it links tables with relationships, holds large data sets efficiently and lets you write DAX calculations. The course covers both, and when to use each.

How long is the Excel for Data Analysis course and how much does it cost?

Excel for Data Analysis runs for one day, from 9am to 5pm, and carries 6 CPD hours. It costs $385 incl GST and includes a PDF course manual, a certificate of completion and 12 months of free email support. Publicly scheduled courses also include unlimited free repeats within 8 months. It is also part of the Microsoft Training Package: book any two one-day courses and receive a third one-day Microsoft Office course free.

Is Excel for Data Analysis a good step towards Power BI?

Yes. Power BI uses the same Power Query editor, the same kind of data model and the same DAX language, so the skills carry straight across. Many students take Excel for Data Analysis and then move on to our Power BI courses.

What do I need for the Excel for Data Analysis course online?

Power Pivot and 3D Maps run in Excel for Windows, so for Online Live classes you need a Windows PC or laptop with Microsoft Excel installed, the Microsoft Teams app, a headset or earbuds with a microphone, and a reliable internet connection. A second screen is recommended. In our North Sydney and Melbourne classrooms, we provide the computers.

Microsoft Package
Save $385

Book any two 1-day Microsoft Office courses and receive a third 1-day Microsoft Office course for
FREE!


For more info please

Call 1300 888 724

View Package Details

Contact Us

Enquire now

Fill in your details to have a training consultant contact you to discuss your training needs. We offer public, on-site and workplace IT and software training services across Australia. Complete the form or call us during business hours (8.30am to 5pm AEST/AEDT) and our friendly customer service team will respond within 1 business day.

Contact us

Level 11, 32 Walker Street, North Sydney NSW 2060
8.30am to 5pm AEST/AEDT, Monday to Friday

1300 888 724 info@dynamicwebtraining.com.au ·Enquire online

Fields marked with * are required. We respond within 1 business day.

Our Training Locations

Train in-class or Online Live, Australia wide

Classroom + Online Live

Sydney

Level 11, 32 Walker Street, North Sydney NSW 2060

Classroom + Online Live

Melbourne

Level 12, 379 Collins Street, Melbourne VIC 3000

Online Live

Brisbane

All courses facilitated in Online Live format or In-house workplace training, QLD

Online Live

Canberra

All courses facilitated in Online Live format or In-house workplace training, ACT

Online Live

Adelaide

All courses facilitated in Online Live format or In-house workplace training, SA

Online Live

Perth

All courses facilitated in Online Live format or In-house workplace training, WA