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

Take your time. Find what helps.
Editorial illustration for School fees tracker spreadsheet for more than one child
Spreadsheets 3 min read

School fees tracker spreadsheet for more than one child

A school fees tracker spreadsheet for more than one child, with fee components by term, due dates, paid or pending status and a shared transport line.

Read article
Editorial illustration for Find seasonal spending spikes by comparing years month by month
Spreadsheets 4 min read

Find seasonal spending spikes by comparing years month by month

Find your seasonal spending spikes by laying months against years in a grid, shading repeat peaks, and turning them into monthly sinking funds.

Read article
Editorial illustration for See who changed a cell and when in Google Sheets
Spreadsheets 4 min read

See who changed a cell and when in Google Sheets

Use Show edit history on a cell, and highlight edits by person in version history, to see who changed a figure in a shared sheet and what these tools cannot show.

Read article
Editorial illustration for Split one amount column into debit and credit in Google Sheets
Spreadsheets 4 min read

Split one amount column into debit and credit in Google Sheets

Split one amount column into separate debit and credit columns in Google Sheets using IF and ARRAYFORMULA, from a Dr/Cr marker or from signed amounts.

Read article
Editorial illustration for Separate person-to-person UPI from merchant payments in a sheet
Spreadsheets 3 min read

Separate person-to-person UPI from merchant payments in a sheet

Separate payments to people from merchant payments in a UPI sheet using name heuristics and a review column, keeping a To people bucket for manual checks.

Read article
Editorial illustration for SEQUENCE and EDATE: a 12-month header row that builds itself
Spreadsheets 4 min read

SEQUENCE and EDATE: a 12-month header row that builds itself

Build a row of 12 month-start dates with SEQUENCE and EDATE, format them as Apr-25, and drive a SUMIFS year grid from a single start date.

Read article
Editorial illustration for Set Excel and Windows to the English (India) date format
Spreadsheets 4 min read

Set Excel and Windows to the English (India) date format

Set Excel and Windows to the English (India) date format: change the Windows region, reopen Excel, and apply dd/mm/yyyy to dates you already have.

Read article
Editorial illustration for Settle-up formula: who owes whom between flatmates in a sheet
Spreadsheets 3 min read

Settle-up formula: who owes whom between flatmates in a sheet

Work out who owes whom between flatmates with simple spreadsheet formulas: total paid, equal share, balance per person and the fewest transfers.

Read article
Editorial illustration for Shagun and gift ledger in Excel for weddings you attend
Spreadsheets 3 min read

Shagun and gift ledger in Excel for weddings you attend

A shagun and gift ledger for Excel: record what you gave and received by family and occasion, with a lookup of what you gave last time.

Read article
Editorial illustration for Share an expense spreadsheet read-only with family or your CA
Spreadsheets 4 min read

Share an expense spreadsheet read-only with family or your CA

Compare a view link, Mark as Final and a PDF copy, and strip sensitive columns first so an expense sheet can be shared read-only with family or a CA.

Read article
Editorial illustration for Sharing an expense workbook with someone on older Excel: what breaks
Spreadsheets 4 min read

Sharing an expense workbook with someone on older Excel: what breaks

Why an expense workbook shows #NAME? or _xlfn on older Excel, with safe swaps such as INDEX and MATCH for XLOOKUP and SUMIFS for FILTER.

Read article
Editorial illustration for Can you share just one tab of a Google Sheet? Workarounds that work
Spreadsheets 4 min read

Can you share just one tab of a Google Sheet? Workarounds that work

Google Sheets shares a whole file, not one tab. Here are three workarounds, a separate file via IMPORTRANGE, a values copy and a PDF, with the risk of each.

Read article