08:03

7.9- Referencing Another Query in M Code

08:31

7.8- Add or Expand Rows

08:07

7.7- Variables | Power Query | Excel

13:11

7.6- Manage Parameters | Power Query | Excel

05:27

7.5- Formula Firewall Errors | Power Query | Excel

08:08

7.4- Dynamic File Paths | Power Query | Excel

11:40

7.3- Dynamic Folder Paths | Power Query | Excel

10:35

7.2- Scrape Data from Multiple Web Pages | Power Query | Excel

11:06

7.1- Parameter Tables for Filtering | Power Query | Excel

02:57

6.10- Conditional Columns | Power Query | Excel

05:09

6.9- Replicating IF OR and IF AND in Power Query | Power Query | Excel

04:04

6.8- if and Nested if Function | Power Query | Excel

05:43

6.7- Error Trapping | Power Query | Excel

01:53

6.6- Commenting Code | Power Query | Excel

05:44

6.5- Tips for Writing M | Power Query | Excel

06:20

6.4- Splitting Text | Power Query | Excel

07:59

6.3- Using a Function to Add a Custom Column | Power Query | Excel

03:00

6.2- Where to Edit and Write M | Power Query | Excel

02:25

6.1- Introduction to M | Power Query | Excel

04:58

5.4- Load Direct to Power Pivot Excel 2010 | Power Query | Excel

05:53

6.4- Reading M | Power Query | Excel

03:35

6.5- Writing M | Power Query | Excel

02:46

6.6- Type System | Power Query | Excel

08:34

6.7- Lists and Records

02:41

5.3- Load Settings & Automatic Refresh | Power Query | Excel

04:21

5.2- Loading to Data Model Power Pivot Excel 2013 Onward | Power Query | Excel

05:55

5.1- Loading to the Workbook Options | Power Query | Excel

04:00

4.22- Data Profiling | Power Query | Excel

09:19

4.21- Reuse and Share Queries | Power Query | Excel

05:50

4.20- Add Column From Examples | Power Query | Excel

03:54

4.19- Duplicating & Referencing Another Query | Power Query | Excel

02:54

4.18- Transpose | Power Query | Excel

17:10

4.17- Unpivot | Power Query | Excel

06:29

4.16- Grouping | Power Query | Excel

05:50

4.15- Adding Custom Date & Time Columns | Power Query | Excel

04:26

4.14- Adding Custom Calculated Columns | Power Query | Excel

07:44

4.13- Adding Custom & Index Columns | Power Query | Excel

05:36

4.12- Transforming Dates | Power Query | Excel

03:20

4.11- Transforming Text & Numbers | Power Query | Excel

01:59

4.10- Replace & Fill | Power Query | Excel

01:57

4.9- Sorting | Power Query | Excel

03:24

4.8- Remove Duplicates & Errors | Power Query | Excel

04:57

4.7- Filtering Rows | Power Query | Excel

01:25

4.6- Merging Columns | Power Query | Excel

09:09

4.5- Splitting Columns | Power Query | Excel

02:35

4.4- Columns Move, Remove, Rename & Duplicate | Power Query | Excel

04:46

4.3- Fixing Dates with the Locale Setting | Power Query | Excel

03:18

4.2- Data Types | Power Query | Excel

02:48

4.1- Editing Queries | Power Query | Excel

04:04

3.4- Query Dependencies View | Power Query | Excel

07:25

3.3- Appending Queries | Power Query | Excel

07:01

3.2- Worksheets Not Correctly Formatted | Power Query | Excel

03:34

3.1- Multiple Excel Tables or Named Ranges | Power Query | Excel

15:34

2.9- From OneDrive and SharePoint | Power Query | Excel

05:23

2.8- Data Catalog Search | Power Query | Excel

02:14

2.7- From Other Sources | Power Query | Excel

06:54

2.6- From Database SQL | Power Query | Excel

11:42

2.5- From Folder | Power Query | Excel

03:30

2.4- From CSV or Text File | Power Query | Excel

05:03

2.3- From Current Workbook | Power Query | Excel