For full functionality of this site it is necessary to enable JavaScript. Here are the instructions how to enable JavaScript in your web browser.

Excel Finesse: Pivot Tables - Beginning Techniques

David H. Ringstrom, CPA is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include: Microsoft Excel Microsoft Access Sage 50/Peachtree Acco........

Read More


You'll learn the basics of creating and using Excel pivot tables in this valuable webcast presented by Excel expert David Ringstrom, CPA. Pivot tables allow you to create reports from complex data simply by using your mouse. Pivot tables have a few nuances that can trip up the unaware user, so David points out the traps and sh........

Why should you attend?

Practitioners who may benefit from learning 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. He'll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Areas Covered in the Session:

  • Adding fields to a blank pivot table to create instant reports.
  • Auditing the data source behind pivot tables in Excel spreadsheets.
  • Contrasting sorting data within worksheets to the nuances of sorting data within pivot tables.
  • Creating a pivot table to transform lists of data into on-screen reports.
  • Deleting a group of worksheets all at once from within an Excel workbook.
  • Determining which refresh commands in Excel update a single pivot table versus all pivot tables in a workbook.
  • Discovering four different ways to remove data from a pivot table report.
  • Distinguishing the differences among pivot table-related menus in Excel 2013 and later versus older versions of Excel.
  • Drilling down into the details behind any amount within a pivot table with just a double-click.
  • Exploring the nuances of formatting numbers within pivot tables.
  • Filtering pivot table data based on a new dimension by using the Report Filter command.

Who can Benefit:

  • Accountants.
  • CPAs.
  • CFOs.
  • Controllers.
  • Excel User.
  • Income Tax Preparers.
  • Enrolled Agents.
  • Financial Consultants.
  • IT Professionals.
  • Auditors.
  • Human Resource Personnel.
  • Bookkeepers.
  • Marketers.
  • Government Personnel.
Webinar Id: ISSEDR004

Duration: 90 mins

12:30 PM PT | 03:30 PM ET


Refund Policy

Webinars of David H. Ringstrom
Mastering Excel Pivot Tables: How to Crunch...
Presenter: David H. Ringstrom

View Anytime
Price: $167
Status: Archived

Excel Finesse: Macros - Part 1
Presenter: David H. Ringstrom

View Anytime
Price: $167
Status: Archived

Webinars of Soft Skills
Leadership Development for Executive Assist...
Presenter: Rebecca Staton-Reinstein

View Anytime
Price: $301
Status: Archived

Zap! You're a manager: getting off on the r...
Presenter: Rebecca Staton-Reinstein

View Anytime
Price: $167
Status: Archived