Course Information
Schedules
- 7 Oct 2024 (Mon) - 4 Nov 2024 (Mon) 6:45 PM - 9:45 PM
Registration period
9 Aug 2024 (Fri) - 27 Sep 2024 (Fri)
Price
HKD 2,490
Course Level
Study Mode
Duration
15 Hour(s)
Language
Cantonese, English
Location
Tsimshatsui Oriental Learning Centre
4 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
