Excel quietly runs the world's offices, and 15 core skills separate the people who fight spreadsheets from the people who command them. No math degree needed — just these formulas and tricks.
Formulas That Do the Heavy Lifting
Start with SUM, AVERAGE, COUNT, MIN, MAX — the five you'll use daily. Then learn IF for logic ("if sales exceed target, mark bonus") and VLOOKUP or XLOOKUP to pull data from another table automatically. SUMIF and COUNTIF total only the rows that match a condition. These seven formulas handle 90% of real office work.
Pivot Tables: Instant Reports
Pivot tables summarize thousands of rows in seconds — drag "Region" to rows and "Sales" to values, and you have a report that took colleagues hours. No formulas required. Right-click any value to group dates by month, and use slicers for clickable filters that make your reports look impressively interactive.
Shortcuts and Formatting Tricks
Memorize Ctrl+Shift+L for filters, Ctrl+T for tables, Alt+= for auto-sum, and Ctrl+; for today's date. Press F4 to repeat your last action — formatting fifty rows becomes fifty key presses. Use conditional formatting to auto-highlight overdue dates or top scores, and freeze panes so headers stay visible while you scroll.
Stop Making These Mistakes
Never type the same data twice — that's what formulas are for. Keep one value per cell (no "John, Mary" in a single cell) or your filters will lie to you. And save versions before big changes; "final_FINAL_v3.xlsx" is a joke because everyone has lived it.
Practice one formula per day on real data for two weeks. By the end, colleagues will be asking you for help — and that's when Excel starts paying for itself.