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 7 of 50
Take your time. Find what helps.
Compare two financial years side by side, April to March
Build a month-by-month April to March layout with two financial years side by side, a difference column and a running total, using SUMIFS on fiscal dates.
Read article
Compare two statement tabs in Google Sheets for unmatched rows
Compare two tabs in Google Sheets to find unmatched rows: build a match key, flag with COUNTIF or XLOOKUP, list them with FILTER, and use IMPORTRANGE across files.
Read article
Compound interest calculator in Excel: formula, FV, yearly table
Build a compound interest calculator in Excel with the manual formula, the FV function, a compounding frequency cell and a year-by-year table.
Read article
Conditional formatting with a custom formula in Google Sheets
Three custom-formula rules for an expenses sheet in Google Sheets: highlight a Dining row, an amount above a limit cell, and today's date, step by step.
Read article
Conditional formatting not working: common fixes for a sheet
Conditional formatting not working? Check references, applies-to ranges, rule order and Stop If True, numbers stored as text and duplicate rules.
Read article
Conditional formatting to turn over-budget cells red in Excel
Turn over-budget cells red in Excel with one formula rule, =$C2>$B2, and learn exactly which dollar signs to lock for a budget versus actual table.
Read article
Conditional formatting that flags overspending in your budget sheet
Colour your budget sheet amber at 80 percent and red at 100 percent of each category budget with two formula-based conditional formatting rules.
Read article
Convert 05-Jan-24 style text to real dates in Excel
Convert 05-Jan-24 style text to real dates in Excel: when DATEVALUE and Text to Columns just work, and a MATCH fallback when they do not.
Read article
Convert amounts like "1,234.50 Dr" into numbers in a sheet
Convert bank amounts like "1,234.50 Dr" into real numbers with SUBSTITUTE, VALUE and a sign flip so debits are negative, in Excel and Google Sheets.
Read article
Convert dates written with dots, dashes or spaces to real dates
Convert dates written with dots, dashes or spaces to real Excel dates: Find and Replace, SUBSTITUTE and Text to Columns, each checked with ISNUMBER.
Read article
Convert foreign card spends to INR with GOOGLEFINANCE
Convert foreign card spends to INR in Google Sheets with GOOGLEFINANCE, freeze the rate for each transaction as a value, and see why statements differ.
Read article
Convert a statement PDF to Excel using Get Data From PDF
Convert a bank statement PDF to Excel with Get Data From PDF: using the Navigator, joining pages, cleaning the table and checking the balance.
Read article