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
  • Time:

    TBA,
    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

-

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

-

Courses that may also interest you