Understanding Macros and how to record the actions
Use of VBA Editor to read and edit the Macros
Make use of Relative and Absolute Addressing in Macros
Copy and Share the Marcros to others
Understanding Macros security setting
Run the marcos through various methods
VBA programming concepts
Use of basic variables to store number, text, date and boolean values
Use of array variables to store a group of values
How to make decision using "IF THEN ELSE" structure
How to repeat operations using "FOR LOOP" structure
Make use of other loops like "DO WHILE LOOP" and "DO UNTIL LOOP"
Understanding Excel Object Model
Understanding how to use object methods
Understanding how to access object properties
Use of Application, WorkBooks, WorkSheets, Range and Cell objects
Use of InputBox and MsgBox to get and show information
Call Worksheets functions in VBA
Understanding Sub Procedures to structure the program
Write Function Procedures to create custom functions
Write Event Procedures to trigger actions when certain events happen/span>
Learn how to use immediate window and watch window to debug codes
Learn how to run through the code step by step
Build UserForm to allow user to input data through a form
Use the TextBox to collect text
Use the Option Button or Checkbox to select data
Use the ListBox and ComboBox to select data
Use the Button to run codes
Write sample codes to automate daily tasks
Write codes to check duplicate values
Write codes to calculate commissions based on a rate table
Write codes to various lookup jobs
Write codes to print formatted reports
Write codes to send email from Excel
Instructor
Dannis Mok
who has rich experience in business web and apps system development and have over 20 years of teaching experience.
He has great passion in learning and teaching new technologies and his teaching style is clear to point and can explain complex technologies in simple terms.
He has delivered various workshops and classes for different corporate, government departments and local universities and is the principal lecturer for NCC Education and University of Greenwich.
Besides BSc degree in IT, he also got a MBA, MSc in IT and MSc in Telecommunication degree.