Book Online: Login | Register

1300 658 388

Search form



Learn how to use Goal Seek, Scenario Manager and Solver to help solve business problems quickly and to forecast more efficiently. This virtual training course will focus on learning how to use the right tools in Excel to help you to more effectively model data for different scenarios. The course is suitable for Excel versions 2007, 2010 and 2013.

Course Price (inc GST where applicable): 
90 mins

2007, 2010, 2013

You'll Learn how to: 

Use the following analysis and modeling tools to make informed decisions quickly and efficiently

  • 'What if’ modelling
  • Scenario Manager
  • Goal Seek
  • Solver
Course Content: 
  • Performing simple 'What if’ modelling
  • Using Scenario Manager
  • Using Goal Seek
  • Using Solver
This Course Suits: 

This course will suit you if you currently use Excel and want to learn to use the modeling and analysis tools on your spreadsheet models to compare different scenarios, solve problems, find optimal solutions and make informed decisions quickly and efficiently.


Successful completion of a TP3 Excel Introduction course or the Creating and Using Simple Formulas online course.

System Requirements

To participate in this virtual training course you will also need:

  • Computer: A computer running Windows XP or newer version or Mac running Mac OS X or newer version with a minimum 1 GB RAM
  • Additional software: JavaScript can be downloaded from Internet Explorer 7 or newer, Mozilla Firefox 4 or newer, Google Chrome 5 or newer, Safari 3 or newer
  • Broadband Internet: A connection with 700Kbps or more bandwidth
  • Headset with built-in microphone:  You will need to test this equipment to ensure your headphones and microphone work before attending training. We suggest you use a USB headset with built-in microphone for the best experience. Some mobile phone headsets with microphone may also be suitable. A simple USB headset with microphone can be purchased for as little at $30 and is a good investment if you intend to do other guided online learning sessions. You will need to test this equipment before attending training.
  • Webcam: This is optional and will allow you to communicate visually with your facilitators and other learners making the session more personal and engaging.

Before booking, please click here to run a quick self diagnostic test. This will let you know if your computer can run Citrix GoToTraining. Call us on 1300 658 388 if you have any questions.

The Learning Process: 
Preparing to learn

When you enroll, you receive a course welcome pack by email. It contains instructions to prepare you (and your computer) for training, as well as the link to access your online training session. Download the course materials and complete the pre-course checklist to ensure your computer is ready to run the course via Gototraining. The pack includes a calendar invite, which includes the link to access the session, so that you can schedule your training into your calendar.

Before the session begins

On the day of training, you receive a final course reminder 1 hour prior to the session’s start time. To connect to the session, click on the link provided and wait for the Gototraining session to begin.

If you have never used Gototraining before, we recommend that you join your training session 20 minutes before the scheduled start time to ensure that you are set up to participate in the session. If you are familiar with Gototraining, connect to the session 5-10 minutes before the scheduled start time to ensure that you are set up correctly before class starts.

During the session

During the session, you are one of up to 15 students participating in an online course led by 2 experienced facilitators. You are guided by the course facilitator through practice exercises that develop your skills. You can print off your course booklet before training or if your monitor is large enough, simply arrange the booklet in a window on your screen to use as you work through the exercises. During the session, you can see the facilitator’s screen and participate by using Chat or by ‘raising your hand’ – both features within Gototraining.  One qualified, experienced facilitator leads the session with the support of a co-facilitator, who answers individual questions and keeps each participant’s learning on track.

After the session

There are useful resources, including shortcut keys, in the Learning Resources section of the TP3 website to help you consolidate and continue your learning.

If you just can't figure out how to do something that was covered in the course, email and a training consultant will contact you with an answer and advice.

Customising this course: 

TP3 can provide a range of consulting services to better meet your business needs, including closed courses for your organisation, customised course material relevant to your industry and requirements, individual or group coaching and blended learning solutions.

Booking Information: 
Call 1300 658 388 to book this course, or book and pay online below.
Course Dates: 

Twitter icon
Facebook icon
Google icon
LinkedIn icon
e-mail icon