Use Power Pivot to Build More Powerful Pivot Tables

Tuesday, April 20, 2021
Webcast or Webinar, Online
1:00 PM - 3:00 PM EST
2Credits
Technical Business

Registration is Closed

Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.

Members
$99.00 Regular Price
Non-Members
$119.00 Regular Price
Course Type: Webcast
Course Code: 21/AIUPP06
Level: Basic
Vendor: AICPA CPE Division
Field of Study: Computer Software and Applications

Overview:

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.

Objectives:

Recall the steps to access the Power Pivot window

Identify the process to create table relationships

State the procedure for creating measures

Major Topics:

Review the Power Pivot function

Designed For:

Anyone who uses PivotTables

Prerequisite:

none