Use Power Pivot to Build More Powerful Pivot Tables

Description

Traditional PivotTables are incredible . but, they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using Power Pivot, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. Power Pivot is included in current versions of Excel for Windows (unavailable in Excel for Mac). Power Pivot enables you to build PivotTables that were previously not practical. In this webcast, we'll build PivotTables from multiple tables and create measures. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use Power Pivot to enhance your reports.

Highlights

Review the Power Pivot function

Objectives

Recall the steps to access the Power Pivot window Identify the process to create table relationships State the procedure for creating measures

Designed For

Anyone who uses PivotTables