Advance Excel (FREE)

Duration: 15-20 Days

 

New Advance Excel Topics are : 
 
Arrays Functions
Auto fill And Custom List
Index Function
Rank Function
Insert Watermark In Excel 2010
Concatenate
Formula Copy Shortcut
Nested If
Form Creation Using Developer Tab
Auto Sum With Row Reference And Column Reference
Condition Formatting With Mod Function
Information Function
Match And Index Function
Proper, Upper And Lower Function
Replace And Substitute Function.
Insert And Edit The Data In Multiple Worksheets.
Quickly Transpose Data Using Shortcut. 
Turn Off And On Worksheet Tabs And Scroll Bars. 
Convert Function. 
Count blank And Count Function
Large And Small.
Left And Right Function.
Macro In Excel
Match Function
Mod Function
More Text.
Sum if, Count if And Average If Function.
Sumifs, Countifs, Averageifs Function
Text Function.
Transpose Function.
Vlookup
Weekday

 

 

Participation Certificate

Participation Certificate
Participation Certificate