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 31 of 50
Take your time. Find what helps.
Power Query left anti join: list unmatched bank and ledger rows
Use Power Query's Left Anti merge to list bank lines with no ledger match and the reverse, then load each result to its own review sheet that refreshes.
Read article
Merge queries in Power Query to put budget beside actual spend
Merge queries in Power Query to put each category's budget next to actual spend, add a variance column, and pick the right join kind from one short table.
Read article
Power Query parameter: change your statement folder in one place
Create a text parameter in Power Query for your statement folder path, use it in the Folder.Files step, and change the folder in one place when files move.
Read article
Power Query error about privacy levels when you merge queries
What the Power Query privacy levels message means when you merge a statement folder with a local table, the safe fixes, and what ignoring them changes.
Read article
Reference or Duplicate in Power Query: which to use for statements
Reference or Duplicate in Power Query? See how each behaves with one cleaned bank statement feeding a monthly and a merchant summary, and which to pick.
Read article
Refresh Power Query data when the file opens, or on a timer
Set a Power Query connection to refresh when the workbook opens or every few minutes, and learn why a closed Excel file can never refresh itself.
Read article
Power Query: remove top rows and promote headers on a statement
Remove top rows, promote the first row to headers and remove bottom rows in the right order in Power Query, so a same-layout statement loads every month.
Read article
Power Query refresh taking minutes: speed up a big statement folder
Power Query refresh taking minutes on a folder of bank statements? Practical steps: trim columns early, filter files first, avoid repeat reads, load smart.
Read article
Power Query: split a narration column by delimiter
Split a bank narration column by delimiter in Power Query, choose first, last or every slash, set types and refresh next month's file automatically.
Read article
Power Query: unpivot debit and credit columns into one amount column
Use Power Query to unpivot debit and credit columns into Type and Amount, then add a signed amount column that refreshes when new months arrive.
Read article
Power Query workbook says file not found on another computer
Why a Power Query workbook says the file was not found on another computer, how the absolute path in the Source step causes it, and how to fix it for good.
Read article
Print an Excel dashboard to a one-page PDF
Print an Excel dashboard to a single landscape page and save it as a PDF: set the print area, fit to one page, hide gridlines and check the preview.
Read article