Google Sheets Open Training Video

Google Sheets GC1

Essential Tasks

Copy of Google's Official Practice Sheet

  • Sort your columns

  • Calculate averages using formulas

  • Create a labeled chart from data

  • Add ALT text to your chart

  • Share your sheet

  • Set up sheet one as protected and can only be edited by you

Google Sheets GC2

Essential Tasks

Copy of Google's Official Practice Sheet

  • Use conditional formatting

  • Use conditional formatting to highlight specific cells

  • Create a drop down list in a cell

  • Use data validation

  • Use Criteria to select options from a range

  • List items in a sheet

Google Sheets

Helpful Tips

  • Using Freeze to keep a fixed view

  • Quick copy using drag on cells

  • Insert a Google Drawing

  • Text wrapping

  • Connecting a Form