Advance Excel (Level Corporate)

(Training By Author Purvi Shah)

  • Cell Formatting
  • Format Table
  • Fill Option
  • Custom Short (Custom List)
  • Hyperlink
  • Print Area
  • Name Manager
  • Len Function
  • Left Right Mid Function
  • Unique Access Id Generation
  • Transpose
  • Sumif
  • Sum Ifs
  • One Way Data Table
  • Two Way Data Table
  • Fill Across Worksheets
  • Scroll Table Data
  • If/ If And or/ If Min/ if Max
  • Chart Preparation
  • Age Calculation From Birth Date
  • Vlookup Function
  • Using Vlookup another Sheet
  • Hlookup Function
  • Match & Index Function
  • Choose Function
  • Pivot Table
  • Countif Function
  • Networkdays
  • Weekday
  • Consolidate
  • Rank Given
  • DAVERAGE
  • DGET
  • DSUM
  • Solver Function
  • PMT Function
  • FV Function
  • Rate
  • Received