UEN No.: 198802365N

Search
Contact Us

2 days – Visual Basic Application for Excel 2016

REGISTER TODAY

COURSE details

Course Duration

15 HRS

Mode of Training

Classroom

Course Timing

9am-5.30pm

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.

  • 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
  • This training is relevant to learners in Finance, Sales department and all who need to automate task
    to increase productivity.
  • 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 Outline

Download the PDF below for a summary of the course outline.

DOWNLOAD PDF OUTLINE

COURSE FEES

Company Sponsored / Self Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$680 $61.20 $741.20

DATE & REGISTRATION

Select a date below

17 Feb , 18 Feb
24 Mar , 25 Mar
21 Apr , 22 Apr
15 May , 16 May
12 Jun , 13 Jun
SHARE
Course Outline

Looking at in-house training or have an enquiry? Contact us!

Related Courses

Data Analytics Courses in Singapore

Advanced Data Visualisation using Power BI

IT

24 HRS

WSQ

Excel Courses in Singapore

Perform Spreadsheet Functions 24 hours

IT

24 HRS

WSQ

Excel Courses in Singapore

Dashboards using Power Query

IT

8 HRS

Non-Certifiable

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

message US

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

whatsapp US

Training hotline

Give us a call at
+65 6737 5761

CALL US
IT Courses
Soft Skills Courses
About Us
Resources

Offering an extensive range of courses conducted by our pool of accredited trainers, we take pride in providing training solutions to meet your learning and professional objectives.

Connect With Us

© Copyright James Cook Institute 2025

Data Privacy Notification

UEN No.: 198802365N

Search

SERVICES

Contact Us
SHARE THIS COURSE
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration