Financial modelling - Essential introduction

Date:
15 November 2017
Time:
9:00am-5:00pm
Location:
Edinburgh

Member price: £429.25 + VAT

Non-member price: £505 + VAT

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


Edinburgh, 15 November 2017

Book with BPP


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.

This one-day course is a prerequisite for the subsequent financial modelling course. 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.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

Edinburgh

Contacts

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

Topics

  • Corporate and financial reporting
  • Scotland
  • Training courses
  • Edinburgh

Previous Page