Actual product comes full screen and in high resolution.
In these seven lessons, discover power query techniques such as Adding Calculated Columns to Select Queries; Applying Advanced Criteria; Creating and Running Parameter Queries; and Working with Outer Joins.
Section 8 Power Query Techniques
Lesson 39: Adding Calculated Columns to Select Queries
Lesson 40: Applying Advanced Criteria
Lesson 41: Creating and Running Parameter Queries
Lesson 42: Creating and Running Action Queries
Lesson 43: Using Aggregate Functions to Summarize Numeric Data
Lesson 44: Working with Outer Joins
Lesson 45: Refining Queries with Field, Field List, and Query Properties