Manual processes can slow down decision-making and increase error. This course equips participants to streamline Excel workflows using VBA, developing macros that automate tasks and improve productivity. Through step-by-step guidance, they will develop macros, write custom scripts, and build solutions that enhance productivity.
Learning Outcomes:
Understand the VBA programming environment in Excel
Record, edit, and execute macros for automation
Write VBA procedures using variables and control structures
Create user forms for interactive data input
Debug and troubleshoot basic VBA scripts
Key Topics:
Baisc Macro in Excel
Excel VBA Environment and macro recorder
Variables and Data Types
Conditional Structure for Decision Making
Use Loops for Repetitive Statements
Sub Procedures and User defined Functions
User Form design and Events
Debugging and Error Handling
FUNDING INFORMATION
SkillsFuture Singapore (SSG)
Funding is available on Course Fee. Please see below for the eligibility categories available.
| Self-sponsored | Singapore Citizen & PR aged ≥ 21 years | Up to 50% funding |
| Singapore Citizen aged ≥ 40 years | Up to 70% funding | |
| Company Sponsored (Non-SME) | Singapore Citizen & PR aged ≥ 21 years | Up to 50% funding |
| Singapore Citizen aged ≥ 40 years | Up to 70% funding | |
| Company Sponsored (SME) | Singapore Citizen & PR aged ≥ 21 years | Up to 70% funding |
| Singapore Citizen aged ≥ 40 years | Up to 70% funding |
SSG Funding Requirements
- Trainees must scan their attendance twice daily using the SingPass application.
- Trainees must attain at least 75% attendance.
- Trainees must pass the in-house assessment to be eligible for funding.
- Trainee and/or sponsoring company is/are required to meet all SSG-mandated eligibility criteria and requirements for funding. For more information, please refer to SkillsFuture homepage.
Appeal Policy and Procedure
- As a candidate in this course assessment, you may appeal your results if you disagree with them.
- To do so, submit your written appeal request via email to esv_comat_cse@stengg.com within 3 working days from date of assessment.
Cancellation, Postponement and Refund Policy
- Request for cancellation or postponement must be submitted in writing more than 4 weeks before the class start date to avoid any charges.
- Written notice for cancellation or postponement received 2 to 4 weeks before class start date will incur Late Cancellation Charge - 50% of course fee.
- Written notice for cancellation or postponement received less than 2 weeks before class start date will incur Late Cancellation Charge - 100% of course fee.
- If payment has been made and ST Engineering e-Services Pte Ltd accepts the trainee's written notification to cancel or withdraw from the course, ST Engineering e-Services Pte Ltd will issue a refund, less any applicable Late Cancellation Charges.
Feedback Policy and Procedure
- You may submit feedback via email to esv_comat_cse@stengg.com or your servicing Account Manager.
- Any formal feedback will be handled within 10 working days from receipt with a written reply given. An interim reply will be provided should more time be required.
Module 1: Introduction to Automation
- Programming Language Available
- Suitable applications for Macro
- Basic Macro in Excel
- Run a Macro
Module 2: VBA Environment
- Familiarize with VBA Environment
- Use the Edit Toolbar
- Add Comments
- Use Immediate Window
- Use ? Statement
- Use Debug.Print
- Instructions, Module and Procedures
- Object, Properties and Methods
- Syntax Rules
- The Object Browser
- Msgbox Function
- Inputbox Function
Module 3: Variables and Data Types
- Define Variables
- Data Types
- Creating Variables
- Declaring Variables
- Forcing Declaration of Variables
- The Scope of Variables
- Using Constants in VBA Procedures
Module 4: Conditional Structure and Decision Making
- Relational and Logical Operators
- If…Then Statement
- The If…Then…Else Statement
- The If…Then…ElseIf Statement
- Select Case Statement
Module 5: Loops
- Do Loops: Do…While and Do…Until
- While…Wend Loop
- For…Next Loop
- For Each…Next Loop
- Exiting Loops Early
- Nested Loops
Module 6: Subroutines and Functions
- Sub Procedures
- Functions
Module 7: Userforms and Dialogs and Events
- Create Userforms
- Forms and Event Controls
- Event and Procedures
Module 8: Debugging and Error Handling
- Test Procedures
- Stop a Procedure
- Using Breakpoints
- Add Watch
- Trap Errors
.png?width=50&name=Artificial%20Intelligence%20(AI).png)
-1.png?width=360&name=Server%20(4)-1.png)
/AI%20(6)-1-1.png?width=360&name=AI%20(6)-1-1.png)
/AI%20(8)-1.png?width=360&name=AI%20(8)-1.png)
-1.png?width=360&name=Automation%20RPA%20(2)-1.png)
/AI%20(5)-1.png?width=360&name=AI%20(5)-1.png)
