WSQ Data Automation Using Excel VBA Programming Course in Singapore

WSQ

Singapore Workforce Skills Qualifications

Learn WSQ data automation techniques using Excel VBA programming in just a few steps. Enhance productivity and efficiency with powerful automation tools!

FAQ

Course Start Date

27/05/2024 | 09:30 to 17:30

Week Days

Book now

10/07/2024 | 09:30 to 17:30

Week Days

Book now

25/09/2024 | 09:30 to 17:30

Week Days

Book now

06/11/2024 | 09:30 to 17:30

Week Days

Book now

Schedule

Days: 3 Days

Duration: 24 Hours

Timings: 9:30 AM - 5:30 PM

10 Anson Road, 26-08A International Plaza, Singapore 079903

Why Choose Us

Expert Local Trainers
Hands-on Training by experts
Certificate of Achievement
Free Refresh Class within 6 Month

Quick Register

Who Should Attend This WSQ Data Automation Using Excel VBA Programming

We are glad to inform that we have this WSQ Data Automation Using Excel VBA Programming certified course with upto 70% funding.

Data Scientist

Developer

Hacker

Training Professionals

Student

Course Completion Requirements:

Minimum 75% attendance is required in order to complete the course and receive the course completion certificate

Entry Requirements

Above 21 years old

High School Level English

Efficient internet & computer operation skills

WSQ Data Automation Using Excel VBA Programming in Singapore

Visual Basic for Applications or VBA refers to the development environment that is built into the Microsoft Office suite of products.

This Excel VBA course is for anyone looking to leverage the power of VBA to work more efficiently with Microsoft Office applications, particularly Excel, in both personal and professional contexts. Target audiences for this course include:

Professionals involved in data analysis, modelling, and reporting within their organizations.
Data Analysts who work with data on a regular basis and want to automate data manipulation and reporting tasks in Excel.
Finance professionals who rely on Excel for financial modelling, forecasting, and data analysis.
Accountants and finance professionals who use Excel for financial reporting and analysis.
Administrative staff who manage data, records, and reports using Excel.
Project managers who use Excel for project planning, tracking, and reporting.
Programmers and software developers interested in learning VBA for Office applications.
Individuals who use Microsoft Excel regularly for tasks such as data analysis, reporting, budgeting, or project managementThe objective of this course is to enable learners to develop technical capabilities to understand, design and write instructions to be processed by computers as software programmes to achieve desired outcomes using the Excel Visual Basic for Applications (VBA).

python programming certification singapore

What Will You Learn WSQ Data Automation Using Excel VBA Programming

Learners are able to analyse and translate business requirements of Visual Basic for Applications (VBA) into multiple functions for business requirement and objectives
Learners are able to write programmes and codes with the Visual Basic for Applications (VBA) algorithm and data structures which aligned with business requirements
Learners are able to draft coding frameworks as practical guides for organising programming and coding languages aligning to logic and styles
Learners are able to formulate code solutions in accordance with code management approaches using programming languages
Learners are able to incorporate appropriate improvements and make relevant corrections to pro-grammes and codes to achieve desired outcomes in gathering user input
Learners are able to select appropriate programming languages in Visual Basic for Applications (VBA) for business use cases by applying scripting approaches
Learners are able to document programming and coding updates and changes for business and technical professionals with Visual Basic for Applications (VBA) codes, systems and platform layouts in accordance with organisation’s strategic objectives and processes
Learners are able to test and debug codes to ensure workability of Visual Basic for Applications (VBA)
Learners are able to assess written codes in Visual Basic for Applications (VBA) using problem-solving and error-handling techniques to address errors and gaps for subsequent resolution

Training fee:

*Course fee before WSQ funding: $795.00/pax + 9% GST. GST rate will be applied for all registration made after 31st December 2023

WSQ Funding: (GST included)

*The funding amount mentioned is indicative and will be confirmed upon registration.

Course Fee Subsidies for SMEs	SINGAPORE CITIZENS AND PRS ≥ 21
	70% of Course Fees
	WSQ Deductible: $556.5 Payable: $310.05 (including GST)
	Passing Exam & Full Attendance required
Course Fee Subsidies for Non-SMEs	SINGAPORE CITIZENS ≥ 40	SINGAPORE CITIZENS < 40 AND PRS
	70% of Course Fees	50% of Course Fees
	WSQ Deductible: $556.5 Payable: $310.05 (including GST)	WSQ deductible: $397.5 Payable $469.05 (including GST)
	Passing Exam & Full Attendance required
Course Fee Subsidies for Self-sponsored Individuals	SINGAPORE CITIZENS ≥ 40	21⩽SINGAPORE CITIZENS < 40 AND 21 ⩽PRS
	70% of Course Fees	50% of Course Fees
	WSQ Deductible: $556.5 Payable: $310.05 (including GST) (Can be offset by Skillsfuture credits if have)	WSQ deductible: $397.5 Payable $469.05 (including GST) (Can be offset by Skillsfuture credits if have)
	Passing Exam & Full Attendance required

