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

Take your time. Find what helps.
Editorial illustration for Two people, one Excel file: co-authoring on OneDrive
Spreadsheets 4 min read

Two people, one Excel file: co-authoring on OneDrive

Set up one shared Excel expense file on OneDrive so two people can edit together, what AutoSave and presence markers mean, and what blocks co-authoring.

Read article
Editorial illustration for Excel data model for expenses: link transactions and categories
Spreadsheets 4 min read

Excel data model for expenses: link transactions and categories

Add a transactions table, category table and date table to the Excel data model, draw the relationships, and build one pivot that uses fields from all three.

Read article
Editorial illustration for Build an expense dashboard in Excel with pivot charts and slicers
Spreadsheets 4 min read

Build an expense dashboard in Excel with pivot charts and slicers

Build an Excel expense dashboard on one sheet: pivot charts for category, month and payment mode, shared slicers and a print-ready layout.

Read article
Editorial illustration for Build an Excel expense tracker from scratch in six steps
Spreadsheets 3 min read

Build an Excel expense tracker from scratch in six steps

Build an Excel expense tracker from scratch in six steps: log sheet, table, category dropdown, SUMIFS summary, chart and sheet protection, with the final structure.

Read article
Editorial illustration for Where your data lives: expense spreadsheet vs expense app
Spreadsheets 4 min read

Where your data lives: expense spreadsheet vs expense app

Where does your expense data live? Compare a local spreadsheet, a cloud-drive sheet and an expense app, and what to check about access, sharing and backups.

Read article
Editorial illustration for Excel warns file format and extension do not match: statement .xls
Spreadsheets 4 min read

Excel warns file format and extension do not match: statement .xls

Excel says the file format and extension do not match for a statement .xls. Learn why it happens, how to open it safely and how to save it as XLSX.

Read article
Editorial illustration for Excel Forecast Sheet: a seasonal spending forecast
Spreadsheets 4 min read

Excel Forecast Sheet: a seasonal spending forecast

Use Excel's Forecast Sheet on three years of monthly spending to see seasonal patterns and a confidence band, and learn when history is too short.

Read article
Editorial illustration for Excel formula not recalculating: totals stuck on the old value
Spreadsheets 4 min read

Excel formula not recalculating: totals stuck on the old value

Excel formulas not updating or showing as text? Check calculation mode, Text-formatted cells, a leading apostrophe or space, and Show Formulas, in this order.

Read article
Editorial illustration for Excel hangs on a statement CSV with years of rows: what to do
Spreadsheets 3 min read

Excel hangs on a statement CSV with years of rows: what to do

Excel slow or hanging on a bank statement CSV with years of rows? Practical fixes: Power Query, trimming, manual calculation, splitting by year and file format.

Read article
Editorial illustration for Excel on mobile: enter expenses faster with table card view
Spreadsheets 4 min read

Excel on mobile: enter expenses faster with table card view

How to enter expenses faster in the Excel mobile app using a table in card view, where it works, where it does not, and how to set up dropdown columns.

Read article
Editorial illustration for Excel not recognising dd/mm/yyyy dates from a bank CSV
Spreadsheets 4 min read

Excel not recognising dd/mm/yyyy dates from a bank CSV

Excel treats dd/mm/yyyy dates from a bank CSV as text or swaps the day and month. See why, and fix it with Text to Columns or a DATE formula.

Read article
Editorial illustration for Excel shows 1,234,567 instead of 12,34,567: change digit grouping
Spreadsheets 4 min read

Excel shows 1,234,567 instead of 12,34,567: change digit grouping

Excel shows 1,234,567 instead of 12,34,567 because it follows Windows digit grouping. See where to change it, what it affects and what to do on a Mac.

Read article