Loading...

Excel Explained: PivotTables 101

PivotTables are one of Excel’s most powerful tools—when you know how to use them well. In this session, David Ringstrom, CPA and author of Excel for Dummies, shows how to build, customize, filter, refresh, and audit PivotTables to generate faster, more reliable insights.

OnDemand
DATE

Recorded Friday,
April 17, 2026

INSTRUCTOR

David Ringstrom

DURATION

2 Hours

FORMAT

Webinar

$299.00 or 1 Token

Includes: 30 Days OnDemand Playback, Presenter Materials and Handouts

  • Accounting/Reporting
  • Commercial/Business Lending
  • Compliance
  • Computer Skills
  • Human Resources
  • Information Technology/Security
  • Lending
  • Mortgage Lending
  • Reporting
  • Sales
  • Branch Manager
  • Commercial Lender
  • Compliance Officer
  • Consumer Lender/Retail Banker
  • Controller/Accountant
  • Credit Analyst
  • Human Resources Officer
  • Internal Auditor
  • IT Professional
  • Loan Operations Manager/Specialist
  • Marketing Officer/Business Development
  • Mortgage Lender
  • Small Business Lender
  • Training Manager
  • Trainer

Save on annual training costs with our Webinar Subscription Service and share webinars across your entire organization.

Become a subscriber

Learn about upcoming events, webinars and discounts.

Sign Up For Email Notifications

PivotTables are one of Excel’s most powerful features—when you know how to use them properly. In this comprehensive session, David Ringstrom, CPA and author of Excel for Dummies, guides you through building, customizing, and managing PivotTables with confidence. You’ll learn how to prepare ideal source data, create PivotTables from ranges or Excel tables, add and remove fields efficiently, control layouts and formatting, and filter results using built-in tools such as Top 10 filters, slicers, and report filters. The session also covers refreshing and auditing PivotTables, generating multiple reports at once, and leveraging newer features like Recommended PivotTables and Analyze Data. Designed for Excel users who want faster insights with fewer missteps, this webinar provides a practical foundation you can use immediately.

What You'll Learn

  • Exploring the PivotTable ribbon tabs and PivotTable Field List.
  • Creating a table to prep for summarizing data with PivotTables or Power Pivot.
  • Collapsing or expanding PivotTable fields to view different levels of summary or detail.
  • Identifying the ideal data for analysis with Excel’s PivotTable feature.
  • Generating PivotTables and PivotCharts from suggested insights.
  • Selecting items to display and recognizing filter indicators.

Who Should Attend

Designed for Excel users who work with summarized data and want to build, customize, and manage PivotTables more efficiently and confidently.

David Ringstrom

Instructor Bio

David H. Ringstrom, CPA, has more than 30 years of experience as a spreadsheet and accounting software consultant, educator, and speaker. He has presented more than 2,500 live webinars to professionals nationwide.


David is the author or co‑author of ten books, including Microsoft 365 Excel For Dummies, Exploring Microsoft Excel’s Hidden Treasures, QuickBooks Online For Dummies, and Idiot’s Guide to Introductory Accounting.


 


 

Print this page