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 37 of 50
Take your time. Find what helps.
Rupee symbol and special characters garbled when opening a CSV
Rupee symbol showing as odd characters in a CSV opened in Excel? Learn why UTF-8 and ANSI clash, how to reopen the file correctly and how to repair damage.
Read article
Salary day split sheet: divide your paycheque in Google Sheets
Divide your salary on payday with a Google Sheets plan that allocates rent, EMI, bills, SIP and savings, flags over-allocation and adds a second salary.
Read article
Discount and final price formulas in Excel for sale shopping
Discount formulas for Excel: price after discount, discount percent from two prices, stacked card and coupon offers, and a two-shop comparison table.
Read article
A salon sheet for daily sales, products used and staff commission
A salon accounts sheet in Excel: daily services sold, staff commission from editable rates, product usage and a simple monthly profit view with formulas.
Read article
Save a cleaned statement as XLSX or CSV: what each one keeps
XLSX or CSV for bank statement data? A side-by-side look at what each keeps, from formulas and dates to leading zeros, and when to use which.
Read article
How much to save each month for a goal: the PMT formula in Excel
Work out how much to save each month for a goal with Excel's PMT formula, including an assumed rate, an existing balance and the zero-interest shortcut.
Read article
Savings goal tracker spreadsheet with a progress bar
Build a savings goal tracker in Excel with target, deadline, percentage complete, a text progress bar and the monthly amount each goal needs.
Read article
Savings rate formula in Excel (income minus expenses)
Savings rate formula in Excel: (income minus expenses) divided by income, built with SUMIFS for each month, IFERROR for zero income and a weighted average.
Read article
SCAN function: a running balance in one spilled formula
Replace a fill-down running balance column with one SCAN formula that starts from an opening balance. Covers inserted rows; needs Microsoft 365.
Read article
Scanned statement PDF to Excel with OCR: what to check afterwards
Scanned bank statement PDF to Excel with OCR: what the software gets wrong, three checks that catch it and a balance reconciliation at the end.
Read article
Scenario Manager in Excel: save and compare budget cases
Use Excel's Scenario Manager to save named budget cases with rent, income and EMI as changing cells, then build a Scenario Summary report to compare them.
Read article
A scenario table with a dropdown: lean, base and stretch budgets
Build a scenario table with a dropdown in Excel or Sheets: lean, base and stretch budgets, with INDEX and MATCH feeding every formula from one choice.
Read article