Advanced Excel by a well experienced and qualified teacher

COURSE TITLE : ADVANCED EXCEL

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


DURATION:
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