Excel PivotTables - Part I (4 hours)

Previous Add to Calendar Next

Jul 13, 2020

Registration: 6:30 AM / Program: 7:00 AM - 11:00 AM Pacific Time

Fees

Member Fee: $0.00
Nonmember Fee: $0.00

Available Discounts

AICPA Member: None
Full time Accounting Educator: None

Description

PivotTables are the most powerful feature of Excel, yet few business professionals use them in their day-to-day activities. For some, PivotTables are too intimidating; for others, PivotTables are a foreign concept. With a little information, guidance, and demonstration from your instructor, you will be ready to take advantage of PivotTables to perform routine data analysis and reporting more quickly and more effectively than ever. In this session, you will learn the nuts-and-bolts of PivotTables, setting the stage for greater productivity than perhaps you can even imagine!

Designed For

Accounting, financial, and other business professionals who want to use the power of Excel PivotTables to analyze and summarize data

Objectives

*Identify and define the six main elements of a PivotTable report *Create PivotTables that summarize large volumes of data *Apply specific formatting techniques to PivotTables *Create a PivotTable that links data from an external data source, such as an accounting database *Consolidate multiple ranges of data quickly and easily using PivotTables

Major Subjects

*Accounting *Computer Software & Applications

This event has already passed. If you have any questions, please contact us at 503-641-7200 or email profdev@orcpa.org.