VBA     training  by   International   Institute of  sas training  and  Research

 Syllabus

1 Navigating into The Visual Basic Editor

 2 Features and uses of VBA IDE

3 VBA Programming - Variable, Data types and constants

 4 VBA Programming - Functions and Subroutines

 5 VBA Programming - Handling Built In function and statements

 6 VBA Programming- Control structure

 7 VBA Error Handling

 8 Understanding Excel object model

9 Excel event and Properties

 10 Creating Custom Menus and toolbars

 11 Excel Application object

 12 Understanding Worksheet Object

13 working with Workbook object

 14 Using Range object

15 Handling Pivot tables