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 25 of 50
Take your time. Find what helps.
Merge yearly expense tabs into one master transaction list
Combine multiple Excel sheets of expenses into one master list: stack yearly tabs, add a year column, fix column order and remove duplicates safely.
Read article
Microsoft Forms to Excel: log expenses from your phone
Build a Microsoft Form tied to an Excel workbook in OneDrive to log expenses from your phone, then add a summary tab that reads the responses without editing them.
Read article
Mileage log template in Excel for business trips
Create a mileage log in Excel with start and end odometer, purpose, per-km value in a settings cell and a business versus personal split, with an example.
Read article
Milk delivery log in Google Sheets to check the monthly bill
A milk delivery tracker in Google Sheets: daily litres, price per litre, skipped and extra days, and a monthly total to check against the vendor's bill.
Read article
Why expense entry in Excel on a phone is painful and what helps
Why entering expenses in an Excel or Google Sheets file on your phone is painful, which workarounds help, and when a mobile-first tracker removes the issue.
Read article
Month-by-category expense matrix with one SUMIFS formula
Build a month-by-category expense matrix with a single SUMIFS formula using mixed references, then add total row and column plus a check cell.
Read article
Extract month and year from a date column in an expense sheet
Add a month and year helper column in Excel with MONTH, TEXT and a sortable key, and learn which version works best for SUMIFS and pivot tables.
Read article
Add a month name column that fills itself in Google Sheets
Make a month name column in Google Sheets that fills itself for every new transaction with one ARRAYFORMULA and an IF guard for blank rows.
Read article
Month-on-month spending change: percentage formula in Excel
Calculate month-on-month spending change in Excel with =(this-last)/last, guard against zero with IF or IFERROR, and colour rises and falls automatically.
Read article
Month selector dropdown for an Excel spending dashboard
Add a month dropdown to an Excel spending dashboard with data validation, so SUMIFS formulas and charts update for whichever month you pick.
Read article
Monthly expense tracker in Excel with Indian categories pre-filled
Build a monthly expense tracker in Excel with Indian categories pre-filled, a transaction log and a SUMIFS summary, in about fifteen minutes.
Read article
Monthly grocery tracker sheet for Excel with price per unit
A grocery expense tracker for Excel with a purchase log, price per kg or litre by month and a kirana, supermarket and online split to spot price creep.
Read article