MS-Excel Programming

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.

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