One Day Basic Excel Training(2007 & 10) in Banashankari

Calsses are for the Freshers conducted for 12 hours comprising of two saturdays.

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


ON LINE PRACTICE SESSIONS

Who should attend

This course is for Final year B.com/BBM and Final year MBA/MFA students

Pre-requisites

Basic computer skills

What you need to bring

A laptop will be good or please inform earlier so that we can arrnage one.

Key Takeaways

More informed about working with Excel, a first step towards exploring analytical capability through Excel. A must for all commerce and Finance Graduates.