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

Excel 2016 from Scratch Exercise

What-If-Analysis C – Goal Seek and Scenario Manager

An Excel tutorial by Peter Kalmstrom

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


Please 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.

Learn more

Office 365 from Scratch cover SharePoint Online from Scratch cover SharePoint Online Exercises cover
SharePoint Workflows from Scratch cover Excel 2016 from Scratch cover SharePoint Flows from Scratch cover

Always the latest news in the kalmstrom.com blog

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

back icon next icon
Products Buy FAQ Services Tips Services Books Contact About Us Blog

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved