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.
WHY SHOULD YOU ATTEND?
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.
AREA COVERED
- 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
LEARNING OBJECTIVES
- 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
WHO WILL BENEFIT?
- Executives
- Managers
- Business Analysts
- Production Supervisors
- Anybody who needs to analyze their part of the business
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.
- 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
- 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
- Executives
- Managers
- Business Analysts
- Production Supervisors
- Anybody who needs to analyze their part of the business
Speaker Profile
Neil Malek
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
Medical Device Cybersecurity Following FDA’s 2026 Premarket…
Managing Toxic Employees: Strategies For Leaders To Effecti…
California Meal and Rest Breaks: What You Don't Know Can Co…
Human Error Reduction Techniques for Floor Supervisors
Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Your AI Advantage: How HR Professionals Can Use Claude to S…
The Anti-Kickback Statute: Enforcement and Recent Updates
Empowering Conflict Resolution: Letting Go to Gain Control
Wage & Hour Laws: Ensuring Compliance with the Fair Labor S…
Using Copilot to Format Legal Documents in Microsoft Word
Dealing With Difficult People: At Work & In Life
Using Stay Interviews To Improve Employee Retention & Engag…
AI in Word - Smarter Writing and Document Creation with Cha…
FDA Current Trends in Compliance and Enforcement for FDA-Re…
Zero Acceptance Sampling to Reduce Inspection Costs
Why EBITDA Doesn't Spell Cash Flow and What Does?
Mastering Tough Conversations: Turn Conflict into Clarity, …
Enhancing Pivot Tables with Images: Visualize Your Data Lik…
Discover how Emotional Intelligence turns AI from a technic…
Understanding Financial Statements for Non-Financial Profes…
SOPs - How to Write Them to Satisfy those Inspectors
Managing Projects When AI Joins the Team: Human Judgment, A…