Excel has 500+ functions. You need about 20.
Lookup & Reference
VLOOKUP: Find a value in a table. INDEX/MATCH: Better VLOOKUP (handles any direction). XLOOKUP: The modern replacement (Excel 365+).
Math
SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF, SUMIF, ROUND. These 8 cover 80% of calculations.
Text
LEFT, RIGHT, MID: Extract parts of text. CONCATENATE (or &): Join text. TRIM: Remove extra spaces. UPPER/LOWER: Change case.
Logic
IF: Basic conditions. AND/OR: Multiple conditions. IFERROR: Handle errors gracefully.
Working with CSV data? Our CSV viewer lets you browse data without Excel, and CSV to Excel converts for editing.