Financial Modeling with Excel VBA (CEF Approved) 2017-09-15T14:03:01+00:00

Project Description

Loading...
cef CEF Course Code: 23C03605-1
CEF Institution Code: 548
Welkin Course Code: CVB

Course Features

Excel VBA is the embedded programming language in Excel. VBA is able to automate complicated and repetitive tasks and enables Excel to produce powerful data models. In this course, you will learn the fundamentals of Excel VBA and apply the techniques to building financial models to better analyze data, predict revenues and costs, and assess risks to justify business decisions in an effective and efficient way.

  • Begin with basic skills and progresses 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

By the end of the course you should have a good understanding of Excel VBA and be able to apply the skills learnt to building spreadsheets for financial modeling purposes.

  • Qualified and experienced instructors who will share their experiences
  • Practical and hands-on approach
  • Evening and weekend classes with Cantonese and English tuition options

Learn from the Experts

Get Professional Recognition

mos-certificate

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

After completing this course you may further develop your knowledge and skills in data analysis with the CEF reimbursable course Business Analysis with Microsoft Excel.

Course Fee

$1380*

*after max. 80% fee reimbursement from CEF. Full course fee is $6900, payable by monthly installments.

Do I qualify for CEF subsidy?

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 to have a good command in using simple worksheet functions such as SUM, MAX , MIN, VLOOKUP and especially the IF functions, and 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 assignments as part of the course. Upon successful completion of the course, including a minimum attendance record, students will receive a Certificate of Achievement.

Schedule & Online Enrolment
Enquiry/Booking
(A) Evening classes, 6 hours per week, course fee in 3 instalments

COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
CVBC-25C23C
 Central
 Cantonese / PC
23/1~9/3
1900-220039 hrs/
13 sessions
TUE, FRI2,300.00
CVBC-6D3E
 Central
 English / PC
3/2~24/3
1000-1300
1400-1700
39 hrs/
13 sessions
SAT2,300.00
CVBC-6D10K
 Mongkok
 Cantonese / PC
10/2~7/4
1000-1300
1400-1700
39 hrs/
13 sessions
SAT2,300.00
CVBC-35C33K
 Mongkok
 Cantonese / PC
21/2~6/4
1900-220039 hrs/
13 sessions
WED, FRI2,300.00
CVBC-14C27E
 Central
 English / PC
26/2~16/4
1900-220039 hrs/
12 sessions
MON, THU2,300.00
CVBC-6D17C
 Central
 Cantonese / PC
17/3~5/5
1000-1300
1400-1700
39 hrs/
13 sessions
SAT2,300.00
CVBC-52C25K
 Mongkok
 Cantonese / PC
25/5~6/7
1900-220039 hrs/
13 sessions
TUE, FRI2,300.00
CVBC-6D23K
 Mongkok
 Cantonese / PC
23/6~4/8
0900-1200
1400-1700
39 hrs/
13 sessions
SAT2,300.00
CVBC-13C25C
 Central
 Cantonese / PC
25/6~8/8
1900-220039 hrs/
13 sessions
MON, WED2,300.00
CVBC-52C3E
 Central
 English / PC
3/8~14/9
1900-220039 hrs/
13 sessions
TUE, FRI2,300.00
CVBC-52C17C
 Central
 Cantonese / PC
17/8~2/10
1900-220039 hrs/
13 sessions
TUE, FRI2,300.00
CVBC-6D25K
 Mongkok
 Cantonese / PC
25/8~6/10
1000-1300
1400-1700
39 hrs/
13 sessions
SAT2,300.00
CVBC-25C28K
 Mongkok
 Cantonese / PC
28/8~12/10
1900-220039 hrs/
13 sessions
TUE, FRI2,300.00
CVBC-42C27E
 Central
 English / PC
27/9~8/11
1900-220039 hrs/
13 sessions
TUE, THU2,300.00
Financial Modeling with Excel VBA (CEF Approved)
Complete your Enrol
How to enrol/pay online

 

