Description

Recent research released by Microsoft shows that 80% of Excel users have yet to use pivot tables. In these micro courses, Excel expert David H. Ringstrom, CPA, covers the basics of creating and using Excel pivot tables. You’ll quickly be able to instantly summarize lists of data into meaningful reports with just a few clicks of your mouse. As with many aspects of Excel, pivot tables have several nuances that can frustrate new users, so David will be sure to bring these to your attention so that you can use the feature effectively. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to 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.

Pivot Tables: Introduction
Pivot Tables: Interfaces
Pivot Tables: Managing Subtotal Positions
Pivot Tables: Renaming Fields
Pivot Tables: Top 10 Filters
Pivot Tables: 4 Ways to Remove Fields
Pivot Tables: Delete Report Filter Worksheet
Pivot Tables: Expanding & Collapsing
Pivot Tables: Correcting Number Fields Treated As Text