Unisoft Education Centre

Certificate in Excel Automation with Macro and VBA

Enquire Now

Course Information

Registration period
4 Jun 2021 (Fri) - 30 Sep 2021 (Thu)
Price
HKD 7,500
(本課程針對企業客戶而設,客戶可組團到本校上課或要求導師上門授課均可。
一班最多20人,價錢為 HK7,500元。 可安排一天或兩個半天上課。
客戶使用軟件為 Excel 2010, 2013, 2016均可。此為標準課程內容,如需增強或減少某部分。)
Course Level
Study Mode
Duration
1 Day(s)
Language
Cantonese
Location
九龍佐敦德興街11-12號興富中心5樓501室(佐敦港鐵站E出口)
1 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


Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed