Eight Awesome PivotTable Features

Eight Awesome PivotTable Features - Virtual

Create Account

Availability

Registration Required

Online Meeting

Sep 17, 2026 11:30 AM - 3:30 PM CT

Cost

Member: $260.00

Non-Member: $345.00

Retired: $260.00

Educator & Government & Non-Profit Member: $260.00

Credit Offered

4 CPE Credits

Field of Study:

4 Computer Software & Applications

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.

Upon completing this course, you should be able to:

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

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

Working knowledge of PivotTables created using Microsoft Office Excel

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: webinar@k2e.com. Thank you.