Excel Pro Education

Master in Microsoft Excel VBA

Enquire Now

Course Information

  • 1 Apr 2021 (Thu) - 8 Apr 2021 (Thu) 10:00 AM - 5:00 PM
Registration period
1 Mar 2021 (Mon) - 31 Mar 2021 (Wed)
HKD 3,190
(【 原價$4,990 】限時優惠!$3,190)
Course Level
Study Mode
12 Hour(s)
香港銅鑼灣軒尼詩道381-383號 華軒商業中心

Course Overview

Master in Microsoft Excel VBA

Master in MS Excel VBA 大師級商務課程涵蓋所有在工作中需要的多重函應用 (Functions Nesting) 以及程式編寫 (VBA Macro)。內容完全涵蓋各專門行業的 MS Excel應用,令你在工作上邊得更專業,更強大!

本課程融合了多年的實戰經驗,令各位學員能夠充分利用及了解MS Office各版本的特點。由1997年的紮實基礎到Office 365版本的最新技術,都能夠靈活運用。


如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵 info@excelproedu.com.hk 與我們聯絡!


Reporting data using analytical tools

  • Adding drop down menu with Data Validation
  • Using what-if analysis and Scenario cases
  • Using Excel Solver Add-ins for modeling
  • Analysis of Data using Excel Statistic Tools
  • VBA Layout and Background
  • Excel Macro, VBA, VBE?
  • VBE Layout
  • How to setup the VBA Layout
  • What is Modules
  • VBA Code basic structure

The VBA Language Background

  • What is a computer language
  • The Object Oriented Language
  • The Object-Method Model
  • What is an Object in Excel?
  • What is a Method?
  • How to call an object and apply a method?
  • The Excel Object Hierarchy

The VBA Language Structure and Syntax

  • Option Explicit
  • Declare Variables
  • Variables Types
  • VBA Operators
  • MsgBox
  • With
  • If…Then…
  • If…Then…Else…
  • If…Then…ElseIf…Else…
  • For Loop
  • For Each…In…
  • Do While Loop
  • Do Until Loop
  • Exit Do
  • Application.Run
  • Cell Reference
  • Range
  • Cells
  • The VBA Language Structure and Syntax
  • Add new worksheet
  • Delete a worksheet
  • Copy worksheet
  • Move a worksheet
  • Get the worksheet name
  • Close a workbook
  • Charts
  • Add a chart
  • Add a chart with positions

VBA Application Forms

  • Build a form
  • Show the form
  • Build a button to show the form
  • Close the form
  • Write text on the form
  • Build a text box for user input
  • Create a operation button
  • Radio buttons
  • Check boxes
  • Drop menu
  • Get the value from the drop menu


如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵到 info@excelproedu.com.hk 與我們聯絡!

What you'll learn

Master in Microsoft Excel VBA

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