Excel-Using PivotTables for Data Analysis

Course Details

Date

Wednesday, June 19, 2019

9:00am – 1:00pm (Registration: 4:01pm)

Location

Online

Field of Study

Technology

CPE Credit

4 hours CPE credit

Level of Knowledge

Intermediate

Vendor

AICPA

Prerequisites

A working knowledge of Excel features and functions

Description

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.

Highlights

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

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.

Designed For

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

Registration for this course has passed.

Course Pricing

WYOCPA Member Fee
$179.00

Non-Member Fee
$229.00

Your Price
$229.00

View All Professional Development Courses