The role of Power Query
Principle and mechanism of Power Query
Overview of the query editor

Retrieving data from the same file
Excel and Text Sources
Importing from an Access database

Clean Up Transform Data
Change Data Types
Add a Simple Calculation Column

Rotate, un-rotate and transpose a table
Data aggregation
Combine several queries

Create a table from Power Query
Use the Query tab
Create a pivot table

Workshop: import and transform data from external sources