Certificate in Excel Automation with Macro and VBA

Control Excel with Automation Excel Macro 及 VBA 自動化證書課程

課程目標

Excel Macro

認識 Excel Marco 錄製技巧

Excel VBA

認識 Excel VBA 程式語言

Excel Object Model

學習使用 VBA 的物件模型、變數及資料結構

Decision & Looping

基本程式設計技巧 - 決策及迴路

Procedures and Functions

將程式化繁為簡 - 分拆程式成為不同的子程式

Event Handling

學習 VBA 的事件(Event) 回應處理手法

Data Forms

建立表格收集資料

External Environments

VBA 與其他程式互動

課程相關資料

課程對象針對企業客戶而設
上課模式面授上課或者即時網上教學
上課安排客戶可到本校上課或要求導師上門授課
上課收費每班最多20人，每班收費$8,800
課程時數6小時
使用軟件Excel 2010, 2013, 2016. 2019, Office 365 均可
入學要求需懂 Excel 基本功能，方能事半功倍

課程內容

Understanding Macros and how to record the actions
Use of VBA Editor to read and edit the Macros
Make use of Relative and Absolute Addressing in Macros
Copy and Share the Marcros to others
Understanding Macros security setting
Run the marcos through various methods

VBA programming concepts
Use of basic variables to store number, text, date and boolean values
Use of array variables to store a group of values
How to make decision using "IF THEN ELSE" structure
How to repeat operations using "FOR LOOP" structure
Make use of other loops like "DO WHILE LOOP" and "DO UNTIL LOOP"

Understanding Excel Object Model
Understanding how to use object methods
Understanding how to access object properties
Use of Application, WorkBooks, WorkSheets, Range and Cell objects
Use of InputBox and MsgBox to get and show information
Call Worksheets functions in VBA

Understanding Sub Procedures to structure the program
Write Function Procedures to create custom functions
Write Event Procedures to trigger actions when certain events happen/span>
Learn how to use immediate window and watch window to debug codes
Learn how to run through the code step by step

Build UserForm to allow user to input data through a form
Use the TextBox to collect text
Use the Option Button or Checkbox to select data
Use the ListBox and ComboBox to select data
Use the Button to run codes

Write sample codes to automate daily tasks
Write codes to check duplicate values
Write codes to calculate commissions based on a rate table
Write codes to various lookup jobs
Write codes to print formatted reports
Write codes to send email from Excel

Instructor

Dannis Mok

who has rich experience in business web and apps system development and have over 20 years of teaching experience. He has great passion in learning and teaching new technologies and his teaching style is clear to point and can explain complex technologies in simple terms. He has delivered various workshops and classes for different corporate, government departments and local universities and is the principal lecturer for NCC Education and University of Greenwich. Besides BSc degree in IT, he also got a MBA, MSc in IT and MSc in Telecommunication degree.

企業客戶

Dannis Mok

導師曾教授以下客戶 - 辦公室軟件或者相關課程

Prince Hotel 香港太子酒店
Marco Polo Hong Kong Hotel 馬哥孛羅香港酒店
Kerry Warehouse 嘉里貨倉
Labor Department 勞工處
Baguio Green Group 碧瑤綠色集團
香港耆康老人福利會
Education Bureau 教育局
Hong Kong Institute of Education 香港教育大學
Hong Kong Housing Authority 香港房屋委員會
Hong Kong ICAC 香港廉政公署
Hang Seng Bank 恒生銀行
Civil Aivation Department 民航處
Darty Asia
UA Finance 亞洲聯合財務有限公司
基督教香港信義會
NCSI Hong Kong Ltd
香港善道會
恆生銀行
聯合國兒童基金會
City University of Hong Kong 香港城市大學
香港明愛
救世軍
City Facilities Management Holdings Ltd
HACEO 香港飛機工程
JLL 仲量聯行
Hong Kong VTC 職業訓練局
Hong Kong IVE 香港專業教育學院
Adidas Hong Kong
Polyplastics
Apex Logistics
Defond 德豐
JAS Worldwide
VTech Hong Kong 偉易達香港
VTech Hong Kong 偉易達香港
YWCA 女青年會
東華三院
iRobot Hong Kong
Bureau Veritas
Boardway 百老滙
StarLite Holdings (星光集團)
Puma Hong Kong
Marriott International 萬豪國際
WheeLock會德豐
香港立信德豪會計師事務所 (BDO)
Kering Group
中華電力有限公司
Wilko Worldwide Limited
華懋集團
機電工程署
無國界醫生
Unilever Hong Kong 聯合利華
獅王 (Lion Corporation)
菱電商事株式会社
Merck & Co 默克藥廠
九龍木球會
香港航空發動機維修服務有限公司
維他奶國際集團
Toyota 豐田汽車
adidas Hong Kong
連續五年 (2017,2018,2019,2020,2021) 為VTC 職業訓練局的員工作培訓
連續八年為勞工處YES的會員作”辦公室軟件”培訓
浸會大學
西門子 Siemens
Fujitsu Hong Kong
Luxasia
Miele
Pacific Coffee
PersolKelly
Schmoll Group
Johnson & Johnson
周大福集團
Tory Burch
南洋商業銀行
新鴻基
迪士尼樂園
一田百貨

Certificate in Excel Automation with Macro and VBA

課程簡介

使用 Excel Macro 能將重複大量而且繁瑣的工作步驟記錄下來， 再利用 Excel VBA 優化程式，便能將工作時間縮短99%兼且零出錯，是優化辦公室工作流程的利器。

課程目標

Excel Macro

Excel VBA

Excel Object Model

Decision & Looping

Procedures and Functions

Event Handling

Data Forms

External Environments

課程相關資料

課程內容

深入認識錄製 Marco 的技巧及細節

VBA 程式設計基本觀念

Excel物件模型及常用物件

利用 Procedure 建構程式及除錯技巧

建立資料表格收集資料

各種 VBA 應用案例

Instructor

Dannis Mok

相關專業認證

相關教學經驗

企業客戶

Dannis Mok

導師曾教授以下客戶 - 辦公室軟件或者相關課程

Our Clients

相關課程 Related Courses

Enrollment Form for Excel VBA

Please fill in the details

Enrollment details

Your enrollment details are as follows:

Class Code:

First Name:

Last Name:

Email:

DOB:

Mobile:

Other Phone:

Gender:

Chinese Name:

Address:

Enrollment Confirmation

Thank for your enrollment

We have already reserved a seat for you and wee will contact you soon to inform your payment procedures

Enquiry Form

Please fill in the details

Enquiry Confirmation

Thank for your Enquiry

We have received your question and will feedback you soon

Success

Error

Thank for your Enquiry

We have received your question and will feedback you soon

使用 Excel Macro 能將重複大量而且繁瑣的工作步驟記錄下來，再利用 Excel VBA 優化程式，便能將工作時間縮短99%兼且零出錯，是優化辦公室工作流程的利器。