Home · Course Details

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.

  • 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

  • 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

Topics covered include:
  • Performing simple 'What if’ modelling
  • Using Scenario Manager
  • Using Goal Seek
  • Using Solver

No pre/post work required

Name Date Time Location Cost
Virtual Class - Excel: Data modelling with Scenarios, Goal Seek & Solver 18 February 2019 12:00 pm - 01:30 pm Online $99
Virtual Class - Excel: Data modelling with Scenarios, Goal Seek & Solver 9 May 2019 09:30 am - 11:00 am 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.