Home >Tips >Excel 2016 from Scratch >What-If-Analysis B, Scenario Manager kalmstrom.com site map icon Site map  

Excel 2016 from Scratch Exercise

What-If-Analysis B – Scenario Manager

An Excel tutorial by Peter Kalmstrom

Excel 2016 iconPlease 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.

Exercise

Please download the Excel file Peter uses in the demo and try the exercise yourself!

Content

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.





Learn more



---------------------------------------------------------------------------------------






Always the latest news in the kalmstrom.com blog


Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!

back icon next icon