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 30 of 50
Take your time. Find what helps.
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
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
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
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
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
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
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
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
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
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
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
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