EXCEL

LEARN BASIC TO ADVANCE EXCEL

ADVANCE EXCEL COURSE.

      Data Analysis 

•     Cell Reference      
• 
  
•     Custom List       
• 
  
•     Drop-down List 
• 
  
•     Data Validation .
• 
  
•     Sort                   
• 
  
•     Filter               
• 
  
•     Conditional Formatting
• 
  
•     Pivot Table      

  

ADVANCE EXCEL FUNCTIONS

MATH & TRIGONOMETRY FUNCTIONS(Click & Watch)

1.  SumFunction.
2.  Sumif Function.
3.  Sumifs Function.
   
4.  Sumproduct Function.
5.  AverageFunction.
   
6.  Averageif Function.
7.  Averageifs Function.
8.  CountFunction.
9.  Countif Function.
10.  Countifs Function.

LOGICAL FUNCTIONS

1. If  Function.
2. Nested If Function.
3. And Function.
4. OR  Function.

LOOKUP & REFERENCE FUNCTIONS

1. Vlookup Function.
2. Hlookup Function.
3. Match Function.
4. Index Function.

FINANCIAL FUNCTIONS

1. PMT Function.
2. PPMT Function.
3. IPMT  Function.
4. RATE  Function.
5. NPER  Function.
6. PV Function.
7. FV Function.

TEXT FUNCTIONS

1. Concatenate  Function.
2. Upper If Function.
3. Lower Function.
4. Proper  Function.
5. Mid Function.
6. Substitute Function.

DATE FUNCTIONS

1. Date  Function.
2. Days360 If Function.
3. Edate Function.
4. Eomonth  Function.
5. Networkdays Function.