Skip to content

← Using a Computer, in Practice

Spreadsheets · 63 of 111

Track your spending in a three-column sheet

Not tested on its own

Do this

  1. Open a new sheet: Google Sheets on your phone, or Calc.
  2. Make three columns: Date, What, Rs.
  3. Add a row each time you spend. Use one word for the kind of thing, like Bus or Snacks.
  4. At the top right, put =SUM(C:C), or use the range you need.
  5. 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

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.

← All 111 things to do