This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.


Streamlined Excel Reporting Series Logo aicpa

  $299.00 - 399.00 |   10 Oct 2018 |   11:00-16:00 |   CPE: 8.0 |   AICPA |   AICPA Store

PivotTables are one of Excel's most powerful features. A PivotTable allows you to extract the significance from a large, detailed data set. The Streamlined Excel Reporting Series includes four webcasts that will guide you through step-by-step demonstrations on how to create and use PivotTables to increase your productivity and effectiveness as a finance professional. You will learn efficient ways to build PivotTables from data extracts and dynamically linked external databases and financial accounting systems. We will also examine various Excel features that enable you to communicate your message graphically. The features, functions, and techniques presented in this series are sure to shave valuable time off of your reporting tasks.

Learning Objectives
  • State the process to create a PivotTable report and a PivotChart
  • Distinguish between formula-based and PivotTable reports
  • Identify three Excel features that can graphically communicate information

Webcasts included in this series:

Session 1: PivotTable Fundamentals

Wednesday, October 10
11:00 AM - 1:00 PM ET

Session 2: Working with PivotTables

Wednesday, October 10
2:00 PM - 4:00 PM ET

Session 3: PivotTable Wrap-Up and Web Data

Thursday, October 11
11:00 AM - 1:00 PM ET

Session 4: External Data and PivotCharts

Thursday, October 11
2:00 PM - 4:00 PM ET

The registration on this page is for all 4 parts.

Important Information on Your CPE Credit

Your registration includes access to the entire Streamlined Excel series webcasts thru December 2018. If you are unable to attend one or more broadcasts in the series, you will be able to attend a later session and still earn the CPE credit.

Topics covered:
  • Management accounting: Technical: Accounting information systems: Information systems environment, Foundational
  • IT management & assurance: Technical: Information management: Data management & analytics, Foundational