Excel

Summary

Desktop spreadsheet editor from Microsoft

Jots

Used at all layers of Data Analysis for small data management (small in computer terms, that is)

Core Excel Functions

• Starting from and expanded somewhat on what Data Analyst Roadmap describes
• SUM
  • add a collection of values, including literals, cell references, and / or ranges
  • SUM function - Microsoft Support
• MIN / MAX
  • MIN function - Microsoft Support
  • MAX function - Microsoft Support
  • provides insight into dataset range, identifies possible outliers, and helps understand data variability
• AVERAGE
  • returns the mean of its arguments
  • AVERAGE function - Microsoft Support
• COUNT
  • return the number of cells in argument list with values
  • COUNT function - Microsoft Support
• CONCAT
  • combines text from multiple ranges and / or strings
  • CONCAT function - Microsoft Support
• TRIM
  • Clean up whitespace in text by stripping spaces off the edges and ensuring there is only a single space between words in the text.
  • TRIM function - Microsoft Support
• UPPER / LOWER / PROPER
  • UPPER function - Microsoft Support
  • LOWER function - Microsoft Support
  • PROPER function - Microsoft Support
• REPLACE / SUBSTITUTE
  • REPLACE, REPLACEB functions - Microsoft Support
  • SUBSTITUTE function - Microsoft Support
• VLOOKUP / HLOOKUP / XLOOKUP
  • XLOOKUP is recommended over both HLOOKUP and VLOOKUP
  • Use the XLOOKUP function to find things in a table or range by row.
  • XLOOKUP function - Microsoft Support
  • Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.
  • HLOOKUP function - Microsoft Support
  • Use VLOOKUP when you need to find things in a table or a range by row.
  • VLOOKUP function - Microsoft Support
• IF
• DAYS
  • Returns the number of days between two dates.
  • DAYS function - Microsoft Support
• DATEDIF
  • Calculates the number of days, months, or years between two dates. (DATEDIF is a legacy function for ancient Lotus spreadsheets, and sometimes gets it wrong.)
  • DATEDIF function - Microsoft Support

Related

Excel help & learning

Added to vault 2024-05-06. Updated on 2024-05-06