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

Take your time. Find what helps.
Editorial illustration for Project month-end spending from what you have spent so far
Spreadsheets 4 min read

Project month-end spending from what you have spent so far

Project your month-end spending in Excel from what you have spent so far, compare it with the budget and flag a likely overspend, plus where the method fails.

Read article
Editorial illustration for Project-wise profit sheet for freelancers in Excel
Spreadsheets 4 min read

Project-wise profit sheet for freelancers in Excel

A project-wise profit sheet for freelancers in Excel: fee, direct costs, hours, profit per hour and a way to share a software subscription across projects.

Read article
Editorial illustration for Protect formula cells in an Excel expense workbook
Spreadsheets 4 min read

Protect formula cells in an Excel expense workbook

Protect formulas in Excel and keep entry columns open: unlock the input cells, lock the rest, then switch on Protect Sheet with filter and sort allowed.

Read article
Editorial illustration for Protect formulas in your expense sheet from accidental edits
Spreadsheets 4 min read

Protect formulas in your expense sheet from accidental edits

Lock the formula cells in your expense sheet and leave the input cells open, in Excel or Google Sheets, so family edits cannot overwrite your totals.

Read article
Editorial illustration for Protect workbook structure so nobody deletes or hides your tabs
Spreadsheets 4 min read

Protect workbook structure so nobody deletes or hides your tabs

Protect workbook structure in Excel so nobody deletes, hides or renames your tabs, and see how it differs from sheet protection and a file password.

Read article
Editorial illustration for Pull bank charges and interest lines into their own category
Spreadsheets 4 min read

Pull bank charges and interest lines into their own category

Flag fee, charge, GST-on-charge and interest lines with a keyword list and a helper column in Excel, so bank charges get their own monthly total.

Read article
Editorial illustration for Pull budget and actual into one table with XLOOKUP and SUMIFS
Spreadsheets 4 min read

Pull budget and actual into one table with XLOOKUP and SUMIFS

Combine a budget list and an expense log into one summary table with XLOOKUP for the budget and SUMIFS for the actual, ready for new categories.

Read article
Editorial illustration for Pull exchange rates into Google Sheets with GOOGLEFINANCE
Spreadsheets 4 min read

Pull exchange rates into Google Sheets with GOOGLEFINANCE

Use GOOGLEFINANCE("CURRENCY:USDINR") in Google Sheets for current and historical exchange rates, and learn why they are indicative and not your card's rate.

Read article
Editorial illustration for Quarter formula for an April to March financial year in Sheets
Spreadsheets 4 min read

Quarter formula for an April to March financial year in Sheets

The fiscal quarter formula for an April to March year: ROUNDUP on the fiscal month gives Q1 to Q4, plus a SUMIFS summary table laid out by quarter.

Read article
Editorial illustration for QUERY across two sheets with curly brackets in Google Sheets
Spreadsheets 4 min read

QUERY across two sheets with curly brackets in Google Sheets

Stack this year's and last year's tabs in Google Sheets with curly brackets, then run QUERY on the combined block, with matching columns and no repeated header.

Read article
Editorial illustration for Make a QUERY respond to a dropdown: category and month selectors
Spreadsheets 4 min read

Make a QUERY respond to a dropdown: category and month selectors

Make a Google Sheets QUERY react to dropdown cells for category and month: join cell values into the query string, handle quote rules and an All option.

Read article
Editorial illustration for QUERY with pivot: categories down, months across in Google Sheets
Spreadsheets 4 min read

QUERY with pivot: categories down, months across in Google Sheets

Build a category-by-month grid in Google Sheets with QUERY and its pivot clause, using a helper month column instead of a pivot table.

Read article