Standard SharePoint Products
Calendar Browser
Kanban Task Manager
Pivot Explorer
Templates Manager
Ideas
Buy
Standard plan
Premium plan
Support
Discount
Services
4 hours sessions
Demonstrations
Enhancement Contracts
Tips
Books
Excel from Scratch
Power Apps with SharePoint from Scratch
PowerShell with SharePoint from Scratch
SharePoint Flows from Scratch
SharePoint Online Essentials
SharePoint Online Exercises
SharePoint Online from Scratch
SharePoint Workflows from Scratch
Microsoft Teams from Scratch
Office 365 from Scratch
Contact
About us
Founder
Tools
PnP Generator
Home
>
Tips
>
Excel 2016 from Scratch
>
What-If-Analysis C, Goal Seek and Scenario Manager
Site map
Excel 2016 from Scratch Exercise
What-If-Analysis C – Goal Seek and Scenario Manager
An Excel tutorial by Peter Kalmstrom
This 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.
Exercise
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
Products
Buy
Services
Tips
Books
Contact
About Us
Tools
Security and integrity
Copyright Kalmstrom Enterprises AB All rights reserved
This
exercise in the Excel 2016 from Scratch series is connected
to two demos. 
