PivotTables are arguably the most popular analysis tool in Microsoft Excel, used across industries to report on performance. This 90-minute beginner's guide to Excel PivotTables shows how to summarize large data sets in flexible ways and turn them into useful insights.
You'll learn to create a PivotTable and change its structure, filter and sort data, change calculations and show results as percentages. You'll group date fields to view different periods, refresh the table when the source data changes, format it for easy reading and drill down to the underlying records.
The session finishes with slicers, which make filtering a PivotTable simple for you and for anyone else who reads your report.
PivotTables help you sift through large data sets and focus on the details that matter, build several custom reports in a few steps and group data easily, saving time and supporting better business decisions.
This session suits business owners, executives, managers, accountants, CPAs, financial consultants, IT professionals, auditors, HR staff, bookkeepers, marketers and anyone who works with large amounts of data in Excel.
PivotTables help you sift through large data sets and focus on the details that matter, build several custom reports in a few steps and group data easily, saving time and supporting better business decisions.
This session suits business owners, executives, managers, accountants, CPAs, financial consultants, IT professionals, auditors, HR staff, bookkeepers, marketers and anyone who works with large amounts of data in Excel.
Cathy Horwitz
Cathy Horwitz is a highly experienced Microsoft Office instructor, specializing in Excel, Word, PowerPoint, Outlook, and Access. With over 30 years of expertise in both in-person and online training, she has helped thousands of professionals boost productivity, streamline workflows, and master essential Microsoft Office skills.Cathy has been teaching Microsoft Office since its inception, offering tailored training programs that meet the unique needs of individuals and businesses. Her courses cover everything from Excel formulas, PivotTables, and automation with macros to Word document formatting, PowerPoint presentation design, and Outlook email management. Workshops from beginning level through advanced are available.Known for her engaging, …
Elevate Your Workplace Wellness: 10 Critical Wellness Facto…
Project Management For Administrative Professionals
Onboarding is NOT Orientation - How to Improve the New Empl…
Managing Complex Projects - Project Management
Utilizing HR Metrics to Illustrate & Improve Human Resource…
Negotiating Skills For Professional Results - Winning Strat…
NEW Nacha Rule - Third-Party Sender (TPS) Roles and Respons…
FDA Technology Modernization Action Plan (TMAP) and Impact …
Paying and Receiving Payments for Referrals: You Can Go to …
Human Factors Usability Studies Following ISO 62366 and FDA…
Construction Lending And Real Credit Administration: Evalua…
Validation Statistics for Non-Statisticians
Thriving in a Hybrid Workplace: Keys to Leadership and Team…
Excel Power Skills: Master Functions, Formulas, and Macros …
Discover how Emotional Intelligence turns AI from a technic…
Batch Record Review and Product Release
ChatGPT for HR - Build HR Policy Framework and Strategy
Female to Female Hostility @Workplace: All you Need to Know
Copilot and HR: An Introduction for HR Professionals
The Perfect Storm Coming to Healthcare: Value Based Care Me…
Language is Code - Intro to AI - Generative AI - ChatGPT an…
Major cGMP Issues: FDA Concerns in 2026
Excel Spreadsheets; Develop and Validate for 21 CFR Part 11…
ChatGPT and Project Management: Leveraging AI for Project M…
I-9 Audits: Strengthening Your Immigration Compliance Strat…
Pivot tables beginner to advanced + 20 advanced Pivot table…
Emotional Intelligence: Mastering the Emotions of Great Lea…
