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
This course covers the basic programming construct such as
- For-Next loop
- Random Number Generation
- 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.
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:
- Finance Managers
- Portfolio Managers
- Bank Managers
- Credit Officers
- Financial Advisors
- Investment Bankers
No pre-requisite is required, although some introductory knowledge in accounting would be helpful.
COURSE FEES AND FUNDINGS
SME (ETSS Scheme)
|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.