Visual Basic for Applications in Microsoft Excel - Fundamental

Course Overview

This Visual Basic for Applications in Microsoft Excel – Fundamental course 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 in Excel 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.

This Excel VBA Course 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.

Individuals who are keen to register for this course, must have either completed the Microsoft Excel – Advanced course or possess advanced Excel skills.

Elevate your skills and programming knowledge on VBA with this VBA course in Singapore.

Mode of Assessment

No Assessment

Course Duration

3 Days

Total Training Duration (Hour)

24 Hours

Course Outline

'- Introduction to Macros

- Introduction to the Programming Environment

- Exploring Excel Objects

- Controlling Visual Basic with Variables

- Controlling Visual Basic with Conditionals

- Controlling Visual Basic with Loops

- Extending Functionality with Subroutines and Functions

- Building Intuitive User Interfaces

- Debugging and Error Handling

- Project

Certification Obtained and Conferred by

Upon successful completion of the Visual Basic for Applications in Microsoft Excel – Fundamental course, participants who have attended at least 75% of the course will receive a Certificate of Attendance by @ASK Training.

Course Learning Outcome

Upon completion of this VBA Excel course, you will be able to:

- Identify repetitive tasks and think logically and do more complicated macros

- Understand how Excel programming environment works

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

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

Pre-requisites

To enrol in this course, you should possess the following:

- (≥ 16 years old); or

- 1 year working experience

You must have attended Excel Advanced course or have been using Excel for the past three years continuously, with strong working knowledge of Excel.

Price

	Course Fee Payable
Original Fee	Before GST	With GST (9%)
Course Fee	$800.00	$872.00
Corporate Pricing (Fee payable to Training Provider)
SME	Before GST	With GST (9%)
SDF Funding	$800.00	$872.00
Non-SME	Before GST	With GST (9%)
SDF Funding	$800.00	$872.00