Introduction
  • Course Introduction
Mathematical Formulas
  • Average Formula
  • Large Formula
  • Max Formula
  • Minimum Formula
  • Rand Between Formula
  • Rank Formula
  • Round Formula
  • Sub Total Formula
  • Sum Formula
  • Sum Product Formula
Look Up Formulas
  • Hlook Up Formula
  • Index Formula
  • Match Formula
  • Vlook Up Formula
  • Combination of Both Index & Match
Logical Formulas
  • AND Formula
  • IF Formula
  • OR Formula
  • CountIF & CountIFS
  • SumIF & SumIFS
Text Formulas
  • Complete Text Formulas
Date & Time Formulas
  • Complete DATE & TIME Formulas