Course Information
Registration period
Year-round Recruitment
Price
HKD 8,800
(本課程針對企業客戶而設，客戶可組團到本校上課或要求導師上門授課均可。
一班最多20人，價錢為 HK8800元。 可安排一天或兩個半天上課。
客戶使用軟件為 Excel 2010, 2013, 2016均可。此為標準課程內容，如需增強或減少某部分。)
(本課程針對企業客戶而設，客戶可組團到本校上課或要求導師上門授課均可。
一班最多20人，價錢為 HK8800元。 可安排一天或兩個半天上課。
客戶使用軟件為 Excel 2010, 2013, 2016均可。此為標準課程內容，如需增強或減少某部分。)
Course Level
Study Mode
Duration
1 Day(s)
Language
Cantonese
Location
九龍佐敦德興街11-12號興富中心5樓501室(佐敦港鐵站E出口)
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
11 views
Course Overview
使用 Excel Macro 能將重複大量而且繁瑣的工作步驟記錄下來， 再利用 Excel VBA 優化程式，便能將工作時間縮短99%兼且零出錯，是優化辦公室工作流程的利器。
What You’ll Learn
課程內容
UNDERSTANDING VBA AND MACRO
- Enable the Developer Option
- Record and view a Macro
- Code Analysis
- Understanding Relative Reference
- Saving Macros
- Adding Form Controls
- Trusting Macros
- Introduction to Visual Basic Editor (VBE)
- Creating a Macro Manually
VBA OBJECT MODEL, VARIABLES AND COLLECTIONS
- Recognizing object hierarchy
- Collections and its properties
- Understanding "Active" object
- Identifying a Range and addressing cells using R1C1
- Creating Variables
- Reserved Keywords
- Defining data types
- Using Option Explicit
- Managing Strings
- Examples of using String and Date
- Producing Arrays and Dynamic Arrays
- Multi-dimensional Array
- Representing Objects
- PROGRAMMING TECHNIQUES
- Arithmetic and Comparison Operators
- Logical Operations
- Understanding precedence
- Choosing a branch
- Example of Using if-then conditional test
- Branching alternatives
- Selecting branches
- Example of Selecting Cases
- Performing loops
- For Loop Syntax
- Example of Using For Loop
- Do-While Loop
- Example of Using While Loop
- Iterating for each
- Example of Using For Each Loop
- Using With
PROCEDURE, FUNCTIONS AND EVENTS
- Sub Procedure
- Modifying scope
- Passing arguments
- Handling Errors
- Example of Error Handling
- Defining Functions
- Example of Functions
- Recognizing eventsg
- Event Handler’s Locations
- Opening Workbook Events
- Closing workbook events
- Acquiring input
- Showing messages
- Customizing the Message Box
- Example of using Message Box
BUILDING FORMS FOR DATA COLLECTION
- Inserting a User Form
- Adding Controls
- Different Types of Controls
- Adjusting properties
- Displaying forms
- Handling form events
INTERACTING WITH EXTERNAL ENVIRONMENTS
- Sending Emails from Excel With VBA
- Using the FileSytemObject to manage files
