Solving data problems in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 6 Videos | 16m 52s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
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.

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

  • Playable
    1. 
    Overview: Solving data problems in Excel 365
    47s
    UP NEXT
  • Playable
    2. 
    Recognizing formula errors
    2m 50s
  • Locked
    3. 
    Using the Excel formula auditing tools
    3m 45s
  • Locked
    4. 
    Reviewing and debugging formula errors
    3m 52s
  • Locked
    5. 
    Adjusting formulas automatically with the Goal Seek tool
    2m 21s
  • Locked
    6. 
    Keeping an eye on your data with the Watch Window
    3m 17s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 50 Likes 50  
Likes 13 Likes 13  
COURSE Managing Data
Likes 112 Likes 112