Applied Digital Skills lessons have moved to a new platform! This site will no longer be available after 30 June 2025 and all accounts and data will be deleted. Learn more

This lesson will no longer be available after 30 Jun 2025.

Track Your Monthly Expenses

Use a spreadsheet to track your monthly expenses.

Example outcome

Lesson details

Learning objectives

By the end of this lesson, students should be able to:
  • Create a spreadsheet table to categorize and track monthly expenses

Time to complete

45—90 minutes

Audience

  • Key Stage 3
  • Key Stage 4
  • Post-16

Digital tools

  • Icon representing the Sheets toolSheets

Skills

  • Conditional formulas
  • Organising data
  • Spreadsheet organisation
namespaces/google.engedu.apski/contents/Unit-184582808736429690504295377312031706271en-uk