Microsoft Excel VBA (Visual Basic for Applications)

Course Objective:

UTAP Funding
Funding available for this course

Participant will get in-depth knowledge on

Target Audience:

For Advanced Microsoft Excel user who wish to automate repetitive tasks or simplify more complex tasks using Excel Macros and Visual Basic for Applications (VBA) programming.

Training Methodologies

Trainer

Training will be conducted by our experienced local trainer who has more than 10 years of experience with relevant certification.
 

Pre-Requisites:

Student must have good Excel Skills and understand key concepts of spreadsheets or equivalent. However, it is not necessary to have a programming knowledge.

 

Duration

3 Days

Time

9am to 5pm

Course Dates

30 - 01 Sep 2021
27 - 29 Sep 2021
18 - 20 Oct 2021
24 - 26 Nov 2021
13 - 15 Dec 2021

Course Fee

S$395.00

(Group Discount of 10% for 3 or more participants)

Training Venue

10 Anson Road #31-12
International Plaza
Singapore 079903

Available Funding

SDF Grant, UTAP Funding & SkillsFuture Credit

VTeach Pte. Ltd.

Tel: +65 6673 4479
admin@vteach.com.sg
www.vteach.com.sg

Course Content

Lesson 1: Getting Started

Lesson 2: Working with Procedures and Functions

Lesson 3: Understanding Objects

Lesson 4: Using Expressions, Variables, and Intrinsic Functions

Lesson 5: Controlling Program Execution

Lesson 6: Working with Forms and Controls

Lesson 7: Working with the PivotTable Object

Lesson 8: Debugging Code

Lesson 9: Handling Errors