特别通告

早前一宗新冠病毒确诊个案曾于传染期间到访安年大厦十五楼,大厦管业处已完成所有楼层的清洁及消毒工作;本院也已彻底为安年教学中心所有课室清洁和消毒。安年教学中心于2021年3月9日(星期二)重开,继续为学员提供服务。请各使用者必须遵守防疫措施,以减低病毒传播风险。

关闭
Main content start

系统开发及程式编写

Excel VBA Programming
EXCEL VBA程式编写 (实时网上教学)

Course No. : 211-119260-01|Start Date : 19/01/2021

Admission Requirements

Participants are expected to have good knowledge in Excel and basic knowledge in programming. The students will need to have stable internet connection and computer at home to attend the online teaching by Zoom too.

Instructor

CUSCS Instructor

Language Used

Cantonese (supplemented with English)

Total Hours

15.0 hour(s)

Session

5

Place

The course will be delivered by live online learning (Zoom)

Start Date

19/01/2021

Schedule

Tuesday

Time

18:45 - 21:45

Tuition Fee

HK$ 1,880.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.

COMMENCED

1
Introduction

Visual Basic for Applications (VBA) the macro programming tool in Microsoft Excel for developers to create sophisticated user-oriented applications for automating tasks like data analysis. Topics include:1) Getting start with recording macros; 2) VBA Programming fundamentals; 3) Creation of specific user forms; 4) VBA interaction with charts; 5) Data analysis in Excel; 6) Case studies

2
Related Courses

Please click this link for related courses information.