THE SPENDIXAI JOURNAL

Make room for
better money habits.

Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.

READ. UNDERSTAND. PUT IT INTO PRACTICE.Original guides · SpendixAI Editorial

Find your next good read.

Small decisions. Clearer thinking. A useful place to start.

Clear

599 guides · Page 4 of 50

Take your time. Find what helps.
Editorial illustration for BYROW and BYCOL: totals and peaks for a month-by-category grid
Spreadsheets 4 min read

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
Editorial illustration for CAGR formula in Excel: calculate annual growth between two values
Spreadsheets 3 min read

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
Editorial illustration for Calendar heat map of daily spending in Excel
Spreadsheets 4 min read

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
Editorial illustration for Cap how much budget rolls over with MIN: a category example
Spreadsheets 4 min read

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
Editorial illustration for Car ownership cost sheet: what a car really costs per year in Excel
Spreadsheets 4 min read

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
Editorial illustration for Carry an overspend into next month's budget in a sheet
Spreadsheets 3 min read

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
Editorial illustration for Cash book with opening and closing balance formulas in Excel
Spreadsheets 4 min read

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
Editorial illustration for Cash envelope budget sheet: tracking envelopes in Excel
Spreadsheets 4 min read

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
Editorial illustration for Categorise a transaction when the narration contains a keyword
Spreadsheets 3 min read

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
Editorial illustration for Categorise transactions with XLOOKUP and wildcard keywords
Spreadsheets 3 min read

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
Editorial illustration for Category by month heat map with colour scales in Excel
Spreadsheets 4 min read

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
Editorial illustration for Category rules table in Power Query, with priority when two match
Spreadsheets 4 min read

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