Excel Power Query Course Syllabus - 5hrs 32min
Session 1: Introduction 0:10:04
| 1.01 | What is Power Query | 0:03:11 |
| 1.02 | Installing Power Query | 0:02:23 |
| 1.03 | Interface | 0:04:30 |
Session 2: Data Sources0:47:19
| 2.01 | From Web | 0:06:35 |
| 2.02 | From Excel File | 0:07:41 |
| 2.03 | From Current Workbook | 0:04:06 |
| 2.04 | From CSV or Text File | 0:02:48 |
| 2.05 | From Folder | 0:11:41 |
| 2.06 | From Database (SQL) | 0:06:53 |
| 2.07 | From Other Sources (OData Feed) | 0:02:13 |
| 2.08 | Data Catalog Search | 0:05:22 |
Session 3: Combining Multiple Sources 0:37:18
| 3.01 | Multiple Excel Tables or Named Ranges | 0:03:33 |
| 3.02 | Worksheets not Correctly Formatted | 0:07:00 |
| 3.03 | Appending Queries | 0:07:24 |
| 3.04 | Merging Queries | 0:15:18 |
| 3.05 | Query Dependencies View | 0:04:03 |
Session 4: Transforming and Cleaning Data 1:35:56
| 4.01 | Editing Queries | 0:02:47 |
| 4.02 | Data Types | 0:03:17 |
| 4.03 | Fixing Dates with the Locale Setting | 0:04:45 |
| 4.04 | Columns - Move, Remove, Rename & Duplicate | 0:02:34 |
| 4.05 | Splitting Columns and Extracting Text | 0:09:08 |
| 4.06 | Merging Columns | 0:01:24 |
| 4.07 | Filtering Rows | 0:04:55 |
| 4.08 | Remove Duplicates & Errors | 0:03:23 |
| 4.09 | Sorting | 0:01:56 |
| 4.10 | Replace & Fill | 0:01:58 |
| 4.11 | Transforming Text & Numbers | 0:03:19 |
| 4.12 | Transforming Dates | 0:05:35 |
| 4.13 | Adding Custom & Index Columns | 0:07:43 |
| 4.14 | Adding Custom Calculated Columns | 0:04:25 |
| 4.15 | Adding Custom Date & Time Columns | 0:05:49 |
| 4.16 | Grouping | 0:03:14 |
| 4.17 | Unpivot | 0:17:09 |
| 4.18 | Transpose | 0:02:53 |
| 4.19 | Duplicating & Referencing Another Query | 0:03:53 |
| 4.20 | Add Column From Examples | 0:05:49 |
Session 5: Data Destinations & Refereshing Queries 0:15:44
| 5.01 | Loading to the Workbook Options | 0:04:07 |
| 5.02 | Loading to the Data Model or Power Pivot | 0:04:00 |
| 5.03 | Load Settings & Automatic Refresh | 0:02:40 |
| 5.04 | Load Directly into Power Pivot in Excel 2010 | 0:04:57 |
Session 6: M Language 1:01:42
| 6.01 | Introduction to M | 0:02:24 |
| 6.02 | Where to Edit and Write M | 0:02:59 |
| 6.03 | Using a Function to add a Custom Column | 0:07:58 |
| 6.04 | Reading M | 0:05:52 |
| 6.05 | Writing M | 0:03:34 |
| 6.06 | Type System | 0:02:45 |
| 6.07 | Lists and Records | 0:08:33 |
| 6.08 | Splitting Text | 0:06:19 |
| 6.09 | Tips for Writing M | 0:05:43 |
| 6.10 | Commenting Code | 0:01:52 |
| 6.11 | Error Trapping | 0:04:12 |
| 6.12 | if and Nested if Function | 0:04:03 |
| 6.13 | Replicating IF OR and IF AND in Power Query | 0:05:28 |
Session 7: Parameter Tables & Custom Functions1:00:02
| 7.01 | Parameter Tables for Filtering | 0:11:08 |
| 7.02 | Scrape Data from Multiple Web Pages | 0:10:32 |
| 7.03 | Dynamic Folder Paths | 0:11:39 |
| 7.04 | Dynamic File Paths | 0:08:07 |
| 7.05 | Formula Firewall Errors | 0:05:26 |
| 7.06 | Manage Parameters | 0:13:10 |
