Excel Agility: Pivot Tables - Advanced
Recorded Webinar | David H. Ringstrom | From: Feb 24, 2023 - To: Dec 31, 2023
* Click Here to download our Order Form
When you participate in this comprehensive webcast, you’ll discover how to push the boundaries of pivot tables and add even more interactivity to them by grouping data in various ways. Excel expert David Ringstrom, CPA, explains how to easily extract data from Microsoft Access, create simple macros that can resolve the most frustrating aspects of pivot tables, determine the number of duplicates in a list, reap the benefits of Excel’s Slicer feature, sort data in any order you desire, and more.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) 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.
Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
Who Should Attend:-
Practitioners who would like to expand their knowledge of pivot tables so they can manipulate their data faster and more efficiently.