course-banner-img Data Analytics-8

Automating Data Processing With Microsoft Excel Visual Basic for Applications (VBA)

Topic:Data Analytics & Visualisation, Others

Course Type:Short & Modular Courses

Register interest
Download PDF for print

Overview

  • Course Date:

    18 Mar 2024 to 19 Mar 2024
  • Registration Period:

    09 Jan 2024 to 18 Feb 2024
  • Time:

    09:00 AM to 05:00 PM,
    14 hours
  • Mode of Training:

    Facilitated Learning (F2F)
  • Venue:

    Singapore Polytechnic
  • Funding:

    Eligible for SkillsFuture Credit

MS Excel is a ubiquitous application which is indispensable in many companies. Users can harness the full potential of MS Excel by automating repetitive and manual tasks using Excel VBA. Through automation, users can also improve their productivity and reduce human errors in data processing.

Course Objective

This course aims to enhance the productivity of users of MS Excel by reducing the time spent on repetitive and manual data processing tasks and minimising human errors through spreadsheet automation using MS Excel VBA.

Participants will learn how to write Excel VBA codes from the ground up and this serves to build a basic understanding of programming.


Course Outline

By the end of the course, participants will be able to:

• Understand the basics of object oriented programming
• Create MS Excel VBA macros that can help automate tasks and processes while reducing human errors.

Topics to be covered

• Basic MS Excel VBA Syntax and Functions
• Automatic Tasks With MS Excel VBA
• Using MS Excel VBA With MS Outlook

Minimum Requirements

Working knowledge of Microsoft Excel

Certification / Accreditation

  • Certificate of Attendance (electronic Certificate will be issued)
    A Certificate of Attendance will be awarded to participants who meet at least 75% attendance rate
  • Certificate of Completion (electronic Certificate will be issued)
    A Certificate of Completion will be awarded to participants who pass the assessment and meet at least 75% attendance rate

Suitable for

Accountants, Human Resource Professionals, Sales Professionals, Marketing Professionals, Secretaries, Clerks, Operations Administrators, etc.

Course Fees

The course fees payable above are inclusive of prevailing GST rate.

Applicants/Eligibility SkillsFuture Funding GST* Subsidised Fee (after GST)
Singapore Citizens aged 40 and above¹ $315.00 $9.45 $44.45
Singapore Citizens aged below 40 $245.00 $9.45 $114.45
Singapore Permanent Residents and LTVP+ Holders $245.00 $9.45 $114.45
SME-sponsored Singapore Citizens, Permanent Residents and LTVP+ Holders² $315.00 $9.45 $44.45
Others (Full fees payable) $0.00 $31.50 $381.50

As per SSG’s policy, the GST payable for all funding-eligible applicants is calculated based on prevailing GST rate after baseline funding subsidy of 70%

Singaporeans aged 25 years and above may use **SkillsFuture Credit balance to offset respective course fees.

¹ Under the SkillsFuture Mid-career Enhanced Subsidy. For more information, visit the SkillsFuture website here
² Under the Enhanced Training Support for Small & Medium Enterprises (SMEs) Scheme. For more information of the scheme, click here. To view SP’s list of similar funded courses, click here. Please submit the attached “Declaration Form for Enhanced Training Support Scheme for SME” together with your online application.


Funding Incentives

Please click here for more information on funding incentives.


Related Links

 

Application Procedure

1. Application must be made through STEP. 

2. All successful applicants will be notified with a letter of confirmation via email.
 

Courses that may also interest you