Eight Awesome PivotTable Features - Virtual (C74794)

Log In to Register

Cancellation Policy

Please note that this course is from a third party vendor, K2 Enterprises. We strongly recommend registering no later than one-hour before the course begins. Please contact K2 if you have questions at least 24 hours before the course begins: [email protected]. Thank you.

Date(s):

05/06/2026

Registration Open:

11:15 AM - 11:30 AM

Time:

11:30 AM - 3:30 PM

Facility:

 Online

Meeting Type:

Courses

CPE Credit:

4.00

Field(s) Of Study:

Computer Software and Applications (4.00)

Level of Knowledge:

Intermediate

Price:

Member: $260.00
Nonmember: $345.00

Individual Discounts:

Not Available

Group Discounts:

10+ Registrants - Discount: 5.00%
20+ Registrants - Discount: 10.00%

Overview

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.

·         Name at least two benefits of using PivotTables for data consolidation needs

·         List the steps necessary to add Key Performance Indicators to PivotTables

·         Differentiate between Slicer and Timeline filters

·         Identify three types of user-defined calculations in PivotTables

·         Cite examples of potential benefits associated with linking data into PivotTable reports

 

Highlights

  • Adding user-defined calculations to PivotTables
  • Enhancing PivotTables with Key Performance Indicators
  • Using PivotTables to consolidate “standard” Excel reports
  • Creative ways to filter PivotTables
  • Linking accounting software data into PivotTables

Speaker(s)

Prerequisites

Working knowledge of PivotTables created using Microsoft Office Excel