Automation using Visual Basic for Applications
About This Course
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 to develop simple software automation using Excel VBA programming.
What You'll Learn
In this course, the learners will learn how to automate complex tasks and get more meaningful insights from data in Excel using Visual Basic for Applications (VBA) code.
Entry Requirements
The skills and knowledge for this course, which the learner is assumed to possess, are as follows:
• Applicants who have attained Level 5 and above for the Workplace Literacy and Numeracy (WPLN) assessment in these 5 components (Reading, Listening, Speaking, Writing and Numeracy).
• 1 year of working experience
• At least 21 years of age
Learners are expected to:
• possess basic personal computer skills
• operate a personal computer independently