Resources
Excel Reference Guides & Cheat Sheets
Deep-dive reference pages that back up the function library — grab the pattern or fix you need, then get back to your spreadsheet.
Troubleshooting
Common Excel Errors and How to Fix Them
Every Excel error code in one place — #REF!, #N/A, #VALUE!, #SPILL! and more. What each one means, why it happens, and exactly how to fix it.
Open guideReferenceExcel Criteria and Wildcards
The criteria patterns shared by every conditional function — SUMIF, COUNTIF, AVERAGEIFS and more — with a copyable example for each.
Open guideFormattingExcel Custom Number Formats Guide
Every custom number format code, what it does, and a working example you can paste into a cell — for TEXT() and Format Cells → Custom.
Open guide