Financial Modeling, Forecasting and Analysis with Excel VBA

Course details

The rapidly increasing computational power of personal computers in combination with the development of dynamic software solutions for computational needs have in the recent few years brought the advantage of fairly sophisticated financial models in to the reach of a broader audience. The increasing flow of financial information is covering the skill of quantitative modeling using computers from an advantage into necessity.

MS Excel offers a good balance of ease-of-use, flexibility and efficiency in financial modeling, and has become the standard in the financial community. A reasonable level of efficiency however requires rather good knowledge in the Visual Basic for Applications (VBA) programming language.

The intensive course will teach Excel users how to harness additional programming power in the context of building Excel financial spreadsheet models. The sessions will emphasize technical issues to give the participants the tools needed for the latter sessions which will focus on familiar spreadsheet financial models which participants have already acquired. A short introduction into each topic is offered during the lectures, generally accompanied with examples. This course will be held in an interactive fashion where participants have the chance to instantly work with each presented example using a building block approach in learning.

COURSE OUTLINE

• Module 1 : Using Spreadsheet And Financial-Modeling Languages
• Module 2 : Introduction to VBA Development in Excel
• Module 3 : Getting Started with VBA
• Module 4 : Arrays
• Module 5 : Control Logic and Loops
• Module 6 : Working With Excel Objects
• Module 7 : More On Variables And Subroutines
• Module 8 : Integrating a VBA Application

LEARNING OUTCOME

What you will learn:

• Learn how to develop sophisticated spreadsheet models using Visual Basic for Applications (VBA) programming language.
• Gain hands-on experience on how to build Excel spreadsheet models.
• Learn how to improve your current spreadsheet models.
• Know what is spreadsheet models and its limitations.
• Increase your skills and capabilities in building advanced financial and corporate models.

PRE-REQUISITE

• The participants are assumed to have fundamental knowledge of Excel and already have foundational knowledge in financial, statistical and econometric concepts