MAIN TASK :
To provide students an understanding of practical approaches related to business activities.
COURSE OBJECTIVES :
Learn fundamentals of worksheet
Complete command on advanced features
Implementation of daily routine problems
Graphical representation of data
COURSE OUTLINE :
How to find the ranks for the data?
Linking of different sheets
Types of FILTERS
How to calculate overtime?
How to use CONDITIONAL FORMATTING?
Determination of Income tax
How to use GOAL SEEK function?
How to use the SUBTOTALS function?
Types of COUNT functions
Difference between IF and Nested IF
How to relate INDEX & MATCH functions?
The proper implementation of DATABASE functions
How to use PIVOT TABLE ?
How to implement different types of number formats?
Application of DATA VALIDATION
Different types of LOOKUP functions
Difference between IF WITH AND & IF WITH OR functions
How to use SUMIF & SUMIFS functions?
How to convert TEXT to COLUMN?
How to trim the data?
DURATION:
8 weeks (i.e., two months) with 4 hours per week.
Friday and Saturday.
Total 32 hours.
INFORMATION ABOUT TEACHER :
e-mail address : [email protected]
Mobile# : 0565244961
Qualification : Masters in Computer Science
Experience : 24 years
NOTE: Offline and Online options both are available