特别通告

所有学生及访客在进入香港中文大学专业进修学院 (CUSCS) 教学中心时,必须

 

  1. 以「安心出行」流动应用程式扫描「安心出行」场所二维码;
  2. 出示疫苗通行证,证明已符合新冠疫苗接种规定。

 

各中心使用者亦须遵守卫生措施:i) 佩戴口罩;ii) 量度体温;及iii) 使用消毒搓手液。若发烧、身体不适,或正进行强制检测而尚未取得核酸检测阴性结果,请勿前往教学中心。多谢合作。

关闭
Main content start

系统开发及程式编写

Advanced Excel VBA Programming
EXCEL VBA程式编写深造班

Course No. : 223-119265-01|Start Date : 16/11/2022

Admission Requirements

Participants are expected to have good knowledge in Excel VBA.

Instructor

CUSCS Instructor

Language Used

Cantonese (supplemented with English)

Total Hours

15.0 hour(s)

Session

5

Place

Central Learning Centre

Start Date

16/11/2022

Schedule

Wednesday

Time

18:45 - 21:45

Tuition Fee

HK$ 2,150.00

Level

General Short Courses

Course Enquiries

3943913127708275[JavaScript encoded]

Enrolment Enquiries

2209 0290

Closing Date for Application

Enrolment deadline is 10 calendar days before the course commencement date. Late enrolment will only be considered if there are still vacant places.

1
Course Content

This course is the continuation of 'Excel VBA Programming' course, and will teach participants for more Excel VBA programming techniques. Topics include:1) Speed up applications with Arrays; 2) Automate Pivot Table; 3) Build web queries to obtain data from Internet; 4) Create customized classes and functions; 5) Interaction with databases; 6) Mini-project.

2
Related Courses

Please click this link for related courses information.