01 Welcome (16.27 MB)
02 Important - Versions and compatibility (11.4 MB)
03 Download the course exercise files (3.74 MB)
04 Set expectations (4.97 MB)
05 The power Excel workflow (10.02 MB)
06 The best thing to happen to Excel in 20 years (23.35 MB)
07 When to use Power Query and Power Pivot in Excel (2.34 MB)
08 Power Query introduction (2.54 MB)
09 Meet Power Query aka Get & Transform (7.27 MB)
10 The Query Editor (8.86 MB)
11 Options for loading data in Excel (4.34 MB)
12 Basic Power Query table transformations (24.95 MB)
13 Text-specific query editing tools (32.02 MB)
14 Number-specific query editing tools (23.2 MB)
15 Date-specific query editing tools (22.5 MB)
16 Create a rolling calendar with Power Query (13.71 MB)
17 Add index and conditional columns with Power Query (21.61 MB)
18 Group and aggregate data with Power Query (18.94 MB)
19 Modify Excel workbook queries (12.38 MB)
20 Merge queries (22.56 MB)
21 Append queries (16.84 MB)
22 Connect Excel to a folder of files (27.7 MB)
23 Excel Power Query best practices (7.5 MB)
24 Pivot and unpivot data with Power Query (23.73 MB)
25 Next steps (2.01 MB)
Ex Files Excel Business Intelligence Part 1 Power Query (21.55 MB)