Excel for Data Analysis
(4.84 out of 5) 63 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
$396 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
Excel Data Analysis Course Dates
Sydney Class Dates
Level 11, 32 Walker Street, North Sydney , NSW 2060
| 05 Nov 25 | Wed | Online Live |
| 19 Nov 25 | Wed | Online Live |
| 01 Dec 25 | Mon | Online Live |
| 19 Dec 25 | Fri | Online Live |
| 07 Jan 26 | Wed | Online Live |
| 28 Jan 26 | Wed | Online Live |
| 16 Feb 26 | Mon | Online Live |
| 03 Mar 26 | Tue | Online Live |
| 18 Mar 26 | Wed | Online Live |
Melbourne Class Dates
Level 12, 379 Collins Street, Melbourne , VIC 3000
| 05 Nov 25 | Wed | Online Live |
| 19 Nov 25 | Wed | Online Live |
| 01 Dec 25 | Mon | Online Live |
| 19 Dec 25 | Fri | Online Live |
| 07 Jan 26 | Wed | Online Live |
| 28 Jan 26 | Wed | Online Live |
| 16 Feb 26 | Mon | Online Live |
| 03 Mar 26 | Tue | Online Live |
| 18 Mar 26 | Wed | Online Live |
Brisbane Class Dates
All courses facilitated in, Online Live format , QLD
| 05 Nov 25 | Wed | Online Live |
| 19 Nov 25 | Wed | Online Live |
| 01 Dec 25 | Mon | Online Live |
| 19 Dec 25 | Fri | Online Live |
| 07 Jan 26 | Wed | Online Live |
| 28 Jan 26 | Wed | Online Live |
| 16 Feb 26 | Mon | Online Live |
| 03 Mar 26 | Tue | Online Live |
| 18 Mar 26 | Wed | Online Live |
Canberra Class Dates
All courses facilitated in, Online Live format , ACT
| 05 Nov 25 | Wed | Online Live |
| 19 Nov 25 | Wed | Online Live |
| 01 Dec 25 | Mon | Online Live |
| 19 Dec 25 | Fri | Online Live |
| 07 Jan 26 | Wed | Online Live |
| 28 Jan 26 | Wed | Online Live |
| 16 Feb 26 | Mon | Online Live |
| 03 Mar 26 | Tue | Online Live |
| 18 Mar 26 | Wed | Online Live |
Adelaide Class Dates
All courses facilitated in, Online Live format , SA
| 05 Nov 25 | Wed | Online Live |
| 19 Nov 25 | Wed | Online Live |
| 01 Dec 25 | Mon | Online Live |
| 19 Dec 25 | Fri | Online Live |
| 07 Jan 26 | Wed | Online Live |
| 28 Jan 26 | Wed | Online Live |
| 16 Feb 26 | Mon | Online Live |
| 03 Mar 26 | Tue | Online Live |
| 18 Mar 26 | Wed | Online Live |
Perth Class Dates
All courses facilitated in, Online Live format , WA
| 05 Nov 25 | Wed | Online Live |
| 19 Nov 25 | Wed | Online Live |
| 01 Dec 25 | Mon | Online Live |
| 19 Dec 25 | Fri | Online Live |
| 07 Jan 26 | Wed | Online Live |
| 28 Jan 26 | Wed | Online Live |
| 16 Feb 26 | Mon | Online Live |
| 03 Mar 26 | Tue | Online Live |
| 18 Mar 26 | Wed | Online Live |
Excel Data Analysis Course Content
⊕ Expand full topic list
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
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
Unit 5: Data Model Relationships
- Create table relationship Joins
- Manage Relationships
- View Relationships
⊕ See more
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
⊕ See more
Unit 7: PowerPivot vs Query
- Understand the difference between Power Query and PowerPivot
⊕ See more
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
⊕ See more
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
⊕ See more
Unit 10: DAX Time Intelligences Calculations
- Create a Calendar
- Create Calendar Values
- Create Year to Date Sales
- Create Month to Date Sales
⊕ See more
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
⊕ See more
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
⊕ See more
Training Packages
Microsoft Training Package
Book any two 1-day Microsoft Office courses and receive a third 1-day Microsoft office course for FREE!
Related Courses
Student Reviews
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.
This course was very informative and I have gained valuable knowledge. The instructor was clear and friendly.
There is so much to learn about Excel! Sean was an excellent instructor, very happy with the course and the learning opportunity. Thank you!
Highly reccomended due to the instructor. Was able to gain an amazing understanding of the course and its application for future projects
Sean made a topic that may have been a bit dry, very interesting and I appreciated the opportunity to participate.
Great tools to learn, especially when dealing with multiple source of data and be able to connect them and analysing them together as it is from the same worksheet. Sean is a great instructor and very knowledgeable.
This course along with others - very helpful, well paced and a good balance of watching and practical
Refreshed some parts of excel that I've forgotten but also learnt alot of new features and now just wondering how I can integrate that into my projects.
Sean was a great instructor and showed us how to get the most out of Excel and the features of Power Pivot and Power Query. Really useful information that is applicable to data I work with. Thank you.
Excellent presentation and very well delivered. Adam made sure no one was left behind. I've learnt so much on this one.
Good examples of Power query through to Power Pivot and creating final dashboard. Thanks for explaining FY, which is very relevant to my work.
I learned a lot from the course, Adam has explained well all the necessary concepts. I would have wished the pacing to be a little bit faster but understand it is necessary to accommodate skill levels for all participants. Overall, would highly recommend.
This course was a great blend of information and practical examples. Adam our lecturer was extremely knowledgeable and kept a great pace.
This session was a repeat/(refresher) to a session originally undertaken back in January 2025. Adrian talked the participants through different case studies/examples today which proved very valuable.
Adam has explained all topics in a very understandable yet precise way! It would have been better if we can practice more on sample data but understand time is limited to 1 day, but in general I've learned a lot!!
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.
Save $396
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
