(08) 9383 8000
Excel - Power Query
Level - Advanced
This course introduces Power Query to discover, connect to and import data into Microsoft Excel. It also focuses on using PowerPivot to remodel and enhance the imported data by writing queries through Power Query M language.
Half-day
Overview
The Excel - Power Query course will enable you to understand how to connect to a variety of data sources and extract data, group and summarise data and transpose and unpivot complex data. After completion of this course you will be able to understand basic Power Query formulas and the M language.
Content
- Import data from databases and text files
- Aggregate Excel worksheets
- Group and summarise data
- Transpose and unpivot complex data
- Automate refreshing
- Introduce Power Query formulas and the M language.
Learning Outcomes
Participants should be able to:
- Connect to a variety of data sources and extract data
- Clean and load the data into PowerPivot
- Understand basic Power Query formulas.
Level - Advanced
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.
Level - Fundamental
In this course you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations.
Level – Fundamental.
If you want your presentations to look clearer and more polished, this course helps you build the practical design skills to create slides that communicate with impact.
You will learn how to structure layouts, use templates effectively and enhance content with data visuals and multimedia elements that support clear, engaging communication.
Level – Advanced.
If you work with long or detailed documents, this course builds the skills to structure, format and manage them with confidence.
You will learn how to keep reports consistent, add references and produce polished, professional outputs.