Loading Events

« All Events

Number Crunching with Excel Pivot Tables

December 10 @ 12:00 pm - 4:00 pm

$439 non-member · $319 member
TS Thumbnail new 7nv3l8

Register for this session

$439 non-member · $319 member

Add to cart

Technology & Digital Skills

Thursday, December 10, 2026 ยท In Person ยท Charlotte

Register Now →

Course Details

FormatIn Person
LocationCharlotte
Date & TimeThursday, December 10, 2026
12:00 PM โ€“ 4:00 PM ET
Price$319Member ยท Non-member: $439
FacilitatorKen Worthy
Seats10 seats
9 available

Pivot tables are the perfect solution when summarizing and analyzing large amounts of data. You can access a whole new information set in just a few clicks. Pivot tables extract meaning from that endless jumble of numbers on your screen allowing you to group your data differently, drawing helpful conclusions more quickly. If you work with large amounts of data in Excel, you need to know Pivot Tables to work more efficiently.ย ย 

Prerequisites: This course requires that you are familiar with Excel. You should have successfully completed Excel I and II or used the software for over six months.

Program Level: Advanced

Contents:

  • PivotTable Fundamentals
  • Creating a Basic Pivot Table
  • Introduce Slicers and other New Pivot Table Tools
  • Customize the Pivot Table View
  • Layout Changes
  • Changing Summary Calculations
  • Using Running Totals, % Of, and Rank Options
  • Grouping, Sorting, and Filtering Pivot Tables
  • Calculations within Pivot Tables
  • Calculated Fields and Calculated items
  • Using Pivot Charts
  • Advanced Pivot Table Tips & Techniques
  • Solutions to Common Pivot Table Problems

Note: This course will be taught using the windows operating system environment

Ready to Advance Your Career?

Join professionals across the Carolinas who trust Catapult for professional development.

Register Now →

​

Details

Venue

  • Catapult โ€“ Charlotte
  • 9140 Arrowpoint Blvd., Suite 140
    Charlotte, NC 28273 United States

Organizer

  • Ken Worthy

Get sharper HR insights, every month.

Practitioner-written guidance on compliance, leadership, and workplace strategy, sent straight to your inbox.

Prefer something specific? Choose exactly what you get