In this presentation, author and Excel expert David H. Ringstrom, CPA, will take you on a deep dive into the art of data management and analysis in Excel. You'll discover indispensable techniques for filtering Data efficiently and learn time-saving filtering keyboard shortcuts, including how to add Clear Filter to the Quick Access Toolbar for seamless data refinement. David will unveil the power of ad hoc totals while filtering and demonstrate the versatility of the Table feature. You'll also gain insights into optimizing your workflow by mastering Slicers with Tables and harnessing the Custom Filter option for precise data extraction. Learn how to streamline your analysis by Filtering by Color and easily Reapply filters when needed. Dive into Advanced Filter functionalities and explore the FILTER function in Excel 2021 and Excel for Microsoft 365 for enhanced data manipulation. David will also show you how to use FILTER with multiple conditions and show how to filter charts. Join us for this enlightening webinar to transform your data filtering and analysis skills in Excel.
David is the author of “Microsoft Excel 365 for Dummies”, “Exploring Microsoft Excel’s Hidden Treasures”, and has written or co-authored six other books. He demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Excel for Microsoft 365. David draws your attention to any differences in Excel 2021, 2019 or 2016 during the presentation and in his detailed handouts. The handouts include an Excel workbook with most of the examples he uses during his demonstrations.
Excel for Microsoft 365 is a subscription-based product that receives periodic feature updates. Conversely, perpetually licensed versions have year numbers in their names and do not receive any feature updates.
This webinar is available with
NO ADDITIONAL FEE if you have an active
all access membership or
webinar membership or can be purchased for
$29.00!
| Instructor: | David Ringstrom |
| Course No: | COMP-FILTE-G34125 |
| Recommended CPE: | 2.00 |
| Delivery Method: | Group Live - Seminar |
| Date Offered: | 10/6/2026 10:00 AM - 12:00 PM |
| Level of Knowledge: | Basic |
| Prerequisites: | None |
| Advanced Preparation: | None |
| Registration Requirements: | No registration is required |
| Recommended Field of Study: | Computer Software and Applications
Webinars - Group
|
|
|
|
Learning Objectives
- State which argument number informs the SUBTOTAL function that you wish to calculate the average for a range of cells.
- Recall the keystroke that enables you to select two or more non-adjacent items from a Slicer.
- State which feature in Excel allows you to identify a criteria range for specifying data you wish to see within a list on a worksheet.