THE SPENDIXAI JOURNAL

Make room for
better money habits.

Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.

READ. UNDERSTAND. PUT IT INTO PRACTICE.Original guides · SpendixAI Editorial

Find your next good read.

Small decisions. Clearer thinking. A useful place to start.

Clear

599 guides · Page 46 of 50

Take your time. Find what helps.
Editorial illustration for Total expenses between two dates with SUMIFS
Spreadsheets 3 min read

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
Editorial illustration for Total expenses for a financial year with SUMIFS and EDATE
Spreadsheets 4 min read

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
Editorial illustration for Totals off by a paisa in Excel: rounding and floating point
Spreadsheets 4 min read

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
Editorial illustration for Traffic-light icons for budget status in Excel
Spreadsheets 3 min read

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
Editorial illustration for Trailing minus signs or brackets for negative amounts: convert them
Spreadsheets 3 min read

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
Editorial illustration for Own-account transfers in an expense sheet: avoid double counting
Spreadsheets 3 min read

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
Editorial illustration for Treemap chart of spending categories in Excel
Spreadsheets 4 min read

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
Editorial illustration for TREND function: project the next six months of spending
Spreadsheets 3 min read

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
Editorial illustration for Clean messy bank statement text with TRIM, CLEAN and PROPER
Spreadsheets 4 min read

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
Editorial illustration for Group trip budget template in Google Sheets with who owes whom
Spreadsheets 4 min read

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
Editorial illustration for Tuition fee collection sheet for home tutors in Excel
Spreadsheets 4 min read

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
Editorial illustration for Turn a Dr/Cr column into a signed amount in Excel
Spreadsheets 4 min read

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