Loading Events

« All Events

Number Crunching with Excel Pivot Tables

May 18, 2027 @ 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

Tuesday, May 18, 2027 ยท Virtual Live

Register Now →

Course Details

FormatVirtual Live
LocationVirtual Live (Online)
Date & TimeTuesday, May 18, 2027
12:00 PM โ€“ 4:00 PM ET
Price$319Member ยท Non-member: $439
FacilitatorKen Worthy
Seats28 seats
28 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

  • Virtual Live (Online)

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