VBA for EXCEL

VBA, or Visual Basic for Applications, a simple programming language that can be used within Excel 2007 to develop macros and complex programs. They help in doing the same things which we do in MS EXCEL but at a much faster rate. They help in automating the routine tasks across multiple EXCEL Files

Topics Covered

VBA with EXCEL

Introduction to Macros

Understanding VBA Editor

Constants & Variables in VBA

Class & Objects in VBA

Working with Arrays

Working with Loops

UI Forms & Actions in VBA

Creation of Dynamic Application

 Functions & Subroutines in VBA User Defined Functions

Introduction to Databases

Rows, Columns & Cells using Macros

 Ranges using Macros Events using Macros Pivot Tables using Macros
Time using Macros Charts using Macros Case Study with Questions

EXCEL with VBA Training COURSE

  • Classroom/Online EXCEL Classes(WebEX).
  • After Classes SUPPORT for 1 YEAR.
  • Hands On Coaching- Participants may get their laptops for the training to perform along with the trainer. Training conducted by IIM Alumnus
  • Training driven through appropriate examples across different Industries.
  • Support via Email/Phone/Chat/One on One session (with prior appointment).
  • Complete Recording of the 20 Hours Training in Downloadable Format.
  • Attending training again for NO COST.
  • Training Completion Certificate for all participants.
  • Online Trainings will be Live through WebEX - Downloadable Format.

Batch Start Dates

Batch Start Date Batch End Date Timings Fee

1-Mar-2012

(Weekday)

2-Mar-2012

(Weekday)

 8AM-5PM Rs. 4,000

 

 

 

 

10% discount for a group of 3 or more

15% discount for a group of 5 or more

P.A.C.E - EXCEL with VBA Recorded DVD's:

P.A.C.E - Recorded Training of EXCEL with VBA available for Rs. 1500 (Price includes support for 1 Hour). Fee Adjustment for Participants willing upgrade Classroom/Online Training.

Who should attend EXCEL with VBA Training

  • Investors.
  • Credit analysts.
  • Fund managers.
  • Equity analysts.
  • Equity Traders.
  • Equity sales.
  • Investment bankers.
  • Equity Researchers.
  • Chartered Accountants.
  • Treasures.
  • Executive Level managers.
  • Graduates from any Stream.
  • Students.