Search

03 August 2017

Financial modelling - advanced (and introduction to VBA)

Category: MASTER COURSE

Consolidate your Excel skills and learn some more advanced techniques that apply in a corporate finance and financial markets context.

Who should attend?
Those who already have Excel financial modelling experience and are looking to consolidate their skills as well as learn some more advanced techniques. It is appropriate for those working in corporate finance, financial planning, financial markets, consulting, and also for general users of Excel for financial applications. 

What you will gain
Enhance and consolidate your Excel and VBA skills as they apply to financial modelling, including the ability to:

  • build models appropriate to a number of situations which are transparent, error-free, flexible and robust
  • use a large set of the tools, Excel and VBA functions that are often required when building models in a wide variety of financial modelling contexts.

The course consists primarily of hands-on exercises (laptops with Excel 2013 provided), with a brief recap of underlying financial theory only where appropriate.

Programme outline

  • Introduction: recap of modelling basics; review and improvement of existing model (exercise)
  • Excel financial functionality including IRR, XIRR, PMT, PPMT, RATE and others
  • LOOKUPS: advanced uses for Match, Choose, Index, Offset, VLookup and HLookup
  • Text features including LEN, MID, FIND, TEXT, VALUE and others….
  • Date and time features including: TODAY, DATE, EDATE, EOMONTH, NOW and others
  • Array functions: examples, and pros and cons
  • SUMIF: advanced uses
  • Circularity: finding it, using it, removing it
  • Sensitivity analysis: watch window, goal seek and solver; switches and scenarios: data validation and ActiveX controls; data tables: 1 and 2 dimensional
  • Model review, audit, security and protection
  • Charting
  • Introduction to VBA: VBA and macros: overview; subroutines vs functions; recording a simple macro; macro review, edit and debug; calling a macro from a macro; triggering a macro; user-defined functions; macro to roll-forward a financial forecasting model

Delegates have exclusive use of a PC throughout the course. Numbers are restricted to 12 to ensure you receive the most effective training during your session.

The course has been developed as a natural follow-on from Financial modelling - comprehensive. The VBA section does not require prior experience. 

The course starts at 9.00am on both days. Lunch and refreshments are included, but not accommodation.
12 CPD hours (where applicable). 

Booking Information

Date Location Price
3 August 2017 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
14 September 2017 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
12 October 2017 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
9 November 2017 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
7 December 2017 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.


Related Events

16/10/2017 09:00:00

Debt modelling (with LBO)

MASTER COURSE

  • Cost:
    GBP 695.00
    Member price: £625. CDS member price: £560. Plus VAT on all prices.
  • Location:
    London
  • Speaker(s):

Discover how to construct a flexible model capable of analysing the suitability of target businesses for a leveraged buy-out.

Find out more

07/09/2017 09:00:00

Project finance modelling

MASTER COURSE

  • Cost:
    GBP 1,390.00
    Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
  • Location:
    London - two day workshop
  • Speaker(s):

Gain a robust and flexible methods for building project models, plus training in the established design solutions to the challenges commonly encountered.

Find out more

14/08/2017 09:00:00

Venture capital and private equity - introduction

MASTER COURSE

  • Cost:
    GBP 1,845.00
    Member price: £1,661. CDS member price: £1,470. Plus VAT on all prices. Excluding accommodation.
  • Location:
    London - three day course
  • Speaker(s):

An explanation of the working of the venture capital and private equity industry, this course gives practical instructions on analysing and structuring transactions, including buy-outs and buy-ins.

Find out more

Financial modelling - advanced (and introduction to VBA)

CIMA members and students should log in to MY CIMA before booking to receive the appropriate discount. Save up to 30% with the CIMA Corporate Discount Scheme (CDS). Find out more at: www.cimamastercourses.com/CDS

Book Now

Tailored training 
We can tailor any of our Mastercourses to meet your needs as well as providing completely bespoke training solutions. Find out more

Find out more 
If you have any queries please email or phone us on: +44 (0)3332 221608. Visit our booking page for information on how to book and pay.

The venue for this course will be confirmed 14 days before the scheduled date. 

CIMA Mastercourses are held in partnership with BPP.  

CIMA on demand is our range of online CPD courses specifically designed for busy finance and business professionals who need training that's convenient and will fit around their schedule. Find out more