Excel Error Prompts (Video) (Course Id 2581)

• Who is this course for?
  This course is intended for anyone needing Continuing Professional Education (CPE), particularly CPAs and other financial professionals who use Excel regularly.

• What is this course about or what problem does this course solve?
  This course addresses common Excel formula and error-handling challenges, offering solutions for merged cell errors, formula issues, circular references, and compatibility concerns across Excel versions.

• How can the knowledge from this course be used?
  The knowledge gained can be applied to troubleshoot and resolve Excel errors, improve spreadsheet reliability, and enhance productivity when using Excel for data analysis or reporting.

• Why is this course important to a CPA, Accountant, or IRS Enrolled Agent?
  It is crucial for professionals relying on Excel to maintain accurate and error-free financial data, which supports compliance, reporting accuracy, and efficient data handling.

• When is this course relevant or timely?
  The course is especially timely for users of Excel 2021 and Microsoft 365, as it covers recent updates and newly introduced functions and errors.

• How is a course like this consumed or used?
  This self-study video course is delivered online and includes video instruction, detailed handouts, an Excel workbook with examples, and requires a final exam with a passing score for CPE credit.

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.

Video - NASBA QAS - NASBA Registry - 2581

Course 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.

Chapter 1 - Excel Error Prompts

Chapter 1 Review Questions

Key Terms