Forecasting & Solving Problems

Excel 2019 (Windows)    |    Intermediate
  • 7 Videos | 33m 59s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 50 Likes 50
Discover how to go further with your Excel document through understanding potential formula errors, use intelligent data types, and set goals to reach targets as well as problem-solve with the Solver and Forecast tools offered by Excel 2019. Key concepts in this 7-video course include how to identify formula errors and to understand the wide range of formula error messages; how to check for and evaluate formulas in a workbook; and how to use formulas to estimate loan-related costs and help you estimate and managed repayments. Continue by learning how to use the Goal Seek tool to modify a data variable and reach a target value; how to use the Solver add-in to analyze constraints and variables and optimize data values; and how to insert a Forecast worksheet to display trends and predictions based on available historic data. Finally, observe how to use Data Tables to create what if, variable-based scenarios, and once created, learn to adjust the values and change the calculation options. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Forecasting & Solving Problems Exercise as well as the associated materials in the Resources section.

WHAT YOU WILL LEARN

  • identify formula errors
    review and debug formula errors
    calculate the interest on a loan
    reach a target value
  • solve a problem in a table
    use forecast tools
    use data tables

IN THIS COURSE

  • Playable
    1. 
    Understanding formula errors
    5m 43s
    UP NEXT
  • Playable
    2. 
    Reviewing & debugging formula errors
    5m 3s
  • Locked
    3. 
    Calculating the interest on a loan
    5m 32s
    FREE ACCESS
  • Locked
    4. 
    Reaching a target value
    4m 12s
    FREE ACCESS
  • Locked
    5. 
    Solving a problem
    4m 55s
    FREE ACCESS
  • Locked
    6. 
    Using the forecast tool
    4m 5s
    FREE ACCESS
  • Locked
    7. 
    Using data tables
    4m 30s
    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 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

COURSE Solving data problems in Excel 365
COURSE Working with Excel Tables
Likes 351 Likes 351  
COURSE Finding & Analyzing Information with Formulas
Likes 122 Likes 122  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Creating & Saving Workbooks
Likes 172 Likes 172  
COURSE Referencing Data
Likes 123 Likes 123  
COURSE Custom & Conditional Formatting
Likes 75 Likes 75