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 13 of 50
Take your time. Find what helps.
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
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
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
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
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
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
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
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
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
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
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
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