Special Notice

On entering the Learning Centres of the School of Continuing and Professional Studies of The Chinese University of Hong Kong (CUSCS), all students and visitors are required to:

 

  1. Scan the LeaveHomeSafe venue QR code using the LeaveHomeSafe mobile app;
  2. Present their Vaccine Pass to show they have complied with the vaccination requirements.

 

You are also required to (i) Wear a face mask; (ii) Perform temperature screening, and; (iii) Use hand sanitizer. If you have a fever, feel unwell or are undergoing compulsory testing without proof of a negative nucleic acid test result, please refrain from coming to the Learning Centres. Thank you for your co-operation.

Close
Main content start

System Development & Programming

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.