Google Sheets 101

Google Sheets 101

This session is a true intro to Google Sheets. For those who have heard that spreadsheets are amazing, but have yet to dive in, this is a great place to start. Participants will learn the basics of creating and organizing tabs, auto-sorting lists, formatting cells, rows and columns, as well as begin to use formulas such as split, sum, merge and more.

Welcome!

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

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.

Outcomes (MORE RESOURCES)

Spreadsheets 101: Navigating a Spreadsheet

• Understand the relationship between Cells, Rows and Columns
  • Click a cell (Change Color)
  • Click a row (Change Color)
  • Click a Column (Change Color)
  • Sort A-Z and watch what moves with what?
• Create new Tab
  • Name Tab
  • Color Tab
• Organize a list:
  • Sort A-Z
  • Sort #'s
• Create a Header
  • Merge Cells
  • Fill Color
  • Freeze Header

Spreadsheet Magic: Using Formulas

• Down-fill and auto-fill
  • Drag down to copy
  • Drag down to auto-fill
• Conditional Formatting
  • Change the color of the Cell based on the contents
• The power of Equal
  • =sum(list cells here)
  • =Split(Cell, split by what)
  • =Name a Cell
  • =Name a Cell & Name another Cell
  • =Name a Cell & "Add text"

Using Sheets for Collaboration

• Uses with Staff
• Uses with Students

Click Here to Learn More Formulas

JohnDavidEick@gmail.com

@John_Eick

CapCue Board Member

CUE Lead Learner

Google Certified Teacher