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

Course Date:
8 - 9 March 2021

Registration Period:
15 January - 21 February 2021

Duration:
14 hours / 2 days

Time:
Monday & Tuesday

Mode of Training:
Classroom

Venue:
Singapore Polytechnic

Remarks:
Participants are required to bring along their laptop installed with Excel 2013 or later

---

Course Introduction

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.

Course Content & Structure

Topic	No. of Hours
Basic MS Excel VBA Syntax and Functions	7
Automatic Tasks With MS Excel VBA	3.5
Using MS Excel VBA With MS Outlook	3
Total Hours	13.5

---

Suitable for

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

---

Minimum Entry Requirements / Assumed Skills and Knowledge

Working knowledge of Microsoft Excel

---

Award / 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

Course Fees payable:

Singapore Citizens aged below 40 and Singapore PRs		Singapore Citizens	Others
Non-SME sponsored	1Sponsored by SME	2Aged 40 and above
$112.35 (incl. GST)	$42.35 (incl. GST)	$42.35 (incl. GST)	$374.50 (incl. GST)

Singaporeans aged 25 years and above may use **SkillsFuture Credit balance to offset respective course fees.
¹ Under the Enhanced Training Support for Small & Medium Enterprises (SMEs) Scheme. For more information, click here. Please submit the attached “Declaration Form for Enhanced Training Support Scheme for SME” together with your online application.
² Under the SkillsFuture Mid-career Enhanced Subsidy. For more information, visit the SkillsFuture website here.

---

Funding Incentives

Please click here for more information on funding incentives.

---

 

*Please note that once the maximum class size is reached, the online registration will be closed.

Application Procedure

1. All applications must be made via Online Registration at www.pace.sp.edu.sg
Course fees can be paid by the following payment modes:

a) Credit Cards, Internet Banking, NETS (Not Applicable for company sponsored)
For e-payment using Visa/Master cards and Internet Banking, please click on the ‘Make e-Payment’ button on the acknowledgement page to proceed.

b) For NETS payment, you can pay at:
Singapore Polytechnic
PACE Academy

c) Cheques
Please make cheques payable to “Singapore Polytechnic”. Do cross the cheque and write the Registration Reference ID, Applicant Name and NRIC/FIN number at the back of the cheque. When you have completed required details, you may mail the cheque here. 

Please note that an administrative charge of $15 will be imposed for any returned cheques from the bank or financial institution.

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