Overview:
The workshop is about the What-if Analysis-a set of Excel's decision-making tools.
These tools enable the user to investigate what is the impact of input changes on correlated outputs. It allows the decision-maker to make wiser choices. The two topics covered are the Goal Seek and the Data Table-Sensitivity Analysis.
You will learn how to use these features for any of your models (budgets, forecasts, or other disciplines) - to be able to understand what is the impact of changes of these models. These tools empower the users to evaluate and examine their decision models - potentially reaching better decisions. The chapter covers the Goal Seek and the Sensitivity Analysis tools.
The two topics used frequently for this matter are:
- Goal Seek
- Data Table -Sensitivity Analysis
Goal-Seek, the first tool, allows the analyst to check the impact of one variable input’s change on a target output. The user determines a goal-and the tool shows the user what has to be changed to achieve that goal.
Data Table is a Sensitivity Analysis tool. The analyst can change one or two inputs (One-Way and Two-Way Data Tables) and find out the impact of making small incremental input changes in one or two variables on the outputs.
Why you should Attend:
Excel users that need advanced tools for decision-making. These topics were taught by the presenter in the executive MBA programs, where the attendees did not have a solid quantitative background.
Areas Covered in the Session:
- Goal-Seek
- Data-Table
- One-Way Data Table
- Two-Ways Data Table
- Using Scroll Bars
- Case Study
Who Will Benefit: