Default-Pace-Course-Banner

​​Excel Visual Basic for Applications (VBA) For Industrial Automation​

Topic:Data Analytics & Visualisation

Course Type:Short & Modular Courses

Register interest
Download PDF for print

Overview

  • Course Date:

    TBA
  • Registration Period:

    TBA
  • Duration/Frequency:

    16 Hours
  • Mode of Training:

    Face-to-Face (Classroom Teaching),Practical Training
  • Venue:

    Singapore Polytechnic
  • Funding:

    Eligible for SkillsFuture Credit

Excel Visual Basic for Applications (VBA) is widely used in companies for automatic data processing. Beyond the powerful data processing capabilities, Excel Visual Basic for Applications can also be used for creating real-time dashboard, accessing database, communicating with machines using standard industrial protocols and so on. These features make Excel Visual Basic for Applications a useful tool in industrial automation as well.

Course Objective

​​This course aims to demonstrate participants how to use Excel Visual Basic for Applications (VBA) to run procedure periodically, create a real-time dashboard, read/write to My Structured Query Language (MySQL) database, and send Outlook email. Communications using Open Platform Communications Unified Architecture (OPC UA) and Application Programming Interface (API) are also included.​

Course Outline

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

  1. Develop basic VBA procedures
  2. Create dynamic dashboard
  3. Interact with MySQL database through reading and writing
  4. Transmit Outlook using VBA
  5. Implement a simple user authentication procedure
  6. Communicate with machine using OPC UA
  7. Call REST API in VBA

Topics to be covered

- Some Basics of VBA programming

- Dynamic Dashboard

- MySQL Database Accessing

- Outlook Email

- User Authentication

- OPC UA and REST API

- Experiential Learning - AMC (Smart zone)  

Minimum Requirements

Working knowledge of Microsoft Excel and basic level of concept in programming.

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

Assistant Equipment Engineer / Assistant Integration Engineer / Integration and Application Engineers

Course Fees

The course fees payable above are inclusive of 9% GST rate.

Applicants/Eligibility SkillsFuture Funding GST Subsidised Fee (after GST)
Singapore Citizens aged 40 and above $639.00 $19.17 $90.17
Singapore Citizens aged below 40 $ 497.00 $19.17 $232.17
Singapore Permanent Residents and LTVP+ Holders $19.17 $497.00 $232.17
SME-sponsored Singapore Citizens, Permanent Residents and LTVP+ Holders2 $19.17 $19.17 $90.17
Others (Full fees payable) $0.00 $63.90 $773.90

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.

1Under the SkillsFuture Mid-career Enhanced Subsidy. For more information, visit the SkillsFuture website here
2 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.


Application Procedure

1. For self-sponsored applicant, please click on the “Register” button to apply for the course. You will be directed to STEP portal to manage all your course activities. Please note that you will be prompted to sign in with Singpass/Student ID.
 
2. For company-sponsored applicant, please approach your company's Human Resource (HR) team to put in the application through the company portal using CorpPass.  You may only apply after receiving the registration link from your company's HR.
 
3. Your application does not guarantee acceptance into the course. Your acceptance into the course is dependent on meeting the course requirements and course vacancy.
 
4. All successful applicants will be notified with a letter of confirmation via email.
 
6. PACE Academy course schedules, including course trainer, course fees and course availability are subject to change.

7. PACE Academy reserves the right to cancel or postpone any course at short notice; & at its absolute discretion without assigning any reason for such cancellation/postponements. In the event that the applicant’s chosen course is cancelled prior to its commencement, PACE Academy will make a full refund of course fees already paid by the applicant.

8. The data provided to Singapore Polytechnic will be kept strictly confidential and will be used for the purpose of course administration. The data may be passed on to the relevant organisations that require the information related to the course.  

Courses that may also interest you