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 46 of 50
Take your time. Find what helps.
Total expenses between two dates with SUMIFS
Total expenses between two dates with SUMIFS in Excel or Google Sheets: from and to input cells, including the end date, and why a time part can drop rows.
Read article
Total expenses for a financial year with SUMIFS and EDATE
Total a whole April to March year with one SUMIFS formula, a single start-date cell and EDATE for the end date, then split it by category.
Read article
Totals off by a paisa in Excel: rounding and floating point
Why Excel totals differ by a paisa or a tiny stray decimal, how ROUND to two places fixes floating point, and how a difference cell proves your sum.
Read article
Traffic-light icons for budget status in Excel
Add traffic-light icons to a budget in Excel with an Icon Set on percent used: green below 80, amber to 100, red above, numbers hidden if you like.
Read article
Trailing minus signs or brackets for negative amounts: convert them
Convert trailing-minus text like 1,200.00- and bracketed (1,200.00) amounts into real negatives in Excel, one formula each, plus a Text to Columns trick.
Read article
Own-account transfers in an expense sheet: avoid double counting
Stop own-account transfers and credit card bill payments inflating your spending: add a Type column and use SUMIFS that ignore transfers, with a worked example.
Read article
Treemap chart of spending categories in Excel
Build a treemap of spending categories and subcategories in Excel from a flat table, and learn when area comparison is hard and a bar chart is better.
Read article
TREND function: project the next six months of spending
Use the TREND function in Excel to project six months of spending in one spill formula, chart actual against projected, and avoid array-entry mistakes.
Read article
Clean messy bank statement text with TRIM, CLEAN and PROPER
Clean bank statement text in Excel with TRIM, CLEAN, SUBSTITUTE and PROPER in one helper column so duplicate checks and lookups behave.
Read article
Group trip budget template in Google Sheets with who owes whom
A group trip budget template for Google Sheets: pre-trip estimates, an expense log with payer and participants, and a settle-up block for who owes whom.
Read article
Tuition fee collection sheet for home tutors in Excel
A tuition fee collection sheet for home tutors in Excel: students, monthly fee, a paid-or-pending grid, partial payments and the oldest unpaid month.
Read article
Turn a Dr/Cr column into a signed amount in Excel
Turn a Dr/Cr column into a signed amount in Excel with IF or SWITCH, and add a check column that counts rows whose flag is neither Dr nor Cr.
Read article