Excel Power User Module 7: Introduction to PivotTables

Available Until Friday, April 30

Self-study

2.00 Credits

Member Price $69.00

Non-Member Price $89.00

The item(s) you are attempting to remove has already been removed from your cart.

Overview

Accountants and other business professionals who work in Excel extensively become very strong with many aspects of the ubiquitous spreadsheet application. In this course, we’ll highlight many of the powerful tools found in Excel and provide details on how they are beneficial and used. Topics include data connectivity, advanced functions available for formula creation, Tables and PivotTables, and charting tools. Many proficient Excel users only utilize a limited percentage of the available functionality when they work with spreadsheets, which is like tying one’s hands behind his back. This session will help make participants “two-fisted” Excel users!

Highlights

PivotTable basics
Row fields
Value fields
Column fields
Filter fields
Updating data
Groups and subtotals
Value formats

Prerequisites

Excel Power User Modules 6 or knowledge of the topics covered.

Designed For

Accounting professionals who use Excel for Windows.

Objectives

State the process to create a PivotTable report.
Identify the four PivotTable report layout areas.
State which type of PivotTable field will create report filters.

Preparation

None.

Notice

This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by CalCPA. The course expires one year from the purchase date. Format = Online Self-Study.