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 30 of 50

Take your time. Find what helps.
Editorial illustration for Top 10 merchants by spend using a pivot table
Spreadsheets 4 min read

Top 10 merchants by spend using a pivot table

Find your top 10 merchants by spend with a pivot table: Value Filters Top 10 in Excel, and a sorted pivot or QUERY formula in Google Sheets.

Read article
Editorial illustration for Pivot table vs SUMIFS: which is better for expense summaries?
Spreadsheets 4 min read

Pivot table vs SUMIFS: which is better for expense summaries?

Pivot table or SUMIFS for an expense summary? Compare refresh, layout, new categories and sharing, with a clear recommendation for each use case.

Read article
Editorial illustration for PIVOTBY function: a category-by-month table from one formula
Spreadsheets 4 min read

PIVOTBY function: a category-by-month table from one formula

Build a category-by-month spending table with the PIVOTBY function, compare it with a normal pivot table, and use a SUMIFS fallback if you lack it.

Read article
Editorial illustration for Pocket money tracker sheet for kids in Google Sheets
Spreadsheets 3 min read

Pocket money tracker sheet for kids in Google Sheets

A pocket money tracker for kids in Google Sheets: allowance and gifts in, save, spend and give jars with running balances, printable or fillable on a tablet.

Read article
Editorial illustration for Power Query: change a column to date using locale for dd/mm/yyyy
Spreadsheets 4 min read

Power Query: change a column to date using locale for dd/mm/yyyy

Power Query change type using locale: set a date column to English (India) so dd/mm/yyyy text converts correctly on any PC, and keeps working on refresh.

Read article
Editorial illustration for Combine monthly bank statement CSV files with Power Query
Spreadsheets 5 min read

Combine monthly bank statement CSV files with Power Query

Combine monthly bank statement CSV files into one Excel table with Power Query, fix dates and amounts once, and refresh when a new file arrives.

Read article
Editorial illustration for Power Query: combine all statement files in a folder automatically
Spreadsheets 4 min read

Power Query: combine all statement files in a folder automatically

Use Power Query From Folder to combine all statement files in one folder into a single table, drop repeated header rows and keep each source file name.

Read article
Editorial illustration for Power Query: convert amount text to decimal without errors
Spreadsheets 4 min read

Power Query: convert amount text to decimal without errors

Convert amount text to decimal in Power Query without losing rows: the right step order, a try-otherwise column and a review table for error rows.

Read article
Editorial illustration for Add a custom column in Power Query to flag unusual transactions
Spreadsheets 3 min read

Add a custom column in Power Query to flag unusual transactions

Add a custom column in Power Query that flags large or suspiciously round transactions, with the Conditional Column dialog as a no-code alternative.

Read article
Editorial illustration for Power Query DataFormat.Error: we couldn't convert to Number
Spreadsheets 4 min read

Power Query DataFormat.Error: we couldn't convert to Number

Fix the Power Query error about converting to Number: find the failing rows, then clean Dr and Cr suffixes, commas, total rows and blank text first.

Read article
Editorial illustration for Power Query: extract text between delimiters from a narration
Spreadsheets 4 min read

Power Query: extract text between delimiters from a narration

Use Power Query's Extract Text Between Delimiters to pull a merchant name from a narration, with start and end index notes for repeated slashes.

Read article
Editorial illustration for Group By in Power Query: monthly category totals before you load
Spreadsheets 3 min read

Group By in Power Query: monthly category totals before you load

Use Group By in Power Query to total spending by month and category, count rows, and load a small summary table instead of thousands of transaction rows.

Read article