Mobile Edition


Excel PivotTables - Part I (ACEPPI15)

 
Date:Wednesday, March 7, 2018
Time:9:00 AM - 1:00 PM
(Registration at 8:30 AM)
Facility:Webcast or Webinar, Online
CPE Credit:2.0 Accounting and Auditing
2.0 Technical Business
Instructor: Thomas G. Stephens
Vendor:ACPEN
Course Level:Intermediate
Early Bird Price:$129.00 FICPA Members, $159.00 Non-Members

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!

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 Topics:
  • Accounting
  • Computer Software & Applications


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

Prerequisite:
Fundamental knowledge of Microsoft Excel

Advanced Preparation:
None

Session/Options

If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: OPEN