Advanced modelling

This financial modelling course is designed for participants who have some prior experience of working with Excel financial models.

On this financial modelling course delegates cover the Excel functions most likely to be helpful when building advanced models. Delegates work through particularly useful Excel functions, tackling data manipulation and advanced financial modelling problems in class.

The course includes an introduction to macros and Excel VBA programming. On the course participants work together to build simple macros. Delegates also work on exercises which demonstrate how to begin solving advanced data manipulation problems using VBA.

This is a “hands on” program where participants spend the majority of their time on practical financial modelling tasks. 

Exploring advanced Excel functionality

On this financial modelling course delegates cover the Excel functions most likely to be helpful when building advanced models. Delegates work through particularly useful Excel functions, tackling data manipulation and advanced financial modelling problems in class.

Responding to delegate needs

This program is taught according to training delegates’ needs – and requests the group makes regarding Excel functions they would like covered. In advance the group agrees with the tutor which functions they would like taught and demonstrated. The aim here always is to make sure that attendees don’t spend a lot of time covering functions most people are familiar with.

Introducing VBA

The course includes an introduction to macros and Excel VBA programming. On the course participants work together to build simple macros. Delegates also work on exercises which demonstrate how to begin solving advanced data manipulation problems using VBA.

Small group teaching

We always keep numbers on this course extremely low to preserve the learning experience. Personal attention is guaranteed. Please feel free to make an enquiry regarding how many individuals are currently booked on your run of the course.

We deliberately cap numbers at six.

With the help of the course tutor, and through a well-proven step-by-step approach, participants depart this intensive course with the confidence and ability to apply advanced financial modelling techniques in Excel.

This course includes detailed coverage of Excel functions that are both:
(i) essential and
(ii) often helpful in financial modelling.

The course also includes an introduction to VBA.

You can see the full outline for the advanced modelling course

Advanced modelling course

As a result of using high-quality trainers, and teaching in very small class sizes, training delegates’ consistently give exceptionally strong reviews for our programs.

We have made available online every single one of our course reviews publicly here. The reviews consistently show very strong feedback for our financial modelling course training.

 

You can see what other delegates have said about their course with us

Course reviews

Our trainers will come to your company.

If you have 3-4 employees who may be interested in the same course in-house training will likely prove cost effective.