Google Sheets are the Answer

Welcome!

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.

Colors

Understand the relationship between Cells, Rows and Columns

Click a cell (Change Color)
Click a row (Change Color)
Click a Column (ChangeColor)

Viewing the Data

Name a Tab
Color the tab
Scroll...where did the header go?
- Click the header, click view, click Freeze Row 1
- Scroll again
Adjusting the column width
- Drag
- Double Click
Sort A-Z and watch what moves with what:
- Sort A-Z
- Sort #'s
Create a Header
- Merge Cells
- Fill Color
- UnFreeze Header
Duplicate the Tab
- Rename the duplicate
- Add Rows
- Add columns
- Move Columns
- Move Rows
- Conditional Formatting
  - Change the color of the Cell based on the contents