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 to calculate cost, revenue, and profit
  • Combine other file formats with spreadsheets in Google Sheets
  • Use conditional formatting to emphasize specific data

Time to complete

45—90 minutes

Audience

  • Adult Learners
  • High School

Digital tools

  • Icon representing the Sheets toolSheets

Skills

  • Advanced formulas
  • Conditional formulas
  • Data analysis
  • Data representation
  • Data visualization
  • Organizing data
  • Sorting and filtering
  • Spreadsheet design
  • Spreadsheet organization

Teaching materials

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