2 days – Visual Basic Application for Excel 2016

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.

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