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 41 of 50
Take your time. Find what helps.
SORTN to get the top 5 expenses in Google Sheets
Get the five biggest expenses in Google Sheets with a single SORTN formula, handle ties properly and combine it with FILTER for one month.
Read article
Round-up savings column: save the spare change from each spend
Make a round-up savings column in Google Sheets or Excel: CEILING each spend to the next ten rupees and sum the spare change for the month.
Read article
SPARKLINE trend for each spending category in Google Sheets
Build a SPARKLINE trend for each spending category in Google Sheets: a mini line chart per row, same scale across rows, with colour and high-point options.
Read article
Sparklines for each spending category in Excel
Add a line sparkline per spending category across twelve months in Excel, with high and low markers and a shared axis so small and large categories compare fairly.
Read article
Spending by day of the week in Excel with WEEKDAY
Find which day of the week your money leaves with WEEKDAY and SUMPRODUCT, from Monday to Sunday totals to a weekend versus weekday share.
Read article
Build a spending dashboard in Google Sheets
Build a one-tab spending dashboard in Google Sheets with QUERY, a pivot table, SPARKLINE and charts, plus what to do when you paste in new data.
Read article
#SPILL! error in an Excel expense summary: causes and fixes
Fix the #SPILL! error in an Excel expense summary: find the blocking cell, clear merged cells, handle tables, and resize formulas that spill too far.
Read article
The # spill reference: summaries and charts that grow with your data
Use the # spill reference in Excel so a category summary and its chart grow on their own when a new spending category appears in your data.
Read article
Split amounts like 1,200.00 Dr into a number and a Dr/Cr flag
Split a statement amount like 1,200.00 Dr into a number and a Dr/Cr flag with LEFT, RIGHT and TRIM, with or without a space, then a signed column.
Read article
Split a bill unevenly in Google Sheets: shares, weights and rounding
Split a bill unevenly in Google Sheets with weights, a SUMPRODUCT share formula and rounding that adds up, using a dinner where two people skipped dessert.
Read article
Split currency code from amount text like "USD 12.50"
Split text such as USD 12.50 into a currency code and a numeric amount in Excel using LEFT, MID, VALUE, Text to Columns or Flash Fill, then test for unknown codes.
Read article
Split date and time from a transaction timestamp in Excel
Split a date and time in Excel from a transaction timestamp: INT and MOD for true date-times, and Text to Columns or formulas when the stamp is text.
Read article