Microsoft Excel PivotTables and PivotCharts turn raw data into clear business insight without advanced formulas. This 90-minute Excel PivotTables training starts with setting up your source data correctly, then shows how to build PivotTables and PivotCharts that summarize large datasets.
You'll learn to aggregate data with metrics such as sum, average and count, group and segment it to find patterns, format the results for readable reports and data storytelling, and drill down or up for deeper analysis.
The session finishes with interactive dashboards built with slicers, so users can explore several scenarios on their own and reach decisions faster. It is aimed at business professionals who want to get from data to understanding quickly.
WHY SHOULD YOU ATTEND?
Large datasets are hard to make sense of, and guesswork leads to slow or poor decisions. This webinar teaches proven techniques for organizing, analyzing and visualizing data with PivotTables, so you can make faster, better-informed decisions without learning advanced formulas and functions.
It suits data and business analysts, finance professionals, small business owners, operations and sales staff, and anyone responsible for reporting or performance tracking.
AREA COVERED
- Introduction to data analytics in Excel
- What PivotTables are and their business value
- Structuring and preparing source data correctly
- Creating and modifying PivotTables
- Aggregating data with metrics such as sum, average and count
- Formatting data for readability and reporting
- Drill-down and drill-up techniques
- Managing PivotTables: move, copy and refresh
- Creating and customizing PivotCharts
- Using slicers to build interactive dashboards
LEARNING OBJECTIVES
- Explain how PivotTables and PivotCharts support data-driven decisions
- Create PivotTables that summarize large datasets with sum, average, count and other metrics
- Group and segment data to identify patterns and trends
- Format and present results for professional reporting and data storytelling
- Create PivotCharts to visualize trends and outliers
- Validate insights through drill-down analysis
- Build interactive dashboards with slicers
WHO WILL BENEFIT?
- Data Analysts and Business Analysts
- Finance professionals (CFOs, Accountants, Financial Analysts)
- Small business owners and entrepreneurs
- Operations and sales professionals working with data
- Anyone responsible for reporting, or performance tracking
- Professionals who need to summarize, analyze, or present large datasets efficiently
Large datasets are hard to make sense of, and guesswork leads to slow or poor decisions. This webinar teaches proven techniques for organizing, analyzing and visualizing data with PivotTables, so you can make faster, better-informed decisions without learning advanced formulas and functions.
It suits data and business analysts, finance professionals, small business owners, operations and sales staff, and anyone responsible for reporting or performance tracking.
- Introduction to data analytics in Excel
- What PivotTables are and their business value
- Structuring and preparing source data correctly
- Creating and modifying PivotTables
- Aggregating data with metrics such as sum, average and count
- Formatting data for readability and reporting
- Drill-down and drill-up techniques
- Managing PivotTables: move, copy and refresh
- Creating and customizing PivotCharts
- Using slicers to build interactive dashboards
- Explain how PivotTables and PivotCharts support data-driven decisions
- Create PivotTables that summarize large datasets with sum, average, count and other metrics
- Group and segment data to identify patterns and trends
- Format and present results for professional reporting and data storytelling
- Create PivotCharts to visualize trends and outliers
- Validate insights through drill-down analysis
- Build interactive dashboards with slicers
- Data Analysts and Business Analysts
- Finance professionals (CFOs, Accountants, Financial Analysts)
- Small business owners and entrepreneurs
- Operations and sales professionals working with data
- Anyone responsible for reporting, or performance tracking
- Professionals who need to summarize, analyze, or present large datasets efficiently
Speaker Profile
Tom Chandler
Tom Chandler started teaching Excel and other Microsoft Office (now Microsoft 365) applications in Silicon Valley in 1996. In 2010 he started a computer training and consulting company named TechMentors. He has had the pleasure of teaching and consulting with many small and large companies including Stanford Medical Center, Visa, Seagate, and the City of San Jose.Tom received his Bachelors of Science in Finance and Accounting from Brigham Young University. He also received a MBA with a concentration on Computer/Information Technology Administration and Management from Western Governors University.Tom and his wife, Madeline, are very family oriented. They have …
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…