Learn the basics of creating and using Excel pivot tables in this comprehensive webcast presented by Excel expert David Ringstrom, CPA. Pivot tables allow you to create reports from complex data simply by using your mouse. David explains how to initiate a pivot table from a list of data, expand and collapse pivot table elements, remove fields from a pivot table, and more. Pivot tables have a few nuances that can trip up the unaware user, so David points out the traps and shares tricks that will help ensure the reports you create are accurate.
Those who wish to learn how to use Excel pivot tables to easily create accurate reports.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016.
David draws participants’ attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts.
David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward.
David provides an Excel workbook that includes a majority of the examples he uses during the session
Those who wish to learn how to use Excel pivot tables to easily create accurate reports.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016.
David draws participants’ attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts.
David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward.
David provides an Excel workbook that includes a majority of the examples he uses during the session
David H. Ringstrom
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents dozens of webinars annually on Excel and other topics. He has written numerous articles on spreadsheets, some of which have been published internationally. He has served as the technical editor for other 30 books on accounting software, and is the Tech Editor-at-Large for Accounting WEB and Going Concern. David offers Excel training and consulting services nationwide.
Harassment, Bullying, Gossip, Confrontational and Disruptiv…
Leadership: Strategic Planning and Decision Making
4-Hour Virtual Seminar on Transformational Leadership - The…
Workplace Investigations 101: How to Conduct your Investiga…
Copilot and HR: An Introduction for HR Professionals
Negotiating Skills For Professional Results - Winning Strat…
2-Hour Virtual Seminar on the 6 Most Common Problems in FDA…
Managing Complex Projects - Project Management
Managing Toxic Employees: Strategies For Leaders To Effecti…
Excel Power Skills: Master Functions, Formulas, and Macros …
Ultimate Persuasion Strategies! - Secret Influence Tools & …
Excel - Pivot Tables - The Key To Modern Data Analysis and …
2-Hour Virtual Seminar on How to Conduct an Internal Harass…
Do's and Don'ts of Giving Effective Feedback for Performanc…
Using High-Performance Coaching for Managers to Address Per…
Utilizing HR Metrics to Illustrate & Improve Human Resource…
Understanding Artificial Intelligence (AI) & using Chat GPT
Do's and Don'ts of Documenting Employee Behaviour, Performa…
Creating Your 2025 Marketing Strategy
Enhance Your Confidence and Leadership Presence
Trust in Leadership: Building and Maintaining Trust as a Le…
Effective Communication Skills It’s Not What You Say, But H…
2026 Handbook Overhaul: Navigating Critical Updates! Does t…
From Concept to Creation: Strategies for Cultivating Workpl…
Mastering Performance Management: Strategies for Continuous…
2025 EEOC & Employers: Investigating Claims of Harassment …
Project Management for administrative professionals
The Importance of the first 5 seconds when presenting
How to Reduce Human Error in a GMP Manufacturing Floor
Trump’s Executive Orders on DEI and Disparate Impact, and t…
How Accountants Can Use Chat GPT Effectively
Changing Behavior: Why Rewards and Punishments Often Aren't…
Pivot tables beginner to advanced + 20 advanced Pivot table…
The OBBBA Era & Beyond: Your 2025 Playbook for Compliance a…
Managing Toxic & Other Employees Who Have Attitude Issues
ChatGPT Unlocked: A Beginner’s Guide to AI and ChatGPT
Employee Handbooks: 2025 Critical Issues