#### 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