Show Menu

Excel What if Analysis Cheat Sheet (DRAFT) by

Excel what if analysis cheat sheet

This is a draft cheat sheet. It is a work in progress and is not finished yet.

List of Handy Shortcuts

Goal Seek
Alt A W G
Alt T G
Scenario Manager
Alt A W S
Alt T E
Data Table
Alt A W T
Alt D T

What is what if Analysis

What-if analys­is is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.

What is Goal Seek

Goal Seek helps to find out a desired result in Formula Cell by changing a dependent formula Cell.
Goal Seek works in Opposite direction of Formula

What is Scenario Manager

Scenario Manager is an What if Analysis tools which are used to determine different projected Outcomes by changing the formula connected Cells (Formula Dependent Cells).

What is Data Table

A data table is a range of cells that shows how changing one or two variables in your formul­as will affect the results of those formulas. 

What is Solver

Solver changes a group of cells to find an optimum solution to a problem by given condit­ions.

Target Cell

Target cell represents objective or goal. We want to either minimize or maximize the target cell. In some situation one can have a multiple Target Cells

Changing Cells

Changing cells are the spread­sheet cells that we can change or adjust to optimize the target cell.


Constr­aints are restri­ctions you place on the changing cells. In Short they are the condition to change the cell. They are not compul­sory.