Excel Power Query Syllabus Sales

Excel Power Query Course Syllabus - 6hrs 33min


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 Sources1:04:29

2.01 From Web 0:06:35
2.02 From Excel File 0:07:41
2.03 From Current Workbook 0:05:02
2.04 From CSV or Text File 0:03:29
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
2.09 From OneDrive and SharePoint Online 0:15:33

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:52:27

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:06:28
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
4.21 Reuse and Share Queries 0:09:18
4.22 Data Profiling 0:03:59

Session 5: Data Destinations & Refereshing Queries 0:17:51

5.01 Loading to the Workbook Options 0:05:54
5.02 Loading to the Data Model or Power Pivot 0:04:20
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:05:48

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
6.14 Conditional Columns 0:02:56

Session 7: Parameter Tables & Custom Functions1:24:36

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
7.07 Variables 0:08:08
7.08 Add or Expand Rows 0:08:26
7.09 Referencing Another Query in M Code 0:08:02