Course Description:
A recent study by Microsoft reported that 80% of Excel users have yet to use the pivot table feature. In this presentation Excel expert David Ringstrom, CPA, takes you beyond the basics of pivot tables. You'll be empowered to quickly transform unwieldy reports into pivot table-ready lists. You'll also see how pivot tables differ from worksheet formulas, the importance of the Refresh and Report Filter commands, how to disable the GETPIVOTDATA function, how to drill down into numbers with a simple double-click, and much more.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws 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.