1. Learning
  2. Courses
  3. Certificate in Excel VBA
  1. Back to course listing

Feva Works IT Education Centre

Certificate in Excel VBA

Enquire Now
Save Course Compare

Course Information

Schedules
  • 9 Feb 2025 (Sun) - 23 Feb 2025 (Sun) 10:30 AM - 5:30 PM
Registration period
7 Jan 2025 (Tue) - 8 Feb 2025 (Sat)
Price
HKD 1,500
Course Level
Short Course
Study Mode
Online
Duration
18 Hour(s)
Language
Cantonese
Location
-
1 views

Course Overview

VBA全名為VisualBasicforApplications，主要應用於MicrosoftOffice內，尤其是MicrosoftExcel。透過VBA，你可簡化工作流程，達至辦公室自動化的目的。

利用ExcelVBA，你可輕易地製作客戶管理系統，每月自動製作報表；財務策劃系統，替你自動製作精彩圖表；互動多媒體學習系統，又或是與其他Office程式如Word，PowerPoint，Outlook等結合，自動利用Excel的資料製作Word文件、信件，PowerPoint文件及管理Outlook等等。

為令你可編寫自家獨有的ExcelVBA程式，從此重覆討厭的工作只須按一個鍵，及後的工序，就由Excel替你辦妥，FevaWorks特別開設CertificateinExcelVBA。

課程設計由淺入深，適合所有對ExcelVBA有需要的人士報讀。

FevaWorks為香港微軟認可培訓方案合作伙伴

What You’ll Learn

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
　

 

 

See more details
Report

Start FollowingSee all

Save Course
Enquire Now

Free eNewsletter

You will receive below exclusive information:

Sign Up Now

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