Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Enhance Your Employability with Certified Skills and Courses in Singapore - WSQ , IBF-STS, Skills Certification

Currency: SGD  
Menu
  • Home
  • Visual Basic Application (VBA) for Excel Training

Visual Basic Application (VBA) for Excel Training in Singapore

Visual Basic Application (VBA) for Excel Training

26 Review(s) | Add Your Review

Dive into the transformative world of Visual Basic Application (VBA) for Excel with our specialized training course. Participants will gain hands-on experience working in the Visual Basic Editor, adding and optimizing code for macros, and effectively managing code modules. The curriculum further illuminates the nuances of declaring and utilizing variables, the intricacies of variable scope, and the power of defining arrays.

Delving deeper, the course also focuses on masterfully managing workbooks and worksheets using VBA, automating repetitive tasks with loops, and employing advanced debugging techniques. Additionally, the training sharpens skills in managing cell data operations and proficiently running event procedures. Equip yourself with the expertise to harness the full potential of Excel using VBA with Tertiary Courses.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant Applications

No funding is available for this course.

For WSQ funding, please checkout the details at WSQ - Software Automation with Excel VBA Programming

Course Code: C357

Course Booking

The course fee listed below is before subsidy/grant, if applicable. We will apply for the grant and send you the invoice with nett fee.

$600.00 (GST-exclusive)
$654.00 (GST-inclusive)

Course Date

Course Time

* Required Fields

Course Information

  • Session (days): 2
  • Duration (hrs): 15
  • Level: Beginner
  • Additional Note: Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.
  • Venue:

    All courses except hydroponics courses:

    12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

    The venue is disabled-friendly.


    Hydroponics courses:

    Toh Orchid Farm, 84 Sungei Tengah Singapore 698986

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Course Cancellation/Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commerce.
  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
  • Note the venue of the training is subject to changes due to availability of the classroom

Course Details

Topic 1 Get Started on VBA

  • What is VBA
  • Access VBA from Excel
  • Write Your First VBA Code
  • Message and Input Box
  • Macro Record

Topic 2 VBA Programming

  • Variables and Constants
  • Data Types and Array
  • Operators
  • Decision
  • Loops

Topic 3 Function and Sub Procedure

  • Worksheet Functions
  • Create Charts
  • Sub Procedure

Topic 4 Managing Excel Objects

  • Work with Excel Objects
  • Error Handling
  • Debugging

Topic 5 Events and User Forms

  • Events
  • User Forms

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions
  • Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

  • Positive Learning Attitude
  • Enthusiastic Learner

Experience

  • Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

TBD

Hardware: Window or Mac Laptops

Job Roles

  • Data Analyst
  • Business Analyst
  • Financial Analyst
  • Operations Manager
  • Marketing Analyst
  • HR Metrics Specialist
  • Sales Operations Specialist
  • Report Developer
  • Project Manager
  • Management Accountant
  • Product Manager
  • Supply Chain Analyst
  • Performance Metrics Specialist
  • Market Researcher
  • Business Intelligence Coordinator

Trainers

Jim Gan Chiu Liang: Jim Gan Chiu Liang is a ACTA certified trainer. Jim Gan Chiu Liang obtained his Master of Technology (M.Tech Knowledge Engineering) from National University of Singapore (NUS) Institute of System Science. He is currently working as adjunct trainer at PACE (Professional Adult Continuing Education) Academy, Singapore Polytechnic. His past experience included being a chief instructor for Kumon Education.

Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations.

Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.

Customer Reviews (26)

All good Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
All good (Posted on 6/13/2023)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 6/13/2023)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 12/5/2022)
Ken was able to adapt the content based on the background I shared. Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Ken was able to adapt the content based on the background I shared. (Posted on 10/11/2021)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Ken was able to adapt the content based on the background I shared. (Posted on 10/11/2021)
Longer time. Abit too short Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 6/26/2021)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 5/29/2021)
might recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 5/3/2021)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 9/19/2020)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
- go through all exercise, can skip the slides.
- give some tips and trick like how to use object orient, customized the ribbon, useful toolbars (Posted on 8/17/2020)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
It was quite comprehensive, but being nitpicky maybe the slides might've been more suited to newer versions of excel as some functions like modulus had the old symbols listed in the slides. (Posted on 8/17/2020)
might recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
- there are some error with slides:
1)Workbooks.Open - never specific relative path
2)Last exercise, variable in case is sales
3) Arthimetic operator : % is not in used.
4) Do while loop does not function

2nd, show on how to improve programming productivity, customized ribbons, error handling, object class modules, understand it is a day course, do a bit of touch and go.

3rdly, the entire class just use option explicit, force all variable need to declare data type, just show one counter example.

4th, just save time on the slides do the entire exercises.
the reason I say might recommend is I got some background in word VBA (Posted on 8/17/2020)
wil recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 3/15/2020)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 2/28/2020)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Johnson is clear in explaining the difficult VBA concepts. (Posted on 5/28/2019)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
More hands on

