Make room for
better money habits.
Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.
Find your next good read.
Small decisions. Clearer thinking. A useful place to start.
599 guides · Page 24 of 50
Take your time. Find what helps.
Loan amortisation schedule in Excel, built month by month
Build a loan amortisation schedule in Excel with opening balance, interest, principal and closing balance for each month, plus a total row and a zero-balance check.
Read article
Lock cells and protect formulas in an expense workbook
Lock the formula cells in your expense workbook, keep input cells editable, choose sorting and filter options, and learn why protection is not encryption.
Read article
Lock a closed month: protect past data in Sheets and Excel
Protect a closed month with an edit warning or restricted editors in Google Sheets, a protected sheet per month in Excel, and a month-close checklist.
Read article
Look up a value on two conditions in Excel: merchant and month
Find the amount for one merchant in one month in Excel with XLOOKUP on a joined key, INDEX and MATCH with two tests, or a helper column for older versions.
Read article
MAP function: apply one rule to every transaction in Excel
Use MAP with LAMBDA in Excel to flag every transaction above its category limit with one spilled formula, instead of copying a formula down 3,000 rows.
Read article
MAP and LAMBDA in Google Sheets: apply a rule to every row
Use MAP with LAMBDA in Google Sheets to label every transaction with a spending tier in one formula, and learn when it beats ARRAYFORMULA.
Read article
Map your spreadsheet categories to app categories before importing
Build a two-column mapping from old category names to new ones, apply it with a lookup and merge near-duplicates like Food and Groceries before you import.
Read article
Match refunds and reversals to the original purchase in a sheet
Match refunds and reversals to the original purchase in a sheet with COUNTIFS on merchant, amount and a date window, so category totals are not overstated.
Read article
Match transactions when the dates differ by a day or two
Reconcile transactions when dates differ by a day or two: match on amount plus a date window using COUNTIFS with date bounds and handle cheque and card delays.
Read article
MAXIFS and MINIFS: highest expense per category in Excel
Use MAXIFS and MINIFS to find the highest and lowest expense in each category, then look up the date it happened. Covers Excel 2019 and later plus Google Sheets.
Read article
Median or average monthly spend: which describes you better?
Median or average monthly spend? A twelve-month worked example with one big one-off shows MEDIAN and AVERAGE side by side and when each suits your budget.
Read article
Medical expense tracker in Excel by family member and claim status
Build a medical expense tracker in Excel that logs every bill by family member, tracks each insurance claim and shows your real out-of-pocket cost.
Read article