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

Take your time. Find what helps.
Editorial illustration for Repeat header rows on every printed page in Excel
Spreadsheets 4 min read

Repeat header rows on every printed page in Excel

Repeat the header row on every printed page in Excel using Print Titles, plus the Google Sheets way with a frozen row, and a quick Print Preview check.

Read article
Editorial illustration for Replace dashes and NIL text in amount columns with zero
Spreadsheets 3 min read

Replace dashes and NIL text in amount columns with zero

Replace dashes and NIL in debit and credit columns with zero so SUM and SUMIFS work, using Go To Special, whole-cell Replace or a safe formula.

Read article
Editorial illustration for Reset rollover balances at the start of the financial year
Spreadsheets 3 min read

Reset rollover balances at the start of the financial year

Restart rollover balances each April with an IF on the month number, keep earlier years as history, and get the April-to-March month index right.

Read article
Editorial illustration for A daily sales, wastage and food-cost sheet for a small restaurant
Spreadsheets 3 min read

A daily sales, wastage and food-cost sheet for a small restaurant

A daily sales, wastage and food-cost sheet for a small restaurant in Excel, with a food-cost percentage formula and a weekly view to find where money leaks.

Read article
Editorial illustration for Restore an earlier version of an Excel file from OneDrive
Spreadsheets 4 min read

Restore an earlier version of an Excel file from OneDrive

Restore an earlier version of an Excel file from OneDrive: open Version History from the file name menu, then preview, restore or save a copy.

Read article
Editorial illustration for Roll unspent budget into next month: the formula
Spreadsheets 3 min read

Roll unspent budget into next month: the formula

Roll unspent budget into next month with a simple formula: opening balance, budget added, spend subtracted, plus a three-month groceries worked example.

Read article
Editorial illustration for Rolling 12-month spending total in Excel with SUMIFS and EDATE
Spreadsheets 4 min read

Rolling 12-month spending total in Excel with SUMIFS and EDATE

Build a rolling 12-month spending total in Excel with SUMIFS and EDATE, with a worked example and how it differs from financial-year-to-date.

Read article
Editorial illustration for A rolling 12-month table in Google Sheets that shifts every month
Spreadsheets 4 min read

A rolling 12-month table in Google Sheets that shifts every month

Build a rolling 12-month table in Google Sheets with TODAY, EDATE and SUMIFS so the months slide forward each month, plus a warning on TODAY recalculation.

Read article
Editorial illustration for Rolling three-month average of spending in Excel
Spreadsheets 4 min read

Rolling three-month average of spending in Excel

Calculate a rolling three-month average of monthly spending in Excel with AVERAGE over a sliding window, handle the first two months and chart it.

Read article
Editorial illustration for Running balance column for a cash book in Google Sheets
Spreadsheets 4 min read

Running balance column for a cash book in Google Sheets

Build a cash book in Google Sheets with receipts, payments and a running balance formula that handles blank rows and shows the closing balance.

Read article
Editorial illustration for Running total of expenses in Excel (cumulative sum)
Spreadsheets 3 min read

Running total of expenses in Excel (cumulative sum)

Add a running total of expenses in Excel with =SUM($E$2:E2), the =E2+F1 alternative and a table formula that extends itself when you add rows.

Read article
Editorial illustration for Show the rupee symbol (₹) in Excel and Google Sheets
Spreadsheets 3 min read

Show the rupee symbol (₹) in Excel and Google Sheets

Show the rupee symbol in Excel and Google Sheets with currency formats, keyboard shortcuts and UNICHAR, and fix the empty box some fonts show.

Read article