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
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 markup percentage.
- 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.