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.
WHY SHOULD YOU ATTEND?
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.
AREA COVERED
- Creating PivotTables and changing their structure
- Filtering and sorting PivotTable data
- Changing PivotTable calculations
- Showing pivoted data as percentages
- Refreshing a PivotTable after source data changes
- Grouping date fields to view different periods
- Formatting a PivotTable
- Drilling down to the source data
- Using slicers to filter a PivotTable
LEARNING OBJECTIVES
- Explain why PivotTables are so useful in Excel
- Analyze large data sets from different business perspectives
- Create a PivotTable to summarize data
- Use PivotTables to answer questions and spot patterns in the data
- Customize summaries by grouping data
- Format PivotTables so others can understand them easily
WHO WILL BENEFIT?
- Business Owners
- CEOs / CFOs / CTOs
- Managers
- Accountants
- CPAs
- Financial Consultants
- IT Professionals
- Auditors
- Human Resource Personnel
- Bookkeepers
- Marketers
- Anybody with large amounts of Data
- Anybody who uses Microsoft Access/Excel regularly, and wants to be more efficient and
- productive
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.
- Creating PivotTables and changing their structure
- Filtering and sorting PivotTable data
- Changing PivotTable calculations
- Showing pivoted data as percentages
- Refreshing a PivotTable after source data changes
- Grouping date fields to view different periods
- Formatting a PivotTable
- Drilling down to the source data
- Using slicers to filter a PivotTable
- Explain why PivotTables are so useful in Excel
- Analyze large data sets from different business perspectives
- Create a PivotTable to summarize data
- Use PivotTables to answer questions and spot patterns in the data
- Customize summaries by grouping data
- Format PivotTables so others can understand them easily
- Business Owners
- CEOs / CFOs / CTOs
- Managers
- Accountants
- CPAs
- Financial Consultants
- IT Professionals
- Auditors
- Human Resource Personnel
- Bookkeepers
- Marketers
- Anybody with large amounts of Data
- Anybody who uses Microsoft Access/Excel regularly, and wants to be more efficient and
- productive
Speaker Profile
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, …
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…