Main content start

BusinessAccounting and Corporate Governance

Certificate for Module (Business Modeling with Excel in Accounting)
證書(單元 : EXCEL會計與商業模式)

Course Code
AC047A
Application Code
1570-1172AW

Study mode
Part-time
Start Date
03 Feb 2018 (Sat)
Next intake(s)
02-2019
Duration
8 weeks
Language
Cantonese supplemented with English (粵語授課/英文教材)
Course Fee
HK$4,800*
How to Apply
Deadline on 30 Dec 2017 (Sat)
Enquiries
28678469
28584750

This programme aims to enable students to use EXCEL as a tool to create powerful spreadsheet models for analysis and presentation of financial data and business results.Students will learn the important features of Microsoft EXCEL from basic spreadsheet design and creation through formulas, functions, formatting, charts, multiple worksheets and “what-if” analysis. 課程旨在教導學員使用Microsoft Excel設計及創作電子工作表以進行財務數據和業務分析。學員將學習怎樣規劃及制定良好商業模式 (Business Models)來處理業務問題。內容涵括電子工作表模式設計及財務建模,CVP及財務報表分析與預測及用商業模式執行「Sensitivity Analysis」及「What-if Analysis」。

  1. Introduction to Financial Models
  2. Spreadsheet Model Design
  3. Spreadsheet for Financial Modeling
  4. Models for planning (Budgeting)
  5. Cost-Volume-Profit Modeling
  6. Sensitivity Analysis
  7. Financial Statement Analysis
  8. Financial Statements Forecasting

Students are awarded the Certificate for Module if they can achieve 70% attendance rate and successfully complete the assessment (4 Individual Practical Tasks on business modeling).

Application Code 1570-1172AW -

Days / Time
  • Saturday 2:30 - 6:30pm
Duration
  • 30 hours
Venue

No specific academic entry requirements. However, applicants are expected to possess a good understanding of financial and managerial accounting concepts and the basic knowledge of using Excel functions.

申請人無須具備任何學術資格,但須具有基本財務和管理會計概念及基礎Excel知識。

Course Fee
  • Course Fee : HK$4,800*
  • (*Fee are subject to revision without prior notice, or even after admission onto the course. All fees paid are non-refundable, unless a course is over-subscribed or cancelled.)
  • The CEF Institution Code of HKU SPACE is 100

CEF SectorFinancial Services

CEF Courses
Certificate for Module (Business Modeling with Excel in Accounting)
證書(單元:EXCEL會計與商業模式)
COURSE CODE 23C09751-4 FEES $4,800 ENQUIRY 2867-8470
Continuing Education Fund Continuing Education Fund
This programme has been included in the list of CEF reimbursable programmes. Application for CEF has to be made before commencement of the programme.

Application Form Download Application Form

Enrolment Method

We provide online application and payment service for students to make enrolment via the Internet. Enrolment will be confirmed once students have made the payment online by using either PPS or credit card.

For first-come, first-served courses:
  1. Complete the online application form
    Click the "Apply Now" button on the top right hand corner of the course webpage to make online application. Follow the instructions to fill-in the online application form.
  2. Make Online Payment
    Pay the course fees by either using
     

    PPS via Internet - You will need a PPS account and a PPS Internet password. For information on how to open a PPS account and how to set up a PPS Internet password, please visit http://www.ppshk.com.

    Credit Card Online Payment - Course fees can be paid by VISA or MasterCard via a secure online payment gateway for all first-come, first-served courses.

For award-bearing programmes:

Selected award-bearing programmes also provide online enrolment and payment service for its students.

If your programme accepts online enrolment and payment, a re-enrolment icon will be shown on the course webpage. Click the icon and follow the instructions to perform online enrolment and payment. You will receive relevant information from the programme team nearer the time of enrolment.

You may click here directly to access the online enrolment and payment service.

