Visual Basic for Application (VBA) for Excel 2003/2007/2010
Course Objective:
The 3-day course 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) programming language to simplify many
of the tasks in Excel 2007 environment.
Participants will be proficient in using VBA
to create macros for automating repetitive
tasks in Excel 2003/2007/2010
Prerequisites:
Prior knowledge for Excel 2003/2007/2010 and especially
suitable for students who had attended Excel
2003/2007/2010 Intermediate and Advance course.
Certificate Of Attendance:
Certificate Of Attendance will be awarded to
students completing the course.
Training Duration:
Full-time: 3 Days Time : 9.30am - 5.30pm
Part-time: 6 Sessions Time : 7pm - 10.00pm (twice a week)
Course Outline:
1. Getting Started
2. Working with Procedures and Functions
3. Understanding Objects
4. Using Expressions, Variables, and Intrinsic
Functions
5. Controlling Program Execution
6. Working with Forms and Controls
7. Working with the PivotTable Object
8. Debugging Code
9. Handling Errors