Excel 2016 from Scratch
What-If Analysis A
An Excel tutorial by Peter Kalmstrom
this exercise in the Excel 2016 from Scratch series, Peter
Kalmstrom explains how to use the three tools you can find
in the What-If Analysis dropdown under the Excel Data tab:
Scenario Manager, Goal Seeker and Data Table.
All three tools show what happens when different parameters
changes, but they work in different ways.
This is what Peter shows in the demo below:
Peter uses Excel 2016 for his demo, but the Excel basics
are the same for earlier versions of Excel.
- How to use the Goal Seek to see what value
one cell must have to give a set value in another cell.
Peter uses the example "What sales price must I have
to get a profit of ...?"
to use the Scenario Manager to create different
scenarios where values in certain cells vary and affect
values in other cells that depend on them.
Peter uses the example "How will values in the other
cells change when the interest value changes to ...
- How to create a column of values of the same kind
and a row of values of another kind and use them as
axes for a Data Table.
The example question is: "How will the profit change
for all possible combinations of interests (the column
axis) and loan (the row axis)?"