Introduction
  • Introduction
  • Introduction to Ribbons and Environment of Excel
Basic Features
  • Sorting
  • Filtering Data
  • Merge and Centre
  • Text Wrap
  • Format Painter
Formulas
  • Introduction to Formulas
  • OR Formula or Operator
  • AND Formula or Operator
  • AND Vs OR Formula
  • IF Formula
  • Sum formula
  • Count Formula
  • CountA Formula
  • Average Formula
  • Now Formula
  • Today
Advanced Features
  • Text to Columns
  • Pivot Tables
  • Remove Duplicates
  • Paste Special
  • Data Protection - Allowing Edit for Ranges
  • Data Validation
  • Flash Fill
Advanced Formuals
  • SumIF formula
  • AverageIF Formula
  • Round Formula
  • Len Formula
  • Left Formula
  • Right Formula
  • Proper Formula
  • Lower Formula
  • Upper Formula
  • Vlookup
  • XLookup