Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Forecasting and What-If Analysis

Description

Because Excel is such a powerhouse for storing and analyzing data, there are a wealth of tools for pushing from analyzing the past to forecasting the future. With tools like What-If, Scenarios, Solver, and a range of add-ins, Excel can create new charts and tables that explain potential future conditions.

Topics include:

  • Creating new calculated results with What-if and Data Tables
  • Adding Scenarios to existing calculations
  • Searching for desired outcomes with Solver
  • Sampling and forecasting data

Prerequisites

Absolute and relative references and experience creating Excel functions

Introduction to formulas and functions (linkedin.com)