Excel 2019: Forecasting & Solving Problems


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
0.6

Lesson Objectives

Excel 2019: Forecasting & Solving Problems

  • identify formula errors
  • check for and evaluate formulas in a workbook
  • use formulas to estimate loan-related costs
  • use the Goal Seek tool to modify a data variable and reach a target value
  • use the Solver add-in to analyze constraints and variables and optimize data values
  • insert a Forecast worksheet to display trends and predictions based on available historic data
  • use Data Tables to create what if, variable-based scenarios
  • Course Number:
    ds_msex2019_12_enus

    Expertise Level
    Intermediate