K2'S Eight Awesome PivotTable Features
Thursday, June 20, 2024
Webcast or Webinar, Online
11:00AM - 12:56PM (opens at 10:30AM) EST
2Credits
Technical Business
Registration is Open
Members
$79.00 Regular Price
Non-Members
$109.00 Regular Price
CPE PowerPass Users
Click the "Apply PowerPass" button to use your PowerPass for the applicable course below.
$40.00 Members / $56.00 Non-Members
Don't have a CPE PowerPass? Click
here to find out more about the CPE PowerPass program.
Course Type: Webcast
Course Code: 24/AC122391
Level: Intermediate
Vendor: ACPEN
Field of Study: Computer Software and Applications
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.
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
Major Topics:
- 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
Major Topics:
- 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