- Add/Remove My Favorite Course
- Print
Excel Formula and VBA Programming
Hong Kong Institute of Information Technology (HKIIT)
Programme Code
IT5200141
Subject Area
Information Technology
Programme Type
Short Course
Offering Institution
Hong Kong Institute of Information Technology (HKIIT)
Contact Hours
12
Programme Fee
HKD$2,400.00
| Class Code | Commencement Date | Class Location | Medium of Instruction | Apply Online | Class Remarks | Class Status |
| IT5200141-1 | 2025.03.24 |
Hong Kong Institute of Information Technology at Hong Kong Institute of Vocational Education (Morrison Hill)
Hong Kong Institute of Information Technology at Hong Kong Institute of Vocational Education (Morrison Hill) |
Cantonese supplemented with English |
This course aims to equip participants with the skills to efficiently use Excel formulas and VBA programming to automate tasks and enhance productivity in data manipulation and analysis.
Course Content
Introduction to Excel Formulas
- Understanding basic and advanced formulas
- Using logical, lookup, and statistical functions
- Tips and tricks for efficient formula usage
Advanced Excel Techniques
- Conditional formatting and data validation
- Using PivotTables and charts for data analysis
Introduction to VBA Programming
- Understanding the VBA environment
- Writing simple macros to automate tasks
- Debugging and error handling in VBA
Advanced VBA Applications
- Creating user-defined functions
- Developing interactive forms and user interfaces
- Integrating VBA with Excel for complex solutions
Tentative Schedule
24, 31 Mar & 7, 14 Apr 2025 (Time: 18:30-21:30)
- In special circumstances, some lessons may be conducted in online mode.
- Duration: 12 hrs.
Entry Requirements
Suitable for applicants who are interested in this course
Application deadline: 9 March 2025 (Sun)
Please press 'Apply Online' button above
Notes
⦁ Applicants who fulfil the entry requirements will receive a payment notice later. Applications are not required to pay the tuition at this moment.
⦁ In general, course enrollment is made on a first-come-first-served basis.
⦁ Subject to the availability of the classes, applicants will be informed to change to another class if the applied class was full.
⦁ Any change in class selection will be put on the waiting list.
(Mon-Fri: 09:00-17:00)
Website: hkiit.edu.hk
Enrollment and Enquiry:
Tel: 2835-7403
e-mail: skillsup_adm@vtc.edu.hk
Online Email Enquiry
Icon Description
Icon Description:
Apply Online
Continuing Professional Development
New Industrialisation and Technology Training Programme
Putonghua Course
Chinese Courses for Non-Chinese Speakers- Latest Courses / Seminars
Continuing Education Fund
Vocational English Programmes
Putonghua Shuiping Ceshi
Vplus Engineering
Vplus Creative Industries
Vplus Health and Life Sciences