01 - Introduction
Ex_Files_Excel_Business_Intelligence_Part_1_Power_Query
02 - 1. Getting Started
03 - 2. Intro to the Power Excel Series
04 - 3. Power Query
-
01 - Power Query introduction (0:27)
-
02 - Meet Power Query aka Get & Transform (2:40)
-
03 - The Query Editor (3:17)
-
04 - Options for loading data in Excel (1:40)
-
05 - Basic Power Query table transformations (8:06)
-
06 - Text-specific query editing tools (10:17)
-
07 - Number-specific query editing tools (7:41)
-
08 - Date-specific query editing tools (7:39)
-
09 - Create a rolling calendar with Power Query (5:02)
-
10 - Add index and conditional columns with Power Query (7:44)
-
11 - Group and aggregate data with Power Query (7:10)
-
12 - Modify Excel workbook queries (4:18)
-
13 - Merge queries (7:43)
-
14 - Append queries (5:49)
-
15 - Connect Excel to a folder of files (9:32)
-
16 - Excel Power Query best practices (2:42)
-
17 - Pivot and unpivot data with Power Query (8:52)
05 - Conclusion