Tutor does not seem very knowledgeable with VBA: unable to answer some questions (Posted on 5/13/2019)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 5/13/2019)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Perhaps can send the material before the class so we can prepare before class (Posted on 3/22/2019)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
I believe it will be better if more syntax are introduced! (Posted on 11/25/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Very patient and clear explanation from trainer (Posted on 7/28/2018)

Items 1 to 20 of 26 total

per page
Page:
  1. 1
  2. 2

Write Your Own Review

You're reviewing: Visual Basic Application (VBA) for Excel Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha
    Attention: Captcha is case sensitive.

You May Be Interested In These Courses

WSQ – Data Visualisation with Tableau

WSQ – Data Visualisation with Tableau

225 Review(s)
$750.00 (GST-exclusive)
$817.50 (GST-inclusive)
WSQ - Statistical Data Analysis with Excel for Beginners

WSQ - Statistical Data Analysis with Excel for Beginners

62 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)
WSQ - Data Analytics and Visualization with Power BI

WSQ - Data Analytics and Visualization with Power BI

172 Review(s)
$800.00 (GST-exclusive)
$872.00 (GST-inclusive)
WSQ - Data Storytelling with Tableau

WSQ - Data Storytelling with Tableau

31 Review(s)
$750.00 (GST-exclusive)
$817.50 (GST-inclusive)
WSQ – Software Automation with Excel VBA Programming

WSQ – Software Automation with Excel VBA Programming

56 Review(s)
$750.00 (GST-exclusive)
$817.50 (GST-inclusive)
WSQ - Create Interactive Dashboard Using Excel

WSQ - Create Interactive Dashboard Using Excel

59 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)
About Us

Tertiary Courses, founded in 2014, specializes in providing modular, skill-based courses tailored to Industry 4.0. We are WSQ Approved Training Organization (ATO), and IBF Approved ATO.. We are also Authorized Microsoft Learning Partner, Autodesk Authorized Training Center (ATC), Pearson Vue Authorized Test Center and Kryterion Authorized Testing Center. We offer a comprehensive range of training, certification prep and certification exam services. Additionally, we are a registered supplier with Singapore GeBiz, further solidifying our position as a trusted educational institution in the region.

Training Grants and Subsidies

We have various grants and subsidies for different courses. Please check the respective funding available on individual course page.

WSQ: Company and Singaporeans/PR can apply WSQ 70-90% funding depending on eligibility
SkillsFuture Enterprise Credit (SFEC) - Eligible Singapore-registered companies can tap on $10000 SFEC to cover up to 90% of out-of-pocket expense
SkillsFuture Credit: All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses.
IBF-STS Companies and Singaporeans/PR can apply IBF-STS 70-90% funding depending on eligibility
UTAP: NTUC members enjoy 50% subsidy for unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP
SGTech STAR Fund: SGTECH members enjoy $500 grant per pax for SGTech STAR courses

Authorised Training Partners
1

Microsoft Learning Partner

Microsoft Learning Partner with Tertiary Infotech
2

CompTIA Authorised Delivery Partner

CompTIA Authorised Delivery Partner with Tertiary Infotech
3

AWS APN Training Partner

AWS APN Traning Partner with Tertiary Infotech
4

Autodesk Authorised Training Center

Autodesk Authorised Training Center with Tertiary Infotech
Authorized Testing Centers
1

Pearson VUE Authorised Test Center

Pearson VUE Authorised Test Center
2

Kryterion Authorized Testing Center

Kryterion Authorized Testing Center with Tertiary Courses Singapore
Approved Training Organizations
1

WSQ Approved Training Organization

WSQ Approved Training Organization for WSQ Courses
2

Institute of Banking & Finance (IBF) Approved Training Provider

Institute of Banking & Finance (IBF) Approved Training Provider
3

Singapore Chartered Accountant (SAC) Accredited Training Organisation

Singapore Chartered Accountant Accredited Training Organisation
Regional Training Centers
1

Singapore (Headquarter)

2

Malaysia Kuala Lumpur and Penang

3

Bhutan

4

Vietnam

5

Ghana Accra

6

Nigeria Lagos

Contact Us Information

Tel: +65 6100 0613

whatsapp

Whatsapp: https://wa.me/6561000613

Tertiary Courses SG GPT

Tertiary Courses SG GPT

Email: enquiry@tertiaryinfotech.com

Training Centers venue :
12 Woodlands Square, #07-85/86/87, Woods Square Tower 1, Singapore 737715 (Disabled-Friendly) .

Mailing address:
45, #06-13, Choa Chu Kang Loop, The Warren, Singapore 689679

Approved Suppliers
7

GeBiz Registered Supplier

Singapore GeBiz Registered Supplier
Information
Enquires
Training Grant and Subsidy
Our Websites
Certified Trainers

Copyright © 2023. Tertiary Infotech Pte Ltd. ROC/GST #: 201200696W. All Rights Reserved.

PayPal Master Card Visa Card PayNow