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 48 of 50
Take your time. Find what helps.
VLOOKUP exact match to categorise merchants in a sheet
Use VLOOKUP with FALSE to categorise merchants in a sheet: the formula, the locked table range, and why exact match matters, with a worked mistake.
Read article
VLOOKUP not working on merchant names: spaces and hidden characters
VLOOKUP returning #N/A though the merchant name looks identical? Find hidden spaces and CHAR 160 characters with LEN and clean them with SUBSTITUTE.
Read article
VLOOKUP vs XLOOKUP vs INDEX MATCH for expense categories
Compare VLOOKUP, XLOOKUP and INDEX MATCH on a merchant-category table: readability, left lookups, missing values and older Excel or Sheets support.
Read article
Volatile functions slowing Excel: TODAY, INDIRECT and OFFSET
Why TODAY, INDIRECT and OFFSET make a big Excel statement file slow, which other functions are volatile, and what to use instead, with formulas you can copy.
Read article
VSTACK: combine monthly expense sheets into one table in Excel
Use VSTACK in Excel 365 to combine twelve monthly expense tabs into one table, with a header row and blank rows removed, instead of copy-pasting.
Read article
VSTACK to stack several statement tables in Excel 365
Stack several monthly statement tables into one list with VSTACK in Excel 365, add a source label with HSTACK, and see how it compares with Power Query.
Read article
Waterfall chart: income to savings in Excel
Build a waterfall chart from monthly income through category spending to savings in Excel, set the last bar as a total, and use a stacked-column fallback.
Read article
Wedding budget template in Excel with vendor advance and balance
A wedding budget template in Excel for India with vendor quote, advance, balance due, due date, who paid and a total-versus-budget check with contingency.
Read article
Wedding catering cost sheet: per-plate rate by guest count
Compare three caterer quotes against 300, 400 and 500 guests in one grid, with service charge as its own line and the cost of each extra fifty guests.
Read article
Weekday name and week number from a date for spend analysis
Add weekday name and week number columns in Excel with TEXT, WEEKDAY and ISOWEEKNUM so you can chart spending by day of week or build a heat map.
Read article
Weekly expense tracker template in Excel with a seven-day grid
A weekly expense tracker template in Excel: a seven-day grid by category, weekly limit and left-to-spend cell, plus how to roll weeks into months safely.
Read article
A ten-minute weekly money review using your spreadsheet
A ten-minute weekly money review for your spreadsheet: update, check three numbers with formulas, clear unclear rows and note one change for next week.
Read article