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

Take your time. Find what helps.
Editorial illustration for Power Query left anti join: list unmatched bank and ledger rows
Spreadsheets 3 min read

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
Editorial illustration for Merge queries in Power Query to put budget beside actual spend
Spreadsheets 3 min read

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
Editorial illustration for Power Query parameter: change your statement folder in one place
Spreadsheets 4 min read

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
Editorial illustration for Power Query error about privacy levels when you merge queries
Spreadsheets 4 min read

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
Editorial illustration for Reference or Duplicate in Power Query: which to use for statements
Spreadsheets 4 min read

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
Editorial illustration for Refresh Power Query data when the file opens, or on a timer
Spreadsheets 4 min read

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
Editorial illustration for Power Query: remove top rows and promote headers on a statement
Spreadsheets 4 min read

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
Editorial illustration for Power Query refresh taking minutes: speed up a big statement folder
Spreadsheets 4 min read

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
Editorial illustration for Power Query: split a narration column by delimiter
Spreadsheets 4 min read

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
Editorial illustration for Power Query: unpivot debit and credit columns into one amount column
Spreadsheets 3 min read

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
Editorial illustration for Power Query workbook says file not found on another computer
Spreadsheets 4 min read

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
Editorial illustration for Print an Excel dashboard to a one-page PDF
Spreadsheets 4 min read

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