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.
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.