Certificate Programme in Excel for Business ApplicationsExcel商业应用证书课程 - 资讯科技基础及管理 - 资讯科技 - 课程一览表 - 兼读制课程 - 香港中文大学专业进修学院
Main content start

资讯科技基础及管理

Certificate Programme in Excel for Business Applications
Excel商业应用证书课程

Course No. : 251-212200-01|Start Date : 12/05/2025

Admission Requirements

Applicants should:
(1) have completion of secondary education, or equivalent; or
(2) be aged 21 or above

Language Used

Cantonese (supplemented with English)

Total Hours

90 Hours (around 8-9 months)

Place

Central Learning Centre

Start Date

12 May 2025

Schedule

Monday

Time

6:45pm to 9:45pm (one lesson per week)

Application Fee

HK$150

Tuition Fee

HK$15,000

Level

Certificate programmes

QF Level

3

QR Registration No.

24/000616/L3

QR Registration Validity Period

05/06/2024 - Ongoing

Course Enquiries

2209 7752 / 2209 77602723 5569scs-it@cuhk.edu.hk

Enrolment Enquiries

2209 0290

Closing Date for Application

11 April 2025

1
Objective

The objective of this programme is to integrate the different levels of Excel skills to help participants to perform automation of business tasks and do small-scale data analysis to help make business decisions and improve business processes.

2
Content

Module 1. Essential Business Excel Skills (30 hours)
This course aims to enhance students’ proficiency in Excel by reviewing the basic skills and introducing essential business operations that can be performed using Excel. Students will have a solid understanding of how to utilize Excel in common business scenarios at the end of the course. Topics include:
1. Revision of Basic Excel Skills
2. Formula and references
3. Essential Functions
4. Conditional formatting
5. Filtering, Lookup and Sorting data
6. Importing data
7. Template
8. Array Formula
9. Use of Named Range
10. Data Validation
11. Graphs and Charts
12. Pivot Table

Module 2. Excel VBA Business Applications (30 hours)
This course will equip students with VBA programming skills to automate routine tasks and processes. Starting from basic macros recording for simple tasks, students will progress to learn basic VBA programming for automating more complex processes at the end of the course and participate in a mini project. Topics include:
1. Basic Macro Recording
2. Introduction to VBA programming
3. Object Oriented Programming Concepts
4. VBA Programming Control Structures
5. Error Handling
6. VBA Events
7. Subroutine and Function
8. Userform
9. VBA Objects and Classes

Module 3. Business Analytics using Excel (30 hours)
The course will enhance students’ business decision-making skills by utilizing Excel to analyze data, identify trends and informed decisions. Students will gain hands-on experience in data manipulation, visualization and data analysis techniques through lab practice and a business application project. Topics incldue:
1. What-if Analysis tools
2. Excel Power Tools for data analysis
3. Data Visualization techniques
4. Web Scraping and Data Cleansing
5. Automated data mining tasks

3
Assessment

Assignments, Case Studies, Project and Final Exam.

4
Award of Certificate

To qualify for the award of 'Certificate in Excel for Business Applications', students are required to have an attendance rate of 70% or above in each course and have passed the assessment of each course.

5
Continuing Education Fund

This course has been included in the list of reimbursable courses under the Continuing Education Fund. This course is recognised under the Qualifications Framework (QF Level 3).

Course Code: 34C160865
CEF Course Name : Certificate in Excel for Business Applications

6
Application Procedure

A. Online enrollment:

Please submit your application via online enrollment system (click "Online Enrolment" button at programme webpage). Upon the completion of online enrollment (including "Computer Knowledge and Other Skills" field), please email copies of the supporting documents to scs-it@cuhk.edu.hk:
• Copies of academic qualifications (e.g. award certificate / final transcript);
• Copies of proof of working experience, if applicable (e.g. reference letter or employment letter).


B. Enrollment by paper form:

Applicants are required to submit the following documents:
• A duly completed "Enrolment Form for Certificate and Diploma/Professional Programmes" (please include the "Computer Knowledge and Other Skills" field);
• Copies of academic qualifications (e.g. award certificate / final transcript);
• Copies of proof of working experience, if applicable (e.g. reference letter or employment letter);
• Application Fee of $150 (please refer to "Part B - Methods of Payment" listed in the Enrollment Form).

Please submit to the enrolment form and supporting documents to any one of our School's Enrolment Centres in-person; OR post to the Programme Team at:

17/F, Oriental Centre, 67 Chatham Road South,
Tsim Sha Tsui, Kowloon, Hong Kong
(Attn: Information Technology Programme Team - Application of Certificate Programme in Excel for Business Applications)

Admission will be assessed on a first-come-first served basis for qualified applicants. Thus, early enrollment is encouraged.