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

Take your time. Find what helps.
Editorial illustration for Depreciation for a part-year purchase: pro-rata by months in Excel
Spreadsheets 4 min read

Depreciation for a part-year purchase: pro-rata by months in Excel

How to prorate first-year depreciation for an asset bought mid-year: count months in use up to 31 March with DATEDIF, then charge that share in Excel.

Read article
Editorial illustration for A depreciation schedule for several assets in one Excel sheet
Spreadsheets 3 min read

A depreciation schedule for several assets in one Excel sheet

A fixed asset register in Excel with purchase date, cost, life and a financial-year grid of depreciation, filled from one formula copied down and across.

Read article
Editorial illustration for Design a Google Sheet that works on a phone screen
Spreadsheets 3 min read

Design a Google Sheet that works on a phone screen

Lay out a Google Sheet that works on a phone: narrow columns, a frozen header, a one-column summary tab, checkboxes and dropdowns instead of typing.

Read article
Editorial illustration for #DIV/0! in a savings rate or % change: fix it properly
Spreadsheets 3 min read

#DIV/0! in a savings rate or % change: fix it properly

How to fix #DIV/0! in a savings rate or month-on-month percent change by testing for zero with IF, and why a blanket IFERROR can hide real mistakes.

Read article
Editorial illustration for Diwali budget planner sheet: gifts, sweets, clothes and decor
Spreadsheets 3 min read

Diwali budget planner sheet: gifts, sweets, clothes and decor

A Diwali budget planner for Google Sheets: planned and actual spend by category, a gift list with bought status, and a comparison with last year's column.

Read article
Editorial illustration for Do you need an expense app if you only have one bank account?
Spreadsheets 4 min read

Do you need an expense app if you only have one bank account?

Do you need an expense tracker app with one bank account? A plain decision guide on when a monthly statement review is enough and when an app saves time.

Read article
Editorial illustration for Domestic help salary and attendance sheet in Excel
Spreadsheets 4 min read

Domestic help salary and attendance sheet in Excel

A domestic help salary and attendance sheet for Excel: monthly grid for maid, cook and driver, per-day deduction formula, advances and net payable.

Read article
Editorial illustration for Donut chart of category spending in Google Sheets
Spreadsheets 4 min read

Donut chart of category spending in Google Sheets

Make a pie chart of expenses in Google Sheets, shown as a donut: build the top six plus Other, insert the chart and turn on percentage labels.

Read article
Editorial illustration for Create a category dropdown list in Excel with Data Validation
Spreadsheets 3 min read

Create a category dropdown list in Excel with Data Validation

Create a category dropdown in Excel with Data Validation: a Lists sheet, a named range, the list rule, and a Stop alert that blocks typos in your expenses.

Read article
Editorial illustration for Dropdown from a range in Google Sheets for expense categories
Spreadsheets 4 min read

Dropdown from a range in Google Sheets for expense categories

Make a category dropdown in Google Sheets from a range: keep the list on its own tab, choose whether other values are rejected, and check pasted data.

Read article
Editorial illustration for Dropdown that grows automatically when you add a category
Spreadsheets 4 min read

Dropdown that grows automatically when you add a category

Make a dropdown in Excel that grows when you add a category: use an Excel table, a spill range, or an OFFSET formula so the rule never needs editing.

Read article
Editorial illustration for Education loan tracker sheet for disbursements and study period
Spreadsheets 4 min read

Education loan tracker sheet for disbursements and study period

Track an education loan in Excel: log each semester disbursement, see interest accrue during the course, estimate the first EMI and follow repayments.

Read article