18 Must-Know Functions in Microsoft Excel

Must-Know Functions 18

• Lecture1.1
  MAX function
• Lecture1.2
  MIN function
• Lecture1.3
  COUNT function
• Lecture1.4
  COUNTIF function
• Lecture1.5
  SUMIF
• Lecture1.6
  IF function
• Lecture1.7
  Nested IF statements
• Lecture1.8
  VLOOKUP function
• Lecture1.9
  HLOOKUP function
• Lecture1.10
  LEFT function
• Lecture1.11
  RIGHT function
• Lecture1.12
  MID function
• Lecture1.13
  LEN function
• Lecture1.14
  CONCATENATE function
• Lecture1.15
  LOWER function
• Lecture1.16
  UPPER function
• Lecture1.17
  PROPER function
• Lecture1.18
  NOW function