Ryan Loredo
Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Discover how to go further with your Excel 365 content by understanding the potential for formula errors. See how to use error checking and formula auditing tools, use the Goal Seek tool to let Excel 365 update variables for a formula to meet a specific outcome, and use the Watch Window tool to monitor data entries stored in different locations. Key concepts in this course include how to identify formula errors and understand the wide range of error messages. You will also learn how to check for and evaluate formulas in a workbook and how to use the Goal Seek tool to change constraints and variables to optimize your data values accordingly. Finally, you will explore how to use the Watch Window tool to monitor specific data entries, even from other workbooks.
In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
Issued on
October 31, 2021
Expires on
Does not expire