Kindly note that you are required to achieve a minimum of 75% attendance and be certified competent in all the assessment components. Should you fail to meet the attendance/assessment requirements and/or terms and conditions of SSG's funding, you will not be eligible for the course fee funding and will have to bear the full course fees.

Discount policy:

4 pax from a same group: 5% discount for each person
5 pax from a same group: 10% discount for each person

Assessment Plan:

Written Assessment – Short Answer Question (WA-SAQ): 1 hour
Practical Performance: 1 hour

An entrance test is required before the course, kindly help us process via Entrance Quiz (Est time to complete: 10 min).

Grants available

SkillsFuture Eligible

SkillsFuture Credit: Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Course Outline:

Lesson 1. Visual Basic for Applications (VBA) for Office (1.5 Hrs)

1.1 Recognizing the need and uses for VBA applications (K2)
1.2 Get Started with Visual Basic for Applications (K2)
1.3 Displaying the Developer Tab in the Ribbon (A1)
1.4 Understanding the Development Environment (A1)
1.5 Understanding Macro Security (A1)

Lesson 3. Understanding objects, methods, properties, and events (3 Hrs)

3.1 Understanding and Navigating Excel Object Hierarchy (K1)
3.2 Understanding Collections (K1)
3.3 Using the Object Browser (K1)
3.4 Working with Properties (K1)
3.5 Using the “WITH” Statement (A3)
3.6 Working with VBA Methods (A3)
3.7 Creating an Event Procedure (A3)

Lesson 5. Controlling Program Execution (4 Hrs)

5.1 Understanding Control-of-Flow Structures (K5)
5.2 Working with Boolean Expressions (K5)
5.3 Using the If…End If Decision Structures (A4)
5.4 Using the Select Case…End Select Structure (A4)
5.5 Using the Do…Loop Structure (A4)
5.6 Using the For…To…Next Structure (A4)
5.7 Using the For Each…Next Structure Guidelines for use of Control-of-Flow Structures (A4)

Lesson 7. Gathering User input (2 Hrs)

7.1 Gathering user input Using dialog boxes (A8)

Lesson 9. Handling Errors (1.5 Hrs)

9.1 Understanding Error Handling (K3)
9.2 Understanding VBA’s Error Trapping Options (K3)
9.3 Trapping Errors with the On Error Statement (K3)
9.54 Writing an Error-Handling Routine (A6)

Lesson 2. Working with Procedures and Functions (2 Hrs)

2.1 Understanding Modules (K4)
2.2 Understanding Procedures (K4)
2.3 Sub Procedure (K4)
2.4 Creating a Function Procedure (A2)
2.5 Naming Procedures (A2)
2.6 Working with the Code Editor (A2)

Lesson 4. Using Expressions, Variables, and Intrinsic Functions (3.5 Hrs)

4.1 Understanding Expressions, Statements and Declaring Variables (K6)
4.2 Understanding Data Types (K6)
4.3 Working with Variable Scope (K6)
4.4 Using Intrinsic Functions (A5)
4.5 Using Intrinsic Constants (A5)
4.7 Declaring and Using Object Variables (A5)

Lesson 6. Working with Forms and Controls (3 Hrs)

6.1 Understanding UserForms (K7)
6.2 Using the Toolbox (K7)
6.3 Working with UserForm Properties, Events, and Methods (K7)
6.4 Understanding Controls (K7)
6.5 Setting Control Properties in the Properties Window (K7)
6.6 Working with the Controls (A9)
Label Control
Text Box Control
Command Button Control
Combo Box Control
Frame Control
Option Button Controls
Control Appearance
Setting the Tab Order
6.7 Populating a Control (A9)
Adding Code to Controls
Launching a Form in Code

Lesson 8. Debugging Code (1.5 Hrs)

8.1 Understanding Errors (A7)
8.2 Using Debugging Tools (A7)
8.3 Setting Breakpoints (A7)
8.4 Stepping through Code (A7)
8.5 Using Break Mode during Run mode (A7)
8.6 Determining the Value of Expressions (A7)

Reviews of our students

Sarah Lah

4 months ago

Great excel course by Bee Hoon for 3 Days. Trainer was humorous and contextualised the info learnt in real life examples. Exercise files were easy to follow also.

Arun Dixit

11 months ago

I attended the excel course, our trainer Valene was really patient and well versed. The training environment was really good, I will definitely go again. Will recommend to my friends and family for sure.

Cara Chan

4 days ago

