Show Menu

Help  |  Pay an Invoice  |  My Account  |  CPE Log  |  Log in

Webinar

K2's Eight Awesome PivotTable Features

If you have questions about this event, please call us at 952-831-2707.

Thursday, June 11, 2026
11 a.m.-12:55 p.m. Central
2 CPE (2 non-technical)

Course code: 26WA-3356
View pricing

Alternate dates & more options


Unlock the full potential of Excel's most powerful feature-PivotTables! While many users rely on them daily, few tap into the advanced capabilities that can transform data into dynamic insights. Join us for an eye-opening session where you'll discover eight game-changing PivotTable techniques that go far beyond the basics. From custom calculations and KPI integration to multi-source consolidation and advanced reporting tricks, we'll show you how to elevate your analytics and impress stakeholders. Whether you're a seasoned Excel user or just getting started, this session will equip you with the tools to turn ordinary PivotTables into extraordinary decision-making engines. Don't just use PivotTables-master them!

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.
  • Differentiate the steps necessary to add Key Performance Indicators to PivotTables.
  • Identify at least two benefits of using PivotTables for data consolidation needs.
  • Differentiate between Slicer and Timeline filters.
  • Distinguish 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 $89.00
checkmark Standard Nonmember Fee $89.00
Our records indicate you are a nonmember. If you register, you will be charged $89.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.

More program information

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 Business Professionals' Network, Inc.
NASBA ID#: 107810
Prerequisites Prereq. Working knowledge of PivotTables created using Microsoft 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

If you have questions about this event, please call us at 952-831-2707.