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 49 of 50
Take your time. Find what helps.
Weekly spending limit with leftover rolling into the next week
Build a weekly spending limit sheet where each week's leftover or overshoot flows into the next, with week-start dates and a daily allowance figure.
Read article
What-if analysis in Google Sheets without a Data Table feature
What-if analysis in Google Sheets without a Data Table feature: build a grid of direct formulas, use ARRAYFORMULA, and weigh a Goal Seek add-on.
Read article
What is Power Pivot, and do you need it for expense data?
What is Power Pivot in Excel, how does it differ from a normal pivot table, and do you need it for expense data? A plain test to decide in two minutes.
Read article
Which Excel versions have dynamic arrays, LET and LAMBDA?
A plain table of which Excel versions have XLOOKUP, FILTER, LET, LAMBDA and newer functions, and how to check your version before sharing a file.
Read article
Which exchange rate to use for foreign card spend in a spreadsheet
Compare the INR amount your card statement billed, a daily market rate and a fixed budgeting rate, and learn when each is right for foreign card spend records.
Read article
Who paid what: SUMIFS for shared household expenses
Track who paid what in a shared household sheet with a Paid by column, SUMIFS per person and a settle-up cell that shows who owes whom after a 50/50 split.
Read article
SUMIFS slow on whole columns? Use tables or exact ranges
Is SUMIFS slow on whole columns like A:A? When it is fine, when it is not, and how to switch to table references or a bounded dynamic range in Excel.
Read article
Why your budget spreadsheet formulas keep breaking (and what to do)
Why budget spreadsheet formulas break: numbers stored as text, #REF! after deleting rows, ranges that stop short and hidden rows, each with a fix.
Read article
Work trip expense report template in Excel with daily allowance rows
A work trip expense report template in Excel: day-wise rows for travel, stay, food and local transport, receipt numbers, daily limits and advance reconciliation.
Read article
XIRR in Excel: finding the rate on payments made on irregular dates
Use XIRR in Excel or Google Sheets to find the yearly rate hidden in payments made on uneven dates, such as a family loan repaid in parts or a chit fund.
Read article
XLOOKUP approximate match for slabs, like cashback or fee tiers
Use XLOOKUP with match_mode -1 to find a cashback or fee rate from a spend-band table, and learn what to do when a value is below the first band.
Read article
XLOOKUP to assign a category from the merchant name in Excel
Assign a category from the merchant name in Excel with XLOOKUP: a Rules sheet of merchants, an Uncategorised fallback and a list of what is left to sort.
Read article