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 |   04 Jun 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 FundamentalsThursday, April 12
11:00 AM - 1:00 PM ET
Session 2: Working with PivotTablesThursday, April 12
2:00 PM - 4:00 PM ET
Session 3: PivotTable Wrap-Up and Web DataFriday, April 13
11:00 AM - 1:00 PM ET
Session 4: External Data and PivotChartsFriday, April 13
2:00 PM - 4:00 PM ET

The registration on this page is for all 4 parts.

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