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

Take your time. Find what helps.
Editorial illustration for Standardise merchant names with a lookup table in Excel
Spreadsheets 4 min read

Standardise merchant names with a lookup table in Excel

Standardise merchant names in Excel with a two-column mapping table and a lookup formula, so five spellings of one shop become one clean name.

Read article
Editorial illustration for Why a bank statement CSV opens in a single column in Excel
Spreadsheets 4 min read

Why a bank statement CSV opens in a single column in Excel

Why a bank statement CSV opens in one column in Excel, how to tell which of three causes you have, and how to split it with Text to Columns.

Read article
Editorial illustration for Statement file stuck in Protected View and will not let you edit
Spreadsheets 4 min read

Statement file stuck in Protected View and will not let you edit

Excel statement file stuck in Protected View? Learn what the yellow bar means, when Enable Editing is safe and how Unblock fixes a button that does nothing.

Read article
Editorial illustration for Step-up SIP calculator sheet: raise the amount every year
Spreadsheets 3 min read

Step-up SIP calculator sheet: raise the amount every year

Build a step-up SIP sheet where the monthly amount rises each year, with year-end balances at an assumed rate and a flat SIP column to compare.

Read article
Editorial illustration for Stress-test your budget in a sheet: what if income drops?
Spreadsheets 3 min read

Stress-test your budget in a sheet: what if income drops?

Stress-test your household budget in a sheet: an income multiplier, fixed and flexible costs, and a months-of-runway result when income falls.

Read article
Editorial illustration for Student monthly budget template for hostel life in Excel
Spreadsheets 3 min read

Student monthly budget template for hostel life in Excel

A one-tab Excel budget for hostel students: start from the allowance, subtract fixed costs and see a safe daily spend and the days left to payday.

Read article
Editorial illustration for Yearly and per-day cost of subscriptions with formulas
Spreadsheets 3 min read

Yearly and per-day cost of subscriptions with formulas

Work out the yearly and per-day cost of subscriptions in a sheet: a billing-frequency column, IFS to annualise, and a per-day figure.

Read article
Editorial illustration for Subscription tracker in Google Sheets with renewal alerts
Spreadsheets 3 min read

Subscription tracker in Google Sheets with renewal alerts

Build a subscription tracker in Google Sheets that turns yearly plans into monthly cost and highlights renewals coming up in the next seven days.

Read article
Editorial illustration for SUBTOTAL formula to total only the filtered expenses
Spreadsheets 4 min read

SUBTOTAL formula to total only the filtered expenses

Make a total cell follow your filter with SUBTOTAL(109, ...), and learn why SUM ignores filters and how codes 9 and 109 treat hidden rows differently.

Read article
Editorial illustration for Sum expenses by category in Google Sheets with SUMIF
Spreadsheets 4 min read

Sum expenses by category in Google Sheets with SUMIF

Sum expenses by category in Google Sheets with SUMIF: whole-column ranges that grow, copying down a category list, ARRAYFORMULA, QUERY and a circular-reference trap.

Read article
Editorial illustration for Sum only debits from a single amount column in Excel
Spreadsheets 4 min read

Sum only debits from a single amount column in Excel

Sum only the debits from one signed amount column in Excel with SUMIF less than zero, total credits separately, and show spend as a positive figure.

Read article
Editorial illustration for Sum one category across monthly sheet tabs in Excel
Spreadsheets 4 min read

Sum one category across monthly sheet tabs in Excel

Total one category across a workbook with a tab per month, using 3D SUM for a fixed cell and SUMIF with INDIRECT and a list of tab names.

Read article