Course details

Excel Office 365: Forecasting & Solving Problems

Excel Office 365: 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 for Office 365.



Expected Duration (hours)
0.8

Lesson Objectives

Excel Office 365: Forecasting & Solving Problems

  • identify formula errors
  • check for and evaluate formulas in a workbook
  • insert and visualise dynamic geographical and stock-related data in a worksheet
  • 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_msex365_12_enus

    Expertise Level
    Intermediate