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 49 of 50

Take your time. Find what helps.
Editorial illustration for Weekly spending limit with leftover rolling into the next week
Spreadsheets 3 min read

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
Editorial illustration for What-if analysis in Google Sheets without a Data Table feature
Spreadsheets 3 min read

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
Editorial illustration for What is Power Pivot, and do you need it for expense data?
Spreadsheets 4 min read

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
Editorial illustration for Which Excel versions have dynamic arrays, LET and LAMBDA?
Spreadsheets 4 min read

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
Editorial illustration for Which exchange rate to use for foreign card spend in a spreadsheet
Spreadsheets 4 min read

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
Editorial illustration for Who paid what: SUMIFS for shared household expenses
Spreadsheets 4 min read

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
Editorial illustration for SUMIFS slow on whole columns? Use tables or exact ranges
Spreadsheets 4 min read

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
Editorial illustration for Why your budget spreadsheet formulas keep breaking (and what to do)
Spreadsheets 4 min read

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
Editorial illustration for Work trip expense report template in Excel with daily allowance rows
Spreadsheets 3 min read

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
Editorial illustration for XIRR in Excel: finding the rate on payments made on irregular dates
Spreadsheets 3 min read

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
Editorial illustration for XLOOKUP approximate match for slabs, like cashback or fee tiers
Spreadsheets 3 min read

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
Editorial illustration for XLOOKUP to assign a category from the merchant name in Excel
Spreadsheets 3 min read

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