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 40 of 50

Take your time. Find what helps.
Editorial illustration for Signs your statement spreadsheet has outgrown Excel
Spreadsheets 4 min read

Signs your statement spreadsheet has outgrown Excel

Signs your statement spreadsheet has outgrown Excel, how to count your clean-up hours, and what to keep from the workbook if you move to a tracker.

Read article
Editorial illustration for Simple vs compound interest side by side in a spreadsheet
Spreadsheets 4 min read

Simple vs compound interest side by side in a spreadsheet

Put simple and compound interest side by side in a spreadsheet for the same loan, see the gap grow year by year, and settle terms with a relative clearly.

Read article
Editorial illustration for Sinking fund formula: set aside monthly for yearly bills in Excel
Spreadsheets 4 min read

Sinking fund formula: set aside monthly for yearly bills in Excel

Build a sinking fund sheet in Excel: list yearly bills, count the months left, divide to get the monthly amount and track how funded each bill is.

Read article
Editorial illustration for Sinking fund tracker in Excel: monthly set-aside per goal
Spreadsheets 3 min read

Sinking fund tracker in Excel: monthly set-aside per goal

Make a sinking fund spreadsheet in Excel that shows the monthly amount to set aside for insurance, festivals, school fees and other yearly costs.

Read article
Editorial illustration for SIP future value in Excel with the FV function (assumed return)
Spreadsheets 4 min read

SIP future value in Excel with the FV function (assumed return)

Use the FV function to see what a monthly SIP could grow to at an assumed return: the formula, the minus sign, and begin versus end of month.

Read article
Editorial illustration for Add slicers to an expense pivot table in Excel
Spreadsheets 4 min read

Add slicers to an expense pivot table in Excel

Add slicers to an Excel expense pivot table, connect them to two pivots and a chart with Report Connections, and build a one-sheet dashboard.

Read article
Editorial illustration for Use a slicer in Google Sheets to filter expenses by category
Spreadsheets 4 min read

Use a slicer in Google Sheets to filter expenses by category

Use a slicer in Google Sheets to filter expenses by category: add it from the Data menu, set the column, use several slicers, and compare Filter views.

Read article
Editorial illustration for SLN function: depreciate a laptop evenly over its life in Excel
Spreadsheets 3 min read

SLN function: depreciate a laptop evenly over its life in Excel

Use the SLN function in Excel to depreciate a work laptop evenly over its life, get a yearly and monthly figure, and see why it is not the tax rate.

Read article
Editorial illustration for Small shop monthly profit sheet in Excel: sales, stock, expenses
Spreadsheets 4 min read

Small shop monthly profit sheet in Excel: sales, stock, expenses

A small shop monthly profit sheet for Excel: sales, opening and closing stock, purchases, wages, rent and other costs, giving gross margin and a net figure.

Read article
Editorial illustration for Society maintenance collection tracker sheet for a small RWA
Spreadsheets 4 min read

Society maintenance collection tracker sheet for a small RWA

A treasurer's sheet for a thirty-flat society: flat-wise monthly receipts and arrears, an expense tab for security and repairs, and a monthly fund balance.

Read article
Editorial illustration for Sort months April to March in a pivot table or chart
Spreadsheets 4 min read

Sort months April to March in a pivot table or chart

Make a pivot table or chart show months in April to March order: a fiscal month helper column, a custom list, or a Power Query column, with steps for each.

Read article
Editorial illustration for SORTBY: sort expenses by category, then by amount, in one formula
Spreadsheets 4 min read

SORTBY: sort expenses by category, then by amount, in one formula

Sort an expense table by category A to Z, then amount largest first, with one SORTBY formula that updates as rows are added. Excel 2021 or 365.

Read article