Excel Pro Education

Master in Microsoft Excel VBA

Enquire Now

Course Information

Registration period
1 Nov 2020 (Sun) - 20 Nov 2020 (Fri)
Price
HKD 3,190
(【 原價$4,990 】限時優惠!$3,190)
Course Level
Study Mode
Duration
12 Hour(s)
Language
Cantonese
Location
香港銅鑼灣軒尼詩道381-383號 華軒商業中心
547 views

Course Overview

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 與我們聯絡!

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