2 days – Visual Basic Application for Excel 2016

COURSE details

Course Duration

15 HRS

Mode of Training

Classroom

Course Timing

9am-5.30pm

DATE & REGISTRATION

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

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.

COURSE FEES

Company Sponsored / Self Sponsored

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

DATE & REGISTRATION

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

Related Courses

IT

24 HRS

WSQ

IT

24 HRS

WSQ

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

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761

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