There are lots of demos of Goal Seek for Excel 3002 on YouTube.
YouTube demo 1
YouTube demo 2
YouTube demo 3
YouTube demo 4
YouTube demo 5
YouTube demo 6
Scenarios
Excel's Scenario Manager makes it easy to look at various options in a spreadsheet.
There are a number of steps involved in the process, so work carefully. However, the idea is not complicated. It gives you a way of trying out various numbers in your cells and comparing the differences.
- Microsoft has lots of help for scenarios.
- About scenarios - simple explanation of what a scenario is from Microsoft
- Check that hunch with Excel "what-if" scenarios video demo from Microsoft
- Using scenario manager to evaluate what-if questions from Microsoft
- Calculate your sales commission with Excel scenarios - an example of using scenarios from Microsoft
- Use the Scenario Manager feature in Excel - another explanation of scenarios from Microsoft
- Scenario analysis to test budget assumptions - an example of advanced use of scenarios from Microsoft
