Make room for
better money habits.
Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.
Find your next good read.
Small decisions. Clearer thinking. A useful place to start.
599 guides · Page 19 of 50
Take your time. Find what helps.
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
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
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
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
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
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
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
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
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
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
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
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