Financial Modelling - Introduction - 8 October 2018

This programme is delivered online live, allowing delegates to interact with expert presenters from either a computer or mobile device.  For an overview of the technology and live class experience, watch our short explanatory video to find out more.

Delivery schedule:

Same content as a traditional course just spread over 3 days in shorter 2 hour sessions.  No more travel no more losing a day out of the office.

For those who prefer the traditional approach please visit our face to face class schedule

Session 1

Mon 8 October 9:30am – 11:30am

Session 2

Thu 11 October 9:30am – 11:30am

Session 3

Fri 12 October 9:30am – 11:30am

* Please note that each session has 30 minutes of non teaching time included, this is to ensure we have time to help you get set up ahead of your learning  
* Before purchasing we advise that you check your system compatibility with this online test passing tests 1,2 & 3 means you're good to go number 4 is not so important.

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.

Course Overview:

Numerous practical, hands-on exercises are demonstrated 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

The presenter will cover the following during these live sessions

  • 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

CPD:

6 hours

Duration of access:

You will have access to the programme for 6 months from the date of the first live session (this includes recordings, learning materials, certificate of completion and other programme information). 

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

24 seats available.
Price: £720.00 (excludes VAT)
Quantity: