|1:00 PM AEDST
|FREE Webinar - Excel What If Techniques
|Excel What If Techniques
|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.