Course details

Excel 2019: Forecasting & Solving Problems

Excel 2019: Forecasting & Solving Problems


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Go further with you Excel document through understanding potential formula errors, use intelligent data types, set goals to reach targets as well as problem solve with the solver and Forecast tools offered by Excel 2019.



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