Attended WORDPRESS WEBSITE CREATION COURSE on 25 Sep 2023. Really appreciate the training made simple for beginners like myself. The trainer Mr Abhinay gave clear explanations and repeated many times to make sure we understood. Understanding how Wordpress works enabled me to navigate my company website and make updates efficiently. Unfortunately, the plug-in used by my company website was not taught in the course; which is understandable given the many different types of plug-ins available.The staffs were helpful and understanding when I was unable to log-in my singpass for attendance. It was overall an enjoyable experience to me. Snacks and beverages at the pantry was a bonus, too! Thank you, Inspizone!

Joanna

10 months ago

Thank you for the practicable courses. Lessons were conducted at a comfortable pace. Trainer Ms Mridula is knowledgeable, very helpful and encourages class participation to liven up the sessions. She also shared about how the tools can be applied in our work. Both intermediate and advanced excel courses exceeded my expectations. Thank you.

Guido Sudero

11 months ago

The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.

Avira Dixit

a year ago

I attended their 3 days excel training. I must say this is one of the best training places here at Singapore. They provide full training materials, you dont even need to bring your own laptop. Their course content was appropriate and examples used for explanation were relatable. The instructor was very patient and cleared all our doubts. Highly recommend!!

Leanie Lee

a year ago

I have just completed my excel levels 1 & 2. Trainer Bee Hoon is great. Her training was clear, audible & practical. A professional trainer indeed. Initially I was having some difficulties in my enrolment, but both the administrators Emma & Huyen were very helpful, patient, accommodating & efficient in their service, making it a pleasant experience I have had with InspiZone. InspiZone Highly recommended.

Wenyan Yeo (W)

7 months ago

Attended the MS Excel course (Beginner & Intermediate) on 25 & 26 Aug. Ms Koh Bee Hoon was the trainer for the above mentioned course. Ms Koh is very knowledgeable and patient, she makes sure everyone in the class understands the current topic before she moves on to the next. The lesson pace is very manageable too. After attending the course, I have learnt much more functions about MS Excel! Highly recommend this course to anyone who wish to learn more about MS Excel.

Lucia

a year ago

I have attended their MICROSOFT OFFICE EXCEL 2016 – INTERMEDIATE & ADVANCED LEVELS training. The trainer Bee Hoon is knowledgeable, patient and made online training an enjoyable hands-on experience. I would recommend the course for anyone wanting practical training, and I hope that there will be more online classes in the future.

J Quek

2 years ago

I am so glad that I had clicked on the site of Inspizone and decided to give a try on one of their courses, Master Excel Training. And I've got more than what I expected, I have done the course many years back but the trainers were never generous with their tips but Bee Hoon, a big "WOOW" she is very generous with the tips and know-how that I had never known before and she is very patient ...gosh! Fantastic trainer!! The Training Coordinator, Sophia, she was very helpful from the moment I send in my request and questions, she patiently guided me from registration, claiming my skill future till the approval and giving me the class schedule. A big thank you and great service! The school, wow!! I never have seen a school supplying such a well-stocked and premium snacks for students/trainees, the class welfare is really great and taken care of!! Thank you! I will definitely recommend Inspizone and I will keep a lookout for other courses that they have.

Katherine Ang

a year ago

I have researched on a few training centres before deciding on Inspizone. Very happy that I have chosen the right one! I have attended Microsoft Excel Intermediate & Advanced Class by Bee Hoon. She is super good, knowledgeable and clear with the online class. If you have any doubts she will also guide you patiently and ensure that you know how the functions work. If you are a beginner or you want to brush up your excel skills Bee Hoon will be my number one recommendation! 🙂 My training coordinator Emma has been very helpful towards my question too. Will definitely sign up for more courses with Inspizone!

Patricia Tong

5 years ago

Attended MS Excel 2013 Intermediate and Advanced levels. IT Trainer Ms Asha was patient and knowledgeable. Her lessons were conducted systematically. Additionally, their Project Coordinator Ms Huyen took efforts to text reminder a day before; kept the place neat and clean; and making sure refreshments were ready and adequate.

alex koh ming

3 years ago

BEST EXCEL TRAINING

Jacqueline Lee

2021-09-22

Went for a accounting course, Steven was friendly and helpful

Guido Sudero

2021-09-01

THIRUMALA DEVI

2021-09-15

Here i attended two courses. The Teacher is more knowledgeable person. I attend here accounts and Corporate Tax Singapore courses. really ill recommend this institute.

Lachu Gandhi

2021-09-07

Content of the course is appropriate. Trainer valene was very good and interactive. The place, course materials, the presentation and content of the material everything were clear and precise and she gave proper response to the queries raised. The place is well maintained too. Overall, a good experience and sure, I will recommend inspizone to my friends who are keen on upgrading themselves.

shengwei tan

2021-07-01

Stella is a great lecturer, the lesson taught are well orderly manner for each day which preps in beforehand and learning better.

Grace CH Ong

2021-06-11

A very useful course with laptops provided and sample datasets for our training. Training was very well-paced and clear, helpful for learning. Trainer also was happy to go around assisting when needed and managed queries well for us. Happy to have participated in a course at Inspizone 🙂