Solving data problems in Excel 365
Excel Microsoft 365 (2021)
| Intermediate
- 6 videos | 16m 52s
- Includes Assessment
- Earns a Badge
- CPE
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.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this solving data problems in excel 365 course
Recognize formula errors in excel 365
Use formula auditing tools in excel 365 -
Review and debug formula errors in excel 365
Use the goal seek tool to modify a data variable and reach a target value in excel 365
Use the watch window tool to monitor data entries in excel 365
IN THIS COURSE
-
47sThis video outlines the key content covered in this Microsoft 365: Solving data problems in Excel 365 course, including how to recognize formula errors, how to use the formula auditing tools, and how to adjust formulas automatically with the Goal Seek tool in Excel 365. FREE ACCESS
-
2m 50sExcel 365 features a wide range of formula error messages. Before you can fix these problems, you are going to need to know how to identify what each message represents and how the error was produced. In this video, you will explore how to recognize and interpret formula error messages in Excel 365. FREE ACCESS
-
3. Using the Excel formula auditing tools3m 45sWith Excel 365's formula auditing tools, you can trace the source of formula problems. A trace indicates which cells are used in a formula and whether formulas are dependent on certain data ranges. You can even determine if a formula uses data from another worksheet. In this video, you will explore how to use the formula auditing tools in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.5.1 Trace precedence and dependence. FREE ACCESS
-
4. Reviewing and debugging formula errors3m 52sYou can check, evaluate, and debug formulas in Excel 365 to determine the cause of an error with a formula and fix it. In this video, you will explore how to review and debug formula errors in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.5.3 Validate formulas by using error checking rules. As well as MOS MO-201 / Excel Expert Certification exam objective: 3.5.4 Evaluate formulas. FREE ACCESS
-
5. Adjusting formulas automatically with the Goal Seek tool2m 21sIf you use formulas to obtain results in a table, you can use the Goal Seek tool to determine which variables need to change to reach a target value, without manually adjusting a formula. In this video, you will explore how to use the Goal Seek tool to modify data variables to reach a target value in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.4.2 Perform what-if analysis by using Goal Seek and Scenario Manager. FREE ACCESS
-
6. Keeping an eye on your data with the Watch Window3m 17sThe Watch Window tool in Excel 365 is used to keep an eye on your data entries and monitor cells for changes. In this video, you will explore how to keep an eye on your data using the Watch Window tool in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.5.2 Monitor cells and formulas by using the Watch Window. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
