Visual Basic Application for Excel 2016
Course Overview
This course sets out the skills and knowledge to make use of Visual Basic functions to convert
tedious manual tasks into one click of a button, and to use Userforms for user interactive interfaces.
Who Should Attend
This training is relevant to learners in Finance, Sales department and all who need to automate task
to increase productivity.
Course Duration
2 Days
Total Training Duration (Hour)
15
Course Outline
Learning Unit 1: Macros for Spreadsheet
- Automation
- Understanding Macros
- Modifying Existing Macros
Learning Unit 2: VBA Basics
- Visual Basic Editor Environment
- Learning about Objects & Property
Learning Unit 3: VBA Programming Novice
- Variables, Data Type & Constants
- Procedures, Functions and Constructs
Learning Unit 4: VBA Programming Senior
- Error Handling
- Using Custom Functions
- Learning Unit 5: VBA Programming Graduate
- Introducing UserForms
- Excel Event
Pre-requisites
- Learners must be able to read, write, speak and listen to English at secondary school level
- Learners to have minimum GCE ‘O’ level or ITE certificate education
- Learner should have at least 1 year’s working experience in any industry
- Learners will need to have a good knowledge of Microsoft Excel
Course Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $680.00 | $741.20 |
Please note that prices are subjected to change.
