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.
For Faculty Profile Click Here
For registrations Click Here
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.
