VBA

Description : Empowers you with the ultimate Excel Working Skills required to transform you into an "Excel"lent Guru. Customized for Executives, Administrators, Co-ordinators, Accountants and all who want to make their work done effectively & smarlty.

Prerequisite : Basic Idea on MS-Office.

Duration : 30 sessions.

Advanced Excel Programming

Introduction
Pivot Tables
Macros
Selections with Macros

Macro Programming

Introduction(VBA)

Dialogs & Lang Basics
Loops & Conditions
VBA Object Model
Class Modules
Working with Collections
Event Handling
Functions

 

 



Debugging & error handling

Forms
Using ADO
XML in Excel
Miscellaneous