MenuClose
 Log Out
Cart 0 items
Site Search
Course Search

K2'S Eight Awesome PivotTable Features

 Various
 
2.0
Registration is Open
Member Price
$79.00 Regular Registration
Your Price
$109.00 Regular Registration
This course is being offered on multiple dates, listed below. Click the Register button next to your preferred date to register.
 Mon, 06/09/2025 from 10:00 am to 12:00 pm
 Fri, 06/27/2025 from 12:00 pm to 2:00 pm
 Thu, 07/03/2025 from 4:00 pm to 6:00 pm
 Thu, 07/31/2025 from 2:00 pm to 4:00 pm
 Sat, 08/09/2025 from 10:00 am to 12:00 pm
 Wed, 08/27/2025 from 12:00 pm to 2:00 pm
 Thu, 09/04/2025 from 4:00 pm to 6:00 pm
 Tue, 09/30/2025 from 2:00 pm to 4:00 pm
 Thu, 10/09/2025 from 10:00 am to 12:00 pm
 Mon, 10/27/2025 from 12:00 pm to 2:00 pm
 Tue, 11/04/2025 from 4:00 pm to 6:00 pm
 Mon, 11/24/2025 from 2:00 pm to 4:00 pm
 Tue, 12/09/2025 from 10:00 am to 12:00 pm
Designed For:

Business professionals seeking to improve their knowledge of Excel PivotTables

Prerequisite:

Working knowledge of PivotTables created using Microsoft Office Excel

Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel’s most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you’ll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we’ll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.

Delivery Method: Individual webcast
CPE Credit: Computer software & applications
Program Level: Intermediate

Sponsors

For Technical Support: 
Please contact the ACPEN Help Desk at (877) 602-9877, [email protected]   or visit https://vscpa.acpen.com/Support/. The Help Desk is available by phone 24/7, 365 days a year. Allow 1 business day for email

Objectives

  • Identify three types of user-defined calculations in PivotTables
  • List the steps necessary to add Key Performance Indicators to PivotTables
  • Name at least two benefits of using PivotTables for data consolidation needs
  • Differentiate between Slicer and Timeline filters
  • Cite examples of potential benefits associated with linking data into PivotTable reports

Speakers

Advanced Preparation

None

Vendor

The Virginia Society of CPAs (VSCPA) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: NASBARegistry.org.

For more information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call (800) 733-8272.