Home > Store > Data > Access

Power Query Techniques, Downloadable Version

Register your product to gain access to bonus material or receive a coupon.

Power Query Techniques, Downloadable Version

Downloadable Video

  • Your Price: $5.99
  • About this video
  • 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.

Audio & Video

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Description

  • Copyright 2010
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-7897-4706-5
  • ISBN-13: 978-0-7897-4706-8

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.

Sample Content

Table of Contents

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

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership