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 33 of 50
Take your time. Find what helps.
QUERY function: sum expenses by category in Google Sheets
Sum expenses by category in Google Sheets with QUERY, with each clause of the select, group by, order by and label statement explained in turn.
Read article
QUERY to group expenses by month in Google Sheets
Group expenses by month in Google Sheets with QUERY: use year() and month()+1, avoid the zero-based month trap, and return readable month labels.
Read article
QUERY returns the wrong header rows: the headers argument explained
Google Sheets QUERY showing an extra header row or missing one? Learn what the third headers argument does and how to set it or trim the range for statements.
Read article
QUERY label and format: rename headers and show rupees in results
Use the QUERY label and format clauses in Google Sheets to rename headers like Total spend and show rupee values, plus the quote mistakes that break the query.
Read article
QUERY with LIKE: search transactions by merchant in Google Sheets
Build a one-cell search box in Google Sheets: type swiggy and QUERY lists every matching transaction using contains or like, ignoring upper and lower case.
Read article
QUERY order by and limit: top merchants by spend in Google Sheets
Find your top 10 merchants by spend in Google Sheets with QUERY: group by merchant, sum amount, order by sum descending, limit 10, and label the header.
Read article
QUERY error: unable to parse query string in Google Sheets
Fix the Google Sheets QUERY error unable to parse query string with a checklist of causes: missing quotes, column letters versus Col1, clause order, locale.
Read article
QUERY with a date range in Google Sheets (where date between)
Filter by date range in a Google Sheets QUERY: the date literal syntax, building it from cells with TEXT, and why you get no results.
Read article
RATE function in Excel: find the real interest rate on a loan offer
Use Excel's RATE function to find the real interest rate behind a loan quote from the amount, EMI and tenure, and adjust it for the processing fee.
Read article
Rebuild a running balance column to verify imported amounts
Rebuild a running balance in Excel from the opening balance and signed amounts, compare it with the bank column and find the first row that diverges.
Read article
Receivables ageing in Excel: 0-30, 31-60 and 61-90 day buckets
Build an accounts receivable ageing report in Excel: days overdue from the due date, SUMIFS buckets of 0-30, 31-60 and 61-90 days per customer, plus a pivot option.
Read article
Reconcile your expense sheet with a bank statement in Excel
Reconcile your expense sheet with a bank statement in Excel: paste the statement beside it, match rows with COUNTIFS, list the gaps and verify the balance.
Read article