Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Share

course photo

Advance Excel 2010 Training in Chennai

Arumbakkam, Chennai

5,000

2 Reviews
0 Interested

About the Course


This course is primariy aimed at professionals who are using Excel on their day to day work. There has been a lot of improvement in Excel 2010 compared to 2003. To make use of these new features and to understand the capability of Excel 2010 one should attend this course to get an edge over others.

Students who attend this course are eligible to get a discount of 10% on MOS Certification Exam 77-882 & 77-888.

Topics Covered

Recap of Excel Basics
VLookup, HLookup, IF & Nested IF
Advance Formulas - SUMIFS, COUNTIFS, AVERAGEIFS, IFERROR
Custom Conditional Formatting with Formula
Custom Validation with Formula
What-If Analysis (Goal Seek, Solver, Scenario Manager, Data Table)
Object Linking and Embedding (OLE)
Pivot Table & Pivot Charts
Data Consolidation
Advance Chart concepts
Introduction to Macros
Creating and Managing Templates

Who should attend

Excel users who would like to enhace their capability of Excel usage, Professionals who aim to get an edge over others, Users who look to exploit Excel to their advantage

Pre-requisites

Basic to Intermediate Knowledge in Excel

What you need to bring

Laptop with Office 2010 Installed

Key Takeaways

Should be able to use advance features of Excel to match your requirements, better understanding of Excel capabilities, Start automating repeated tasks done in Excel by creating simple Excel Macros using VBA
Content
Reviews

Recommendations & reviews from previous Customers:

Gunjan Gupta

"Vijaylakshmi or Viji as I fondly call her has grown to become more as a stress buster and relieveing friend for me rather than only a business partner. She is one of the few most skilled, professional and highly organized trainers that I have come accross in my entire career in organizing trainings. She is typically honest and very flexible yet thoroughly professional human being. My work is reduced to half when she is doing any training for me, coz I can totally depend on her for manuals, practice sheets and all that extra effort required {now you know I am so selfish :-):) }. Its a pleasure to know you.""

attended Advance Excel 2010 Training in Chennai


Chinky David

"Viji is the epitome of perfection to me. I had the opportunity to work with her on advance excel programs and other technical training programs for my clients. I must warn you that if the audience gets use to Viji, they will not settle for any other trainer in the subsequent sessions. Her knowledge of the subject, unique style and methodology has remained unmatched till date. She is sincere and has always given a lot of importance to audience feedback. People who have attended her training will always remember her as the trainer who added value to their skills. Even the most senior audiences would admit that they have learnt something new through her programs. I can guarantee that she would be an asset to any company that she is a part of.""

attended Advance Excel 2010 Training in Chennai


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Showing 1 to 1 of 1
U

Jyothi Raj 04/11/2013

I don't have laptop. Will that be a problem? Also which course helps me to create and run macros?

0 0

Answer

You can add upto 6 Images


Recommendations & reviews from previous Customers:

Gunjan Gupta

"Vijaylakshmi or Viji as I fondly call her has grown to become more as a stress buster and relieveing friend for me rather than only a business partner. She is one of the few most skilled, professional and highly organized trainers that I have come accross in my entire career in organizing trainings. She is typically honest and very flexible yet thoroughly professional human being. My work is reduced to half when she is doing any training for me, coz I can totally depend on her for manuals, practice sheets and all that extra effort required {now you know I am so selfish :-):) }. Its a pleasure to know you.""

attended Advance Excel 2010 Training in Chennai


Chinky David

"Viji is the epitome of perfection to me. I had the opportunity to work with her on advance excel programs and other technical training programs for my clients. I must warn you that if the audience gets use to Viji, they will not settle for any other trainer in the subsequent sessions. Her knowledge of the subject, unique style and methodology has remained unmatched till date. She is sincere and has always given a lot of importance to audience feedback. People who have attended her training will always remember her as the trainer who added value to their skills. Even the most senior audiences would admit that they have learnt something new through her programs. I can guarantee that she would be an asset to any company that she is a part of.""

attended Advance Excel 2010 Training in Chennai


cash back100% Money Back Guarentee

About the Trainer

T K Vijayalakshmi

Master of Computer Applications from The Chennai University & Post Graduate in Financial Management from IMT Ghaziabad


I have good experience in relative manner.

Course Id: 5754