Financial Modelling in Excel

Financial Modelling in Microsoft Excel

Duration:
1 Day
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.
  • Be able to produce flexible models for producing periodic statements.

Pre-Requistites

A basic knowledge of Excel spreadsheets is required, ideally with some practical experience of model building.

Versions

Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
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
Related courses
Run this
course at
your offices
Request a quote
which course
Which level do you need?
Take our online skills assessment
Find out more
Speak to a friendly advisor

call

0333 344 6630

or visit our

Online Chat
Trustpilot