|Duration: 75 minutes||Speaker: David H. Ringstrom, CPA|
In this webinar, Excel expert David Ringstrom, CPA, shows how to quickly clean up unwieldy data sets in preparation for analysis with pivot tables. You'll see how to eliminate a common data integrity risk related to pivot tables by utilizing Excel's Table feature. You'll also see three different ways to perform calculations based on data within pivot tables and get an introduction to the Slicer feature which automates filtering within pivot tables.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. He draws your attention to any differences in Excel 2016, 2013, or 2010 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 attend:
Practitioners who may benefit from learning how to manipulate their pivot table data faster and more efficiently.
Program Prerequisites: Experience with Pivot Tables Is Recommended
Advance Preparation: None
Nationally recognized Microsoft Excel expert David H. Ringstrom, CPA, is the president and owner of Accounting Advisors, Inc. based in Atlanta, Georgia. David founded Accounting Advisors in 1991 as a consulting-services business, later he began teaching continuing education classes as well. His mission since is to offer quality training and consulting services on Microsoft Excel via live webcasts, on-demand self-study webcasts, and in-house engagements. David has taught hundreds of webinars on Excel and other topics, in addition to speaking at conferences and in-house engagements.
To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).
Watch all live or recorded webinars (up to 120 minutes long). Get instant access to a library of more than 500 high quality courses presented by best-in-class presenters.
Fulfil your recertification requirements by earning CEUs from APA, CPE, SHRM and HRCI.
Each program comes with Additional Course Materials, which you can download and read anytime.
Get flat 20% discount on Premium Product Category like, Long Hour Webinars.
What people are saying about us
The speaker was very interactive and made it fun.
Loved the cartoons. Made it easy to understand.
The subject matter was very interesting and the instructor was well informed. Content of the webinar was Very Helpful!
The speaker was extremely knowledgeable. Speaker moved the program forward at a good pace. The time flew by.
I thought it was well organized, comprehensive and the speaker was an effective communicator.
The instructor is very professional and available for the attending students.
May 19th 2021 @ 03:00 PM ET