Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel: Master Power Query in 120 Minutes!
Introduction
Excel Power Query - Introduction (3:04)
Excel Power Query - Query Editor Ribbon (8:38)
Downloadable Files
Exercise Files
Master Power Query in 120 Minutes!
Transform Data - Trim in Excel Power Query (5:26)
Transform Data - Format Dates and Values in Excel Power Query (2:15)
Transform Data - Parsing URLs in Excel Power Query (5:25)
Transform Data - Split Text Fields in Excel Power Query (9:34)
Transform Data - Group By in Excel Power Query (2:57)
Transform Data - Unpivoting Columns in Excel Power Query (5:19)
Transform Data - Pivoting Columns in Excel Power Query (2:18)
Transform Data - Split Columns into Other Columns in Excel Power Query (4:04)
Transform Data - Filtering Rows in Excel Power Query (5:03)
Transform Data - Sorting Columns in Excel Power Query (2:20)
Transform Data - Transform and Add Columns in Excel Power Query (6:41)
From Folder - Import From Folder in Excel Power Query (6:32)
From Folder - Doing Auto Cleanup in Excel Power Query (6:56)
From Folder - Extract Data from Forms in Excel Power Query (13:25)
From Workbook - Extract Multiple Criteria in Excel Power Query (4:39)
From Workbook - Extract Multiple Worksheets in Excel Power Query (4:03)
Joins - Intro to Joins (3:31)
Joins - Merging (7:42)
Joins - Full Outer Join (5:43)
Joins - Right Anti Join (8:50)
Power Query - Convert Reports into Pivot Tables (5:03)
Power Query - Modulo (5:44)
Excel Power Query - Query Editor Ribbon
Complete and Continue