Module 01 – ESSENTIALS

  1. Workbook (Pdf)
  2. Introduction To Excel Function
  3. Basic Formulas
  4. Basic Functions
  5. Basic Functions Part 2
  6. Functions In Mac
  7. Keyboard Shortcuts For Functions
  8. Review Quiz (Number of attempts allowed: Unlimited)

Module 03 – FUNCTION LIBRARY

  1. Workbook (Pdf)
  2. SUM
  3. SUMIF
  4. SUMIFS
  5. COUNT, COUNTA, COUNTBLANK
  6. COUNTIF, COUNTIFS
  7. AVERAGE, AVERAGEA
  8. AVERAGEIF, AVERAGEIFS
  9. MIN, MAX, SMALL, LARGE
  10. MINIFS, MAXIFS
  11. RAND, RANDBETWEEN
  12. TODAY, NOW
  13. MONTH, DAY, YEAR, TEXT
  14. CONCAT, TEXTJOIN
  15. LEFT, RIGHT, MID
  16. UPPER, LOWER, PROPER
  17. TRIM, CLEAN
  18. CHAR, CODE, UNICHAR, UNICODE
  19. REPLACE, SUBSTITUTE
  20. FIND, SEARCH
  21. LEN
  22. IF
  23. AND, OR
  24. NOT
  25. MATCH
  26. INDEX
  27. VLOOKUP
  28. HLOOKUP
  29. LOOKUP
  30. CHOOSE
  31. Review Quiz (Number of attempts allowed: Unlimited)

Module 02 – ADVANCED

  1. Workbook (Pdf)
  2. Named Ranges
  3. 3D Cell Reference
  4. Formula Auditing
  5. Review Quiz (Number of attempts allowed: Unlimited)