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.

Technical

Streamlined Excel Reporting Series Logo aicpa

  $299.00 - 399.00 |   18 Mar 2019 |   13:00-15:00 |   CPE: 8.0 |   AICPA |   AICPA Store
The PivotTable: One of Excel's most powerful features
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.
Key Topics
  • PivotTable fundamentals
  • How to create a PivotTable report and a PivotChart
  • How to build PivotTables from data extracts and external databases
  • How to use Excel features to graphically communicate information
Who Will Benefit?
  • All accounting and finance professionals

If you've ever struggled to make sense of a wealth of data in an Excel spreadsheet, PivotTables can help. A PivotTable allows you to manipulate and clarify what's meaningful in your data and then share what's important in your spreadsheet-or data visualization.

Let's face it: It can be hard to find time to learn new Excel techniques. Our Streamlined Excel Reporting Series offers four webcast sessions to quickly build your PivotTable skills. You'll get step-by-step demonstrations to create and use PivotTables to become a more productive and effective financial professional.

Learn how to create and customize PivotTables

Once you've learned about the power of PivotTables, you'll find them intuitive and invaluable in organizing and summarizing data. The features, functions, and techniques presented in this series are sure to shave time off of your reporting tasks-and boost your ability to determine what's most significant from your analysis.

These webcasts explore smart ways to build PivotTables from:
  • Data extracts
  • Linked external databases
  • Financial accounting systems
We'll also explore Excel features that help communicate your insights graphically. Important Information on Your CPE Credit

Your registration includes access to the all four of the Streamlined Excel series webcasts on PivotTables through December 2018. If you are unable to attend one or more broadcasts in the series, you'll 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

Comments/Reflections