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

Take your time. Find what helps.
Editorial illustration for Convert a statement PDF to Excel via Word: steps and limits
Spreadsheets 4 min read

Convert a statement PDF to Excel via Word: steps and limits

Convert a statement PDF to Excel via Word: open the PDF, copy the table, clean paragraph marks, and know what goes wrong with long statements.

Read article
Editorial illustration for Convert a statement range to an Excel Table and freeze headers
Spreadsheets 4 min read

Convert a statement range to an Excel Table and freeze headers

Turn a statement range into an Excel Table with Ctrl+T, use structured references, and freeze the header row so long transaction lists stay readable.

Read article
Editorial illustration for Convert text dates to real dates in Google Sheets
Spreadsheets 4 min read

Convert text dates to real dates in Google Sheets

Turn text dates like 05 Mar 2025 or 05-03-25 into real dates in Google Sheets using DATEVALUE, SPLIT and DATE, and set the locale so they stay correct.

Read article
Editorial illustration for Pasting a PDF statement into Excel puts everything in one column
Spreadsheets 4 min read

Pasting a PDF statement into Excel puts everything in one column

Pasting a PDF statement into Excel puts every line in one column. Here is why, and how Text to Columns and a few formulas rebuild the table.

Read article
Editorial illustration for Cost per km formula in Excel: fuel, service and EMI combined
Spreadsheets 4 min read

Cost per km formula in Excel: fuel, service and EMI combined

Work out cost per km in Excel: fuel, service, insurance, EMI and parking divided by odometer kilometres, with a variable-only and an all-in figure.

Read article
Editorial illustration for Cost per use: a sheet to see what a purchase really cost
Spreadsheets 4 min read

Cost per use: a sheet to see what a purchase really cost

Build a cost per use sheet: log each use of shoes, gym gear or a bike and watch cost per use and cost per month fall, with formulas that update by themselves.

Read article
Editorial illustration for COUNTIFS to count transactions per category in Excel
Spreadsheets 3 min read

COUNTIFS to count transactions per category in Excel

Count how many transactions fall in each category and month with COUNTIF and COUNTIFS, then divide spend by count to find your average ticket size.

Read article
Editorial illustration for Couple shared expenses in Google Sheets: a proportional split sheet
Spreadsheets 3 min read

Couple shared expenses in Google Sheets: a proportional split sheet

A Google Sheets template for couples with a Joint tab, personal tabs and a settle-up cell that splits shared bills by each partner's take-home pay.

Read article
Editorial illustration for Credit card bill payment counted twice in your spending totals
Spreadsheets 3 min read

Credit card bill payment counted twice in your spending totals

Why a credit card bill payment doubles your spending in a sheet, and how a Type column and SUMIFS leave transfers out so you count each rupee once.

Read article
Editorial illustration for Assign card swipes to the right statement month in a sheet
Spreadsheets 4 min read

Assign card swipes to the right statement month in a sheet

Tag each credit card swipe with the statement it will appear on using IF, DAY and EDATE, so you can see how much cash the next card bill needs.

Read article
Editorial illustration for Credit card EMI conversion: build the schedule with the fee
Spreadsheets 4 min read

Credit card EMI conversion: build the schedule with the fee

Build a credit card EMI conversion schedule in a sheet with PMT, then use RATE to see the effective rate once the one-time processing fee is added.

Read article
Editorial illustration for Cost of paying only the minimum due: a revolving interest sheet
Spreadsheets 4 min read

Cost of paying only the minimum due: a revolving interest sheet

A month-by-month sheet showing what paying only the minimum due on a card balance costs versus a fixed higher payment, with every rate left as an input.

Read article