Power Query revolutionises how data is collected, shaped, and analysed in Excel. This course helps participants automate data preparation from multiple sources and create repeatable workflows for reporting. They will build confidence in using Power Query Editor to transform raw data into meaningful insights.
Learning Outcomes:
Connect to and import data from various sources
Clean, filter, and shape data using Power Query Editor
Automate data refresh and transformation workflows
Merge and append queries to combine data sets
Prepare data for PivotTable and chart analysis
Key Topics:
Power Query interface and tools
Data connection and transformation steps
Merging, appending, and parameterisation
Applied steps, functions, and custom columns
Module 1: Power Query Overview
- What is Power Query
- Connect Data Sources
- Use Power Query Editor
Module 2: Shape and Transform Data
- Apply Data Transforming Principles to a Table
- Apply Data Transforming Principles to a Column
- Add Custom Column
- Use Applied Steps
Module 3: Combine Data from multiple sources
- Using Append Queries
- Using Merge Queries (Left, Right, Inner, Full, Fuzzy)
.png?width=50&name=Artificial%20Intelligence%20(AI).png)
-1.png?width=360&name=Server%20(4)-1.png)
/AI%20(6)-1-1.png?width=360&name=AI%20(6)-1-1.png)
/AI%20(8)-1.png?width=360&name=AI%20(8)-1.png)
-1.png?width=360&name=Automation%20RPA%20(2)-1.png)
/AI%20(5)-1.png?width=360&name=AI%20(5)-1.png)
