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 45 of 50
Take your time. Find what helps.
Tables in Google Sheets: column types, dropdowns and auto-fill rows
Convert an expense log to a Google Sheets table, set Date, Currency and Dropdown column types, and watch new rows inherit formatting. Notes for older files included.
Read article
Top N expenses in Excel 365 with TAKE and SORTBY
List the top N expenses in Excel 365 with TAKE and SORTBY, set N from a cell, and see the LARGE and INDEX method that works in older Excel.
Read article
Document and proof tracker sheet for tax-time paperwork
A tax-time paperwork tracker for Excel or Google Sheets: columns, sample rows and formulas that show which documents have arrived. No figures involved.
Read article
TDS gross to net calculator in Excel for a freelance invoice
Set up a TDS calculator in Excel for a freelance invoice: net receivable from the gross, and the reverse formula for the gross needed to receive a target.
Read article
TDS tracker for freelancers: matching client deductions in Excel
Set up a TDS tracker in Excel for freelancers that logs each client deduction, flags short deductions and totals TDS per client for the year.
Read article
Template or app: which to choose for your very first budget
Template or app for your very first budget? Use a three-question quiz on time, patience and spending habits to decide whether a sheet or a tracker suits you.
Read article
TEXTBEFORE, TEXTAFTER and TEXTSPLIT for narrations in Excel 365
Use TEXTBEFORE, TEXTAFTER and TEXTSPLIT in Excel 365 to cut bank narrations apart by delimiter, with nth-instance, if_not_found and spill examples.
Read article
List merchants per category in one cell with TEXTJOIN and FILTER
List every merchant in each spending category in one cell using TEXTJOIN, FILTER and UNIQUE, with no pivot table and results that update with your data.
Read article
Three-way match of invoice, bank and ledger in one sheet
Build a three-way match of invoice, bank and ledger in one sheet with lookups on invoice number and amount, giving statuses like Matched and Paid not booked.
Read article
Top 5 biggest expenses with LARGE and INDEX MATCH
List your five biggest expenses in Excel with LARGE and INDEX MATCH, including a trick for equal amounts, plus the SORTBY and TAKE shortcut.
Read article
Top 5 expenses in Excel using LARGE (works in older versions)
List your top 5 expenses in Excel with LARGE, fetch the merchant and date with INDEX and MATCH, and handle tied amounts. Works in older Excel versions too.
Read article
Find the top merchant in each category with MAXIFS and XLOOKUP
Find the top merchant in each spending category with a helper table, MAXIFS and XLOOKUP in Excel, with INDEX and MATCH for Google Sheets.
Read article