Objectives:
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.
Pre-requisites;
A
basic knowledge of Excel spreadsheets is required, ideally with some practical
experience of model building.
Content;
Modelling Principles
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
Data analysis
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
Management tools
Goal
Seek
Solver
Scenarios
Introduction
to Macros (VBA)
Introduction
to User Defined Functions using VBA