Show Menu

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

Webinar

New

K2's Eight Awesome PivotTable Features

Thursday, Sept. 17, 2026
11:30 a.m.-3:30 p.m. Central
4 CPE (4 non-technical)

Course code: 26SR-P017
View pricing

Register Me     Register Multiple

Firm administrators: Please log in before starting the employee registration process.


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. Learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, explore how to get the most out of your PivotTables. Walk away with examples of the great things you can do with PivotTables.

Major subjects

  • Creative ways to filter PivotTables.
  • Linking accounting software data into PivotTables.
  • Using PivotTables to consolidate "standard" Excel reports.
  • Creative ways to filter PivotTables.
  • Linking accounting software data into PivotTables.

Learning objectives

  • 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.

Who should take this program?

  • Business professionals seeking to strengthen their knowledge of PivotTables' functionality.

Pricing

Standard Member Fee $220.00
checkmark Standard Nonmember Fee $270.00

MNCPA members save $50.00. Become a member.

Our records indicate you are a nonmember. If you register, you will be charged $270.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.
Register Me     Register Multiple

Firm administrators: Please log in before starting the employee registration process.

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 (4.0)
Level Intermediate
Format Group Internet Based
Sponsor Minnesota Society of CPAs
NASBA ID#: 139884
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

Related programs

May 13, 2026 | K2's Excel Essentials for Staff Accountants | Webinar

May 13, 2026 | K2's Excel PivotTables for Accountants | Webinar

May 13, 2026 | Complete Guide to Analyze Data with Excel PivotTables | Webinar

May 13, 2026 | Mastering the Excel Lookup Functions | Webinar

May 14, 2026 | Excelling at Excel: Tips, Tricks and Updates | Webinar


Related products

Advanced Excel for Staff: Build Reports and Analyze Data | Self-Study (On-Demand)

Complete Guide to Analyze Data With Excel PivotTables | Self-Study (On-Demand)

Finding Errors in Excel Spreadsheets | Self-Study (On-Demand)

Mastering the Excel Lookup Functions | Self-Study (On-Demand)

Shortcuts That Excel Users Love | Self-Study (On-Demand)


Search CPE catalog