Project Description
CEF Course Code: 23C03605-1
CEF Institution Code: 548
Welkin Course Code: CVB
Course Features
- Begin with basic skills and moves step-by-step to more advanced functions
- Learn to build flexible, dynamic and professional models with VBA
- Design spreadsheet models for financial data analysis using Excel VBA
- Qualified and experienced instructors who will share valuable experiences
- Practical and hands-on approach
- Evening and weekend classes with Cantonese and English tuition options
Learn from the Experts
Get Your Skills Certified
Certify your Excel skills with Microsoft Office Specialist Excel Expert certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.
Remark: The course fee does not include the certification exam.
Further Study
Course Fee
$1560*
*after max. 80% fee reimbursement from CEF. Full course fee is $7800.
This course has been included in the list of reimbursable courses under Continuing Education Fund
The Office of the Continuing Education Fund does not have record of registration of this course under the Qualifications Framework
Course Duration
39 Hours
Course Prerequisites
Course participants should be at least 18 years old and have a basic knowledge of finance. It would be advantageous for them to have a good command of using simple worksheet functions such as SUM, MAX , MIN, VLOOKUP and especially IF, and be conversant in writing worksheet formulae for a given problem. Prior programming experience is not required.
Title of Award & Assessment Methods
Students are required to complete and pass 2 course assignments. Upon successful completion of the course and having achieved 80% attendance, students will receive a certificate for the course.
You will pay the course fee ($7,800) by default option. If you choose to pay by monthly installment, please use “Pay when visit Welkin” while checkout. CEF reimburse application (if any) will proceed once the course completed.
Sign up for your course by clicking the “Enrol” button, then proceed to checkout to finish course registration.
| Course No. 課程編號 | Info. 語言/系統/地點 | Start 開課日 | End 完課日 | Day(s) 上課日 | Time 上課時段 | Duration 課程長度 | Course Fee 全期學費 | Enrol 報名 | |
|---|---|---|---|---|---|---|---|---|---|
| CVBB-14C02K | Cantonese / PC / MongKok | 02/11 | 14/12 | MON,THU | 1900-2200 | 39 hours / 13 sessions | 20201102 | $7,800 | $7,800Enrol |
| CVBC-6D21E | English / PC / MongKok | 21/11 | 09/01 | SAT | 1000-1300;1400-1700 | 39 hours / 13 sessions | 20201121 | $7,800 | $7,800Enrol |
| CVBC-25C22K | Cantonese / PC / MongKok | 22/12 | 09/02 | TUE,FRI | 1900-2200 | 39 hours / 13 sessions | 20201222 | $7,800 | $7,800Enrol |
| CVBC-13C18E | English / PC / MongKok | 18/01 | 03/03 | MON,WED | 1900-2200 | 39 hours / 13 sessions | 20210118 | $7,800 | $7,800Enrol |
| CVBB-6D06K | Cantonese / PC / MongKok | 06/02 | 27/03 | SAT | 1000-1300;1400-1700 | 39 hours / 13 sessions | 20210206 | $7,800 | $7,800Enrol |
Financial modeling is an essential skill for finance professionals and students. Excel VBA (Visual Basic for Application, the embedded programming language in Excel) allows you to create powerful spreadsheet models by overcoming the limitations of Excel and automating spreadsheet procedures . In this course, you will learn the fundamentals of Excel VBA and apply VBA skills to developing financial models for various purposes. Upon completion of the course, you should be able to:
- Understand Excel VBA and its application in finance
- Design simple spreadsheet models for financial data analysis using Excel VBA
Part I: Excel VBA Fundamentals
Participants will learn the fundamentals of Excel VBA and prepare themselves to create simple financial models in Part II. Small programs will be used to illustrate the underlying programming concepts.
- The VBA programming environment
- Variables and constants
- Macros
- Built-in VBA functions and operators
- User-defined functions
- Branching and looping
- Object-based concept: Objects, methods and properties
- The Range object
- Debugging
The following additional topics may also be covered if time allows: - Arrays
- Procedures
- Custom dialog boxes
- Workbook and worksheet events
- Chart objects
Part II: Financial Modeling
Participants will apply VBA programming concepts and skills to build simple yet real-world financial models. The techniques of writing good models will also be discussed. As the scope of financial modeling is huge, topics have to be selective. The following shows a list of possible topics. Actual coverage depends somewhat on the finance background of the class.
- Loan amortization
a. Simple model
b. Iteration: The bisection approach
c. Allowance for changing interest rates or repayment period - Financial planning
a. Retirement planning
b. Portfolio restructuring - Market history analysis
a. Normal and real growth of stocks
b. Growth of investment in different assets - Stock simulation
a. Stock volatility estimation
b. The geometric Brownian motion and the log-normal distribution
c. Stock price simulation - Option pricing
a. Different option strategies
b. The Black-Scholes option pricing model
c. Implied volatility estimation
d. Options portfolio
e. The binomial models
- Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
- CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to The Office of the Continuing Education Fund, Units 07-11, 25/F., CDW Building, 388 Castle Peak Road, Tsuen Wan, New Territories. Together with a photocopy of their HKID Card before course commencement. Applicants may also place their applications in the drop-in box on 12/F., Cheung Sha Wan Government Offices.
