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.

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.

To complete this course participants need to: View the video and complete an assessment exam with a minimum passing grade of 70% or higher.

Upon course completion a course evaluation form is provided for your feedback.

You have 1 year from the time of purchase/enrollment to complete the course.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/