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 analysis 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 formulas 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 conditions. |
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 spreadsheet cells that we can change or adjust to optimize the target cell. |
Constrains
Constraints are restrictions you place on the changing cells. In Short they are the condition to change the cell. They are not compulsory. |
|
|
|
