Number Crunching with Excel Pivot Tables
- Live virtual or in person
- 4 hours
- Instructor-led
Live virtual or in person · 4 hours · Instructor-led
Deep dive into Excel PivotTables for powerful data analysis.
Upcoming sessions
Pick a date and register
Course outline
Topics covered
- 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
About this course
What this course covers
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.
Before you attend. Program Level: Advanced.
Your facilitator
Who teaches this course
Ken Worthy
Facilitator
See the full team of Catapult HR Advisors.
Good to know
Course questions
It is delivered live online and in person at the Charlotte Learning Center. Each session runs 4 hours.
A single seat is $439 for non-members and $319 for members. It is also included with a Class Pass.
Next: Dec 10 · 3 upcoming dates. Pick a date from the list above to register.
Yes. Private delivery is available for your organization, scheduled around your calendar, live online or on site.
Learners also liked
Courses learners usually take next
MS Word Level 2
Next: Dec 3 · 2 upcoming datesView dates & register →Pulling Data using Excel VLOOKUPs and More
Next: Nov 10 · 3 upcoming datesView dates & register →Computer Basics: Windows and more
Next: Apr 28 · 1 upcoming dateView dates & register →Cyber-Security Essentials
Next: Dec 9 · 3 upcoming datesView dates & register →Related training
More Technology & Digital Skills training
MS Excel Level 3
Oct 27 · 9 dates
Live virtual or In person, Charlotte
$459 non-member · $339 member
Delivered live online nationwide, with select courses also meeting in person in Charlotte and Raleigh. Explore training by state: North Carolina · Pennsylvania · Wisconsin · Florida · Maine · New Jersey
MS Excel Tips & Tricks
Nov 19 · 1 date
Live virtual
$459 non-member · $339 member
MS OneNote
See upcoming dates
View dates & register →All Courses & Dates
Browse the full catalog of 101 live, instructor-led courses.
Browse the catalog →Technology & Digital Skills
All technology & digital skills courses with upcoming dates.
Explore →All HR Training
Every Catapult training topic and format.
Browse →Private Group Training
Bring this course to your team on your schedule.
Learn more →Register for Number Crunching with Excel Pivot Tables today
Live online, open to your whole team. Or bring it in-house with private delivery.