Archive
Every tutorial published so far, newest first.
| Tutorial | Apps | Checked |
|---|---|---|
| Build a loan amortization schedule in Excel with PMT, IPMT and PPMT | Excel, Sheets, LibreOffice | |
| Look up a price in Excel with INDEX and MATCH | Excel, Sheets, LibreOffice | |
| Track a monthly budget in Excel with SUMIFS | Excel, Sheets, LibreOffice | |
| Count working days between two dates in Excel with NETWORKDAYS | Excel, Sheets, LibreOffice | |
| Clean messy names in Excel with TRIM, CLEAN, and PROPER | Excel, Sheets, LibreOffice | |
| Summarise sales by category in Excel with SUMIFS, COUNTIFS, and AVERAGEIFS | Excel, Sheets, LibreOffice |