Financial Modelling in Microsoft Excel

Financial Modelling in Microsoft Excel

1 Day

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.

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
Speak to a friendly advisor


0333 344 6630

or visit our

Online Chat
i-Cornerstones Learning and Performance Model
Creating the right learning programme for you

Our approach is to provide the skills and knowledge to increase productivity and achieve attitudinal and behavioural change, leading to long-term improved performance, increased employee engagement, retention and consistent gains in profit.

Our i-Cornerstones Learning & Performance Model is dynamic, flexible framework that outlines the TrainingU philosyphy and key stage processes we work through to ensure we deliver the exact learning programme for your needs and within your budget.

How we deliver learning
Your Offices (in-house)
Your Offices

If you have a number of people in your organisation with the same training need, in-house training programmes are an ideal, collaborative learning solution.

Find out more...
Our Training Venues
Our Training

Ideal for single/few staff member(s) that need development in a certain area. Sharing ideas and experiences with people from other organisations can be a huge benefit.

Find out more...
Virtual Learning

Enabling staff to join live classroom training via web conferences. Ideal for organisations with multiple offices or where staff are geographically spread.

Find out more...
Sprint Learning

High impact 90-minute training sessions delivered either face-to-face or virtually in targeted subjects, to boost performance whilst reducing your staff time out of the business.

Find out more...
Managed Learning Services
Learning Services

As an extension to your in-house L&D team, we will look after all the planning and organisation of your staff training needs, from assessment of needs through to delivery and evaluation.

Find out more...
Contact Us

If you need any help with finding
the best course for you, please call us on

0333 344 6630

How did you hear about us?

TrainingU will not pass your contact details onto any third parties, and will only contact you in relation to your enquiry.

Our commitment to quality

We are an accredited training provider with the Learning and Performance Institute which gives you the assurance that we conform to a professional Code of Practice.

Learning and Performance Institute