Excel 2016 Programming with VBA

Course Code:
MSVBA16
Duration:
3 days
9am to 5pm  
Location:
80 Jurong East Street 21 #04-04
Devan Nair Institute
Singapore 609607
 Course Fees:
S$900 (excl of G.S.T)
2020 Course Dates
13 – 15 Jan 2020
16 – 18 Mar 2020
18 – 20 May 2020
6 – 8 Jul 2020
21 – 23 Sep 2020
16 – 18 Nov 2020
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.

Course Overview

Excel VBA (Visual Basic for Applications) is the name of the programming language of Excel.
VBA lets you automate many aspects of Excel by writing Sub and Function procedures (also
known as macros). A good knowledge of VBA can save time and make you a much more
productive Excel user.

Course Outline

Module 1: Getting Started

Module 2: Working with Procedures and Functions

Module 3: Understanding Objects

Module 4: Using Expressions, Variables, and Intrinsic Functions

Module 5: Controlling Program Execution

Module 6: Working with Forms and Controls

Module 7: Working with the PivotTable Object

Module 8: Debugging Code

Module 9: Handling Errors

Click Here for full course outline

Take the Next Step

It Takes Less Than 5 Min