What If Analysis Training

We also have Free training videos on this site ( visit the Home page or the Training Page)

We provide free what if analysis training videos to help you understand the tools used for financial modeling. The video clips can be watched online and include step by step instruction to help you understand how to use the what if analysis tools with confidence.

Some of the free content that includes videos:

• Using Goal Seek
• Working with multiple scenarios
• Making use of the watch window
• Making the most of the data tables.

Using Goal Seek

The tool is useful for specifying the result needed as well as indicating what input may change. When the tool is used the program will make the calculation. This is an important tool when working with breakeven points.

Working with multiple scenarios

Excel offers a feature that makes it possible to change a number of input cells which are based on predefined conditions. You can for instance, specify the worst case scenario, optimistic, and realistic scenarios and have the ability to switch amongst them.

Making use of the watch window

The feature allows for continuous viewing of specified cells irrespective of where the cells are located in the worksheet while input changes can be made at the same time.

Making the most of data tables

The data table feature allows for automatic running of multiple scenarios based on specific variables.

Make your way to our free what if analysis training videos or book one of the one day advanced training courses in Johannesburg, South Africa to become a power user of what if analysistools.