Blog
Spreadsheet guides you can copy
Real examples for Google Sheets and Excel, every formula ready to paste, and a free example file with every post.
QUERY: SQL inside Google Sheets
The QUERY function runs SQL-style questions on your data in Google Sheets. 6 examples to copy: select, where, order by, group by, dates and labels.
6 min read
GOOGLEFINANCE: track stocks for free
GOOGLEFINANCE pulls stock prices, P/E, 52-week ranges, price history and exchange rates into Google Sheets for free. 6 examples to copy.
7 min read
Google Sheets and Excel shortcuts (cheat sheet)
25 Google Sheets and Excel shortcuts side by side, Windows and Mac, checked against the official help pages. Free printable cheat sheet.
7 min read
Every spreadsheet error and how to fix it
What #N/A, #REF!, #VALUE!, #DIV/0!, #NAME?, #SPILL!, #NUM! and #ERROR! mean in Google Sheets and Excel, with a tiny example and the fix for each.
7 min read
PMT: work out any loan payment
PMT works out the monthly payment on any loan. 6 real examples with formulas to copy: mortgage, car loan, total interest, extra payments and savings.
6 min read
XLOOKUP vs VLOOKUP vs INDEX/MATCH: which one to use
VLOOKUP, XLOOKUP or INDEX/MATCH? When to use each, why VLOOKUP breaks, and the same lookup written all three ways, ready to copy.
4 min read
The FILTER function in Google Sheets: 7 examples
FILTER pulls only the rows you need into a live list. 7 examples with formulas to copy, from one condition to AND, OR and quick totals.
4 min read
SUMIFS explained with 5 real examples
SUMIFS adds up only the rows that match your conditions. 5 real examples with formulas to copy: sales, a bakery, coffee, travel and screen time.
5 min read