excel{.chapter}

December 22, 2025 ยท View on GitHub

content

  • Avoid #VALUE! with IFERROR
  • Basic examples of using SumIf in Excel
  • Converting survey responses to numbers in excel
  • Extract Year/Month (for grouping/reporting)
  • In Excel, how do you check IndexOf (or Contains) of a string?
  • LAMBDA and LET in Excel
  • Split cell to words, via a formula, in Excel
  • Subtotal function (used in tables) what is the function num?
  • VLOOKUP