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

Excel - Using PivotTables for Data Analysis Logo aicpa

  $179.00 - 229.00 |   21 Oct 2019 |   11:00-15:00 |   CPE: 4.0 |   AICPA |   Computer Science |   AICPA Store
Key Topics
  • The advantages of PivotTable for data analysis
  • Step-by-Step PivotTable creation
  • Creating PivotCharts
Learning Objectives
  • Understand the advantages of using PivotTables to analyze data from multiple dimensions.
  • Create a PivotTable using a step-by-step process that will analyze accounting data.
  • Use all PivotTable options to maximize your data analysis.
  • Create PivotCharts to present your data graphically for the most effective analysis.

Excel is the #1 data analysis tool for accountants. However, many accountants have never learned the basics of Excel's data analysis tools.

In this webcast, you will learn how PivotTables are crucially important for analyzing data. We will show you examples of PivotTables to demonstrate that data analysis can be an easy task for any accountant. You will learn the step-by-step process to create PivotTables and PivotCharts. To make sure you're prepared for future analysis, we will even cover all the setup options and features.

Important Information on Your CPE Credit

Topics covered:
  • Management accounting: Technical: Accounting information systems: Information systems environment, Intermediate
  • Management accounting: Digital skills: Data analytics, Intermediate

Comments/Reflections