Financial Modelling - Introduction - 19 March 2018 - Try before you buy

This is the try before you buy version of the course. Click add to cart to sign up to the first session of this live interactive online course. Limited availability, so book now to take advantage!

Session 1

Mon 19 March
9:30am – 11:30am

Session 2

Wed 22 March
9:30am – 11:30am

Session 3

Thur 23 March
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 your 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. Laptops (excel v.2013) are provided.

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:

*Please note this includes access to the first free session only and no CPD will be awarded with this offer.

19 seats available.
Price: £0.00 (excludes VAT)
Quantity: