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 21 of 50
Take your time. Find what helps.
Return "Uncategorised" instead of #N/A in a lookup formula
Return Uncategorised instead of #N/A in a lookup: when IFNA is safer than IFERROR, and how to filter the leftover rows for a quick review.
Read article
IFS vs nested IF for categorising expenses
Write the same expense categorising logic with nested IF, IFS and SWITCH, compare readability and what happens on no match, and when to use a lookup.
Read article
IF formula to choose IGST or CGST+SGST by state in Excel
Use an IF formula in Excel to compare the seller's state with the place of supply and fill either CGST and SGST or IGST, with a state dropdown list.
Read article
Import a bank statement CSV into Google Sheets with dates intact
Import a bank statement CSV into Google Sheets with the right locale and separator so dates such as 05/01 are read correctly, with a before and after.
Read article
Import a CSV bank statement into Google Sheets and clean it up
Import a CSV bank statement into Google Sheets: the File, Import options, a locale check for dates, and first clean-up formulas for text amounts.
Read article
Importing an old expense sheet: prepare the columns for CSV
Prepare an old expense sheet for CSV import: the minimum clean layout, plus fixes for merged cells, subtotal rows and amounts stored as text before export.
Read article
Import a statement CSV with Data > From Text/CSV, step by step
Import a bank statement CSV into Excel with Data > From Text/CSV, so narration commas, long references and dates load correctly, step by step.
Read article
IMPORTDATA: load a CSV from a link into Google Sheets
Use IMPORTDATA to load a public CSV or TSV link into Google Sheets, learn how often it refreshes, and see why it cannot read a bank statement behind a login.
Read article
IMPORTHTML: pull a table from a web page into your budget sheet
Use IMPORTHTML in Google Sheets to pull a public table into a helper tab with the index argument, and see why it returns empty or breaks when a page changes.
Read article
Combine two people's expense sheets with IMPORTRANGE
Combine two people's expense sheets into one summary with IMPORTRANGE in Google Sheets, handle the permission prompt and total by category with QUERY.
Read article
IMPORTRANGE #REF!: 'you need to connect these sheets' explained
Fix IMPORTRANGE #REF! and the 'you need to connect these sheets' message with the Allow access button, a range check and a three-step test.
Read article
IMPS narration: extract the beneficiary and mode in Excel
Split an IMPS narration into mode, reference and beneficiary in Excel, add a Mode column with SEARCH, and total spending by mode with a pivot.
Read article