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 38 of 50
Take your time. Find what helps.
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
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
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
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
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
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
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
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
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
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
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
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