You have no items in your shopping cart.
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
-
All good (Posted on 6/13/2023)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 6/13/2023)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 12/5/2022)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. Review by Course Participant/Trainee
-
Ken was able to adapt the content based on the background I shared. (Posted on 10/11/2021)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 - will recommend Review by Course Participant/Trainee
-
Ken was able to adapt the content based on the background I shared. (Posted on 10/11/2021)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 - Longer time. Abit too short Review by Course Participant/Trainee
-
. (Posted on 6/26/2021)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 5/29/2021)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 - might recommend Review by Course Participant/Trainee
-
. (Posted on 5/3/2021)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 9/19/2020)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 - will recommend Review by Course Participant/Trainee
-
- go through all exercise, can skip the slides.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
- 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
-
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)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 - might recommend Review by Course Participant/Trainee
-
- there are some error with slides: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
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
-
. (Posted on 3/15/2020)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/28/2020)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 - Will Recommend Review by Course Participant/Trainee
-
Johnson is clear in explaining the difficult VBA concepts. (Posted on 5/28/2019)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 - Might Recommend Review by Course Participant/Trainee
-
More hands on1. 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
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
-
. (Posted on 5/13/2019)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 - Will Recommend Review by Course Participant/Trainee
-
Perhaps can send the material before the class so we can prepare before class (Posted on 3/22/2019)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 - Might Recommend Review by Course Participant/Trainee
-
I believe it will be better if more syntax are introduced! (Posted on 11/25/2018)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 - Will Recommend Review by Course Participant/Trainee
-
Very patient and clear explanation from trainer (Posted on 7/28/2018)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
Write Your Own Review
You May Be Interested In These Courses
WSQ - Statistical Data Analysis with Excel for Beginners
$350.00 (GST-exclusive)
$381.50
(GST-inclusive)
WSQ - Data Analytics and Visualization with Power BI
$800.00 (GST-exclusive)
$872.00
(GST-inclusive)
WSQ – Software Automation with Excel VBA Programming
$750.00 (GST-exclusive)
$817.50
(GST-inclusive)
