Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Excel Basics
·
Module 5
Data Transformation with Power Query
1
Connecting and Transforming Data with Power Query
Connect to various data sources (CSV, Excel, Web) and navigate the Power Query Editor.
Data Transformation Fundamentals
Apply common transformation steps like filtering, removing columns, and changing data types.
3
Merging Data: Performing Joins with Queries
Merge queries to perform joins between different data tables.
4
Appending Queries
Append queries to combine rows from multiple tables.
5
Unpivot Columns: From Wide to Tidy Data
Use the Unpivot Columns feature to transform wide data into a tidy format.
6
Grouping and Aggregating Data in Power Query
Group and aggregate data within the Power Query editor.
7
Understanding M Language and Transformation Code
Explain the role of the M language and view the code for a transformation step.
8
Loading and Refreshing Transformed Data in Excel
Load transformed data into the Excel Data Model or a worksheet and manage data refresh settings.
Previous module
Structuring and Presenting Data
Next module
Summarizing Data with PivotTables