Sorry, JavaScript required!

Microsoft Excel Programming with VBA

Title Microsoft Excel Programming with VBA
Course code MG33.2-08-2022-C
Objective VBA (Visual Basic® for Applications) is the built-in macro programming language in Microsoft Office applications. This course teaches how to use VBA in Excel to help automating routine tasks (such as repetitive formatting or moving data) of spreadsheets and make available functions that are not usually found on Excel menus or toolbars.
  1. Getting Started
  2. Introducing Objects
  3. Using the Editing Features
  4. Introducing Variables
  5. Creating Procedures and Functions
  6. Working with Conditional Statements
  7. Working with Forms and Controls
  8. Adding Functionality to Forms
  9. Using PivotTables
  10. Controlling Forms
  11. Understanding Debugging
Assessment In-class performance and exercises
Target audience High-level users who need expert skills in analyzing data and building small desktop applications.
Prerequisite Students must be capable of using Excel in performing general spreadsheet tasks, preferably with knowledge of the more advanced features such as Excel functions and PivotTables.
Class size 20
Instructor CPTTM Appointed Instructor(s)
Instruction language Cantonese
Handout language Handouts in Chinese (traditional)
Duration 18 hours in 8 sessions
Schedule 19:00-21:15, from Aug 9, 2022 to Sep 6, 2022 every Tuesday, Thursday, excluding Sep 1, 2022(Thursday).
Fee MOP1,260
Venue CPTTM Head Office (Rua de Xangai 175, Edf. ACM 7 Andar, Macau)
Certificate Certificate of Completion/Merit issued by CPTTM (with at least 80% attendance and passed the assessment).
PDAC code Approved Course under the SAR Government "Continuing Education Development Program", Code: 2201120183-0
  • Affected by the earlier suspension of training due to the Covid-19 pandemic, payment via PDAC subsidy of the Macao SAR Government cannot be used for enrollments after the resumption date of Aug 2, 2022 until further notice.
  • {{col0}}
    Sorry, JavaScript required!