Excel What-If Analysis

Duration: 
½ day
Level: 
Intermediate
Objectives: 

(If you're unable to attend a workshop, try these brief tutorial videos:)

   

By the end of this workshop delegates will understand and have experience of using the different What-If Analysis tools that Excel provides. The workshop will also revisit some supporting tools that help when using What-If Analysis.

Pre-requisites: 

Delegates should have experience of using Excel to an intermediate level; being familiar with basic function formula (=SUM, =AVERAGE) and range names.

Category:

Course Content: 

Basics:

  • What do we mean by What-If Analysis?
  • Relative vs Absolute Cell Referencing
  • Creating a data series
  • Conditional Formatting

Goal Seek:

  • Setting a ‘Target’ Cell
  • Identifying ‘Changing Cells’

Solver:

  • Installing Solver
  • Adding Constraints
  • Creating a Solver Reports

Scenarios:

  • Adding & Editing Scenarios
  • Create a Summary Sheet
  • Using range names
  • Creating Charts from  a Scenario

Solver & Scenarios:

  • Creating a scenario from different Solver constraints

Data Tables:

  • One-variable input table
  • Two-variable input table
  • Conditional formatting & data tables