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 11 of 50
Take your time. Find what helps.
Depreciation for a part-year purchase: pro-rata by months in Excel
How to prorate first-year depreciation for an asset bought mid-year: count months in use up to 31 March with DATEDIF, then charge that share in Excel.
Read article
A depreciation schedule for several assets in one Excel sheet
A fixed asset register in Excel with purchase date, cost, life and a financial-year grid of depreciation, filled from one formula copied down and across.
Read article
Design a Google Sheet that works on a phone screen
Lay out a Google Sheet that works on a phone: narrow columns, a frozen header, a one-column summary tab, checkboxes and dropdowns instead of typing.
Read article
#DIV/0! in a savings rate or % change: fix it properly
How to fix #DIV/0! in a savings rate or month-on-month percent change by testing for zero with IF, and why a blanket IFERROR can hide real mistakes.
Read article
Diwali budget planner sheet: gifts, sweets, clothes and decor
A Diwali budget planner for Google Sheets: planned and actual spend by category, a gift list with bought status, and a comparison with last year's column.
Read article
Do you need an expense app if you only have one bank account?
Do you need an expense tracker app with one bank account? A plain decision guide on when a monthly statement review is enough and when an app saves time.
Read article
Domestic help salary and attendance sheet in Excel
A domestic help salary and attendance sheet for Excel: monthly grid for maid, cook and driver, per-day deduction formula, advances and net payable.
Read article
Donut chart of category spending in Google Sheets
Make a pie chart of expenses in Google Sheets, shown as a donut: build the top six plus Other, insert the chart and turn on percentage labels.
Read article
Create a category dropdown list in Excel with Data Validation
Create a category dropdown in Excel with Data Validation: a Lists sheet, a named range, the list rule, and a Stop alert that blocks typos in your expenses.
Read article
Dropdown from a range in Google Sheets for expense categories
Make a category dropdown in Google Sheets from a range: keep the list on its own tab, choose whether other values are rejected, and check pasted data.
Read article
Dropdown that grows automatically when you add a category
Make a dropdown in Excel that grows when you add a category: use an Excel table, a spill range, or an OFFSET formula so the rule never needs editing.
Read article
Education loan tracker sheet for disbursements and study period
Track an education loan in Excel: log each semester disbursement, see interest accrue during the course, estimate the first EMI and follow repayments.
Read article