Excel PivotTables - Part I

The start date for this course has passed. Registration is no longer available.

This course is 4.00 credits
Fields of Study
Accounting, Technology
Course Level
Intermediate
Vendor
BPN, Inc ACPEN

Registration Fees

MSCPA-AICPA Member
$129.00
MSCPA Member
$129.00
AICPA Member
$159.00
Non-Member
$159.00
Return to Webinars List

Monday, Jun 8, 2020
10:00am – 2:00pm

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!

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

Course 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

Prerequisites

Fundamental knowledge of Microsoft Excel

The start date for this course has passed. Registration is no longer available.