X
  • (+65) - 6323 7911

Excelytics Logo

Course Dates
  OCT: 23-24

  Duration: 2 days
  Time: 9am to 6pm



Course Fee (excluding GST) $1200
7% GST on Nett Course Fee $84
Nett Fee Payable (inclusive of GST) $1284



Register Now


Financial Modeling, Forecasting and Analysis with Excel VBA

What Will Be Taught For This Excel Visual Basic Financial Modeling Course?

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.

This intensive financial modeling 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.

 

Who Should Attend This Excel Visual Basic Course Training?

Ideal for Business and Financial professionals such as Analysts, Investment Managers, CFOs, Accountants, Bankers and much more to harness the more sophisticated programming functions in Microsoft Office Excel to build financial models.

Pre-requisite

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

Enquiry Form
By submitting your contact details, you have given your consent for a ST Electronics (e-Services) representative to contact you regarding your enquiry.