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 18 of 50
Take your time. Find what helps.
Freelancer income and expense tracker in Excel with monthly totals
Set up a freelancer income and expense tracker in Excel with client, invoice, gross, TDS and received columns, and monthly totals using SUMIFS.
Read article
Fuzzy merge in Power Query for slightly different merchant names
Use Merge Queries with fuzzy matching in Power Query to match slightly different merchant names to a clean list, tune the threshold and review borderline rows.
Read article
Get a PDF statement into Google Sheets: the practical routes
How to get a PDF bank statement into Google Sheets: routes that work with Google tools, their honest limits, and a paste-and-split routine to clean it up.
Read article
Goal Seek: how much to cut spending to hit a savings target
Use Goal Seek in Excel to find how much to cut a grocery or dining budget to hit a monthly savings target, with the exact steps and its one-answer limit.
Read article
Gold purchase record sheet: grams, making charges and bill details
A gold purchase record sheet for Excel: date, shop, grams, rate per gram on the bill, making charges, GST printed on the bill, total, plus a jeweller scheme tab.
Read article
Design a Google Form for expense entry that gives clean data
Design a Google Form expense tracker that gives clean data: dropdown categories, a validated amount field, payment mode choices and an optional note, step by step.
Read article
Receipt upload in Google Forms: where the files go and the limits
See where Google Forms receipt uploads are stored, why respondents must sign in, how the file size and type settings work and how to link each file to its row.
Read article
Log expenses from your phone with a Google Form and Sheets
Log expenses from your phone with a Google Form linked to Google Sheets: build the form, link responses, and summarise them on a separate tab with SUMIFS or QUERY.
Read article
The Google Sheets 10 million cell limit: what counts
What counts toward the Google Sheets 10 million cell limit, why empty grid cells count too, how to find the tabs using it up and how to free space safely.
Read article
Dropdown category lists in Google Sheets for cleaner expense data
Set up a category dropdown in Google Sheets from a Settings tab so every expense uses the same spelling and your SUMIFS totals stop going wrong.
Read article
Make an expense tracker in Google Sheets from scratch
Make a Google Sheets expense tracker from scratch: a log tab, dropdown categories, a QUERY monthly summary, sharing settings and phone entry limits.
Read article
Export one tab of a Google Sheet to PDF with the right page setup
Export one tab of a Google Sheet to PDF: choose the current sheet, landscape, fit to width, hide gridlines and repeat frozen rows for a clean result.
Read article