THE SPENDIXAI JOURNAL

Make room for
better money habits.

Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.

READ. UNDERSTAND. PUT IT INTO PRACTICE.Original guides · SpendixAI Editorial

Find your next good read.

Small decisions. Clearer thinking. A useful place to start.

Clear

599 guides · Page 48 of 50

Take your time. Find what helps.
Editorial illustration for VLOOKUP exact match to categorise merchants in a sheet
Spreadsheets 4 min read

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
Editorial illustration for VLOOKUP not working on merchant names: spaces and hidden characters
Spreadsheets 3 min read

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
Editorial illustration for VLOOKUP vs XLOOKUP vs INDEX MATCH for expense categories
Spreadsheets 3 min read

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
Editorial illustration for Volatile functions slowing Excel: TODAY, INDIRECT and OFFSET
Spreadsheets 4 min read

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
Editorial illustration for VSTACK: combine monthly expense sheets into one table in Excel
Spreadsheets 3 min read

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
Editorial illustration for VSTACK to stack several statement tables in Excel 365
Spreadsheets 4 min read

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
Editorial illustration for Waterfall chart: income to savings in Excel
Spreadsheets 3 min read

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
Editorial illustration for Wedding budget template in Excel with vendor advance and balance
Spreadsheets 3 min read

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
Editorial illustration for Wedding catering cost sheet: per-plate rate by guest count
Spreadsheets 4 min read

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
Editorial illustration for Weekday name and week number from a date for spend analysis
Spreadsheets 3 min read

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
Editorial illustration for Weekly expense tracker template in Excel with a seven-day grid
Spreadsheets 4 min read

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
Editorial illustration for A ten-minute weekly money review using your spreadsheet
Spreadsheets 3 min read

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