Advanced Financial Modelling in Excel

* Claim back your VAT
Find out more

Request a different date or location for this course (we regularly add courses following requests).

{{alternativeRequestSuccess}}
{{alternativeRequestError}}

* Claim back your VAT
Find out more

Overview

Introduction

The course includes teaches you how to resolve many complex issues in excel for financial modelling analysis with VBA including efficiently structuring financial models, automating the uploading of data from the internet, using functions to resolve circular references, applying techniques to efficiently work with databases, applying VBA to analyse data and perform Monte Carlo Simulation, creating dynamic goal seek functions and many other VBA applications.

By signing up for the course you will be able to do things like read any stock price or commodity price from the internet and make different automated graphs; create print macros that can print any sheet of a workbook in a flexible manner; develop customised functions that resolve just about any circular reference with resorting to copy and paste macros; and develop functions that make goal seeks work automatically when anything in your excel model is changed.


Teaching Approach/Objectives

Using a number of intensive hands-on exercises and case studies, participants work through the theory and application of valuation and modelling issues that are difficult to solve without sophisticated VBA and functions.  After introducing programming techniques that can address various problems in finance, participants apply the techniques in a real world context. A series of database files, cash flow forecasts and budgeting applications will be used to demonstrate how the efficiency of excel can be dramatically improved through using functions together, through creating VBA macros for custom short-cuts, through selective macros and other tools.  A vast library of case studies, financial models, excel tools for financial analysis and other information is provided to participants. The course is intended to be practical and inter-active, with delegates encouraged to ask questions. The techniques taught to delegates are intended to be of immediate practical use in the workplace.

Who should attend

The advanced modelling course is for all those who wish to develop their financial valuation skills to a higher standard.

Related Courses

Inhouse

We can bring this course to your company's office.

If you simply want to run this course at a location convenient to you or if you want a completely customised learning solution, we can help.

We produce learning solutions that are completely unique to your business. Our tailored learning solutions are designed specifically for your organisation’s needs.

We’ll be here to support you every step of the way. From the initial consultancy through to evaluating the success of the full learning experience. We'll ensure you get the maximum return on your training investment.

Find out more

Why us


We have a combined experience of over 60 years providing learning solutions to the world’s major organisations and are privileged to have contributed to their success. We view our clients as partners and focus on understanding the needs of each organisation we work with to tailor learning solutions to specific requirements.

We are proud of our record of customer satisfaction. Here is why you should choose us to help you achieve your goals and accelerate your career:

  • Quality – our clients consistently rate our performance ‘excellent’ or ‘outstanding’. Our average overall score awarded to us by our clients is nine out of ten.
  • Track record – we have delivered training solutions for 95% of worlds’ top 100 banks and have trained over 250,000 professionals.
  • Knowledge – our 150 strong team of industry specialist trainers are world leading financial leaders and commentators, ensuring our knowledge base is second to none.
  • Reliability – if we promise it, we deliver it. We have delivered over 20,000 events both in person and online, using simultaneous translation to delegates from over 180 countries.
  • Recognition – we are accredited by the British Accreditation Council and the CPD Certification Service. In an independent review by Feefo we scored 96% on service and 95% on product