Excel VBA for Finance

       APPLY NOW





SSG Course Code: CRS-N-0048333/TGS-2020502312

 

In view of the current Covid-19 situation, the upcoming course run will be held online
Learn VBA programming from scratch, applied onto Finance

VBA for Excel remains an important programming language in the Finance industry. It is easy to use, highly available through Excel and very useful in prototyping a programming idea or automating workflow. It’s usage survives beyond more sophisticated languages such as C++, C#, Matlab and R. 

The course teaches individuals VBA programming from scratch with the aid of finance examples.

4 areas of finance will be covered:

  • Corporate finance
  • Asset management
  • Derivatives
  • Bonds


TOPIC COVERAGE

This course covers the basic programming construct such as

  • For-Next loop
  • If-Then-Else
  • Random Number Generation
  • Arrays
  • Functions and Forms

Applications include Retirement Planning Tables, Stock Valuation, Income Tax and Brokerage Computation, Random Walk Models, Black Scholes, Option Pricing, Binomial Option Pricing, and Valuation through simulation. 

 
   

Course Fees

SGD 1,070

(SGD 121 after MAX Funding)

 
   

Date

11 Dec 21

9am - 5.30pm

 
   

Venue

NUS Business

School

 
   

Level

Basic

 


   

Advisor: Crystal Tan (Ms)
Contact: +65 6516 1320
Email: crystal@nus.edu.sg

 

APPLICATION PROCEDURE AND DEADLINE

  • Participants are strongly advised to apply at least 2 weeks in advance.

WHO SHOULD ATTEND

Suitable for anyone who uses Excel extensively in their work, including but not limited to:

  • Accountants
  • Finance Managers
  • Portfolio Managers
  • Brokers
  • Bank Managers
  • Traders
  • Credit Officers
  • Financial Advisors
  • Investment Bankers



PRE-REQUISITES

No pre-requisite is required, although some introductory knowledge in accounting would be helpful. 

COURSE FEES AND FUNDINGS

 Self-Sponsored

Company-Sponsored

SME (ETSS Scheme) 

Company-Sponsored

Non-SME 

Course Fees $1,070.00 $1,070.00 $1,070.00
Singapore Citizens & PRs aged 21 years and above $321.00 $121.00 $321.00
Singapore Citizens aged 40 years and above (MCES Scheme) $121.00 $121.00 $121.00

The above prices are quoted in Singapore dollars (SGD), inclusive of 7% GST.