If you are already using PivotTables and are looking to make your reports and analyses even more powerful, then this is the program for you!

In this session, you will build upon your existing knowledge of basic PivotTables to make Excel's best feature even more powerful. More specifically, you will learn how perform such actions as creating user-defined calculation in your PivotTables, advanced data grouping techniques for PivotTable data, how to use Power Pivot to create more advanced PivotTables, and advanced PivotTable tips and techniques to speed the process of creating reports and analyzing data.

Agenda / Covered Topics

• Create PivotTables and PivotCharts and add advanced elements to PivotTables, such as calculated fields and calculated items
• Group PivotTable data based on user-defined fiscal reporting periods
• Create enterprise-class PivotTables from large and complex data sets, using Microsoft's Power Pivot tool
• Utilize advanced sorting and filtering techniques, PivotCharts, and GETPIVOTDATA to analyze PivotTable data
• Describe how to apply specific PivotTable techniques such as Show Report Filter Pages and VLOOKUPs to solve specific issues associated with PivotTables
• Accounting
• Computer Software & Applications

Included Materials

All ACPEN courses include handouts that are available to download. Handouts typically include a version of the slides used by the presenter, as well as a full course manual or other materials.

How To Access Your Course And The Accompanying Materials

You will receive an email directly from ACPEN with instructions for accessing your course and any accompanying materials.

How To Get Your CPE Credits

In order to obtain CPE credit for viewing ACPEN webcasts, you must view the course during the scheduled date and time. Throughout the program, you will be prompted to save three attendance codes per hour. At the conclusion of the program, your CPE Certificate will be issued assuming all attendance codes have been saved and submitted. Detailed instructions for this process are included in the course introduction and in written form as part of course materials.