Online Directory | NACVA Site Search:

Accelerate Excel: Pivot Tables

Practice Management

 Accelerate Excel: Pivot Tables
CPE Credit

Program Type: Recorded Webinar (Audio, PPT Presentation)
Program Level: Basic
Prerequisites: Previous training or experience.
Advanced Preparation: None
Delivery Method: Group Internet-Based
CPE Credits: Two (2) Hours
Fields of Study: Computer Software & Applications
Item Number: 14PPM1006C
Shipping Weight: 0lbs. 0oz.
Price: $110.00
Program Description

In this webinar Excel expert David Ringstrom, CPA brings you up to speed on an often-overlooked, yet easy to use feature in Excel. In this webinar David teaches from Excel 2010, but includes handouts specific to Excel 2013, Excel 2010, Excel 2007, and Excel 2003 so that you'll easily be able to carry out techniques related to pivot tables and pivot charts.

Learning Objectives

After completing this webinar, attendees will be able to:

- Format unwieldy data into pivot table for analysis
- Create pivot tables
- Avoid frustration by understanding the nuances of pivot table formatting
- Dig deeper into the numbers by using the Report Filter command to create break-out tables
- Drill down into numbers with a double-click--or prevent users from being able to do so
- Incorporate calculations within, or alongside, pivot tables
- Disable the GETPIVOTDATA function if you don't need it for your analysis
- Summarize complex data sets with Excel's Pivot Chart feature
- Master the nuances of keeping your pivot table data correct and accurate
- Summarize information from Access databases and other sources
- Mitigate the side effects of converting a table back to a normal range of cells
- Filter pivot tables faster by way of the Slicers feature in Excel 2010 and 2013
- Utilize the PowerPivot feature in Excel 2010 and 2013
- Transform lists of raw data into usable reports in just a few simple steps
- Format and analyze pivot table data with ease
- Explore the Slicers feature introduced in Excel 2010, as well as Recommended Pivot Tables in Excel 2013

Who Should Attend

Practitioners who may benefit from quicker data manipulations


David H. Ringstrom, CPA
Mr. David Ringstrom is President and Founder of Accounting Advisors, Inc. He started the firm in 1991 and provides consulting and training services nationwide. He is a nationally recognized Microsoft® Excel expert, and regularly teaches live webinars on spreadsheets and other topics. David has written freelance articles on Microsoft® Excel and accounting software for over 15 years, and he has served as the technical editor for over 25 accounting software reference books.