Excel-Using PivotTables for Data Analysis

Printer Friendly
Text Size: A A A A
 

Online registration for this course is now closed. Please contact the Member Service Center at
(800) 342-3197 if you wish to inquire about registering.

Back New Search

Overview

4.0 Credits
ONLINE

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.

Objectives

When you complete this webcast, you will be able to:

- 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.

Major Topics

The major topics that will be covered in this webcast include: - The advantages of PivotTable for data analysis - Step-by-Step PivotTable creation - Creating PivotCharts

Designed For

Accounting and finance professionals who'd like to improve their mastery of Microsoft Excel

Prerequisite

A working knowledge of Excel features and functions