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

Take your time. Find what helps.
Editorial illustration for Compare two financial years side by side, April to March
Spreadsheets 3 min read

Compare two financial years side by side, April to March

Build a month-by-month April to March layout with two financial years side by side, a difference column and a running total, using SUMIFS on fiscal dates.

Read article
Editorial illustration for Compare two statement tabs in Google Sheets for unmatched rows
Spreadsheets 3 min read

Compare two statement tabs in Google Sheets for unmatched rows

Compare two tabs in Google Sheets to find unmatched rows: build a match key, flag with COUNTIF or XLOOKUP, list them with FILTER, and use IMPORTRANGE across files.

Read article
Editorial illustration for Compound interest calculator in Excel: formula, FV, yearly table
Spreadsheets 4 min read

Compound interest calculator in Excel: formula, FV, yearly table

Build a compound interest calculator in Excel with the manual formula, the FV function, a compounding frequency cell and a year-by-year table.

Read article
Editorial illustration for Conditional formatting with a custom formula in Google Sheets
Spreadsheets 3 min read

Conditional formatting with a custom formula in Google Sheets

Three custom-formula rules for an expenses sheet in Google Sheets: highlight a Dining row, an amount above a limit cell, and today's date, step by step.

Read article
Editorial illustration for Conditional formatting not working: common fixes for a sheet
Spreadsheets 4 min read

Conditional formatting not working: common fixes for a sheet

Conditional formatting not working? Check references, applies-to ranges, rule order and Stop If True, numbers stored as text and duplicate rules.

Read article
Editorial illustration for Conditional formatting to turn over-budget cells red in Excel
Spreadsheets 4 min read

Conditional formatting to turn over-budget cells red in Excel

Turn over-budget cells red in Excel with one formula rule, =$C2>$B2, and learn exactly which dollar signs to lock for a budget versus actual table.

Read article
Editorial illustration for Conditional formatting that flags overspending in your budget sheet
Spreadsheets 4 min read

Conditional formatting that flags overspending in your budget sheet

Colour your budget sheet amber at 80 percent and red at 100 percent of each category budget with two formula-based conditional formatting rules.

Read article
Editorial illustration for Convert 05-Jan-24 style text to real dates in Excel
Spreadsheets 4 min read

Convert 05-Jan-24 style text to real dates in Excel

Convert 05-Jan-24 style text to real dates in Excel: when DATEVALUE and Text to Columns just work, and a MATCH fallback when they do not.

Read article
Editorial illustration for Convert amounts like "1,234.50 Dr" into numbers in a sheet
Spreadsheets 4 min read

Convert amounts like "1,234.50 Dr" into numbers in a sheet

Convert bank amounts like "1,234.50 Dr" into real numbers with SUBSTITUTE, VALUE and a sign flip so debits are negative, in Excel and Google Sheets.

Read article
Editorial illustration for Convert dates written with dots, dashes or spaces to real dates
Spreadsheets 3 min read

Convert dates written with dots, dashes or spaces to real dates

Convert dates written with dots, dashes or spaces to real Excel dates: Find and Replace, SUBSTITUTE and Text to Columns, each checked with ISNUMBER.

Read article
Editorial illustration for Convert foreign card spends to INR with GOOGLEFINANCE
Spreadsheets 4 min read

Convert foreign card spends to INR with GOOGLEFINANCE

Convert foreign card spends to INR in Google Sheets with GOOGLEFINANCE, freeze the rate for each transaction as a value, and see why statements differ.

Read article
Editorial illustration for Convert a statement PDF to Excel using Get Data From PDF
Spreadsheets 4 min read

Convert a statement PDF to Excel using Get Data From PDF

Convert a bank statement PDF to Excel with Get Data From PDF: using the Navigator, joining pages, cleaning the table and checking the balance.

Read article