Excel expert David H. Ringstrom, CPA, teaches you pivot table basics in this comprehensive presentation. Pivot tables enable you to easily 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, dig deeper into the numbers with the Report Filter command, and much more. Like many features in Excel, pivot tables have nuances that can trip you up, so David points out traps and teaches you tricks to help ensure your reports are always accurate.
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.