Master in Microsoft Excel VBA

Excel Pro Education
Master in Microsoft Excel VBA
DATE & TIME
5 Oct 2021 (Tue) - 7 Oct 2021 (Thu)
10:00 AM - 5:00 PM
PRICE
HKD 3,190
(【 原價$4,990 】限時優惠!$3,190)
ORGANISER
Excel Pro Education
LOCATION
香港銅鑼灣軒尼詩道381-383號 華軒商業中心
Master in Microsoft Excel VBA
DESCRIPTION

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

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

歡迎到本電腦中心的網上報名系統報讀以上課程,網站連結:https://www.ExcelProEdu.com.hk/

如有任何課程查詢或預約報名歡迎致電 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

  • VBA BASIC
  • 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
  • VBA BASIC
  • 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

歡迎到本電腦中心的網上報名系統報讀以上課程,網站連結:https://www.ExcelProEdu.com.hk/

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


Master in Microsoft Excel VBA

For more details and registration, please click here.
DATE & TIME
5 Oct 2021 (Tue) - 7 Oct 2021 (Thu)
10:00 AM - 5:00 PM
PRICE
HKD 3,190
(【 原價$4,990 】限時優惠!$3,190)
ORGANISER
Excel Pro Education
LOCATION
香港銅鑼灣軒尼詩道381-383號 華軒商業中心