Advanced financial modelling
Advanced financial modelling
Financial Training Associates' 3 day advanced modelling course allows participants to improve the reliability and quality of their Excel models. Experienced modellers appreciate that expert financial modelling demands a highly structured approach, together with an advanced knowledge of key Excel features and techniques. This course is designed for users with some prior experience of building financial models and shows delegates how to build superior financial models using tried and tested methods, applying Excel shortcuts and tricks as they go.
This is a highly practical, hands-on advanced Excel workshop. By the end of the course delegates will be able to:
- Build a financial model, starting from a blank spreadsheet
- Design models which minimise errors
- Write their own financial models using advanced Excel features such as macros and data tables
- Apply advanced modelling techniques to conduct sensitivity and opimisation analyses.
Structure for the advanced financial modelling course
The advanced course starts by outlining good modelling standards and structure, and agreeing objectives for an integrated financial model. Each session considers the next stage of modelling, applying financial theory, model building techniques and exploring potential difficulties as participants build their own model in stages. This is a "hands on" course and participants spend the majority of their time on advanced practical financial modelling tasks. With the help of the course tutor, and through a well proven step-by-step approach, participants will depart this intensive course with the confidence and ability to apply advanced financial modelling techniques in Excel.
Methodology for the advanced financial modelling course
FTA's "advanced financial modelling" course is delivered using a practical and interactive case study. Worked examples demonstrate how and why each financial modelling technique is applied. Emphasis is placed on the practical design and construction of advanced Excel financial models, with delegates gaining plenty of hands-on modelling experience during the course. On this program delegates benefit from group discussion as well as formal lectures. Comprehensive course notes and Excel-based financial modelling software are also supplied for reference.
Financial modelling course extract: advanced Excel functions
This sample course material has proved helpful to other delegates who have asked for help and instructions when using particular Excel functions useful in financial modelling. It provides instructions regarding how to use particular advanced functions in Excel.
The course material is lodged here because it has proved useful to other delegates, either before or after a program. Unless specifically requested by a client, it is not necessarily covered on Financial Training Associates' taught courses.
Poll: what advanced Excel modelling function would you like help with next?
Click on the poll below (opens in a new window) to tell us which advanced Excel modelling function you'd like to see included here next:
Book on the 3 day advanced financial modelling training course
This program is next running Mar 2012. To book on the advanced Excel financial modelling training course please click on the
"red booking button" below.
More details on the advanced financial modelling course
A full outline for FTA's advanced financial training course is available here:
advanced financial modelling course.
