Level 1

• Basic Features

  • Spreadsheet Vocabulary

  • Navigate through Google Sheets

  • Add data and format cells

  • Insert and resize rows and columns

• Working with Cells and Data

  • Adjust cell borders.

  • Use Quick Sum and Explorer

  • Sort data in ranges

    • Sorting Numbers, Text, or Dates

  • Use autofill

  • Add a simple calculation (Sum/Average)

  • Protect Sheet data from editing

  • Freeze columns and rows.

  • Show and hide columns and rows.

• Working with Tabs

  • Duplicate tabs

  • Duplicate and rename tabs

Level 2

• Working with Charts and Graphs

  • Insert a simple chart

    • Create and style charts.

  • Analyze the Data in a Google Sheet with Charts and Graphs, including Pie charts and Line charts

  • Move charts to their own sheets

  • Analyze data using pivot tables

• Collaboration

  • Share a Google Sheet with others

• Advanced Cell Functions

  • Organize Data Collected in a Google Sheet

  • Using Formula and Functions including Sum, Average, Unique, Count, If

  • Work with conditional formatting

  • Data Validation

• Presenting Data

  • Collaborating with other Google Apps

    • Adding charts from Sheets to Sites, Docs and Slides

  • Publish Results from a Google Sheet