Register your product to gain access to bonus material or receive a coupon.
Accessible from your Account page after purchase. Requires the free QuickTime Player software.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
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