Excel Office 365: Forecasting & Solving Problems


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

This 8-video course explores the wide range of formula error messages in Excel for Office 365. Learn how to identify several error messages, and how errors are produced. You will learn to use the Formula auditing tools to evaluate and resolve nested formulas, and to trace errors to their source. Next, learners will observe how to use Excel's data types to insert and visualize information associated with the data, and how to create a loan amortization schedule. This course demonstrates how to use the Goal Seek tool to find a target value. You will learn how to use the Solver tool to automatically solve mathematical problems in a table by selecting the value that you want to optimize, minimize, or otherwise adjust. Then learn how to use One-Click Forecasting to make predictions on historical data, and to adjust the timeline and seasonality settings, and make changes to the forecast data once the sheet has been inserted. Finally, you will learn how to test what-if scenarios while working on data.



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