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 50 of 50
Take your time. Find what helps.
XLOOKUP an exchange rate by transaction date (nearest earlier date)
Use XLOOKUP with match mode -1 to find the exchange rate on or before each transaction date, so weekends and holidays pick up the previous working day rate.
Read article
XLOOKUP with a fallback: check your own list, then a general one
Nest one XLOOKUP inside another so your own merchant overrides are checked first, then a default list, then Uncategorised. Worked on five sample merchants.
Read article
XLOOKUP returning several columns: category, subcategory, tag
One XLOOKUP over a merchant table can return category, subcategory and tag together, spilling into three cells. See the layout and the two-column variant.
Read article
XLOOKUP from the bottom: pull the latest amount paid to a biller
Use XLOOKUP search_mode -1 to pull the latest electricity bill amount from a long log without sorting, and see the LOOKUP(2,1/...) trick for older Excel.
Read article
XLOOKUP with wildcards for partial merchant names
XLOOKUP wildcards for partial merchant names: how match_mode 2 and the asterisk pattern work, and why the lookup direction is reversed for keywords.
Read article
XLOOKUP wildcard picks the wrong merchant: how to fix the match
Why a short keyword like amazon also matches Amazon Pay Bill in your XLOOKUP merchant list, and how to fix it with specific keywords and a match counter.
Read article
Year-end expense summary in Excel: pivot table by month and category
Build a year-end expense summary in Excel with a pivot table by month and category, plus a top-merchants pivot, with the matching steps for Google Sheets.
Read article
Year-over-year spending by category with % change
Build a year-over-year spending table by category in Excel: last year, this year, rupee change and percent change, with sorting and new categories handled.
Read article
Year-to-date expense total in Excel (calendar and fiscal)
Calculate year-to-date expenses in Excel for the calendar year or the April-March financial year with SUMIFS and TODAY, and build a monthly YTD column.
Read article
Zero-based budget in Excel: formulas that check you reach zero
Set up a zero-based budget in Excel with an income cell, category allocations and a Left to allocate formula that turns green at zero and red otherwise.
Read article
Zero-based budget template in Excel where every rupee has a job
Build a zero-based budget template in Excel with income at the top, every category allocated and a Left to assign cell that must reach zero each month.
Read article