Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 15th Apr'24 to 25th Apr'24
Mastering Excel: Advanced Pivot Tables
- Altering the default sort order within pivot tables to a hierarchy of your choice with Custom Lists.
- Determining which refresh commands in Excel update a single pivot table versus all pivot tables in a workbook.
- Displaying two or more pivot tables close together on a single worksheet without triggering a conflict.
- Filtering two or more pivot tables simultaneously by way of the Slicer feature in Excel 2010 and later.
- Preventing pivot tables from automatically resizing columns when you refresh or filter the data.
- Resolving situations where data appears more than once within a pivot table.
- Summarizing data from Access databases with pivot tables, even if you don’t have Microsoft Access installed.
- Understanding the conflicts that can arise when you position two or more pivot tables too close in proximity to each other.
- Utilizing the Tabular Format command to display pivot table data in two or more columns instead of a single column in Compact Form.
- Utilizing the Timeline feature in Excel 2013 and later to filter pivot tables based on date ranges.
Overview of the webinar
Learn from Excel expert David Ringstrom, CPA, how to push the boundaries of pivot tables and add even more interactivity to them by grouping data in various ways. In this comprehensive webcast, David 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?
- Accountants
- CPAs
- CFOs
- Controllers
- Income Tax Preparers
- Enrolled Agents
- Financial Consultants
- IT Professionals
- Auditors
- Human Resource Personnel
- Bookkeepers
- Excel Users
- Marketers
- Government Personnel
Why should you attend?
Practitioners who would like to learn how to manipulate their pivot table data faster and more efficiently.
- Recall how macros can help you format pivot table data faster and more efficiently.
- Define how to create pivot tables from information you extract from databases.
- Identify how to summarize pivot table data in new ways by grouping based on dates or custom arrangements that you define.
Faculty - Mr.David H. Ringstrom, CPA
Acclaimed 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, but in 2009, he began teaching for continuing education providers as well. His mission since then has been to offer quality training on Excel and additional accounting software via live webcasts, on-demand self-study webcasts, and in-house engagements. More than 24 providers, located throughout the country as well as overseas, now look to David for their Excel and accounting software training needs.
David’s Excel courses cover the gamut of the software’s features and functions to provide CPAs as well as accounting and financial professionals the knowledge they need to work more efficiently and effectively in Excel. David is known for saying, “Either you work Excel, or it works you.” Based on this belief, he focuses on teaching users what they don’t know but should know about Excel.
His comprehensive yet easy to understand presentations cover Excel 2019, 2016, 2013, and 2010. David’s webcasts are fast-paced, and he welcomes attendees’ questions. In addition, his detailed handouts and slides serve as handy reference tools students can fall back on after participating in his webcasts or taking his self-study courses.