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 :
Linking of different sheets
Types of filters
How to calculate overtime?
How to use Conditional Formatting?
Determination of Income tax
How to find the package of a new employee through GOAL SEEK function?
How to use the subtotals?
Types of count functions
Difference between simple IF and Nested IF
Proper use of NAME function
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 function?
Locking of particular cells
8 weeks (i.e., two months) with 4 hours/week.
Friday and Saturday.
Total 32 hours.
INFORMATION ABOUT TEACHER :
e-mail address : [email protected]
Mobile# : 0565244961
Qualification : Masters in Computer Science
Experience : 23 years