Signup as a Tutor

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

Advance Excel 2010 Training in Chennai

2 Reviews

Arumbakkam, Chennai

Course ID: 5754

Arumbakkam, Chennai

2 Reviews

Date and Time

Not decided yet.

T K Vijayalakshmi

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

About T K Vijayalakshmi

I have good experience in relative manner.
G

Gunjan Gupta

Attended Advance Excel 2010 Training in Chennai

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."

C

Chinky David

Attended Advance Excel 2010 Training in Chennai

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."

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

Reviews (2) See all Reviews

G

Gunjan Gupta

Attended Advance Excel 2010 Training in Chennai

Vijaylakshmi or Viji as I fondly call her has grown to become more as a stress buster and relieveing...

C

Chinky David

Attended Advance Excel 2010 Training in Chennai

Viji is the epitome of perfection to me. I had the opportunity to work with her on advance excel programs...

Discussions

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now
₹ 5,000 Enquire