Full star Half star Star PDF
The Ultimate Training Experience.

Excel for Data Analysis

(4.85 out of 5) 84 Student Reviews

About the Course

This Excel for Data Analysis course is suitable for participants who wish to extend their advanced Excel skills and want to introduce Business intelligence components into their workbooks. The course will cover Power Query from the Get and Transform in Excel and Power Pivot to model the data. Students will learn to obtain data from Access, Text Files, the Web, and Excel files and tables and then transform the tables by renaming, removing, splitting, and merging table columns. We will also cover various filtering techniques, such as aggregating values, calculating columns, unpivoting rows, and merging queries.

Who should do this course?

This course is suitable for participants who already have advanced knowledge of Microsoft Excel and wish to implement Business Intelligence components into their workbooks and use visualisation tools..

Upon successful completion of this course, students will be able to:

  • Analyse data from muliple sources to enable informed decision making
  • Link external data to Power Query with Get and Transform
  • Understand how to import data from various sources
  • Transform data in Power Query
  • Learn to aggregate data and creat reports in PowerPivot
  • Understand data model relationships
  • Transform data in PowerPivot to make it more meaningful
  • Understand the difference between Power Query and PowerPivot
  • Understand how to perform calculations using DAX
  • Use text visualisations to make complex data more understandable and useful

Prerequisites

This Data Analysis course is suitable for participants who want to extend their advanced Excel skills and be able to implement Business Intelligence within their Excel workbooks.

Excel Data Analysis Course Details

$385 incl GST

  • Duration:1 Days
  • Max. Class Size:10
  • Avg. Class Size:5
  • Study Mode:
    Classroom Online Live
  • Level:Expert
  • CPD Hours:6 hours
  • Times: Classroom: 9.00am to 5.00pm approx(Local Time) Online Live: 9.00am to 5.00pm approx(AEST or AEDT)
  • Download Course PDF
Pay Later

Excel Data Analysis Course Dates

Sydney Class Dates

Level 11, 32 Walker Street, North Sydney , NSW 2060

16 Feb 26 Mon Online Live
03 Mar 26 Tue Online Live
18 Mar 26 Wed Online Live
07 Apr 26 Tue Online Live
21 Apr 26 Tue Online Live
08 May 26 Fri Online Live
20 May 26 Wed Online Live
03 Jun 26 Wed Online Live
19 Jun 26 Fri Online Live
Melbourne Class Dates

Level 12, 379 Collins Street, Melbourne , VIC 3000

16 Feb 26 Mon Online Live
03 Mar 26 Tue Online Live
18 Mar 26 Wed Online Live
07 Apr 26 Tue Online Live
21 Apr 26 Tue Online Live
08 May 26 Fri Online Live
20 May 26 Wed Online Live
03 Jun 26 Wed Online Live
19 Jun 26 Fri Online Live
Brisbane Class Dates

All courses facilitated in, Online Live format , QLD

16 Feb 26 Mon Online Live
03 Mar 26 Tue Online Live
18 Mar 26 Wed Online Live
07 Apr 26 Tue Online Live
21 Apr 26 Tue Online Live
08 May 26 Fri Online Live
20 May 26 Wed Online Live
03 Jun 26 Wed Online Live
19 Jun 26 Fri Online Live
Canberra Class Dates

All courses facilitated in, Online Live format , ACT

16 Feb 26 Mon Online Live
03 Mar 26 Tue Online Live
18 Mar 26 Wed Online Live
07 Apr 26 Tue Online Live
21 Apr 26 Tue Online Live
08 May 26 Fri Online Live
20 May 26 Wed Online Live
03 Jun 26 Wed Online Live
19 Jun 26 Fri Online Live
Adelaide Class Dates

All courses facilitated in, Online Live format , SA

16 Feb 26 Mon Online Live
03 Mar 26 Tue Online Live
18 Mar 26 Wed Online Live
07 Apr 26 Tue Online Live
21 Apr 26 Tue Online Live
08 May 26 Fri Online Live
20 May 26 Wed Online Live
03 Jun 26 Wed Online Live
19 Jun 26 Fri Online Live
Perth Class Dates

All courses facilitated in, Online Live format , WA

16 Feb 26 Mon Online Live
03 Mar 26 Tue Online Live
18 Mar 26 Wed Online Live
07 Apr 26 Tue Online Live
21 Apr 26 Tue Online Live
08 May 26 Fri Online Live
20 May 26 Wed Online Live
03 Jun 26 Wed Online Live
19 Jun 26 Fri Online Live

Excel Data Analysis Course Content

Unit 1: Get and Transform Introduction

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

Unit 2: Accessing Data Types from Query

  • Understand the Database Query Editor
  • Review data download from the 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 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 Down to Replace Missing Values
  • Aggregate Values
  • Calculate Values across Custom Columns
  • Duplicate Columns
  • Unpivot Columns to Rows
  • Merge Queries

