Excel 2016 from Scratch Exercise
What-If-Analysis C – Goal Seek and Scenario Manager
An Excel tutorial by Peter Kalmstrom
exercise in the Excel 2016 from Scratch series is connected
to two demos.
In the first demo Peter Kalmstrom shows some sales calculations.
In the second demo Peter uses the What-If-Analysis tools
Goal Seeker and Scenario Manager to study what happens when
different parameters change.
As an example Peter uses a cupcake store and the different
calculations and analyses needed there.
download the Excel file Peter uses in the demo and try
the exercise yourself!
Peter uses Excel 2016 for his demo, but the Excel What-If-Analysis
tools are similar same for earlier versions of Excel.