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