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.