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

Take your time. Find what helps.
Editorial illustration for Flag unusually large expenses with average and standard deviation
Spreadsheets 3 min read

Flag unusually large expenses with average and standard deviation

Flag unusually large expenses in Excel by category: AVERAGEIFS plus STDEV.S on filtered data to mark anything above the average plus two standard deviations.

Read article
Editorial illustration for Flash Fill to extract the payee from messy narrations
Spreadsheets 4 min read

Flash Fill to extract the payee from messy narrations

Use Flash Fill and Ctrl+E to extract the payee from messy bank narrations, with checks for wrong guesses and a note on why it does not update.

Read article
Editorial illustration for Flat rate vs reducing balance interest: compare both in Excel
Spreadsheets 4 min read

Flat rate vs reducing balance interest: compare both in Excel

Compare a flat-rate loan quote with a reducing balance loan in Excel: compute the EMI, then use RATE to find the effective annual rate behind the same percentage.

Read article
Editorial illustration for Folder structure and file names for saved bank statements
Spreadsheets 4 min read

Folder structure and file names for saved bank statements

A folder tree and a year-month-account file naming pattern for bank statements that sorts correctly and makes a Power Query folder import easy.

Read article
Editorial illustration for FORECAST and TREND in Google Sheets for spending projections
Spreadsheets 4 min read

FORECAST and TREND in Google Sheets for spending projections

Apply FORECAST and TREND in Google Sheets to monthly spending totals, compare them with a chart trendline, and learn why they are fits, not promises.

Read article
Editorial illustration for FORECAST.LINEAR for next month's spending in Excel
Spreadsheets 4 min read

FORECAST.LINEAR for next month's spending in Excel

Use FORECAST.LINEAR in Excel on twelve months of totals to project next month's spending, with a worked example and a warning about lumpy months.

Read article
Editorial illustration for How wrong was your forecast? Compare forecast with actual spend
Spreadsheets 4 min read

How wrong was your forecast? Compare forecast with actual spend

Compare forecast with actual spending: add error columns in rupees and percent, average the misses, and use them to set next month's cushion.

Read article
Editorial illustration for Convert foreign trip expenses to rupees in Google Sheets
Spreadsheets 4 min read

Convert foreign trip expenses to rupees in Google Sheets

Convert foreign trip expenses to rupees in Google Sheets with GOOGLEFINANCE, a manual card-rate override and a way to log the markup on your statement.

Read article
Editorial illustration for Add formula columns to a Form responses sheet without breaking them
Spreadsheets 4 min read

Add formula columns to a Form responses sheet without breaking them

Why a formula dragged down a Form responses sheet stops on new submissions, and how ARRAYFORMULA in the header row or a separate clean tab keeps it working.

Read article
Editorial illustration for Format negative amounts in red with Indian comma grouping
Spreadsheets 4 min read

Format negative amounts in red with Indian comma grouping

Build an Excel custom format with four sections for positive, negative, zero and text, then add a rupee prefix, red negatives and Indian comma grouping.

Read article
Editorial illustration for Google Sheets #ERROR! and formula parse error: what they mean
Spreadsheets 4 min read

Google Sheets #ERROR! and formula parse error: what they mean

What Google Sheets #ERROR! and formula parse error mean, how to fix brackets, quotes and comma versus semicolon, and a table of common Sheets error messages.

Read article
Editorial illustration for Freelance hourly rate calculator sheet built from your expenses
Spreadsheets 4 min read

Freelance hourly rate calculator sheet built from your expenses

Build a freelance hourly rate calculator in Excel or Google Sheets from monthly costs, a tax set-aside and realistic billable hours, with a worked example.

Read article