課程資料
Certificate in Excel VBA
MASTERVBA
 
若想更了解以上資訊,歡迎致電 3106 8211 查詢。
 
課程費用: $1500

 
課程費用無須申請任何政府基金資助。

繳費方法:

一般課程:按月等額收取列明的課程費用。本中心將不早於課程開始的一個月前收取第一期費用。除第一期的費用外,每期的費用會在課程進行期間每月的首個上學日或之後收取。

組合課程:若該課程為組合課程,本中心將按該組合課程分科收費,直至所收學費為該組合課程的等額費用為止。

 
退款安排: 本中心備有完善之退款政策及程序。學生將會於報讀課程前獲發有關之文件,學員亦可按此閱讀。
 
質素保證: 本中心備有完善之免費補堂,免費重讀及彈性上課安排,令學員更有保障。
 
   
理論: 0小時 實習: 18小時 示範: 0小時

合共: 18小時

 


課程內容:
Certificate in Excel VBA
Module 1. The Power of Excel with VBA
1.1. The Developer Tab
1.2. Macro Security
1.3. Overview of Recording, Storing and Running a Macro
1.4. Using New File Types in Excel
1.5. Understanding the VB Editor
1.6. Understanding Shortcoming of the Macro Recorder

Module 2: Referring to Ranges
2.1. The Range Object
2.2. Syntax to Specify a Range
2.3. Named Ranges
2.4. Shortcut for Referencing Ranges
2.5. Referencing Ranges in Other Sheets
2.6. Referencing a Range Relative to Another Range
2.7. Use the Cells Property to Select a Range
2.8. Use the Offset Property to Refer to a Range
2.9. Use the Resize Property to Change the Size of a Range
2.10. Use the Columns and Rows Properties to Specify a Range
2.11. Use the ISEMPTY Function to Check Whether a Cell Is Empty
2.12. Use the CurrentRegion Property to Select a Data Range
2.13. Referencing Tables

Module 3: User-Defined Functions
3.1. Creating User-Defined Functions
3.2. Sharing UDFs
3.3. Useful Custom Excel Functions

Module 4: Looping and Flow Control
4.1. For…Next Loops
4.2. Do Loops
4.3. VBA Loop: For Each
4.4. Flow Control: Using If…Then…Else and Select Case

Module 5: Event Programming
5.1. Levels of Events
5.2. Using Events
5.3. Workbook Events
5.4. Worksheet Events
5.5. Chart Sheet Events
5.6. Application-Level Events

Module 6: Userforms: An Introduction
6.1. User Interaction Methods
6.2. Creating a Userform
6.3. Calling and Hiding a Userform
6.4. Programming the Userform
6.5. Verifying Field Entry
6.6. Illegal Window Closing
6.7. Getting a Filename

Module 7: Data Mining with Advanced Filter
7.1. Replacing a Loop with AutoFilter
7.2. Advanced Filter is Easier in VBA Than in Excel
7.3. Using Advanced Filter to Extract a Unique List of Values
7.4. Using Advanced Filter with Criteria Ranges

Module 8: Using VBA to Create Pivot Tables
8.1. Introducing Pivot Tables
8.2. Creating a Vanilla Pivot Table in the Excel Interface
8.3. Building a Pivot Table in VBA
8.4. Filtering a Data Set

Module 9: Handling Errors
9.1. Basic Error Handing with the On Error GoTo Syntax
9.2. Generic Error Handlers
9.3. Errors While Developing Versus Errors Months Later
9.4. The Ills of Protecting Code
9.5. More Problems with Passwords
9.6. Errors Caused by Different Versions
 

 

 
 
如有任何有關課程之查詢,歡迎致電 3106 8211 與我們的客戶關係主任聯絡。
 
MASTERVBA2410002E 
日期 22/10/2024~26/11/2024 (TUE)
時間 19:00~22:00 
合共 18 小時
上課地點 北角分校
課程費用 $ 1500

 
MASTERVBA2410001O 
日期 3/11/2024~17/11/2024 (SUN)
時間 10:30~17:30 
合共 18 小時
上課地點 網上 Online Live (Microsoft Teams)
課程費用 $ 1500