(B) Evening classes, 6 hours per week, course fee in 2 instalments

COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
CVBB-6D2K
 Mongkok
 Cantonese / PC
2/12~20/1
1000-1300
1400-1700
39 hrs/
13 sessions
SAT3,450.00
CVBB-6D44E
 Central
 English / PC
2/12~20/1
1000-1300
1400-1700
39 hrs/
13 sessions
SAT3,450.00
CVBB-24C34C
 Central
 Cantonese / PC
5/12~18/1
1900-220039 hrs/
13 sessions
TUE, THU3,450.00
CVBB-24C2E
 Central
 English / PC
2/1~13/2
1900-220039 hrs/
13 sessions
TUE, THU3,450.00
CVBB-42C4K
 Mongkok
 Cantonese / PC
4/1~20/2
1900-220039 hrs/
13 sessions
TUE, THU3,450.00
CVBB-6D33C
 Central
 Cantonese / PC
6/1~24/2
1000-1300
1400-1700
39 hrs/
13 sessions
SAT3,450.00
CVBB-6D3C3C
 Central
 Cantonese / PC
3/3~21/4
1000-1300
1400-1700
39 hrs/
13 sessions
SAT3,450.00
CVBB-13C12C
 Central
 Cantonese / PC
12/3~25/4
1900-220039 hrs/
13 sessions
MON, WED3,450.00
CVBB-6D54E
 Central
 English / PC
7/4~19/5
1000-1300
1400-1700
39 hrs/
13 sessions
SAT3,450.00
CVBB-13C9K
 Mongkok
 Cantonese / PC
9/4~21/5
1900-220039 hrs/
13 sessions
MON, WED3,450.00
CVBB-53C13E
 Central
 English / PC
13/4~25/5
1900-220039 hrs/
13 sessions
WED, FRI3,450.00
CVBB-6D14K
 Mongkok
 Cantonese / PC
14/4~26/5
1000-1300
1400-1700
39 hrs/
13 sessions
SAT3,450.00
CVBB-42C3C
 Central
 Cantonese / PC
3/5~19/6
1900-220039 hrs/
13 sessions
TUE, THU3,450.00
CVBB-6D64E
 Central
 English / PC
2/6~14/7
1000-1300
1400-1700
39 hrs/
13 sessions
SAT3,450.00
CVBB-24C12E
 Central
 English / PC
12/6~24/7
1900-220039 hrs/
13 sessions
TUE, THU3,450.00
CVBB-41C12K
 Mongkok
 Cantonese / PC
12/7~23/8
1900-220039 hrs/
13 sessions
MON, THU3,450.00
CVBB-6D74E
 Central
 English / PC
4/8~15/9
1000-1300
1400-1700
39 hrs/
13 sessions
SAT3,450.00
Financial Modeling with Excel VBA (CEF Approved)
Complete your Enrol
How to enrol/pay online

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 to apply it 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.

  1. The VBA programming environment
  2. Variables and constants
  3. Macros
  4. Built-in VBA functions and operators
  5. User-defined functions
  6. Branching and looping
  7. Object-based concept: Objects, methods and properties
  8. The Range object
  9. Debugging
    The following additional topics may also be covered if time allows:
  10. Arrays
  11. Procedures
  12. Custom dialog boxes
  13. Workbook and worksheet events
  14. 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.

  1. Loan amortization
    a. Simple model
    b. Iteration: The bisection approach
    c. Allowance for changing interest rates or repayment period
  2. Financial planning
    a. Retirement planning
    b. Portfolio restructuring
  3. Market history analysis
    a. Normal and real growth of stocks
    b. Growth of investment in different assets
  4. Stock simulation
    a. Stock volatility estimation
    b. The geometric Brownian motion and the log-normal distribution
    c. Stock price simulation
  5. Option pricing
    a. Different option strategies
    b. The Black-Scholes option pricing model
    c. Implied volatility estimation
    d. Options portfolio
    e. The binomial models
  1. 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.
  2. 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, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

 

You may also be interested in