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 10 of 50
Take your time. Find what helps.
Formula to turn dd-mm-yyyy text into a date with DATE, LEFT and MID
Excel formula to turn dd-mm-yyyy text into a date: build it with DATE, LEFT and MID, learn why DATEVALUE depends on region, and cover dates without zeros.
Read article
DAX basics: SUM and CALCULATE for a category total in Power Pivot
Learn DAX basics for expense data: write Total Spend with SUM, build Food Spend with CALCULATE and a category filter, add both to a pivot, and know why.
Read article
Create a date table for your expense data model with DAX
Build a date table for your expense data model with DAX CALENDAR, add Year, Month and April to March Financial Year columns, mark it and link it to dates.
Read article
Compare spend with the same period last year using DAX
Compare spend with the same period last year in Power Pivot: add a SAMEPERIODLASTYEAR measure, a percentage change measure, and read the month pivot result.
Read article
DAX TOTALYTD with an April to March financial year end
Use DAX TOTALYTD with a 31 March year end so year-to-date spend resets each April. See a month-by-month pivot result and what to check if it misbehaves.
Read article
Day-of-week spending chart from transaction dates
Find which weekday you spend most: build daily totals, add a WEEKDAY helper, use AVERAGEIFS and chart it, with a note on small samples.
Read article
DB function: declining balance depreciation in Excel
Use Excel's DB function for declining balance depreciation: see what each argument does, work through five years of an example, and handle a part-year purchase.
Read article
Debt avalanche spreadsheet: highest interest rate first
Build a debt avalanche spreadsheet in Excel that pays the highest interest rate first and compares interest and payoff months with the snowball order.
Read article
Debt snowball spreadsheet with a month-by-month payoff table
Build a debt snowball spreadsheet with a month-by-month payoff table, where each cleared EMI rolls into the next loan, tested on three sample debts.
Read article
Delete blank rows quickly in a statement with Go To Special
Delete blank rows in an Excel statement using Go To Special, a safe helper-column method for partly empty rows, and the mistakes that remove real data.
Read article
Dependent dropdown for category and subcategory in Excel
Build a dependent dropdown in Excel so picking Food offers only Groceries, Dining and Delivery, using named ranges with INDIRECT or OFFSET.
Read article
Dependent dropdown in Google Sheets for category and subcategory
Dependent dropdown in Google Sheets for category and subcategory: a Lists tab, a helper formula with FILTER or QUERY, and the limits to watch for.
Read article