Basic & Advanced EXCEL with VBA Training

EXCEL 2007 Tutorial Objective - Aid participants to perform Basic as well as Advanced EXCEL Formulas & Features like Sorting, Conditional Formatting, Pivot Tables, Charts, What-If Analysis, Look- Up Functions & Basics of VBA.

Topics Covered

Basic and Advanced EXCEL with VBA

Basics of MS EXCEL 2007

Basic EXCEL Formulas

Logical, Arthematic Functions

Advanced Filters and Pivot Tables

Charting in EXCEL

Formatting and Validations

Financial, Lookup Functions

Goal Seek

What-if Analysis Array Functions

Data Table

Scenario Manager

Importing & Exporting Data Introduction to Macro Assignment to Macro
Basic Editing of Macro Basics of VBA Debugging Tools Sorting Data in Variables Case Study with Questions

MS EXCEL Training COURSE Details

  • 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.
  • 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
15-Mar-2012 (Weekday) 16-Mar-2012 (Weekday) 8AM-5PM Rs. 3000

10% discount for a group of 3 or more

15% discount for a group of 5 or more

P.A.C.E - Basic & Advanced EXCEL Recorded DVD's:

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

Who should attend Basic & Advanced EXCEL 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.