資訊科技 - 證書及文憑課程
Certificate Programme in Excel for Business Applications
Excel商業應用證書課程
Course No. : 243-212200-01
Admission Requirements
Applicants should:(1) have completion of secondary education, or equivalent; or
(2) be aged 21 or above
Instructor
CUSCS Instructors
Language Used
Cantonese (supplemented with English)
Total Hours
90 Hours (around 8-9 months)
Start Date
Last quarter of 2024 (New Programme, pending to launch)
Time
6:45pm to 9:45pm (one lesson per week)
Application Fee
HK$150
Tuition Fee
HK$15,000
Level
Certificate programmes
Course Enquiries
2209 7752 / 2209 77602723 5569[JavaScript encoded]
Enrolment Enquiries
2209 0290
Available Soon
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.
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.
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.
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.
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.
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.
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 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.
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.