{{col1}}
{{col0}}
Sorry, JavaScript required!

Microsoft Excel Programming with VBA

Title Microsoft Excel Programming with VBA
Course code MG33.2-02-2020-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.
Content
  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 6 sessions
Schedule 19:00-22:00, from Feb 25, 2020 to Mar 12, 2020 every Tuesday, 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 ---
{{col0}}
{{col1}}
Sorry, JavaScript required!