Course info

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.

Who should attend: Professionals seeking to use Microsoft Excel more effectively.

Topics typically covered:

• Bringing Excel’s green error-checking prompts under control by managing the underlying rules.
• Understanding why you can’t assign the name “History” to a worksheet tab.
• Disabling the Protected View prompt.
• Using FILTER with ISERROR to retrieve rows from a list that return error values such as #N/A.
• Mastering the IFERROR function to display alternate values in lieu of a # sign error.
• Mastering the nuances—and the power—of Excel’s Transpose feature.
• Improving the stability of Excel by deleting accumulations of temporary files in Windows.
• Understanding how to launch Excel in Safe Mode to troubleshoot Excel issues.
• Eliminating the frustrating ""We can't do that do a merged cell"" error prompt.
• Identifying the various # sign errors Excel formulas can return.
• Displaying subsets of data dynamically by way of the FILTER worksheet function.
• Most features and functions work in Excel for Mac as well but expect differences.