Spreadsheets to databases
An introduction to databases for people who are used to spreadsheets.
How tables differ between spreadsheets and databases
A look at the different mental models for spreadsheets and database tables.
3 min read
From VLOOKUP/XLOOKUP to Joins
An introduction to database joins based on Excel's VLOOKUP and XLOOKUP functions.
4 min read