Section 1 : Introduction

Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 2 What to know before starting this course 0:55

Section 2 : What Is Power Query (Get & Transform)

Lecture 3 Power Query example 6:48
Lecture 4 Differences between Excel and Power Query 3:55

Section 3 : Working with Queries

Lecture 5 Data types explained 4:42
Lecture 6 Query data from a table or range
Lecture 7 Query data from another Excel file 2:28
Lecture 8 Load data only as a connection 3:24

Section 4 : Working with Columns

Lecture 9 Fill up and fill down 2:16
Lecture 10 Split column by delimiter 3:9
Lecture 11 Split into rows 1:47
Lecture 12 Add conditional and custom columns 4:51
Lecture 13 Add column by example 4:31
Lecture 14 Merging columns 3:38
Lecture 15 Sorting and filtering data in Power Query 2:44

Section 5 : Working with Formulas

Lecture 16 Use IF formulas
Lecture 17 Nest IF and AND 2:4
Lecture 18 AddDays to determine deadline 2:44

Section 6 : Pivoting and Unpivoting Data

Lecture 19 Pivot data in Power Query 1:29
Lecture 20 Pivot and append data 2:52
Lecture 21 Pivot—Don't aggregate 2:1
Lecture 22 Unpivot data in Power Query 2:8

Section 7 : Grouping

Lecture 23 Group data 1:57

Section 8 : Appending Queries

Lecture 24 Two data sets 2:17
Lecture 25 Multiple tables 3:18
Lecture 26 Query data from a folder and import multiple files 3:12
Lecture 27 Combining table with different headers 2:18
Lecture 28 Append multiple sheets 2:55

Section 9 : Merging Data with Joins

Lecture 29 Overview of joins in Power Query 3:11
Lecture 30 Full outer join 4:3
Lecture 31 Inner join 2:18
Lecture 32 Left anti join
Lecture 33 Right anti join 2:31
Lecture 34 Left outer join
Lecture 35 Right outer join 2:0
Lecture 36 Outer join versus VLOOKUP 2:54
Lecture 37 Merge with multiple fields 3:4
Lecture 38 Joins Left or right 2:13
Lecture 39 Approximate match equivalent of VLOOKUP Binning 2:38
Lecture 40 Approximate match equivalent of VLOOKUP Conditional column 2:31

Section 10 : Drill Down to Use Variables

Lecture 41 Drill down to create a variable in Power Query 5:26

Section 11 : Fuzzy Matching

Lecture 42 Matching inconsistent entries by percentage
Lecture 43 Merging inconsistent data with a transformation table 4:29

Section 12 : Custom Data Types

Lecture 44 Make and use custom data types 7:48

Section 13 : Apply Your Learning with Real-World Challenges

Lecture 45 Easy real-world challenge 1 Pies and prices 7:19
Lecture 46 Easy real-world challenge 2 Volunteer hours 5:8
Lecture 47 Monster real-world challenge Tracking donations 8:26