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 17 of 50
Take your time. Find what helps.
Flag unusually large expenses with average and standard deviation
Flag unusually large expenses in Excel by category: AVERAGEIFS plus STDEV.S on filtered data to mark anything above the average plus two standard deviations.
Read article
Flash Fill to extract the payee from messy narrations
Use Flash Fill and Ctrl+E to extract the payee from messy bank narrations, with checks for wrong guesses and a note on why it does not update.
Read article
Flat rate vs reducing balance interest: compare both in Excel
Compare a flat-rate loan quote with a reducing balance loan in Excel: compute the EMI, then use RATE to find the effective annual rate behind the same percentage.
Read article
Folder structure and file names for saved bank statements
A folder tree and a year-month-account file naming pattern for bank statements that sorts correctly and makes a Power Query folder import easy.
Read article
FORECAST and TREND in Google Sheets for spending projections
Apply FORECAST and TREND in Google Sheets to monthly spending totals, compare them with a chart trendline, and learn why they are fits, not promises.
Read article
FORECAST.LINEAR for next month's spending in Excel
Use FORECAST.LINEAR in Excel on twelve months of totals to project next month's spending, with a worked example and a warning about lumpy months.
Read article
How wrong was your forecast? Compare forecast with actual spend
Compare forecast with actual spending: add error columns in rupees and percent, average the misses, and use them to set next month's cushion.
Read article
Convert foreign trip expenses to rupees in Google Sheets
Convert foreign trip expenses to rupees in Google Sheets with GOOGLEFINANCE, a manual card-rate override and a way to log the markup on your statement.
Read article
Add formula columns to a Form responses sheet without breaking them
Why a formula dragged down a Form responses sheet stops on new submissions, and how ARRAYFORMULA in the header row or a separate clean tab keeps it working.
Read article
Format negative amounts in red with Indian comma grouping
Build an Excel custom format with four sections for positive, negative, zero and text, then add a rupee prefix, red negatives and Indian comma grouping.
Read article
Google Sheets #ERROR! and formula parse error: what they mean
What Google Sheets #ERROR! and formula parse error mean, how to fix brackets, quotes and comma versus semicolon, and a table of common Sheets error messages.
Read article
Freelance hourly rate calculator sheet built from your expenses
Build a freelance hourly rate calculator in Excel or Google Sheets from monthly costs, a tax set-aside and realistic billable hours, with a worked example.
Read article