Financial modelling - Essential introduction

Date:
13 May 2019
Time:
9.00am-5.00pm
Location:
London, Manchester, Birmingham, Edinburgh

Member price in Scotland: £361.25 + VAT
Non-member price in Scotland: £425 + VAT

Please note, the ICAS member discount will be applied after checkout.

Member price in England: £612 + VAT
Non-member price in England: £720 + VAT

Please note, due to differences regarding external costs, courses outside of Scotland are priced separately. ICAS members are eligible for a discounted price on all courses running in England & Wales.


Edinburgh, 26 September 2019

Book with BPP


London, 13 May 2019
Manchester, 20 May 2019
London, 10 June 2019
London, 10 July 2019
London, 12 August 2019
London, 9 September 2019
Birmingham, 30 September 2019
London, 7 October 2019
London, 6 November 2019
London, 2 December 2019

Email to book



A practical 1-day course covering all of the basic excel skills needed to start building a financial model.

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. It covers all the basic excel required in order to start to build a financial model.  Laptops (excel v.2007) are provided.

Full speaker list

Speakers

View full event details

Content

  • 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

Location

London, Manchester, Birmingham, Edinburgh

Contacts

BPP
Tel: 0330 060 3303
Email: ldicas@bpp.com

Topics

  • Corporate and financial reporting
  • England and Wales
  • Scotland
  • Training courses
  • Edinburgh
  • London and Home Counties
  • Manchester and the North
  • Birmingham and the Midlands
  • Technology

Previous Page