PivotTables are the most powerful feature of Excel, yet few business professionals use them in their day-to-day activities. For some, PivotTables are too intimidating; for others, PivotTables are a foreign concept.

With a little information, guidance, and demonstration from your instructor, you will be ready to take advantage of PivotTables to perform routine data analysis and reporting more quickly and more effectively than ever.

In this session, you will learn the nuts-and-bolts of PivotTables, setting the stage for greater productivity than perhaps you can even imagine!

Agenda / Covered Topics

• Identify and define the six main elements of a PivotTable report
• Create PivotTables that summarize large volumes of data
• Apply specific formatting techniques to PivotTables
• Create a PivotTable that links data from an external data source, such as an accounting database
• Consolidate multiple ranges of data quickly and easily using 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.