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 26 of 50
Take your time. Find what helps.
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
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
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
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
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
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
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
#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
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
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
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
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