All 2020 CPE and networking events have been moved online. Visit our updated catalog »

Webinar(CA): Working with Excel® PivotTables – Powerful and Not Hard to Use…Really!

Description

Excel users that manipulate, analyze or present data can improve their productivity with PivotTables. Many avoid them, believing they’re confusing and hard to use. Others don’t realize the depth of their capabilities.
Gain an understanding of PivotTable conventions, overcome your intimidation, and master robust features. Also, discover Excel Tables as both a stand-alone feature and as a means to enhance PivotTable reporting.

Learning Objectives

Recognize the underlying concepts and conventions that drive PivotTable operation
List four important components used when creating and working with PivotTables
Identify the benefits of using Excel Tables, not only with PivotTables but as stand-alone objects
Explain ways to improve data presentation in PivotTables with:
Recognize automatic and custom groups
Identify PivotTable options
Identify the Design tab of the PivotTable tools ribbon add-In
Recognize formatting, sorting and filtering features in Excel
Understand calculations including calculated fields and calculated items
Create and modify PivotCharts

Major Topics

Introducing PivotTables
Working with Excel tables
Connecting PivotTables to external data
Extended PivotTable functionality
Creating calculations in PivotTables
Using PowerPivot and creating PivotCharts

Provider
California CPA Education Foundation
Course Level
Intermediate
CPE Field of Study
Computer Software and Applications
8
Who Should Attend

Excel users.

Instructor(s)
Karl Egnatoff
Prerequisites

An understanding of Excel conventions.

Advanced Preparation

None

Location
Webinar
Register Now
When
Dec 10, 2020
7:30 am - 3:30 pm MDT
Location
Webinar
Total CPE Credits
8
Format
Webinar

MEMBER


$ (% off)
$295.00

NON-MEMBER


$ (% off)
$400.00
Become A Member

Register for this Event

Webinar(CA): Working with Excel® PivotTables – Powerful and Not Hard to Use…Really!


Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×