Syllabus of excel

Introduction  to excel

Definition of data,database, worksheet, workbook etc

Definition of different tabs and menus used in excel

Basic function or formulas used in excel like addition,subtraction, average,multiplication  etc

Working with formulas like date,time,sumit,sumifs,counting,countifs,averageif etc

Working with formulas like  vlookup,lookup, hlookup etc

Manipulating and working with cells and worksheets

Working with formulas  like countifs,counta,,countblank ,rank etc

Working with  scenarios, goalseek, datavalidation,subtotal,pivottable,pivotchart, etc

Working with trace precedents,trace dependents,trace error etc.

Working with results sheet,profit and loss,employee payroll system etc

Working with macros,macros using vb applications 

Working excel with windows  vb applications 

Working with basic tabs which are in word  also in excel

Note.if any part is left it will be covered in class not a single part is missed in excel.