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

Take your time. Find what helps.
Editorial illustration for Rupee symbol and special characters garbled when opening a CSV
Spreadsheets 4 min read

Rupee symbol and special characters garbled when opening a CSV

Rupee symbol showing as odd characters in a CSV opened in Excel? Learn why UTF-8 and ANSI clash, how to reopen the file correctly and how to repair damage.

Read article
Editorial illustration for Salary day split sheet: divide your paycheque in Google Sheets
Spreadsheets 4 min read

Salary day split sheet: divide your paycheque in Google Sheets

Divide your salary on payday with a Google Sheets plan that allocates rent, EMI, bills, SIP and savings, flags over-allocation and adds a second salary.

Read article
Editorial illustration for Discount and final price formulas in Excel for sale shopping
Spreadsheets 3 min read

Discount and final price formulas in Excel for sale shopping

Discount formulas for Excel: price after discount, discount percent from two prices, stacked card and coupon offers, and a two-shop comparison table.

Read article
Editorial illustration for A salon sheet for daily sales, products used and staff commission
Spreadsheets 4 min read

A salon sheet for daily sales, products used and staff commission

A salon accounts sheet in Excel: daily services sold, staff commission from editable rates, product usage and a simple monthly profit view with formulas.

Read article
Editorial illustration for Save a cleaned statement as XLSX or CSV: what each one keeps
Spreadsheets 4 min read

Save a cleaned statement as XLSX or CSV: what each one keeps

XLSX or CSV for bank statement data? A side-by-side look at what each keeps, from formulas and dates to leading zeros, and when to use which.

Read article
Editorial illustration for How much to save each month for a goal: the PMT formula in Excel
Spreadsheets 4 min read

How much to save each month for a goal: the PMT formula in Excel

Work out how much to save each month for a goal with Excel's PMT formula, including an assumed rate, an existing balance and the zero-interest shortcut.

Read article
Editorial illustration for Savings goal tracker spreadsheet with a progress bar
Spreadsheets 3 min read

Savings goal tracker spreadsheet with a progress bar

Build a savings goal tracker in Excel with target, deadline, percentage complete, a text progress bar and the monthly amount each goal needs.

Read article
Editorial illustration for Savings rate formula in Excel (income minus expenses)
Spreadsheets 3 min read

Savings rate formula in Excel (income minus expenses)

Savings rate formula in Excel: (income minus expenses) divided by income, built with SUMIFS for each month, IFERROR for zero income and a weighted average.

Read article
Editorial illustration for SCAN function: a running balance in one spilled formula
Spreadsheets 4 min read

SCAN function: a running balance in one spilled formula

Replace a fill-down running balance column with one SCAN formula that starts from an opening balance. Covers inserted rows; needs Microsoft 365.

Read article
Editorial illustration for Scanned statement PDF to Excel with OCR: what to check afterwards
Spreadsheets 4 min read

Scanned statement PDF to Excel with OCR: what to check afterwards

Scanned bank statement PDF to Excel with OCR: what the software gets wrong, three checks that catch it and a balance reconciliation at the end.

Read article
Editorial illustration for Scenario Manager in Excel: save and compare budget cases
Spreadsheets 4 min read

Scenario Manager in Excel: save and compare budget cases

Use Excel's Scenario Manager to save named budget cases with rent, income and EMI as changing cells, then build a Scenario Summary report to compare them.

Read article
Editorial illustration for A scenario table with a dropdown: lean, base and stretch budgets
Spreadsheets 4 min read

A scenario table with a dropdown: lean, base and stretch budgets

Build a scenario table with a dropdown in Excel or Sheets: lean, base and stretch budgets, with INDEX and MATCH feeding every formula from one choice.

Read article