About this Course

The 3-day VBA Excel course in Singapore guides participants in using some of Excel's commonly used formulas. Participant also learns how to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of database development.

In this course, participant will apply the Visual Basic for Applications (VBA Excel ) programming language to simplify many of the tasks in Excel 2007/2010/2013 environment.

Participants will be proficient in using VBA to create macros for automating repetitive tasks in Excel 2007/2010/2013

Course Outline:

1. Introduction to VBA in Microsoft Excel 2010/2013

2. The Macro Recorder in Excel 2010/2013

3. Starting, Triggering a Macro in Excel 2010/2013

4. VBA Variables

5. Working with Procedures and Functions

6. Conditions, Branches and Looping Control

7. Debugging in VBA Excel

8. Error Handling

9. Excel Object Model

10. Userforms and Controls

11. VBA Macros Security and Protection in Excel

Prerequisites:

Prior knowledge for Excel 2007/2010/2013 and especially suitable for students who had attended Excel 2007/2010/2013 Intermediate and Advance course.

Certificate Of Attendance:

Certificate Of Attendance will be awarded to trainees completing the course achieving minimum 75% attendance.

Training Duration:

Full-time: 3 Weekday / 3 Sats                Time : 9.30am - 5.30pm 

Part-time: 6 Sessions                            Time : 7.00pm - 10.00pm (twice a week)

Rate this course:

Log in to submit

Comments