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 32 of 50
Take your time. Find what helps.
Project month-end spending from what you have spent so far
Project your month-end spending in Excel from what you have spent so far, compare it with the budget and flag a likely overspend, plus where the method fails.
Read article
Project-wise profit sheet for freelancers in Excel
A project-wise profit sheet for freelancers in Excel: fee, direct costs, hours, profit per hour and a way to share a software subscription across projects.
Read article
Protect formula cells in an Excel expense workbook
Protect formulas in Excel and keep entry columns open: unlock the input cells, lock the rest, then switch on Protect Sheet with filter and sort allowed.
Read article
Protect formulas in your expense sheet from accidental edits
Lock the formula cells in your expense sheet and leave the input cells open, in Excel or Google Sheets, so family edits cannot overwrite your totals.
Read article
Protect workbook structure so nobody deletes or hides your tabs
Protect workbook structure in Excel so nobody deletes, hides or renames your tabs, and see how it differs from sheet protection and a file password.
Read article
Pull bank charges and interest lines into their own category
Flag fee, charge, GST-on-charge and interest lines with a keyword list and a helper column in Excel, so bank charges get their own monthly total.
Read article
Pull budget and actual into one table with XLOOKUP and SUMIFS
Combine a budget list and an expense log into one summary table with XLOOKUP for the budget and SUMIFS for the actual, ready for new categories.
Read article
Pull exchange rates into Google Sheets with GOOGLEFINANCE
Use GOOGLEFINANCE("CURRENCY:USDINR") in Google Sheets for current and historical exchange rates, and learn why they are indicative and not your card's rate.
Read article
Quarter formula for an April to March financial year in Sheets
The fiscal quarter formula for an April to March year: ROUNDUP on the fiscal month gives Q1 to Q4, plus a SUMIFS summary table laid out by quarter.
Read article
QUERY across two sheets with curly brackets in Google Sheets
Stack this year's and last year's tabs in Google Sheets with curly brackets, then run QUERY on the combined block, with matching columns and no repeated header.
Read article
Make a QUERY respond to a dropdown: category and month selectors
Make a Google Sheets QUERY react to dropdown cells for category and month: join cell values into the query string, handle quote rules and an All option.
Read article
QUERY with pivot: categories down, months across in Google Sheets
Build a category-by-month grid in Google Sheets with QUERY and its pivot clause, using a helper month column instead of a pivot table.
Read article