ASK Training

Course Description

This course, Visual Basic for Applications in Microsoft Excel – Fundamental, is designed with a practical approach towards unleashing the power of Spreadsheet through VBA programming. It aims to enhance productivity by equipping participants with the knowledge and skills to automate repetitive tasks or simplify a complex task. For example, if you have to copy certain rows and columns from a table into different tables in different excel sheets on a daily basis. Or you have to calculate the average, mean, median or carry out some statistical function of certain columns in few excel sheets every week. Learning VBA allows you to automate repetitive tasks or simplify a complex task easily.

 

In short, VBA allows you to save time, avoid boredom and reduce mistakes from performing repetitive tasks. It also makes you more employable or valuable to your employer as you are more productive. It also opens up career opportunities if you join an organisation that use Ms Excel extensively eg. finance, data warehouse, analytics etc that deals with huge data. Another advantage of learning VBA is, it can stimulate your brain to think logically and do more complicated macros. It is easy to learn even when you have no Programming basics because you don’t need to learn the whole Syntax.

 

It is an introductory course for learners to learn the Excel programming environment and grasp the fundamentals in working with Objects, Variables, Conditionals, and Looping. You will also learn how to debug errors and make necessary correction to make the program works.

 

The individuals who are keen to register for this course, you should have attended the Microsoft Excel – Advanced course or an Advanced user of Excel before attending this course.

 

Further on your skills and programming knowledge on VBA with Visual Basic for Applications in Microsoft Excel – Advanced.

 

SDF Subsidy & Skillsfuture credit eligible.

Course Objectives

At the end of this course, you should be able to:

Identify repetitive tasks and think logically and do more complicated macros

Identify repetitive tasks and think logically and do more complicated macros

Understand how Excel programming environment works

Understand how Excel programming environment works.

Grasp the fundamentals in working with Objects Variables Conditionals and Looping

Grasp the fundamentals in working with Objects, Variables, Conditionals and Looping.

Debug errors and make necessary correction to make the program works

Debug errors and make necessary correction to make the program works.

Identify repetitive tasks and think logically and do more complicated macros

Identify repetitive tasks and think logically and do more complicated macros

Understand how Excel programming environment works

Understand how Excel programming environment works.

Grasp the fundamentals in working with Objects Variables Conditionals and Looping

Grasp the fundamentals in working with Objects, Variables, Conditionals and Looping.

Debug errors and make necessary correction to make the program works

Debug errors and make necessary correction to make the program works.

Course Outline

You will be learning the following:

Introduction to Macros

Exploring Excel Objects

Controlling Visual Basic with Conditionals

Extending Functionality with Subroutines and Functions

Debugging and Error Handling

Introduction to the Programming Environment

Controlling Visual Basic with Variables

Controlling Visual Basic with Loops

Building Intuitive User Interfaces

Project

Course Fees And Grants

S$642.00 per participant (Incl. GST)

 

SDF Subsidy for Company Sponsored Individuals: S$2 per training hour. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

 

Click here for UTAP Fundings

 

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

Course Schedule

CourseCodeVenueJun-22Jul-22Aug-22Sep-22Oct-22Nov-22Dec-22
Visual Basic for Applications in Microsoft Excel - FundamentalTGS-2016500026JTC Summit20-22-22-24-10-12-19-21
TGS-2016500026Mountbatten Square-04-06-14-16-07-09-

Registration

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

S$642.00 per participant (Incl. GST)

 

SDF Subsidy for Company Sponsored Individuals: S$2 per training hour. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

 

Click here for UTAP Fundings

 

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

REGISTRATION

For Organisations on HRP Portal, you are strongly encouraged to use this platform for registration.

Browse Courses

Learning Paths

Master Microsoft Office

Master Microsoft Office

Become a Web Designer

Become a Web Designer

Become a Digital Marketer

Become a Digital Marketer

Become a Video Producer

Become a Video Producer