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 42 of 50
Take your time. Find what helps.
SPLIT function in Google Sheets: break narrations into columns
Learn the SPLIT function in Google Sheets to break a slash-separated bank narration into columns, pick one part with INDEX, and know when the menu command is better.
Read article
SPLIT on several separators at once: slash, dash and space
See how to pass several separators to SPLIT in Google Sheets, what split_by_each and remove_empty do, and clean a messy NEFT-style narration in one formula.
Read article
Split a narration into columns by slash with Text to Columns
Split a bank narration into separate columns at each slash with Excel's Text to Columns, keep the original column safe and handle uneven rows.
Read article
Split one amount column into separate debit and credit columns
Split one signed amount column into separate debit and credit columns with MAX(0,...) formulas, plus a check that debit minus credit equals the original.
Read article
Split a semicolon or pipe separated statement file into columns
Split a semicolon or pipe separated bank statement file into Excel columns using Text to Columns, or Power Query when you want it repeatable.
Read article
Spreadsheet cannot read your bank statement PDF: what to do
What to do when a spreadsheet cannot read your bank statement PDF: retyping, copy-paste, CSV or Excel download, converters or an app, and each one's risks.
Read article
When your spreadsheet has 40 categories: how to simplify them
Too many expense categories in your spreadsheet? Audit each category with COUNTIF and SUMIF, merge the rare ones and settle on 12 to 15 for a family.
Read article
Spreadsheet or app for freelancers: tracking client income
Spreadsheet or app for freelancer expense tracking? Compare invoice, TDS and GST columns, business versus personal spends, and quarter-end totals.
Read article
Spreadsheet vs app for small business expenses: where each fits
Compare a cash book spreadsheet with an expense app for a one-person business: GST fields, receipts, payment modes, accountant sharing and warning signs.
Read article
Stacked column chart of monthly spend by category in Excel
Build a stacked column chart of monthly spend by category in Excel from a SUMIFS grid, order the series sensibly and know when 100% stacked reads better.
Read article
Stacked column chart of categories by month: build and read it
Build a stacked column chart of expenses by month in Excel or Sheets, learn when it shows category mix, and how it compares with 100 percent stacked.
Read article
Standardise column names and order across different statement files
Build a column-mapping table and use Power Query to rename and reorder different statement headings into one standard layout before you append the files.
Read article