New Advance Excel

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