Mastering Excel Pivot Tables: The Ace Analytical Tool Of Excel Instead
Most Excel users eventually face the big list: employees, customers, products, sales, events or support tickets. The value is in there, such as your most profitable customer type or your most productive support rep, but the list won't reveal it on its own. This 60-minute Excel pivot tables training shows the fast way to get those answers.
You'll start with data layout best practices and PivotTable basics, then build your first PivotTable. From there you'll format and style it, add number formatting and multiple calculations, and filter and focus the data with filters, slicers and timelines.
The session also covers charting with on-the-fly filtering, custom calculated fields and items, and using the Excel Data Model.
- Explain what a PivotTable is and when to use one
- Lay out data correctly and create your first PivotTable
- Format PivotTables and add multiple calculations
- Filter data with slicers and timelines
- Create PivotCharts with on-the-fly filtering
- Build custom calculated fields and items
- Use the Excel Data Model
- Data layout best practices
- What a PivotTable is and why to use one
- Creating your first PivotTable
- Formatting, color-coding and styles
- Number formatting and multiple calculations
- Filtering with filters, slicers and timelines
- Charting and on-the-fly filtering
- Custom calculated fields and items
- Using the Excel Data Model
Without PivotTables, summarizing data takes many steps that you repeat for every new calculation or group. A PivotTable builds a summary in a few clicks and pivots to a new view in a couple more, and several on one page form a dynamic dashboard.
This session suits executives, managers, business analysts, production supervisors and anyone who needs to analyze their part of the business.
- Executives
- Managers
- Business Analysts
- Production Supervisors
- Anybody who needs to analyze their part of the business
Neil Malek runs Knack Training, and Orlando, FL area software and professional development training company. He is a Microsoft Certified Trainer, Adobe Certified Instructor, and CompTIA Certified Technical Trainer with 20 years of working with individuals, small businesses, non-profits, and Fortune 500 companies to identify and close skill gaps. He specializes in customized, hands-on, live workshops.
Upcoming Webinars
By William Mack Copeland
Date: Nov. 6, 2026
By Carolyn Troiano
Date: Nov. 6, 2026
By Edwin Waldbusser
Date: Nov. 9, 2026
By Dev Strischek
Date: Nov. 9, 2026
By Cathy Horwitz
Date: Nov. 10, 2026
By Paul Pelletier
Date: Nov. 10, 2026
By Lesley Crook
Date: Nov. 13, 2026
By Dr. Susan Strauss
Date: Nov. 16, 2026
By Allen Evitts
Date: Nov. 17, 2026
By Dr. Bill Trombetta
Date: Nov. 17, 2026
By David Nettleton
Date: Nov. 17, 2026
By Bruce Lee
Date: Nov. 17, 2026
By Dr. Susan Strauss
Date: Nov. 18, 2026
By Mike Thomas
Date: Nov. 18, 2026
By Donna K Olheiser
Date: Nov. 19, 2026
By Charles H. Paul
Date: Nov. 19, 2026
By Diane L. Dee
Date: Nov. 19, 2026
By Abdelrahman Abdou
Date: Nov. 19, 2026
By Richard E Cascarino
Date: Nov. 20, 2026
By Edwin Waldbusser
Date: Nov. 23, 2026
By Meredith Crabtree
Date: Nov. 24, 2026
By Donna K Olheiser
Recorded Session
By Pete Tosh
Recorded Session
By Bruce Lee
Recorded Session
By Don Phin
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Margie Faulk
Recorded Session
By Carolyn Troiano
Recorded Session
By Kelly Thomas
Recorded Session
By Rachelle D Souza
Recorded Session
By Marcia Zidle
Recorded Session
By Beverly Beuermann-King
Recorded Session
By Margie Faulk
DOL Reverses Course on Independent Contractor Rule for 2026! How Will Employers Adapt to the Change?
Recorded Session
By Mike Thomas
Recorded Session
By Marcia Zidle
Recorded Session
By Ritu Arora
Recorded Session
By Diane L. Dee
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Diane L. Dee
Recorded Session
By Beverly Beuermann-King
Recorded Session
By Charles H. Paul
Recorded Session
By Marcia Zidle
Recorded Session
By Audrey Halpern
Recorded Session
