Power Pivot Basics

Description

Although traditional PivotTables are incredible, 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 session, 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

• Power Pivot
• Data Model
• PivotTables
• Measures
• Table Relationships
• Calculated Columns
• Cube Functions

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

CPAs, accountants and staff.