Learning Excel What-If Analysis

Find out how to analyze hypothetical business cases in Excel.

Introduction

• Improve decision-making with what-if analysis
• What you should know

1. Defining Scenarios and Data Tables

• Create a scenario
• Show and hide scenarios
• Summarize scenarios
• Edit and delete scenarios
• Define a one-variable data table
• Define a two-variable data table

2. Creating Goal Seek and Solver Models

• Find a target value using Goal Seek
• Activate Solver
• Set up a Solver worksheet
• Select an optimization target and operation
• Define constraints
• Require integer solutions

3. Creating a Configurable Model

• Organize your analysis worksheet
• Create a slider
• Create check boxes
• Manipulate your model

4. Performing Monte Carlo Simulation

• Define a scenario
• Create an input table
• Calculate demand
• Run and evaluate your simulation

Conclusion

• Next steps