← Using a Computer, in Practice
Spreadsheets · 63 of 111
Track your spending in a three-column sheet
Not tested on its own
Do this
- Open a new sheet: Google Sheets on your phone, or Calc.
- Make three columns: Date, What, Rs.
- Add a row each time you spend. Use one word for the kind of thing, like
BusorSnacks. - At the top right, put
=SUM(C:C), or use the range you need. - After a month, sort by What, or use
=SUMIF(B:B,"Bus",C:C).
Why this way
It’s the simplest useful spreadsheet there is, and using it weekly teaches you more than a lesson. Put the total in a column of its own, or it will count itself. Plain know-how.
Do it today
Enter everything you spent this week. Five minutes.
Where these facts come from
- Mathematical Functions, LibreOffice Help.
General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.
