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 22 of 50
Take your time. Find what helps.
Income vs expense chart with a savings rate line
Chart monthly income and expenses as columns with a savings rate line on a secondary axis in Excel. Includes the formula and a four-month example.
Read article
INDEX MATCH to look up a category from a merchant list
Look up a category from a merchant list with INDEX and MATCH, including the case where the category sits left of the merchant and VLOOKUP cannot work.
Read article
Indian lakh comma format in Excel (12,34,567) with a custom format
Show Excel amounts as 12,34,567 with a conditional custom number format, see where it breaks for negatives and crores, and when to use the regional setting.
Read article
Indian number format in Google Sheets: lakh grouping and rupee
Set the spreadsheet locale to India and use a custom number format in Google Sheets to show lakh grouping and the rupee sign, and see how it differs from Excel.
Read article
INDIRECT to pull totals from whichever monthly tab you pick
Use INDIRECT with a month dropdown to pull category totals from whichever monthly tab you pick, plus the trade-offs of a volatile function and a table alternative.
Read article
Inflation-adjusted future cost sheet: what a price may become
Project a future cost with inflation in Excel using FV or a power formula, shown for a college fee as a what-if across a range of rates.
Read article
Insurance premium tracker sheet with renewal dates and policies
Set up an insurance premium tracker in Excel or Google Sheets: one row per policy, due-date alerts, an annualised premium total and a link to each document.
Read article
Interior designer project ledger: client advances and vendors
An Excel project ledger for interior designers: client instalments in, vendor and carpenter payments out, project-wise cash position and a margin check.
Read article
Find invoices paid in the bank but missing from your ledger
List bank debits that match an invoice number or amount but have no ledger entry, rank them by amount, and see what to do with each payment in the books.
Read article
IPMT and PPMT: split any EMI into interest and principal in Excel
Use IPMT and PPMT in Excel to split any EMI into interest and principal for a chosen month, and add up the interest paid in the first twelve instalments.
Read article
Is Google Sheets enough for a family budget? A practical test
A practical four-question test to see whether Google Sheets is enough for your family budget, with a simple score and the point at which an app pays back.
Read article
Is it safe to upload a bank statement PDF to an online converter?
Is it safe to upload a bank statement PDF to a free online converter? A checklist of what the file reveals, what to check and safer offline options.
Read article