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 47 of 50

Take your time. Find what helps.
Editorial illustration for Turn your expense sheet into a yearly family money review
Spreadsheets 4 min read

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
Editorial illustration for Two-digit year dates landing in the wrong century in Excel
Spreadsheets 3 min read

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
Editorial illustration for Self-building category summary with UNIQUE and SUMIFS
Spreadsheets 4 min read

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
Editorial illustration for UNIQUE in Google Sheets: list distinct categories and merchants
Spreadsheets 4 min read

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
Editorial illustration for UNIQUE function to list every category once in Excel 365
Spreadsheets 4 min read

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
Editorial illustration for Unmerge merged cells in a downloaded statement and fill the blanks
Spreadsheets 4 min read

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
Editorial illustration for Use a Google Sheet offline on your phone and sync later
Spreadsheets 4 min read

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
Editorial illustration for Value date or transaction date: which to use for monthly totals
Spreadsheets 3 min read

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
Editorial illustration for #VALUE! error in Excel: text in your amount column and other causes
Spreadsheets 4 min read

#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
Editorial illustration for #VALUE! on a statement amount: hidden non-breaking spaces
Spreadsheets 3 min read

#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
Editorial illustration for Vehicle running cost sheet in Excel: fuel log and cost per km
Spreadsheets 4 min read

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
Editorial illustration for Viewer, commenter or editor: sharing a Sheet with family or CA
Spreadsheets 4 min read

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