Signup as a Tutor

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

Advance Excel

No Reviews Yet

Sangam Vihar, Delhi

Course ID: 13064

Sangam Vihar, Delhi

Students Interested 0 (Seats Left 0)

₹ 2,500

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

Students Interested 0 (Seats Left 0)

₹ 2,500

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 2,500 Enquire