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

24WA-1123: K2's Eight Awesome PivotTable Features (Webinar)

Thursday, June 20, 2024
10:00am - 12:00pm Central Time
2 CPE (2 non-technical)

Register Me     Register Multiple

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

Alternate dates & more options

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 objective(s)

  • 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 who are seeking to stay abreast of major technology developments

Fees

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.
Standard Member Fee $79.00
checkmark Standard Nonmember Fee $79.00

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 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
Register Me     Register Multiple

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

Not a member? Join the MNCPA to start saving on CPE and accessing members-only benefits.


Related programs

Jun. 15, 2024 | K2's Accessing And Managing Data In Excel | Webinar

Jun. 15, 2024 | Moving Beyond the Basics of Excel | Webinar

Jun. 15, 2024 | Practical Excel Topics for the Public Accountant | Webinar

Jun. 17, 2024 | K2's Advanced Excel | Webinar

Jun. 17, 2024 | K2's Excel PivotTables for Accountants | Webinar

Search CPE catalog