Excel 2016 from Scratch Exercise
What-If-Analysis B – Scenario Manager
An Excel tutorial by Peter Kalmstrom
watch What-If-Analysis A before you try this exercise in the Excel 2016 from
Scratch series. In that tutorial Peter Kalmstrom explains the Excel What-If-Analysis
tools in more detail.
In the demo below Peter uses perfume sales as an example and shows how to
use the Scenario Manager to examine how the price changes when the company
changes its markup.
download the Excel file Peter uses in the demo and try the exercise yourself!
This is shown in the demo below:
- How to use formulas to calculate prices with and without VAT with a given
- How to use the Scenario Manager to create scenarios with different markup
values, to study how the sales prices with and without VAT are affected.
Peter uses Excel 2016 for his demo, but the Excel What-If-Analysis tools are
similar same for earlier versions of Excel.