Course Content

Advance Excel ( 2 Months )

  • Introduction of basic excel
  • Excel Function
  • Date and time function
  • Text function
  • Financial function
  • Create custom number formats
  • Statistical function
  • Lookup and reference
  • Charts
  • Conditional formatting
  • Pivo tools
  • SUM functions
  • Countifs
  • Dependent list
  • Searchable drop list
  • Offset link with VLOOKUP
  • Page link with VLOOKUP
  • Page layout tab
  • Macro
  • Data validation
  • Advance filters
  • Connection creation
  • Automatic refreshment
  • Export and import
  • INDEX , SMALL & MATCH
  • RAND & RANDBETWEEN