WSQ - Automating Excel with VBA Programming

TGS-2023036548

Course Overview

Excel VBA (Visual Basic for Applications) is the name of the programming language of Excel. VBA lets you automate many aspects of Excel by writing Sub and Function procedures (also known as macros). A good knowledge of VBA can save time and make you a much more productive Excel user.


Training Type

Full Time


Mode of Assessment

Written & Practical Assessment


Who Should Attend

Microsoft Office power users who wish to automate and simplify their work process with macros and programming


Course Duration

3 Days


Total Training Duration (Hour)

24 Hours


Course Outline

Module 1: Getting Started


Module 2: Working with Procedures and Functions


Module 3: Understanding Objects


Module 4: Using Expressions, Variables, and Intrinsic Functions


Module 5: Controlling Program Execution


Module 6: Working with Forms and Controls


Module 7: Working with the PivotTable Object


Module 8: Debugging Code


Module 9: Handling Errors


Certification Obtained and Conferred by
  1. Avantus Certificate of Attendance (upon achieving minimum 75% class attendance)
  2. WSQ Statement of Attainment (upon passing the relevant assessment)
  • To download WSQ e-Certs, Learners can log in to MySkillsFuture portal via SingPass > go to Skills Passport > Certificates

Course Learning Outcome

This 3-day course will equip learners with the knowledge and ability to automate most tasks in Excel using Visual Basic for Applications (VBA). Learners will learn how to record macros and script Excel to automate procedures and processes. Learners need not have programming background to pick up these skillsets as they will be guided to code from scratch using the intuitive language of VBA. A good knowledge of VBA can help save time, simplify and streamline work processes, and improve productivity at work.


Pre-requisites
  1. Be able to listen and speak English at a proficiency level equivalent to the Employability Skills Workforce Skills Qualifications (ES WSQ) Workplace Literacy (WPL) Level 6 (Sec 4); and
  2. Be able to read and write English at a proficiency level equivalent to ES WSQ WPL Level 6 (Sec 4);
  3. Be able to manipulate numbers at a proficiency level equivalent to ES WSQ WPN Level 6 (Sec 4)
  4. Understand advanced Excel formatting options, including conditional formatting and customised cell formatting
  5. Understand relative cell reference vs. absolute cell references
  6. Recognise which functions to use in formulas
  7. Know how to sort and filter data
  8. Know how to summarize data with Pivot Tables

Medium of Instruction & Trainer

English


Funding Information

Skillsfuture Singapore (SSG) - WSQ Certifiable Funding


Criteria:

  • Applicant must either be a Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must be at least 21 years old and;
  • Applicant must achieve at least 75% attendance, and pass all examinations/assessments and;
  • Applicant is taking the course for the first time


Avantus reserves the right to charge the full course fee (without subsidy) if any of the conditions above are not met.


SSG Funding Validity Period

16 August 2023 - 15 August 2025


Singapore Citizens aged 25 years and above will be able to utilize their Skillsfuture Credits to offset against nett fee payable



Additional Notes

Assessment Retake fee at $80 (before GST)


Documents


Price
Course Fee Payable
Original Fee Before GST With GST (9%)
Course Fee $900.00 $981.00
Individual Pricing (Fee payable to Training Provider) Before GST With GST (9%)
SkillsFuture >=40 years old, Singapore Citizens $270.00 $351.00
SkillsFuture >=21 years old $450.00 $531.00
Corporate Pricing (Fee payable to Training Provider)
Non-SME Before GST With GST (9%)
SkillsFuture >=21 years old $450.00 $531.00
SkillsFuture >= 40 years old $270.00 $351.00
SME Before GST With GST (9%)
SkillsFuture $270.00 $351.00

Please note that prices are subject to change.
Back to Catalogue →
Next Available Schedules
Course Name:
Category:
Delivered By:
Trainer:
Venue:
Language:
Session Dates: Please view schedule

Registration Date:
From To