THE SPENDIXAI JOURNAL

Make room for
better money habits.

Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.

READ. UNDERSTAND. PUT IT INTO PRACTICE.Original guides · SpendixAI Editorial

Find your next good read.

Small decisions. Clearer thinking. A useful place to start.

Clear

599 guides · Page 41 of 50

Take your time. Find what helps.
Editorial illustration for SORTN to get the top 5 expenses in Google Sheets
Spreadsheets 3 min read

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
Editorial illustration for Round-up savings column: save the spare change from each spend
Spreadsheets 3 min read

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
Editorial illustration for SPARKLINE trend for each spending category in Google Sheets
Spreadsheets 4 min read

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
Editorial illustration for Sparklines for each spending category in Excel
Spreadsheets 3 min read

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
Editorial illustration for Spending by day of the week in Excel with WEEKDAY
Spreadsheets 4 min read

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
Editorial illustration for Build a spending dashboard in Google Sheets
Spreadsheets 4 min read

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
Editorial illustration for #SPILL! error in an Excel expense summary: causes and fixes
Spreadsheets 4 min read

#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
Editorial illustration for The # spill reference: summaries and charts that grow with your data
Spreadsheets 4 min read

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
Editorial illustration for Split amounts like 1,200.00 Dr into a number and a Dr/Cr flag
Spreadsheets 4 min read

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
Editorial illustration for Split a bill unevenly in Google Sheets: shares, weights and rounding
Spreadsheets 3 min read

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
Editorial illustration for Split currency code from amount text like "USD 12.50"
Spreadsheets 4 min read

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
Editorial illustration for Split date and time from a transaction timestamp in Excel
Spreadsheets 3 min read

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