Basic & Advanced EXCEL 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 Macros.

Topics Covered

Basic and Advanced EXCEL

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

  • 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 Training in Downloadable Format.
  • Attending training again for NO COST.
  • Training Completion Certificate for all participants.

Batch Start Dates

Batch Start Date Batch End Date Timings Fee
2-June-2012 (Weekend) 3-June-2012 (Weekend) 9AM-5PM Rs. 3500

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 available for Rs. 1,750. Fee Adjustment for Participants willing upgrade Classroom Training.

SUPPORT FOR RECORDED DVD'S:

  • Support via Email/Phone/Chat/One on One session for 1 hour (with prior appointment).
  • Updated recordings of the training in downloadable format for 1 year at no extra cost.
  • 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.