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 29 of 50
Take your time. Find what helps.
PG and flat rent split sheet in Google Sheets with electricity share
Split flat rent, electricity and wifi in Google Sheets using room weights and days stayed, with a worked example for four flatmates and a mid-month joiner.
Read article
A shoot-wise profit sheet for photographers in Google Sheets
A Google Sheets template for photographers: one row per shoot with fee, advance, balance, costs and profit, plus a pending-balance list that updates itself.
Read article
Pie chart or bar chart for spending categories: which to use?
Pie chart or bar chart for spending categories: use a pie for a few parts of a whole and a sorted bar chart for ten categories, shown with the same data.
Read article
Calculated field in a pivot table: income minus expenses
Work out monthly savings in a pivot table: split income and expense into fields, add a calculated field in Excel or Sheets, or use SUMIFS beside the pivot.
Read article
Pivot chart for monthly spending by category in Excel
Make a stacked column pivot chart of monthly spending by category in Excel, hide the field buttons, and use a pie chart for a single month.
Read article
Pivot chart with slicers for expense analysis
Add a pivot chart, a Category slicer and a Date timeline in Excel, then connect them to several pivots so one click filters the whole view.
Read article
Pivot table for expenses by category and month in Excel
Build an Excel pivot table of expenses by category and month, with rows, columns and values set up step by step, using a sample bank export of 300 rows.
Read article
Pivot table by financial year (April to March) using a helper column
Group a pivot table by Indian financial year, April to March, with a helper column for FY, fiscal quarter and month order, plus a worked example.
Read article
Pivot table for an expense summary in Google Sheets
Create a pivot table in Google Sheets to summarise expenses by category, set rows, columns and values, switch on totals and sort by sum of amount.
Read article
Pivot table not showing new expense rows: how to fix it
Pivot table not showing new expense rows? Refresh it, extend the data source, turn the data into a Table so ranges grow, and use whole columns in Sheets.
Read article
Show each category as a percentage of total in a pivot table
Show each expense category as a percentage of total in an Excel or Google Sheets pivot table using Show Values As, and learn which percent option to pick.
Read article
Pivot table of spending by category and month from a statement
Build an Excel pivot table of spending by category and month from a bank statement: clean the rows, group dates, fix blanks and refresh.
Read article