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 26 of 50

Take your time. Find what helps.
Editorial illustration for How much to save each month for a goal: simple Excel formula
Spreadsheets 4 min read

How much to save each month for a goal: simple Excel formula

Work out how much to save each month for a goal in Excel: target minus saved so far, divided by months left with DATEDIF, plus a progress percentage.

Read article
Editorial illustration for Monthly savings rate tracker with a chart in Google Sheets
Spreadsheets 3 min read

Monthly savings rate tracker with a chart in Google Sheets

Build a twelve-month savings rate tracker in Google Sheets from your expense log with SUMIFS, then add a combo chart with a target line.

Read article
Editorial illustration for Monthly summary sheet with SUMIFS: income, spend and savings
Spreadsheets 3 min read

Monthly summary sheet with SUMIFS: income, spend and savings

A monthly summary sheet template in Excel: months down, categories across, SUMIFS from a transaction table, plus income, net and savings rate columns.

Read article
Editorial illustration for Moving average or linear trend: which forecast suits bumpy spending?
Spreadsheets 4 min read

Moving average or linear trend: which forecast suits bumpy spending?

Moving average or linear trend for bumpy monthly spending? Both run on the same 12 months with one insurance spike, with results and a rule of thumb.

Read article
Editorial illustration for Moving house budget sheet: shifting, deposits and setup costs
Spreadsheets 4 min read

Moving house budget sheet: shifting, deposits and setup costs

Plan a house move with an Excel budget sheet: deposit, brokerage, packers, utility setup, and overlap rent, with quote versus actual and reimbursement flags.

Read article
Editorial illustration for Multi-rate GST invoice calculator sheet for mixed items
Spreadsheets 3 min read

Multi-rate GST invoice calculator sheet for mixed items

Build a GST invoice sheet for mixed items: quantity, taxable value, GST percent, tax and line total per row, plus a SUMIFS summary grouped by rate.

Read article
Editorial illustration for Multiple loans tracker in Excel: EMI, outstanding and end date
Spreadsheets 4 min read

Multiple loans tracker in Excel: EMI, outstanding and end date

Build one Excel sheet for every loan: lender, EMI, end date, instalments left, estimated outstanding and a total EMI to income ratio, with working formulas.

Read article
Editorial illustration for #NAME? error in Excel: typos, missing quotes and new functions
Spreadsheets 3 min read

#NAME? error in Excel: typos, missing quotes and new functions

Why Excel shows #NAME? and how to fix it: misspelt functions or names, text missing quotes, functions your Excel version lacks and deleted named ranges.

Read article
Editorial illustration for Named functions in Google Sheets: reuse a formula by name
Spreadsheets 4 min read

Named functions in Google Sheets: reuse a formula by name

Create a named function in Google Sheets that cleans a merchant name from a bank narration, then reuse it across the sheet like any built-in function.

Read article
Editorial illustration for Settings tab and named ranges: make your budget sheet easy to change
Spreadsheets 4 min read

Settings tab and named ranges: make your budget sheet easy to change

Move rates, limits and category lists to a Settings tab, name the cells, and change one value to update every formula in your budget or EMI sheet.

Read article
Editorial illustration for Named ranges in Excel to make expense formulas readable
Spreadsheets 3 min read

Named ranges in Excel to make expense formulas readable

Use named ranges in Excel so expense formulas read like plain English: define names for Amount, Category and Date, tidy them in Name Manager, and know their limits.

Read article
Editorial illustration for Narration split over two rows after PDF conversion: merge them back
Spreadsheets 4 min read

Narration split over two rows after PDF conversion: merge them back

Fix PDF conversion narration split into two rows in Excel: a helper-column formula joins continuation lines to the row above, then you delete the leftovers.

Read article