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 8 of 50
Take your time. Find what helps.
Convert a statement PDF to Excel via Word: steps and limits
Convert a statement PDF to Excel via Word: open the PDF, copy the table, clean paragraph marks, and know what goes wrong with long statements.
Read article
Convert a statement range to an Excel Table and freeze headers
Turn a statement range into an Excel Table with Ctrl+T, use structured references, and freeze the header row so long transaction lists stay readable.
Read article
Convert text dates to real dates in Google Sheets
Turn text dates like 05 Mar 2025 or 05-03-25 into real dates in Google Sheets using DATEVALUE, SPLIT and DATE, and set the locale so they stay correct.
Read article
Pasting a PDF statement into Excel puts everything in one column
Pasting a PDF statement into Excel puts every line in one column. Here is why, and how Text to Columns and a few formulas rebuild the table.
Read article
Cost per km formula in Excel: fuel, service and EMI combined
Work out cost per km in Excel: fuel, service, insurance, EMI and parking divided by odometer kilometres, with a variable-only and an all-in figure.
Read article
Cost per use: a sheet to see what a purchase really cost
Build a cost per use sheet: log each use of shoes, gym gear or a bike and watch cost per use and cost per month fall, with formulas that update by themselves.
Read article
COUNTIFS to count transactions per category in Excel
Count how many transactions fall in each category and month with COUNTIF and COUNTIFS, then divide spend by count to find your average ticket size.
Read article
Couple shared expenses in Google Sheets: a proportional split sheet
A Google Sheets template for couples with a Joint tab, personal tabs and a settle-up cell that splits shared bills by each partner's take-home pay.
Read article
Credit card bill payment counted twice in your spending totals
Why a credit card bill payment doubles your spending in a sheet, and how a Type column and SUMIFS leave transfers out so you count each rupee once.
Read article
Assign card swipes to the right statement month in a sheet
Tag each credit card swipe with the statement it will appear on using IF, DAY and EDATE, so you can see how much cash the next card bill needs.
Read article
Credit card EMI conversion: build the schedule with the fee
Build a credit card EMI conversion schedule in a sheet with PMT, then use RATE to see the effective rate once the one-time processing fee is added.
Read article
Cost of paying only the minimum due: a revolving interest sheet
A month-by-month sheet showing what paying only the minimum due on a card balance costs versus a fixed higher payment, with every rate left as an input.
Read article