Google Sheets are the Answer


First: Click here to offer some quick information about what you would like to learn today.

STOP: Please do not make a copy of the spreadsheet below until everyone has completed the form above.

Next: Click Here and make a copy of this spreadsheet! This is where we will do our learning today!

Want a copy of today's notes? Click here for a Google Doc copy of the notes below.

In this session, participants will learn how to use first the basic functions of Google Sheets, and next, they will learn more advanced formulas to make Google Sheet Magic. Participants will learn to create auto-populating data tables that collect and organize information from Google Forms. Finally, participants will create charts that automatically update when pasted into Google Slides. This session is appropriate for beginning level, intermediate and advanced sheets users.

Understand the relationship between Cells, Rows and Columns
  • Click a cell (Change Color)
  • Click a row (Change Color)
  • Click a Column (ChangeColor)