• Logical Functions
    • IF, AND, OR, NOT: Using logical functions for decision making.
    • Nested IF Statements: Combining multiple IF statements.
  • Lookup and Reference Functions
    • VLOOKUP, HLOOKUP: Vertical and horizontal lookups.
    • INDEX and MATCH: More flexible lookups.
    • OFFSET and INDIRECT: Dynamic range selection.
  • Text Functions
    • TEXT, LEFT, RIGHT, MID: Manipulating text strings.
    • LEN, FIND, SEARCH, SUBSTITUTE: Advanced text operations.
  • Date and Time Functions
    • DATE, TIME, DATEVALUE, TIMEVALUE: Working with dates and times.
    • NETWORKDAYS, WORKDAY, EDATE, EOMONTH: Calculating working days and date differences.