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

Take your time. Find what helps.
Editorial illustration for Formula to turn dd-mm-yyyy text into a date with DATE, LEFT and MID
Spreadsheets 4 min read

Formula to turn dd-mm-yyyy text into a date with DATE, LEFT and MID

Excel formula to turn dd-mm-yyyy text into a date: build it with DATE, LEFT and MID, learn why DATEVALUE depends on region, and cover dates without zeros.

Read article
Editorial illustration for DAX basics: SUM and CALCULATE for a category total in Power Pivot
Spreadsheets 4 min read

DAX basics: SUM and CALCULATE for a category total in Power Pivot

Learn DAX basics for expense data: write Total Spend with SUM, build Food Spend with CALCULATE and a category filter, add both to a pivot, and know why.

Read article
Editorial illustration for Create a date table for your expense data model with DAX
Spreadsheets 4 min read

Create a date table for your expense data model with DAX

Build a date table for your expense data model with DAX CALENDAR, add Year, Month and April to March Financial Year columns, mark it and link it to dates.

Read article
Editorial illustration for Compare spend with the same period last year using DAX
Spreadsheets 4 min read

Compare spend with the same period last year using DAX

Compare spend with the same period last year in Power Pivot: add a SAMEPERIODLASTYEAR measure, a percentage change measure, and read the month pivot result.

Read article
Editorial illustration for DAX TOTALYTD with an April to March financial year end
Spreadsheets 4 min read

DAX TOTALYTD with an April to March financial year end

Use DAX TOTALYTD with a 31 March year end so year-to-date spend resets each April. See a month-by-month pivot result and what to check if it misbehaves.

Read article
Editorial illustration for Day-of-week spending chart from transaction dates
Spreadsheets 3 min read

Day-of-week spending chart from transaction dates

Find which weekday you spend most: build daily totals, add a WEEKDAY helper, use AVERAGEIFS and chart it, with a note on small samples.

Read article
Editorial illustration for DB function: declining balance depreciation in Excel
Spreadsheets 4 min read

DB function: declining balance depreciation in Excel

Use Excel's DB function for declining balance depreciation: see what each argument does, work through five years of an example, and handle a part-year purchase.

Read article
Editorial illustration for Debt avalanche spreadsheet: highest interest rate first
Spreadsheets 4 min read

Debt avalanche spreadsheet: highest interest rate first

Build a debt avalanche spreadsheet in Excel that pays the highest interest rate first and compares interest and payoff months with the snowball order.

Read article
Editorial illustration for Debt snowball spreadsheet with a month-by-month payoff table
Spreadsheets 4 min read

Debt snowball spreadsheet with a month-by-month payoff table

Build a debt snowball spreadsheet with a month-by-month payoff table, where each cleared EMI rolls into the next loan, tested on three sample debts.

Read article
Editorial illustration for Delete blank rows quickly in a statement with Go To Special
Spreadsheets 4 min read

Delete blank rows quickly in a statement with Go To Special

Delete blank rows in an Excel statement using Go To Special, a safe helper-column method for partly empty rows, and the mistakes that remove real data.

Read article
Editorial illustration for Dependent dropdown for category and subcategory in Excel
Spreadsheets 3 min read

Dependent dropdown for category and subcategory in Excel

Build a dependent dropdown in Excel so picking Food offers only Groceries, Dining and Delivery, using named ranges with INDIRECT or OFFSET.

Read article
Editorial illustration for Dependent dropdown in Google Sheets for category and subcategory
Spreadsheets 4 min read

Dependent dropdown in Google Sheets for category and subcategory

Dependent dropdown in Google Sheets for category and subcategory: a Lists tab, a helper formula with FILTER or QUERY, and the limits to watch for.

Read article