| Date: | 15/11/2022 |
|---|---|
| Time: | 1:00 PM AEDST |
| Event: | FREE Webinar - Excel What If Techniques |
| Topic: | Excel What If Techniques |
| Public: | Public |
| Registration: | Click here to register. |
FREE Webinar – Excel What If Techniques
In this webinar we will 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.