Curriculum
Microsoft Excel Power Query: Master Data Cleaning and Analysis in 2 Hours
Power Query
0/24
-
Power Query Intro and Excel version
Preview -
Power Query and Query Editor Ribbon
-
Trim
-
Format Dates and Values
-
Parsing URLs
-
Split Text Fields
-
Group By
-
Import From Folder
-
Doing Auto Cleanup
-
Extract Data from Forms
-
Extract - Multiple Criteria
-
Extract Multiple Worksheets
-
Unpivoting Columns
-
Pivoting Columns
-
Split Columns into Other Columns
-
Filtering Rows
-
Sorting Columns
-
Transform and Add Columns
-
Intro to Joins
-
Merging
-
Full Outer Join
-
Right Anti Join
-
Convert Reports into Pivot Tables
-
Modulo
M Language
0/12
Video lesson