In this webinar recording we examine Excel’s built-in What-If techniques. This is an introductory session on the topic.
In Excel it is easy to change a few cells and see the results. You can use trial and error to achieve a result. There are a few built-in features that can make this process a lot easier and save you a lot of time. In terms of financial models and budgets you may also want to handle best, worst and base case scenarios. There is also a new feature in Excel 2016 called a Forecast Sheet that can automatically create a forecast for you.
The session introduces the following five topics
- Goal Seek – simple what-if changes
- Solver – advanced what-if analysis
- Scenario Manager – handling different sets of inputs
- Data Tables – single and double variable sensitivity analysis
-
NEW - Forecast sheet
As always you may pick up a few other tips along the way.