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.
Skills Acquired
Learning Modules
Learning Unit 1: Macros for Spreadsheet Automation
- Understanding Macros
- Modifying Existing Macros
- Visual Basic Editor Environment
- Learning about Objects & Property
- Variables, Data Type & Constants
- Procedures, Functions and Constructs
- Error Handling
- Using Custom Functions
- Introducing UserForms
- Excel Event
Who is this course for
This training is relevant to learners in Finance, Sales department and all who need to automate task to increase productivity.
Academic prerequisites
- 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 Fees
| Fees | Company / Self Sponsored |
|---|---|
| Full Fee | $650 |
| GST | $58.50 |
| Nett Fee Payable (incl. GST) | $708.50 |
Visual Basic Application for Excel 2016
Course Highlight
Course Duration
15 HRS
Training Time
9am-5.30pm
Mode of Training
Classroom
Course Reference Number
Business Communication via Email & Letters
7 HRS Course
Learn More
Perform Image Editing Functions (Adobe Photoshop)
24 HRS Course
Learn More
Data Visualisation with Excel Dashboards
8 HRS Course
Learn More
Reporting with Pivot Table and Pivot Chart
8 HRS Course
Learn More