Excel expert David Ringstrom, CPA, teaches you the basics of creating and using Excel pivot tables in this valuable presentation. Pivot tables enable you to easily create reports from complex data simply by using your mouse. He shows you how to initiate a pivot table from a list of data, add fields, dig deeper into the numbers, and much more. Pivot tables have a few nuances that can trip up the unaware user, so David points out traps and shares tricks to help ensure the reports you create are 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.
Who Should AttendPractitioners who may benefit from learning how to use Excel pivot tables to easily create accurate reports.
Instructional MethodGroup: Internet-based
NASBA Field of Study
Computer Software & Applications (2 hours)
Program PrerequisitesMust be familiar with Excel