If you've been struggling to remember formulas, shortcuts, or wondering why your VLOOKUP keeps breaking, this one's for you.
I put together a complete Excel Cheat Sheet covering everything from beginner basics to the functions professionals use every day. It's clean, color-coded, and organized so you can actually find what you need when you need it.
The file is attached below. Download it, save it, and keep it open while you work.
The cheat sheet is broken into 7 tabs, each focused on a different skill area:
⌨ Keyboard Shortcuts Over 50 shortcuts organized by category: Navigation, Editing, Formatting, Selection, and more. If you're still using your mouse for everything, this tab alone will change how fast you work.
🔍 Lookup and Reference VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH, 2-way lookups, and the dynamic array functions FILTER, SORT, UNIQUE, and SORTBY. No more guessing which lookup to use or why your formula is returning the wrong column.
🔤 Text Functions LEFT, RIGHT, MID, TEXTBEFORE, TEXTAFTER, TRIM, PROPER, TEXTJOIN, SUBSTITUTE, and more. Perfect for cleaning messy data or reformatting names, IDs, and addresses.
📅 Date and Time TODAY, DATE, DATEDIF, NETWORKDAYS, WORKDAY, EOMONTH, and all the time extraction functions. Healthcare and HR folks, this tab was made for you.
🔢 Math and Statistics SUMIF, SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS, RANK, PERCENTILE, CORREL, STDEV, and all your core rounding functions. Conditional aggregation made simple.
✅ Logical and Error Handling IF, IFS, SWITCH, AND, OR, IFERROR, IFNA, and all the IS functions. Plus a section of common formula combinations you'll actually use in real work.
💡 Tips and Tricks PivotTable shortcuts, Flash Fill, Data Validation, Goal Seek, Named Ranges, Freeze Panes, Sparklines, and a full Number Format reference. The stuff that separates competent Excel users from power users.