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 43 of 50
Take your time. Find what helps.
Standardise merchant names with a lookup table in Excel
Standardise merchant names in Excel with a two-column mapping table and a lookup formula, so five spellings of one shop become one clean name.
Read article
Why a bank statement CSV opens in a single column in Excel
Why a bank statement CSV opens in one column in Excel, how to tell which of three causes you have, and how to split it with Text to Columns.
Read article
Statement file stuck in Protected View and will not let you edit
Excel statement file stuck in Protected View? Learn what the yellow bar means, when Enable Editing is safe and how Unblock fixes a button that does nothing.
Read article
Step-up SIP calculator sheet: raise the amount every year
Build a step-up SIP sheet where the monthly amount rises each year, with year-end balances at an assumed rate and a flat SIP column to compare.
Read article
Stress-test your budget in a sheet: what if income drops?
Stress-test your household budget in a sheet: an income multiplier, fixed and flexible costs, and a months-of-runway result when income falls.
Read article
Student monthly budget template for hostel life in Excel
A one-tab Excel budget for hostel students: start from the allowance, subtract fixed costs and see a safe daily spend and the days left to payday.
Read article
Yearly and per-day cost of subscriptions with formulas
Work out the yearly and per-day cost of subscriptions in a sheet: a billing-frequency column, IFS to annualise, and a per-day figure.
Read article
Subscription tracker in Google Sheets with renewal alerts
Build a subscription tracker in Google Sheets that turns yearly plans into monthly cost and highlights renewals coming up in the next seven days.
Read article
SUBTOTAL formula to total only the filtered expenses
Make a total cell follow your filter with SUBTOTAL(109, ...), and learn why SUM ignores filters and how codes 9 and 109 treat hidden rows differently.
Read article
Sum expenses by category in Google Sheets with SUMIF
Sum expenses by category in Google Sheets with SUMIF: whole-column ranges that grow, copying down a category list, ARRAYFORMULA, QUERY and a circular-reference trap.
Read article
Sum only debits from a single amount column in Excel
Sum only the debits from one signed amount column in Excel with SUMIF less than zero, total credits separately, and show spend as a positive figure.
Read article
Sum one category across monthly sheet tabs in Excel
Total one category across a workbook with a tab per month, using 3D SUM for a fixed cell and SUMIF with INDIRECT and a list of tab names.
Read article