In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide you through a comprehensive exploration of Excel's formula and error-handling capabilities. You'll gain invaluable insights into tackling common spreadsheet challenges, starting with understanding and resolving merged cell errors and various types of formula errors. David will delve into the evolution of worksheet functions and demonstrate techniques for checking worksheet function compatibility across different Excel versions. Explore the latest Excel 2021 and Excel for Microsoft 365 functions, including the powerful FILTER Function and see how to handle new errors like #SPILL! and #CALC!. Discover the art of using the Error Checking and Trace Error commands, and master using the IFERROR function to minimize intermittent errors. David will also reveal how extraneous spaces can trigger #N/A errors in VLOOKUP and XLOOKUP. You'll also learn how to locate pesky circular references. Don't miss this opportunity to learn disaster recovery and prevention techniques, such as repairing damaged workbooks and deleting temporary files. Join us for this illuminating webinar and enhance your Excel expertise.
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-ERROR-G34125 |
| Recommended CPE: | 2.00 |
| Delivery Method: | Group Live - Seminar |
| Date Offered: | 6/30/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 what the FORMULATEXT function returns if the cell being referenced does not contain a formula.
- Recognize which version(s) of Excel offer the FILTER function.
- Identify the argument(s) required by the IFERROR function.