Excel PivotTables - Part I

Course Details

Date

Wednesday, October 14, 2020

8:00am – 12:00pm

Course Number

AC0423

CPE Credit

4.0 hours CPE credit

Level of Knowledge

Intermediate

Vendor

ACPEN

Prerequisites

Fundamental knowledge of Microsoft Excel

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!

Highlights

*Accounting
*Computer Software & Applications

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

Designed For

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

Registration for this course has passed.

Course Pricing

Member Fee

Applicable if you are a HSCPA member in good standing.

$129.00
Non-Member Fee

Applicable if you are not a HSCPA member.

$159.00
Your Price $159.00

CPE Choice

Learn more about CPE Choice.
This course does not qualify for CPE Choice.

View All Webcasts