Microsoft Excel Power Query

Course Overview

Microsoft Excel Power Query

Create queries to interrogate data from data sources. 

Course Content

Module 1 - Excel Table Revision 

• Creating and formatting tables
• Summarising data and table calculations
• Interactive filter slicers  

Module 2 - Getting Started with Power Query 

• Accessing power query
• Creating queries and connecting to data sources
• External data sources
• Producing Excel table outputs
• Working with the query editor
• Importing and loading data  

Module 3 - Transforming Data 

• Managing columns
• Reducing rows and applying filters
• Transposing tables
• Unpivot columns
• Replacing values
• Cleansing values (text, numbers and dates)
• Creating new columns
• Sorting and grouping data  

Module 4 - Working with the Query Editor 

• Query step settings
• Editing query steps
• Refreshing query data 

Module 5 - Advanced Queries 

• Power query formulas
• Modifying query functions
• Advanced query editing 

Module 6 - Multiple Data Sources and Relationships 

• Related data sourcesCreating additional queries
• Merge and append queries
• Producing related data outputs
• Adding queries to the data model
• Using the data model