Lookups
Full content coming soon.
Aggregation
Full content coming soon.
Text functions
Full content coming soon.
Dates and time
Full content coming soon.
Excel Tools
Free Excel and spreadsheet tools — formula helpers, converters, and data cleaners.
Open Excel ToolsFrequently asked questions
More Excel Tools guides
What Is Microsoft Excel?
A friendly introduction to Microsoft Excel: what the app does, where it shines, and why it's still the world's default spreadsheet.
Read articleExcel vs Google Sheets
Excel and Google Sheets do 90% of the same things — but the last 10% matters. Here's how they compare on formulas, collaboration, performance, and price.
Read articleThe Most Useful Excel Functions
Learn these ten Excel functions and you'll handle 90% of everyday spreadsheet work. Examples, syntax, and when to reach for each one.
Read articleHow Excel Formulas Work
A plain-English guide to how Excel actually evaluates a formula — references, operators, functions, and the rules behind = signs and $ pinning.
Read articleCommon Excel Errors and How to Fix Them
Decode Excel's six most common formula errors and learn the quickest way to fix each one — without rewriting your whole spreadsheet.
Read articleExcel for Beginners
Start here if Excel feels intimidating: the core concepts and habits that unlock everything else.
Read articleHow to Use VLOOKUP
The classic lookup function, demystified — with the gotchas that trip up most people.
Read articleHow to Use XLOOKUP
The newer, smarter lookup — and why it's worth switching from VLOOKUP whenever you can.
Read articleExcel Productivity Tips
The shortcuts and habits that separate slow Excel users from fast ones.
Read article