Financial Modelling - Introduction

Pricing

Cost for BPP PD Members: £586 + VAT 6 CPD Hours
(£720.00 + VAT for non BPP PD Members Click Here for details of our membership scheme).

Please click below to watch our short course introduction video

Delegates

This one-day course is a prerequisite for the subsequent financial modelling courses, Financial Modelling - Comprehensive, Financial Modelling - Advanced (& Introduction to VBA) and Debt Modelling (with LBO). It covers all the basic excel required in order to start to build a financial model. There is little time to recap these excel basics on the subsequent courses, so it important that delegates who are at all concerned about their basic excel ability should attend this course first. Laptops (excel v.2013) are provided. Courses are limited to a maximum of twelve delegates, allowing each attendee to experience outstanding tutor support throughout the day. .

Please Note: Financial Modelling vs Data Analysis:

Financial Modelling typically involves building a financial forecasting model in order to answer a particular question, such as which project should we invest in, or what rate of return might we expect from a particular investment.

Data Analysis on the other hand involves analysing large amounts of data, often via summarisation, in order to make informed decisions based on the results.Please refer to our Data Analysis series if this is better suited to your needs.

Overview

During this course numerous practical, hands-on exercises are performed to illustrate all the basic excel features and functionality, from basic navigation through to more complex “lookup” functions. There is a mix of following the instructor on the screen, and exercises designed to help the delegates work the answer out for themselves.

Learning outcomes include obtaining a greater understanding of:

  • Excel shortcuts (use of the mouse is actively discouraged)
  • Basic navigation and selection
  • Toolbar and function access
  • Copying and linking
  • Financial modelling essentials: flexibility and dynamism
  • F4 dollarisation (absolute cell referencing)
  • Formatting and styles
  • Excel names
  • Logical statements: IF, AND, OR
  • Lookups:
    • Match
    • VLookup
    • HLookup
  • Switches and drop-down lists

"A CPD certificate of completion will be provided by BPP Professional Education Limited upon request, following attendance."

This course has an online live option available. Same expert presenters delivering the same content to your desk or mobile over multiple days in short 120 minute sessions. Watch our 5 minute explainer video to find out more.

Online LIVE Dates - -


All online live sessions are 9:30 am to 11:30am

Session 1 Session 2 Session 3
08 October 2018 11 October 2018 12 October 2018 Book Now

Course Dates

Location Dates Time Availability  
London 15 Oct 2018 9:00 AM - 5:00 PM  Spaces Book Now
London 12 Nov 2018 9:00 AM - 5:00 PM  Spaces Book Now
London 17 Dec 2018 9:00 AM - 5:00 PM  Spaces Book Now
London 14 Jan 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 11 Feb 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 11 Mar 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 01 Apr 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 13 May 2019 9:00 AM - 5:00 PM  Spaces Book Now
Manchester 20 May 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 10 Jun 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 10 Jul 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 12 Aug 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 09 Sep 2019 9:00 AM - 5:00 PM  Spaces Book Now
Birmingham 30 Sep 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 07 Oct 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 06 Nov 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 02 Dec 2019 9:00 AM - 5:00 PM  Spaces Book Now

Membership Scheme

You and your firm could be saving £000's on your CPD training. Find out how to join our membership scheme and receive immediate benefits.

Tailored training

We can tailor any of our public courses to meet your needs as well as providing completely bespoke training solutions. Learn more about tailored training.

Special Assistance Policy