Formulas
Plain-English formula guides tied to real tasks. Each one shows the formula, sample data, the expected result, and at least one common mistake so it does not break when you copy it.
LookupsFILTER & QUERYDatesText cleanupIF logicError handlingSummaries
Formula
Google Sheets Formulas for Small Business: Plain-English Starter Guide
Learn the Google Sheets formulas small businesses actually need first: SUM, COUNTIF, IF, FILTER, VLOOKUP/XLOOKUP patterns, date formulas, and error-safe checks.
7 min
Comparison
VLOOKUP vs XLOOKUP in Google Sheets: Which to Use
A plain-English comparison of VLOOKUP and XLOOKUP in Google Sheets, with sample data, copyable formulas, the expected result, and the most common mistake that breaks each one.
4 min