Microsoft Excel for Data Analysts | Online | Wed 18 Nov 2026
$360 (excl. GST)
Microsoft Excel for Data Analysts — Advanced level, 1 Day, Online. Starts Wed 18 Nov 2026.
* Please note that this is an online course, delivered remotely by a live instructor through Zoom *
Course Code: EXLDAT
Duration: 1 Day
Overview
This Excel for Data Analysis 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.
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.
This one-day course covers aspects of Microsoft Excel that goes well beyond building basic workbooks, including workbook automation and productivity features. Participants will learn advanced Excel techniques in a range of areas such as worksheet and workbook consolidation, data validation, PivotTables and Pivot Charts, Lookup and Reference Functions, Linking Data, Financial Functions, Recorded Macros and much more.
Audience
This course will also introduce participants to Data Analysis Expression (DAX) language and bring together Text Based Visualisation with Pivot Tables using Cards and the Matrix views to see the results of DAX functions.
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.
Module List
- Module 1: Get and Transform Introduction
- Module 2: Accessing Data Types from Query
- Module 3: Transforming Data in Query
- Module 4: Importing Data into PowerPivot
- Module 5: Data Model Relationships
- Module 6: Transforming Data in PowerPivot
- Module 7: PowerPivot vs Query
- Module 8: DAX Measures for Columns
- Module 9: DAX Measures and Metrics
- Module 10: DAX Time Intelligences Calculations
- Module 11: Text Based Calculations
- Module 12: Power Maps
Click here for the full 'Excel for Data Analysts' course outline
Combined with some well built labs, and it makes it easy to navigate the mess that can be SharePoint
I give 3grow a solid 5/7, would recommend!
I've tried 3 of the popular google results for Microsoft Training courses. All of these felt like a very rote course. so much so that the instructors couldn't answer questions outside of the scripted exercises.
Attending 3Grow was the diamond in the rough for this market. Russ had the most knowledge and human-interface of M365, particularly sharepoint.
3Grow is the only M365 training provider in will recommend.
I will definitely be attending more training and have recommend other from the company to attend relevant training sessions.
As Australia’s only Microsoft 365-specialist training provider, at 3grow we take great pride in delivering quality Microsoft 365 training courses and workshops.
Our courses are designed to meet the needs of all involved in the full Microsoft 365 spectrum, from end users to developers and IT administrators, offering course across SharePoint, Power Apps, Power Automate, Microsoft Teams, Power BI, and more.
The public courses listed on Humanitix are ideal for organisations looking to upskill up-to 4 attendees; for larger groups or to find out how we can deliver a customised training program, get in touch via learn@3grow.net