excel

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?
• Split cell to words, via a formula, in Excel
• Subtotal function (used in tables) what is the function num?
• VLOOKUP