Unit 4: Importing Data into PowerPivot

  • 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 Excel Table

Unit 5: Data Model Relationships

  • Create table relationship Joins
  • Manage Relationships
  • View Relationships

Unit 6: Transforming Data in PowerPivot

  • 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: PowerPivot vs Query

  • Understand the difference between Power Query and PowerPivot

Unit 8: DAX Measures for Columns

  • Create a Concatenated column
  • Create a Calculated column
  • Use the RELATED function
  • Complete a Task
  • Create a Hierarchy
  • Calculate Across Tables
  • Use the RELATEDTABLE and ROWCOUNT functions
  • Use the IF and ISBLANK Functions

Unit 9: DAX Measures and Metrics

  • Create a count Measure
  • Create Measures with multiple tables
  • Use the SUMX function
  • Filter using the CALCULATE Function
  • Use the FILTER function

Unit 10: DAX Time Intelligences Calculations

  • Create a Calendar
  • Create Calendar Values
  • Create Year to Date Sales
  • Create Month to Date Sales

Unit 11: Text Based Calculations

  • Create a Pivot Table
  • Create a Table Visualisation
  • Modify and move the Table
  • Create a Card Visualisation
  • Create a Matrix Visualisation
  • Filter a Table, Card and Matrix

Unit 12: Power Maps

  • Open Power Maps
  • Add Geocode to Power Maps
  • Navigating 3D Map
  • Add Values to the 3D Ma
  • Add Categories to the 3D Map
  • Add Time Dimension to 3D Map
  • Filter 3D Maps
  • Playing a Tour

Training Packages

Microsoft Training Package

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

$ 770 incl GST
(You save $385)
Total Duration
day
Pay Later

Related Courses

Excel Advanced Course
Excel Advanced
(4.85 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

(5.0)
28 January, 2026

The instructor was very detailed with his explainations and gave some examples that was relevant for my use in data analysis. I found data modelling very helpful for my role.

Narelle T
(5.0)
28 January, 2026

This has been a great course. Well-paced and knowledgeable instructor. Got a lot of new tips and greater understanding of excel pivot tables and queries, which is what I was hoping for with this training.

Brendon H
(5.0)
28 January, 2026

Course content was excellent - Presenter was very informative and explained everything very clearly. Can't wait to put it all into practice.

Alison F
(5.0)
23 January, 2026

Great pace, great real life examples and was happy to explain scenarios for our work. Good content covered and good flow.

Madeline R
(5.0)
23 January, 2026

I liked how all exercises built on the same data set, rather than a random collection of different examples.

Simon W
(5.0)
23 January, 2026

The coach was incredibly knowleageable and helpful. He stayed past the hour answering our questions and just knew so much. It's been an abolute pleasure and looking to appliying this new skills to a complex airline dashboard project I've been working on. Thanks so much!

Nicolas F
(5.0)
19 December, 2025

A valuable online learning course! The humorous lecture brings professional course teaching and demonstrations to everyone.

Melody L
(5.0)
19 December, 2025

This was fantastic, what a great session this was! I would love to re-sit this session to solidify my understanding, it was such a great day, thanks so much for this this will definitely be utilised in my day! The instructor was very clear and very enthused to keep us all engaged

Didi M
(5.0)
19 December, 2025

Very informative and useful information. The presenter was easy to follow. Interactive and answered all of our questions. I would definitely recommend

Helen V
(5.0)
01 December, 2025

Adam was a very kind and insightful instructor! He made everyone feel comfortable and able to keep up with the content which is most important to me. Adam had a fantastic answer to a question I raised which significantly helped me understand how the course materials apply to my work setting.

Kelton H
(5.0)
20 October, 2025

This course was very informative. I have found data analysis to be exactly what we have been missing in regards to capture and slicing certain aspects of our data and reporting. Sean is a great trainer, and we did appreciate the accents and 'Dad' jokes!. Thank you for accommodating for Amber and myself starting later also.

Kerrie R
(5.0)
10 October, 2025

This course was very informative and I have gained valuable knowledge. The instructor was clear and friendly.

Lisa M
(5.0)
10 October, 2025

There is so much to learn about Excel! Sean was an excellent instructor, very happy with the course and the learning opportunity. Thank you!

Ben R
(5.0)
10 October, 2025

Highly reccomended due to the instructor. Was able to gain an amazing understanding of the course and its application for future projects

PAU_David_SOHN
(5.0)
22 September, 2025

Sean made a topic that may have been a bit dry, very interesting and I appreciated the opportunity to participate.

Annette C
Read all course reviews

Enquire Now

Fill in your details to have a training consultant contact you to discuss your training needs.

Note: Form fields marked with * are required.

Your details
Please enter a valid email address for shipping updates.
I am enquiring about a...
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

REQUEST A CALLBACK
A team member will call you at a time convenient to you.
Your message was sent, thank you!
Contact us

Level 11, 32 Walker Street, North Sydney NSW, 2060