# Course details

Excel 2019 for Windows: Forecasting & Solving Problems

### Excel 2019 for Windows: 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 for Windows: 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