Excel expert David H. Ringstrom, CPA, focuses on the basics of using Excel pivot tables in this informative presentation. Pivot tables empower you to easily create reports from complex data, simply by using your mouse. However, 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.
In addition, David explains how to (1) initiate a pivot table from a list of data, (2) expand and collapse pivot table elements, (3) dig deeper into the numbers with the Report Filter command, (4) remove fields from a pivot table...and much more.
David typically demonstrates techniques from the version of Excel used by the majority of attendees. This means he uses Excel 2010, 2013, or 2016 to demonstrate techniques, but his detailed handouts identify differences in Excel 2007, 2010, 2013, and 2016 when needed.
His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants’ questions, so come ready to pick his brain. David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes most of the examples he uses during the webcast.
What You Will Learn:
Who Should Attend?
Practitioners who may benefit from learning how to use Excel pivot tables to create accurate reports.
If you are having issues with registering online, please contact CBAO's Education & Training Coordinator, Lianne Simeone, (614) 610-1877.