Please note the followings:

  1. Admission is on a first-come, first-served basis. Enrolment will be confirmed once you have made the payment online. You will receive a payment confirmation after payment has been made successfully. You are advised to keep your payment confirmation for future enquiries.
  2. Fees paid are not refundable except as statutorily provided or under very exceptional circumstances.
  3. To make an application online, you will need a computer with connection to the Internet and a web browser with JavaScript enabled. Internet Explorer 5.01 or above is recommended as the web browser.

Disclaimer

The School provides a platform for online services for a selected range of products it offers. While every effort is made to ensure timeliness and accuracy of information contained in this website, such information and materials are provided "as is" without express or implied warranty of any kind. In particular, no warranty or assurance regarding non-infringement, security, accuracy, fitness for a purpose or freedom from computer viruses is given in connection with such information and materials.

The School (and its respective employees and subsidiaries) is not liable for any loss or damage in connection with any online payments made by you by reason of (i) any failure, delay, interruption, suspension or restriction of the transmission of any information or message from any payment gateways of the relevant banks and/or third party merchants for processing credit/debit/smart card or other payment facilitation mechanism; (ii) any negligence, mistake, error in or omission from any information or message transmitted from the said payment gateways; (iii) any breakdown, malfunction or failure of those gateways in effecting online payment service or (iv) anything arisen out of or in connection with the said payment gateways, including but not limited to unauthorised access to or alternation of the transmission of data or any unlawful act not permitted by the law.

Payment Method
1. Cash or EPS

Course fees can be paid by cash or EPS at any HKU SPACE enrolment counters.

2. Cheque or bank draft

Course fees can also be paid by crossed cheque or bank draft made payable to “HKU SPACE”. Please specify theprogramme title(s) for application and applicant’s name. You may either:

  • bring the completed form(s), together with the appropriate course or application fees in the form of a cheque, and any required supporting documents to any of the HKU SPACE enrolment centres;
  • or mail the above documents to any of the HKU SPACE enrolment centres, specifying “Course Application” on the envelope. HKU SPACE will not be responsible for any loss of payment sent by mail.
3. VISA/MasterCard

Applicants may also pay the course fee by VISA or MasterCard, including the “HKU SPACE MasterCard”, at anyHKU SPACE enrolment centres. Holders of the HKU SPACE MasterCard can enjoy a 10-month interest-freeinstalment period for courses with a tuition fee worth a minimum of HK$2,000; however, the course applicant must also be the cardholder himself/herself. For enquiries, please contact our staff at any enrolment centres.

4. Online payment

The course fees of all open admission courses (course enrolled on first come, first served basis) and selected award-bearing programmes can be settled by using PPS via the Internet. Applicants may also pay the relevant course fees by VISA or MasterCard online. Please refer to the Online Services page on the School website.

Notes

  1. For general and short courses, applicants may be required to pay the course fee in cash or by EPS, Visa or MasterCard if the course is to start shortly.

  2. Fees paid are not refundable except under very exceptional circumstances (e.g. course cancellation due to insufficient enrolment), subject to the School’s discretion. In exceptional cases where a refund is approved, fees paid by cash, EPS, cheque or PPS (for online payment only) will normally be reimbursed by a cheque, and fees paid by credit card will normally be reimbursed to the payment cardholder’s credit card account.

  3. In addition to the published fees, there may be additional costs associated with individual programmes. Please refer to the relevant course brochures or direct any enquiries to the relevant programme team for details.
  4. Fees and places on courses cannot be transferred from one applicant to another. Once accepted onto a course, the student may not change to another course without approval from HKU SPACE. A processing fee of HK$120 will be levied on approved transfers.
  5. Receipts will be issued for fees paid but HKU SPACE will not be responsible for any loss of receipt sent by mail.
  6. For additional copies of receipts, please send a stamped, self-addressed envelope with a completed form and a crossed cheque for HK$30 per copy made payable to ‘HKU SPACE’. Such copies will only normally be issued at the end of a course.