Financial Modelling in Microsoft Excel
On completion of this course delegates will;
- Be able to build financial models based on best practise modelling principles.
- Be able to build models that are easily understood and easy to share with others.
- Understand the key issues surrounding building financial models.
- Be able to conduct a variety of sensitivity and scenario analyses.
- Have seen and used a wide variety of Excel functions and tools.
- Be able to produce flexible models for producing periodic statements.
A basic knowledge of Excel spreadsheets is required, ideally with some practical experience of model building.
- - Model structure, formatting and best practises
- - Using range names
- - Maximising flexibility
- - Using tables
- - Creating, editing, finding and maintaining links between workbooks
- - Building larger models
- - Auditing
- - Creating charts
- - Shortcuts
- - Financial functions – SUM, SUBTOTAL, NPV, IRR, XIRR etc.
- - Lookup functions – INDEX, VLOOKUP, HLOOKUP, MATCH, OFFSET etc.
- - Text functions – LEN, FIND, LEFT, RIGHT, MID, TRIM etc.
- - Database features – functions, reporting, filtering, extracting, Pivot Tables
- - Circular references
- - Goal Seek
- - Solver
- - Scenarios
- - Introduction to Macros (VBA)
- - Introduction to User Defined Functions using VBA