Excel Business Modelling
Categories: Microsoft Excel
Excel Business Modelling.

About the Course:
This course is for Microsoft Excel versions up to 2003. 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.

Course Contents:
- 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
- The INDIRECT function
- How INDIRECT works
- When to use it
- Masking
- Avoiding the IF function
- Creating a mask
- 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 using charts
- Scenarios
- The scenario drop-down tool
- Adding scenarios
- What-if analysis
- Creating a scenario report
- Data tables
- One-way data tables

 
Tools
 
Key Details
Duration2 days
 
£595
per delegate