THE SPENDIXAI JOURNAL

Make room for
better money habits.

Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.

READ. UNDERSTAND. PUT IT INTO PRACTICE.Original guides · SpendixAI Editorial

Find your next good read.

Small decisions. Clearer thinking. A useful place to start.

Clear

599 guides · Page 33 of 50

Take your time. Find what helps.
Editorial illustration for QUERY function: sum expenses by category in Google Sheets
Spreadsheets 4 min read

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
Editorial illustration for QUERY to group expenses by month in Google Sheets
Spreadsheets 4 min read

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
Editorial illustration for QUERY returns the wrong header rows: the headers argument explained
Spreadsheets 4 min read

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
Editorial illustration for QUERY label and format: rename headers and show rupees in results
Spreadsheets 4 min read

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
Editorial illustration for QUERY with LIKE: search transactions by merchant in Google Sheets
Spreadsheets 3 min read

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
Editorial illustration for QUERY order by and limit: top merchants by spend in Google Sheets
Spreadsheets 3 min read

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
Editorial illustration for QUERY error: unable to parse query string in Google Sheets
Spreadsheets 4 min read

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
Editorial illustration for QUERY with a date range in Google Sheets (where date between)
Spreadsheets 4 min read

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
Editorial illustration for RATE function in Excel: find the real interest rate on a loan offer
Spreadsheets 4 min read

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
Editorial illustration for Rebuild a running balance column to verify imported amounts
Spreadsheets 4 min read

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
Editorial illustration for Receivables ageing in Excel: 0-30, 31-60 and 61-90 day buckets
Spreadsheets 3 min read

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
Editorial illustration for Reconcile your expense sheet with a bank statement in Excel
Spreadsheets 3 min read

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