Many refer to PivotTables as Excel’s most powerful function. In this webcast, you will learn how to use the advanced power of the PivotTable to solve many of your data analysis problems. You will learn how to analyze data using specific PivotTable tools such as Field Settings, Calculated Fields and Items, Grouping, Sorting, and Filtering. You will also discover how PivotCharts extend the functionality of PivotTables and help you communicate key data. Have you been confused by GETPIVOTDATA? Learn how to use it to extract valuable information from a PivotTable. Don’t miss this opportunity to build upon your knowledge of this powerful data analysis and reporting tool.

Who Should Attend
Accountants and financial professionals who want to use the power of Excel PivotTables to analyze and summarize data.

Topics Covered

• Creating basic and advanced PivotTables
• Performing calculations within PivotTables
• Customizing field settings and table options
• Formatting PivotTable reports
• Using external data sources
• Creating consolidation PivotTables

Learning Objectives

• Use PivotTables for analyzing and reporting accounting information
• Understand the limitations of PivotTables
• Take advantage of the advanced features of PivotTables

Level
Advanced

Format
Live webcast

Instructional Method
Group: Internet-based

NASBA Field of Study
Specialized Knowledge and Applications (2 hours)

Program Prerequisites
Good working knowledge of Excel

Advance Preparation
None