Section 1 : Introduction
Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM
Lecture 2 What to know before starting this course 00:00:55 Duration

Section 2 : What Is Power Query (Get & Transform)
Lecture 1 Power Query example 00:06:48 Duration
Lecture 2 Differences between Excel and Power Query 00:03:55 Duration

Section 3 : Working with Queries
Lecture 1 Data types explained 00:04:42 Duration
Lecture 2 Query data from a table or range
Lecture 3 Query data from another Excel file 00:02:28 Duration
Lecture 4 Load data only as a connection 00:03:24 Duration

Section 4 : Working with Columns
Lecture 1 Fill up and fill down 00:02:16 Duration
Lecture 2 Split column by delimiter 00:03:09 Duration
Lecture 3 Split into rows 00:01:47 Duration
Lecture 4 Add conditional and custom columns 00:04:51 Duration
Lecture 5 Add column by example 00:04:31 Duration
Lecture 6 Merging columns 00:03:38 Duration
Lecture 7 Sorting and filtering data in Power Query 00:02:44 Duration

Section 5 : Working with Formulas
Lecture 1 Use IF formulas
Lecture 2 Nest IF and AND 00:02:04 Duration
Lecture 3 AddDays to determine deadline 00:02:44 Duration

Section 6 : Pivoting and Unpivoting Data
Lecture 1 Pivot data in Power Query 00:01:29 Duration
Lecture 2 Pivot and append data 00:02:52 Duration
Lecture 3 Pivot—Don't aggregate 00:02:01 Duration
Lecture 4 Unpivot data in Power Query 00:02:08 Duration

Section 7 : Grouping
Lecture 1 Group data 00:01:57 Duration

Section 8 : Appending Queries
Lecture 1 Two data sets 00:02:17 Duration
Lecture 2 Multiple tables 00:03:18 Duration
Lecture 3 Query data from a folder and import multiple files 00:03:12 Duration
Lecture 4 Combining table with different headers 00:02:18 Duration
Lecture 5 Append multiple sheets 00:02:55 Duration

Section 9 : Merging Data with Joins
Lecture 1 Overview of joins in Power Query 00:03:11 Duration
Lecture 2 Full outer join 00:04:03 Duration
Lecture 3 Inner join 00:02:18 Duration
Lecture 4 Left anti join
Lecture 5 Right anti join 00:02:31 Duration
Lecture 6 Left outer join
Lecture 7 Right outer join 00:02:00 Duration
Lecture 8 Outer join versus VLOOKUP 00:02:54 Duration
Lecture 9 Merge with multiple fields 00:03:04 Duration
Lecture 10 Joins Left or right 00:02:13 Duration
Lecture 11 Approximate match equivalent of VLOOKUP Binning 00:02:38 Duration
Lecture 12 Approximate match equivalent of VLOOKUP Conditional column 00:02:31 Duration

Section 10 : Drill Down to Use Variables
Lecture 1 Drill down to create a variable in Power Query 00:05:26 Duration

Section 11 : Fuzzy Matching
Lecture 1 Matching inconsistent entries by percentage
Lecture 2 Merging inconsistent data with a transformation table 00:04:29 Duration

Section 12 : Custom Data Types
Lecture 1 Make and use custom data types 00:07:48 Duration

Section 13 : Apply Your Learning with Real-World Challenges
Lecture 1 Easy real-world challenge 1 Pies and prices 00:07:19 Duration
Lecture 2 Easy real-world challenge 2 Volunteer hours 00:05:08 Duration
Lecture 3 Monster real-world challenge Tracking donations 00:08:26 Duration