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

Singapore Polytechnic Open House 2026

Save the date now! Explore SP schools through visits and talks, meet future seniors and lecturers, try out CCAs, and grab our SP merch and freebies!

Know more

University Pathways

Discover how Singapore Polytechnic helps students transition to top universities with a robust curriculum and university accelerated pathway programmes.

Know more

Overview

Course Date:

TBA

Registration Period:

TBA

Duration/Frequency:

14 hours / 2 days (9am-5pm)

Mode of Training:

Face-to-Face (Classroom Teaching)

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.

More Information

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.

Overview

Course Date:

Registration Period:

Duration/Frequency:

Mode of Training:

Course Objective

More Information

Specialist Diploma in Data Science (Predictive Analytics)

Specialist Diploma in Data Protection and AI Governance

Specialist Diploma in Data Science (Data Analytics)

Specialist Diploma in Data Science (Vision & Language Analytics)