Course Information
Schedules
- 21 May 2024 (Tue)
Registration period
5 Jan 2024 (Fri) - 10 May 2024 (Fri)
Price
HKD 2,310
Course Level
Study Mode
Duration
15 Hour(s)
Language
Cantonese, English
Location
Central Learning Centre
1 views
Course Overview
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.
Admission Requirements
Participants are expected to have good knowledge in Excel and basic knowledge in programming.
What You’ll Learn
Topics include:
- Getting start with recording macros;
- VBA Programming fundamentals;
- Creation of specific user forms;
- VBA interaction with charts;
- Data analysis in Excel;
- Case studies
