1 - 2.Introduction-to-Excel-Power-Query.xlsx
1 - Installing and Exploring Power Query
2 - Power Query Interface
3 - Power Query Update With Pivot Tables
4 - 5.Format-Date-and-Values.xlsx
4 - Format Dates and Values in Power Query
5 - 6.Parsing-URLs-in-Excel-Power-Query.xlsx
5 - Parsing URLs in Excel Power Query
6 - 7.Split-Text-Fields-in-Excel-Power-Query.xlsx
6 - 7.Split-Text-Fields-in-Excel-Power-Query-Finished.xlsx
6 - Split Text Fields in Excel Power Query
7 - 8.Group-By-in-Excel-Power-Query.xlsx
7 - Group By in Excel Power Query
8 - 9.Unpivoting-Columns.xlsx
8 - Unpivoting Columns
9 - 10.Pivoting-Columns.xlsx
9 - Pivoting Columns in Power Query
10 - 11.Split-Columns-into-Other-Columns.xlsx
10 - Split Columns into Other Columns
11 - 12.Filtering-Rows.xlsx
11 - Filtering Rows
12 - 13.Sorting-Data-in-Power-Query.xlsx
12 - Sorting Data in Power Query
13 - 14.Transform-and-Add-Columns.xlsx
13 - 14.Transform-and-Add-Columns-Finished.xlsx
13 - Transform and Add Columns
14 - 15.Regions.rar
14 - 15.Regions-Finished.xlsx
14 - Combine Excel Data Files in Power Query
15 - 16.Auto-Clean-Up-in-Power-Query.rar
15 - Perform Auto Clean Up in Power Query
16 - 17.Extract-Data-from-Forms.rar
16 - 17.Extract-Data-from-Forms-Finished.xlsx
16 - Extract Data from Forms in Power Query
17 - 18.Extract-Multiple-Criteria-in-Excel-Power-Query.xlsx
17 - 18.Extract-Multiple-Criteria-in-Excel-Power-Query-Finished.xlsx
17 - Extract Multiple Criteria in Excel Power Query
18 - 19.Extract-Multiple-Worksheets-in-Excel-Power-Query.xlsx
18 - Extract Multiple Worksheets in Excel Power Query
19 - 20.Introduction-to-Joins.xlsx
19 - 20.Introduction-to-Joins-Finished.xlsx
19 - Introduction to Joins
20 - Merging Tables In Power Query Using Joins
21 - 22.Outer-Joins-In-power-Query.xlsx
21 - Merge Tables in Power Query With Outer Joins
22 - 23.Right-Anti-Join.xlsx
22 - 23.Right-Anti-Join-Finished.xlsx
22 - Right Anti Join In Power Query
23 - 24.Convert-Reports-To-Pivot-Table-in-Power-Query.xlsx
23 - Convert Reports to Pivot Table in Power Query
24 - 25.Modulo.xlsx
24 - 25.Modulo-Finished.xlsx
24 - Modulo to Arrange Data
25 - Get a List of File Names Through Power Query
26 - 27.Get-Files-Names-Based-on-User-Selection-Finished.xlsx
26 - Get Files Names Based on User Selection