Back to Search Results

Training Course Summary:

This course is aimed fairly and squarely at people who work in Finance and business modelling. Developed in-house by an expert in business modelling, this course shows you how to create robust business models which are easy to build and (above all) easy to test. The course makes extensive use of Excel range names.

Training Course Overview/Content:

Building models

Freezing windows
What makes a good formula
Separating inputs and calculations
Avoiding the IF function
Maintaining constant periodicity
Range names and absolute references

Absolute references ($ symbol)
Fixing only the row/column
Creating range names
Labelling ranges automatically
The amazing 40% rule
Number formatting

Conditional number formats
The four parts of a format
Creating custom formats
Formatting dates and times
Advanced formatting

Creating and applying styles
Grouping and outlining
Data validation
Applying protection
Styles

Creating formatting styles
Using the style drop-down box
The NORMAL style
Reference functions

Combining MATCH and INDEX
Using VLOOKUP
Using the OFFSET function

Creative use of functions

Using INDIRECT
Ways to avoid IF functions
Using input masks
Analysis Toolpak functions
Cashflow calculations

Avoiding circularity
Separating interest paid and received
Dealing with compound interest rates
Getting quarterly summary figures
Investment appraisal

Net present value
Internal rate of return
Non-periodic cashflows
Array formulae

Creating array formulae
Editing and deleting
Strengths and weaknesses
Goal-seeking

Goal-seeking
Goal-seeking using charts
Scenarios

The scenario drop-down tool
Adding scenarios
What-if analysis
Creating a scenario report