"Advance Excel" is no longer available

No Reviews Yet

Sangam Vihar, Delhi

Course ID: 13064

Sangam Vihar, Delhi

No Reviews Yet

Date and Time

Not decided yet.

Chandan Kumar

B.Sc(Math)

About Chandan Kumar

+5 Years industrial experience in core MIS.
No reviews currently

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.

Topics Covered

Auto Fill Series-Numeric, Alphanumeric
• Comments
• Paste and Paste Linking
• Transpose
• Basic Excel functions and introduction to Formulae
• Relative and Absolute cell referencing
• Mathematical functions-SUM,MAX,MIN,AVERAGE,COUNT ,COUNTBLANK
• Subtotals
• Auto Filters
• Creating charts
• Need to represent data graphically
• Position of a chart
• Types of charts
• Guidelines on selecting a chart

• Titles, Gridlines, Legends
• Data labels and Data table
• Representing data graphically
• Choosing different types of charts
• Creating Dynamic Ranges using charts
• Pivot Tables-introduction, concepts
• Source data for a pivot table-internal, external, internal or external
Pivot table
• Modifying a pivot table Pivot charts

Who should attend

For them who are the basic user of MS Excel and would like to enhance their skill and knowledge by pushing excel beyond their expectation.

Pre-requisites

Basic understanding of Microsoft Excel.

What you need to bring

Notebook / scribbling pad

Key Takeaways

Soft Copies of the hands in exercise and reference manual

Reviews

No reviews currently

Gallery (1)

Discussions

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more