WSQ Data Automation Using Excel VBA Programming

Physical Training Available, Fundings Applicable.

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).

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

WSQ VBA Excel Course Outline

Module One: Create And Manage Worksheets And Workbooks

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)

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
Kindly help us process via Quiz