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

Take your time. Find what helps.
Editorial illustration for Get an email when someone edits your shared sheet, without scripts
Spreadsheets 4 min read

Get an email when someone edits your shared sheet, without scripts

Get an email when someone edits your shared Google Sheet using Notification settings, no scripts, and learn its limits, including why one cell cannot be watched.

Read article
Editorial illustration for Google Sheets slow with a big statement: what to change
Spreadsheets 4 min read

Google Sheets slow with a big statement: what to change

Google Sheets slow with a big bank statement? Fixes in order of impact: bounded ranges, fewer ARRAYFORMULA and IMPORTRANGE calls, and splitting by year.

Read article
Editorial illustration for Version history in Google Sheets: restore and name versions
Spreadsheets 4 min read

Version history in Google Sheets: restore and name versions

Open Google Sheets version history, restore or copy an earlier version, and name a version at financial-year close. Learn how restoring differs from copying.

Read article
Editorial illustration for Group dates by month and year in a pivot table
Spreadsheets 4 min read

Group dates by month and year in a pivot table

Group dates by month and year in an Excel or Google Sheets pivot table, so January 2026 and January 2027 never merge, and fix the cannot-group error.

Read article
Editorial illustration for Group small categories into "Other" before charting spending
Spreadsheets 4 min read

Group small categories into "Other" before charting spending

Stop a pie chart from becoming unreadable: group small spending categories into Other with a helper column or pivot. Includes a 14 to 7 example.

Read article
Editorial illustration for GROUPBY function: one-formula expense summary in Excel 365
Spreadsheets 4 min read

GROUPBY function: one-formula expense summary in Excel 365

Use the GROUPBY function in Excel 365 to total expenses by category with one formula, sort largest first and add a grand total, no pivot table needed.

Read article
Editorial illustration for Remove GST from a price in Excel: inclusive to exclusive formula
Spreadsheets 3 min read

Remove GST from a price in Excel: inclusive to exclusive formula

Remove GST from a bill in Excel: divide the total by one plus the rate for the base price, subtract for the tax, and add a check column for every invoice.

Read article
Editorial illustration for GST invoice tracker in Excel for a small business
Spreadsheets 4 min read

GST invoice tracker in Excel for a small business

Build a GST invoice tracker in Excel with CGST, SGST and IGST columns, payment status and a monthly summary of tax collected and money outstanding.

Read article
Editorial illustration for GST purchase register in Excel for tracking input bills
Spreadsheets 4 min read

GST purchase register in Excel for tracking input bills

A GST purchase register in Excel for input bills: supplier, GSTIN, bill number, taxable value, tax split, paid status and checks for missing GSTIN.

Read article
Editorial illustration for Hide helper columns and gridlines before you share a sheet as PDF
Spreadsheets 4 min read

Hide helper columns and gridlines before you share a sheet as PDF

A checklist for sharing an Excel sheet as a clean PDF: hide helper columns, remove personal details, turn off gridlines, add a footer and check the preview.

Read article
Editorial illustration for Highlight duplicate transactions in Google Sheets
Spreadsheets 4 min read

Highlight duplicate transactions in Google Sheets

Highlight duplicate transactions in Google Sheets with a COUNTIFS custom-formula rule, so only rows repeated on every field light up and not single-column matches.

Read article
Editorial illustration for Highlight expenses above a chosen amount in Excel
Spreadsheets 4 min read

Highlight expenses above a chosen amount in Excel

Highlight expenses above a chosen amount in Excel with a Greater Than rule that reads its limit from a cell, so you can change the limit without edits.

Read article