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.
- Online Resources
- 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
Microsoft has lots of help for scenarios.
