Special Notice

Please note that Learning Centres of the School of Continuing and Professional Studies of The Chinese University of Hong Kong (CUSCS) will be closed during Easter holidays (29 Mar - 1 Apr 2024). Thank you for your attention.

Close
Main content start

System Development & Programming

Advanced Excel VBA Programming
EXCEL VBA程式編寫深造班

Course No. : 242-119265-01|Start Date : 05/06/2024

Admission Requirements

Participants are expected to have good knowledge in Excel VBA.

Instructor

CUSCS Instructor

Language Used

Cantonese (supplemented with English)

Total Hours

15.00 hour(s)

Session

5

Place

Tsimshatsui Oriental Learning Centre

Start Date

05/06/2024

Schedule

Wednesday

Time

18:45 - 21:45

Tuition Fee

HK$ 2,310.00

Level

General Short Courses

Course Enquiries

2209775227235569[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.