Make room for
better money habits.
Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.
Find your next good read.
Small decisions. Clearer thinking. A useful place to start.
599 guides · Page 36 of 50
Take your time. Find what helps.
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
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
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
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
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
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
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
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
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
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
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
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