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 4 of 50
Take your time. Find what helps.
BYROW and BYCOL: totals and peaks for a month-by-category grid
Use BYROW and BYCOL in Excel to find each month's biggest category and each category's average in a 12-month by 8-category grid, with no helper columns.
Read article
CAGR formula in Excel: calculate annual growth between two values
Calculate CAGR in Excel with the power formula or RRI, and use it on grocery bills, fees or salary to see the steady yearly growth between two values.
Read article
Calendar heat map of daily spending in Excel
Build a calendar heat map of daily spending in Excel with a week-by-weekday grid, SUMIFS and a colour scale, starting with one month and extending to a year.
Read article
Cap how much budget rolls over with MIN: a category example
Use MIN to stop a leisure envelope rolling past a ceiling and send the excess to a savings line, with formulas and a before-and-after table.
Read article
Car ownership cost sheet: what a car really costs per year in Excel
Work out what a car costs a year with an Excel sheet: fixed and variable blocks, cost per month and per kilometre, and a side column that compares cab spending.
Read article
Carry an overspend into next month's budget in a sheet
Let a category's leftover go negative so an overspend reduces next month's budget, with a Carry or Absorb switch and a four-month worked example.
Read article
Cash book with opening and closing balance formulas in Excel
Build a daily cash book in Excel where each day's opening balance carries over from yesterday's closing, with SUMIFS by date and a cash-in-hand check.
Read article
Cash envelope budget sheet: tracking envelopes in Excel
Track cash envelopes in Excel with a simple log, balance-left per envelope and a way to record transfers so totals still match your bank withdrawal.
Read article
Categorise a transaction when the narration contains a keyword
Categorise a transaction when the narration contains a keyword in Excel, with LOOKUP and SEARCH, an Excel 365 alternative and a UPI narration example.
Read article
Categorise transactions with XLOOKUP and wildcard keywords
Categorise bank transactions in Excel with a keyword table and XLOOKUP, learn why wildcard mode points the other way and how to order keywords.
Read article
Category by month heat map with colour scales in Excel
Make a category by month heat map in Excel with colour scales, applied per row so each category's own peaks show, and add a legend note.
Read article
Category rules table in Power Query, with priority when two match
Categorise transactions in Power Query with a rules table, keep the highest-priority match when two keywords hit, and refresh when the rules change.
Read article