Home > Courses > IT & Digital > Microsoft Office Productivity > Microsoft Excel > Visual Basic Application for Excel 2016

Visual Basic Application for Excel 2016

Funding Validity Period

Non-Funded

Course Overview

This course sets out the skills and knowledge to make use of Visual Basic functions to convert tedious manual tasks into one click of a button, and to use Userforms for user interactive interfaces.

Skills Acquired

Learning Modules

Learning Unit 1: Macros for Spreadsheet Automation

Understanding Macros
Modifying Existing Macros

Learning Unit 2: VBA Basics

Visual Basic Editor Environment
Learning about Objects & Property

Learning Unit 3: VBA Programming Novice

Variables, Data Type & Constants
Procedures, Functions and Constructs

Learning Unit 4: VBA Programming Senior

Error Handling
Using Custom Functions

Learning Unit 5: VBA Programming Graduate

Introducing UserForms
Excel Event

Automation
Understanding Macros
Modifying Existing Macros

Visual Basic Editor Environment
Learning about Objects & Property

Variables, Data Type & Constants
Procedures, Functions and Constructs

Error Handling
Using Custom Functions

Introducing UserForms
Excel Event

Who is this course is for

This training is relevant to learners in Finance, Sales department and all who need to automate task to increase productivity.

Academic prerequisites

Learners must be able to read, write, speak and listen to English at secondary school level
Learners to have minimum GCE ‘O’ level or ITE certificate education
Learner should have at least 1 year’s working experience in any industry
Learners will need to have a good knowledge of Microsoft Excel

Course Fees

Fees	Company / Self Sponsored
Full Fee	$650
GST	$58.50
Nett Fee Payable (incl. GST)	$708.50