Spreadsheet Modeling in Corporate Finance (CEF Approved) 2017-08-04T14:45:03+00:00

Project Description

Loading...
cef CEF Course Code: 23C02275-1
CEF Institution Code: 548
Welkin Course Code: CSS

Course Features

This course enables you to use advanced Excel features and functions to create effective spreadsheet models for financial analysis and projections. It is a practical hands-on program to complement theories learned at universities or business schools.

  • Lectures, demonstrations and hands-on practice
  • Learn advanced Excel techniques and functions
  • No Excel VBA programming involved

By the end of the course, you would have gained an in-depth understanding of financial modeling techniques and be able to build robust models for financial analysis and projections.

  • Qualified and experienced trainer
  • Easy-to-follow, step-by-step instructions
  • Evening and weekend classes available

Learn from the Experts

Excel in Business Analysis

Get Professional Recognition

mos-certificate

Certify your Excel skills with the 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 with the course Business Analysis with Microsoft Excel.

Course Fee

$1260*

*after maximum 80% fee reimbursement from CEF. Full course fee is $6300, payable by monthly instalments.

Am I eligible for CEF subsidy?

Course Duration

30 Hours

Course Prerequisites

Course participants should be at least 18 years old, have an education level of Form 5 or above, and possess basic business concepts and knowledge of Microsoft Excel.

Title of Award & Assessment Methods

Students will receive the course certificate after achieving 80% attendance and passing in 2 course assignments.

Schedule & Online Enrolment
Enquiry/Booking

Evening or Saturday full-day classes, 6 hours per week, course fee in 2 instalments

COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
CSSB-42C1K
 Mongkok
 Cantonese / PC
1/2~8/3
1900-220030 hrs/
10 sessions
TUE, THU3,150.00
CSSB-6D24C
 Central
 Cantonese / PC
24/2~24/3
1000-1300
1400-1700
30 hrs/
10 sessions
SAT3,150.00
CSSB-35C14C
 Central
 Cantonese / PC
14/3~18/4
1900-220030 hrs/
10 sessions
WED, FRI3,150.00
CSSB-6D7C
 Central
 Cantonese / PC
7/4~5/5
1000-1300
1400-1700
30 hrs/
10 sessions
SAT3,150.00
CSSB-14C7C
 Central
 Cantonese / PC
7/5~7/6
1900-220030 hrs/
10 sessions
MON, THU3,150.00
CSSB-6D9K
 Mongkok
 Cantonese / PC
9/6~7/7
1000-1300
1400-1700
30 hrs/
10 sessions
SAT3,150.00
CSSB-35C27C
 Central
 Cantonese / PC
27/6~27/7
1900-220030 hrs/
10 sessions
WED, FRI3,150.00
CSSB-6D14K
 Mongkok
 Cantonese / PC
14/7~11/8
1000-1300
1400-1700
30 hrs/
10 sessions
SAT3,150.00
CSSB-24C14K
 Mongkok
 Cantonese / PC
14/8~13/9
1900-220030 hrs/
10 sessions
TUE, THU3,150.00
CSSB-6D15C
 Central
 Cantonese / PC
15/9~13/10
1000-1300
1400-1700
30 hrs/
10 sessions
SAT3,150.00
Spreadsheet Modeling in Corporate Finance (CEF Approved)
Complete your Enrol
How to enrol/pay online

Spreadsheet is the most widely used tools in performing financial analysis and yet many finance professionals are not trained in using spreadsheets effectively and hence not being able to perform sensitivity analysis, feasibility studies and other common financial analysis.

The course provides students with relevant skills and techniques in performing financial analysis and is a practical hands-on program to complement theories learned at Universities and Business Schools .

Note that this course does NOT teach Excel VBA programming, but how to build spreadsheet models using Microsoft Excel features and functions.

  • Using Formulas and Analytical tools
    • Using Formula and Functions
    • Using Pivot Table for data analysis
  • Time Value of Money
    • Present Value
    • Future Value
    • Annuity
  • Asset Valuation
    • Bond Valuation
    • Stock Valuation
    • Yield Curve
  • Capital Budgeting
    • Project NPV
    • Cost-Reducing Project
    • Break-even Analysis
    • Three Valuation Methods
  • Financial Planning
    • Corporate Financial Planning
    • Du Pont System of Ration Analysis
    • Life-Cycle Financial Planning
  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