Advanced modelling course
Jul – 2 days
July 20 @ 9:30am - July 21 @ 5:30pm
This financial modelling course is designed for participants who have some prior experience of working with Excel financial models.
This is a “hands on” program where participants spend the majority of their time on practical financial modelling tasks.
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.
All through the course delegates spend their time working with their own spreadsheets, exploring the limits to which Excel can be used to solve advanced data manipulation and financial modelling challenges.
Excel ‘power modelling’ functions
Approximately 3/4 of the course is spent on exploring advanced Excel functions, exploring advanced Excel functionality
Excel macros and VBA programming
Approximately 1/4 of the course is spent showing training delegates how to get started creating Excel Macros and how to move on to programming in VBA.