Back  
Course Information PDF
   
Course Category: Information Technology
Course Title: Introduction to Excel VBA


Course Code: IT010
Medium of Instruction: Cantonese
Duration: 24.0 hour(s)
Pre-requisites: Thorough knowledge of Microsoft Excel
 Course Fee:
Macao Resident: MOP1,800
Non-Macao Resident: MOP1,800
Certificate: Students who have obtained an overall passing grade of the course and met the attendance requirement will be issued a course certificate by UTM. The passing grade of the course is 50.
Course CodeSub CodeCourse Start DateCourse End DateClass Schedule
IT01024012024/01/102024/02/02View



Objective: This course is suitable for advanced users of Microsoft Excel. If you are responsible for very large and variable amounts of data, you should learn how to program features and functions to develop the accessibility and usability of the data.
By the end of this course you should be confident to create procedures for controlling the behavior and appearance of an Excel workbook, spreadsheet and range, create procedures that run in response to specific events, create user forms to accept or display data, and debug and handle errors in code.

Outline:
  • Understanding Excel Macros
  • Understanding VBA
  • Using Variables
  • VBA Basic Programming Techniques
  • Using Excel Objects
  • Creating Custom Forms
  • Error Handling
  • VBA Samples

Teacher: Please refer to the schedule


Remarks: Using English version software

  Last Updated: 2023/05/29

  Back