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.
Content	Getting Started Introducing Objects Using the Editing Features Introducing Variables Creating Procedures and Functions Working with Conditional Statements Working with Forms and Controls Adding Functionality to Forms Using PivotTables Controlling Forms 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
Remark	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.