EXCEL SHORTCUTS AND TIME SAVERS
  • Excel shortcuts and time savers – Part 1
  • Excel shortcuts and time savers - Part 2
  • Formula back tracing and shortcuts
VLOOKUP AND HLOOKUP FUNCTIONS
  • Vlookup and Hlookup formulas
  • Nested, double Vlookup
  • Nested Vlookup and Hlookup
  • Vlookup with multiple criteria
  • HOMEWORK: Vlookup, Hlookup
INDEX AND MATCH FUNCTIONS
  • Index-Match and Vlookup-Match
  • Complex Index-Match exercise
  • BONUS: Extra Functions of Index-Match
  • HOMEWORK: Index Match
IF AND NESTED IF FUNCTIONS
  • IF and nested IF functions
  • IF statement with OR and AND
  • IF with LIST of criteria
  • IF in complex real daily tasks
  • HOMEWORK: IF, nested IF, OR and AND
COUNT AND COUNTIF FUNCTIONS
  • Count and CountIF functions - part 1
  • Count and CountIF functions - part 2
  • HOMEWORK: CountIF and SumIF
REPLACE AND SUBSTITUTE FUNCTIONS
  • Value, Replace and Substitute functions
  • HOMEWORK: Replace and Substitute
ERROR HANDLING IN FORMULAS
  • Error handling (ISerror, IFerror)
  • HOMEWORK: Error handling
ALL ABOUT TEXT FORMULAS
  • Text formulas - (Len, Left, Right, Mid, Trim, Clean, T, Find, Search)
  • Text formulas - (Concatenations, Upper, Lower, Proper)
  • ADVANCED Text formulas - complex exercises
  • HOMEWORK: Text formulas
DATE FUNCTIONS
  • Most important Date functions
  • Complex Date functions
  • HOMEWORK: Date functions