Google Workspace: Sheets - Part 3

Use advanced functions and conditional formatting in Google Sheets.

Example outcome

Lesson details

Learning objectives

By the end of this lesson, students should be able to:
  • Use advanced functions and conditional formatting to calculate and emphasize cost, revenue, and profit for a community fundraiser

Time to complete

45—90 minutes

Audience

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

Digital tools

  • Icon representing the Sheets toolSheets

Skills

  • Advanced formulas
  • Conditional formulas
  • Data analysis
  • Data representation
  • Data visualisation
  • Organising data
  • Sorting and filtering
  • Spreadsheet design
  • Spreadsheet organisation

Teaching materials

namespaces/google.engedu.apski/contents/Unit-137753019046125897917736419933634729286en-uk