Advanced financial modelling using Excel and VBA

Consolidate your skills, learn more advanced techniques

Those who already have significant experience in financial modelling with Excel and who wish to consolidate their skills and learn some more advanced techniques that apply in a corporate finance and financial markets context.

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

• create flexible, robust models
• 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 speaker will be drawn from a pool of qualified professionals who specialise in this subject. Having worked for leading organisations they will relate the course content to real life case studies.

The course consists mostly of hands-on exercises, with a brief recap of underlying financial theory only where appropriate.

• Introduction: best practices in model formulation, design, layout - some highlights; sensitivity analysis and optimisation - key topics recap; the need for flexible models; Excel functions for flexible modelling - overview.
• Creating flexible models I: using lookup functions; hands-on exercises - scenario modelling, flexible timing of  a data set, manipulation of data etc; text functions; hands-on exercises - updating data feeds to graphs and graph labels, using reference functions, switching data sets for model inputs without rewriting formulae.
• Creating flexible models II: using date functions; hands-on exercises - flexing the time axis rather than the data set, creation of database queries; analysis of data sets - statistics functions, database functions, and array functions.
• Manipulation of data sets: using text functions, including combining with lookup and date functions; hands-on exercises - cleaning datasets, combining datasets.
• Getting started with VBA; the need for VBA; introduction to the visual basic editor; hands-on exercises - basic examples in recording a macro, and simple examples of writing code from scratch.

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.

Each day of the programme starts at 9.00am and ends at 5.00pm. Lunch and refreshments are provided. It is non-residential.

12 CPD hours (where applicable).

Participants should already have a good knowledge of core Excel functions and functionality, a solid foundation in the key principles of corporate finance, and some basic knowledge of financial products. The VBA section does not require prior experience although some previous exposure is generally beneficial.

Find out more
If you have any queries please email or phone us on +44 (0)845 026 4722.

CIMA on demand
CIMA on demand is a high quality online professional development solution, specifically designed for busy finance and business professionals. Find out more.