Home ·
Learn how to use Scenario Manager, Goal Seek and Solver to perform complex spreadsheet modelling and how to quickly analyse options and make better decisions.
Snapshot
- Duration: 90 minutes
- Category: Excel
- Platform: Adobe Connect
- Level: Experienced
- Pre-requisites: Basic familiarity with Excel formulas
- Version: Suitable for 2010, 2013, 2016 and Office 365
Learning Outcomes
- Understand spreadsheet modelling
- Create a simple what-if model
- Create models with captured scenarios
- Use Goal Seek to model simple scenarios
- Use Solver to model complex scenarios
Course Outline
Topics covered include:
- Performing simple 'What if’ modelling
- Using Scenario Manager
- Using Goal Seek
- Using Solver
Resources & Precourse Work
No pre/post work required
| Name | Date | Time | Location | Cost (inc GST) | |
| Virtual Class - Excel: Data modelling with Scenarios, Goal Seek & Solver | 9 May 2019 | 09:30 am - 11:00 am | Online | $99 | |
| Virtual Class - Excel: Data modelling with Scenarios, Goal Seek & Solver | 2 August 2019 | 09:30 am - 11:00 am | Online | $99 | |
| Virtual Class - Excel: Data modelling with Scenarios, Goal Seek & Solver | 11 September 2019 | 02:30 pm - 04:00 pm | Online | $99 | |
| Virtual Class - Excel: Data modelling with Scenarios, Goal Seek & Solver | 7 November 2019 | 12:00 pm - 01:30 pm | Online | $99 |
Not quite the content you’re looking for?
Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.