Use Power Pivot to Build More Powerful Pivot Tables WEBCAST

Monday, September 21 10:00am - 12:00pm PDT

Add to Calendar

Your Desk

2 Credits

Member Price $99.00

Non-Member Price $119.00

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. Key Topics: Review the Power Pivot function.

Highlights

Review the Power Pivot function

Prerequisites

NONE

Objectives

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

Preparation

NONE

Notice

NONE

Leader(s):

Leaders

Jeff Lenning

Jeff Lenning, CPA, CITP Click Consulting / Seal Beach, CA

Jeff Lenning, author of Excel University, is an award-winning Excel instructor who has provided continuing education to thousands of CPAs nationwide over the past 10 years.

He is a Microsoft Certified Excel Expert, and his Excel articles have been featured in trade publications such as the Journal of Accountancy and California CPA.

He is a former chair of the California CPA State Technology Committee, and has held a variety of other leadership positions within his local CalCPA chapter.

He worked at Arthur Andersen, Gateway computers, and Interpore Cross International. In 2000, he started Click Consulting, a technology consulting firm.

Return to Top

Non-Member Price $119.00

Member Price $99.00