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 47 of 50
Take your time. Find what helps.
Turn your expense sheet into a yearly family money review
Turn a twelve-month expense sheet into a family money review: total spend, top five categories, biggest bills, months over budget and three decisions.
Read article
Two-digit year dates landing in the wrong century in Excel
Excel two-digit year dates landing in the wrong century, such as 1924 instead of 2024: why it happens and formulas that force the right century.
Read article
Self-building category summary with UNIQUE and SUMIFS
Build a dynamic summary table in Excel 365 where UNIQUE lists your categories and SUMIFS totals them, so a new category appears with no formula edits.
Read article
UNIQUE in Google Sheets: list distinct categories and merchants
Use UNIQUE in Google Sheets to list distinct categories and merchants, skip blanks with FILTER and spot spelling variants of one merchant by sorting.
Read article
UNIQUE function to list every category once in Excel 365
Use UNIQUE in Excel 365 to list every expense category once, sort it, drop blanks and feed a SUMIFS summary beside it with the spill reference.
Read article
Unmerge merged cells in a downloaded statement and fill the blanks
Unmerge merged cells in a downloaded statement, then fill the empty cells below with a one-step formula, shown on a six-row sample.
Read article
Use a Google Sheet offline on your phone and sync later
How to use a Google Sheet offline on your phone: mark it available offline, know what you can edit without a connection, how sync works and what to check.
Read article
Value date or transaction date: which to use for monthly totals
Value date vs transaction date: what the columns usually mean, how they fall in different months, and a simple rule for consistent monthly totals.
Read article
#VALUE! error in Excel: text in your amount column and other causes
Why #VALUE! appears in an Excel expense sheet: text in the amount column, hidden spaces, dates stored as text and mismatched ranges, plus ways to find the cell.
Read article
#VALUE! on a statement amount: hidden non-breaking spaces
Fix #VALUE! on a statement amount caused by a hidden non-breaking space: why TRIM misses CHAR(160), how to detect it with LEN and CODE, and the fix.
Read article
Vehicle running cost sheet in Excel: fuel log and cost per km
Set up a vehicle running cost sheet in Excel with a fuel log, a service tab and formulas for mileage and cost per km, with a two-wheeler example.
Read article
Viewer, commenter or editor: sharing a Sheet with family or CA
What viewer, commenter and editor can really do in Google Sheets, link versus named sharing, and which role suits a spouse, a parent and a CA.
Read article