Master in Microsoft Excel VBA

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@ExcelPro.hk 與我們聯絡！

Master in Microsoft Excel VBA