Back  
Course Information PDF
   
Course Category: Information Technology
Course Title: Excel VBA Intermediate level


Course Code: IT014
Medium of Instruction: Cantonese
Duration: 24.0 hour(s)
Pre-requisites: Good knowledge of Excel and familiarity with basics of Excel VBA.
 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
IT01422012022/01/042022/01/27View



Objective: This course is for users with some experience of Excel Visual Basic programming or who have attended a basic Excel VBA training course. The course provides Excel VBA programmers with a more in-depth knowledge of Excel VBA objects: application, workbooks, worksheets, ranges, charts, pivot table and data manipulation.
By the end of this course you should develop Excel applications and use Excel VBA objects and concepts that make the job more efficiently.

Outline:
  • Application objects
  • Chart objects
  • Pivot table
  • Data manipulation
  • File handling
  • Developing applications
  • Excel vba application examples

Teacher: Please refer to the schedule

Remarks: English version of the software is used.

  Last Updated: 2023/05/31

  Back