K2's Eight Awesome PivotTable Features
Thursday, July 31, 2025
1-3 p.m. Central
2 CPE (2 non-technical)
Course code: 25WA-4697
View pricing
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.
Major subjects
-
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
Learning 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
Who should take this program?
- Business professionals seeking to improve their knowledge of Excel PivotTables
Pricing
|
Standard Member Fee |
$79.00
|
 Standard Nonmember Fee |
$79.00
|
Our records indicate
you are a
nonmember.
If you register, you will be charged
$79.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Instructor
Tommy Stephens, CPA, CITP, CGMA
Location
Online
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (2.0)
Level
Intermediate
Format
Group Internet Based
Sponsor
NASBA ID#: 107810
Prerequisites
Prereq.
Working knowledge of PivotTables created using Microsoft Office Excel
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business
days before the event start date.
Learn more
Search CPE catalog
