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

Take your time. Find what helps.
Editorial illustration for Loan amortisation schedule in Excel, built month by month
Spreadsheets 3 min read

Loan amortisation schedule in Excel, built month by month

Build a loan amortisation schedule in Excel with opening balance, interest, principal and closing balance for each month, plus a total row and a zero-balance check.

Read article
Editorial illustration for Lock cells and protect formulas in an expense workbook
Spreadsheets 4 min read

Lock cells and protect formulas in an expense workbook

Lock the formula cells in your expense workbook, keep input cells editable, choose sorting and filter options, and learn why protection is not encryption.

Read article
Editorial illustration for Lock a closed month: protect past data in Sheets and Excel
Spreadsheets 4 min read

Lock a closed month: protect past data in Sheets and Excel

Protect a closed month with an edit warning or restricted editors in Google Sheets, a protected sheet per month in Excel, and a month-close checklist.

Read article
Editorial illustration for Look up a value on two conditions in Excel: merchant and month
Spreadsheets 3 min read

Look up a value on two conditions in Excel: merchant and month

Find the amount for one merchant in one month in Excel with XLOOKUP on a joined key, INDEX and MATCH with two tests, or a helper column for older versions.

Read article
Editorial illustration for MAP function: apply one rule to every transaction in Excel
Spreadsheets 4 min read

MAP function: apply one rule to every transaction in Excel

Use MAP with LAMBDA in Excel to flag every transaction above its category limit with one spilled formula, instead of copying a formula down 3,000 rows.

Read article
Editorial illustration for MAP and LAMBDA in Google Sheets: apply a rule to every row
Spreadsheets 3 min read

MAP and LAMBDA in Google Sheets: apply a rule to every row

Use MAP with LAMBDA in Google Sheets to label every transaction with a spending tier in one formula, and learn when it beats ARRAYFORMULA.

Read article
Editorial illustration for Map your spreadsheet categories to app categories before importing
Spreadsheets 4 min read

Map your spreadsheet categories to app categories before importing

Build a two-column mapping from old category names to new ones, apply it with a lookup and merge near-duplicates like Food and Groceries before you import.

Read article
Editorial illustration for Match refunds and reversals to the original purchase in a sheet
Spreadsheets 4 min read

Match refunds and reversals to the original purchase in a sheet

Match refunds and reversals to the original purchase in a sheet with COUNTIFS on merchant, amount and a date window, so category totals are not overstated.

Read article
Editorial illustration for Match transactions when the dates differ by a day or two
Spreadsheets 4 min read

Match transactions when the dates differ by a day or two

Reconcile transactions when dates differ by a day or two: match on amount plus a date window using COUNTIFS with date bounds and handle cheque and card delays.

Read article
Editorial illustration for MAXIFS and MINIFS: highest expense per category in Excel
Spreadsheets 3 min read

MAXIFS and MINIFS: highest expense per category in Excel

Use MAXIFS and MINIFS to find the highest and lowest expense in each category, then look up the date it happened. Covers Excel 2019 and later plus Google Sheets.

Read article
Editorial illustration for Median or average monthly spend: which describes you better?
Spreadsheets 4 min read

Median or average monthly spend: which describes you better?

Median or average monthly spend? A twelve-month worked example with one big one-off shows MEDIAN and AVERAGE side by side and when each suits your budget.

Read article
Editorial illustration for Medical expense tracker in Excel by family member and claim status
Spreadsheets 4 min read

Medical expense tracker in Excel by family member and claim status

Build a medical expense tracker in Excel that logs every bill by family member, tracks each insurance claim and shows your real out-of-pocket cost.

Read article