Google Sheets are the Answer

Welcome!

EVALUATION

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

The Auto-Fill

  • Down-fill and auto-fill
    • Drag down to complete sequence
    • Drag down to auto-fill/duplicate info
  • Creating Formulas
    • Auto-Fill Formulas

Using Formulas to do the Work

  • The numeric formulas
    • =sum(list cells here)
    • =Average
    • =Count
  • Text Formulas
    • =A1
    • =A1&" "&A2

Creating a Data Table from a Google Form

  • =countif - Counting the number of responses
  • =Unique - Curating unique responses
  • =A1/Sum(A1:C1) - Finding the Average

The Query

  • =query - Search a table and return data

Using Data Validation

  • Create Dropdown
  • Protect Data Range

Click Here to Learn More Formulas

JohnDavidEick@gmail.com

@John_Eick

- CapCue Board President - CUE Lead Learner - Google Certified Teacher -

- CUE Speaker's Bureau - CUE Rockstar Faculty