Skip to content
The Tech Coaches
The Tech Coaches

Google Sheets (updated 5/11/17)

Dearborn Public Schools > The Tech Coaches > Google Sheets (updated 5/11/17)

How do I. . .

Create a pivot table in Sheets

Quickly add up cells without a formula

Protect sheets and cell ranges in shared Sheets

Create hyperlinks in Sheets

Easily analyze separate lists of data

Pull in data from a live webpage

Spellcheck my Sheet

Share only specific tabs in Sheets

Keep my cell formats consistent

Use formulas in different languages

Change the language settings

Create a table of contents using hyperlinks

Create printable labels

Rotate text

Remove duplicates

Use AutoCrat to create PDFs and Docs

Link Excel documents to Sheets

Expand the formula bar in Sheets

Convert Excel sheets into Google Sheets

Embed Sheets into Slides and Docs

Make Google Sheets act more like Excel

Find out things Google Sheets can do that Excel cannot

Automatically alternate row or column colors

Split text into columns

Send text messages from Google Sheets

Build a Table of Contents in Google Sheets

Create dynamic drop down menus

Insert multiple rows

Insert images into cells

Automatically analyze your data

Use the Explore feature in Google Sheets

Use Flippity in Sheets to make MadLibs

Navigation

  • Meet the Tech Coach
    • Bob Harrison
  • What We Do
  • Models of Integration
    • The SAMR Model
    • The TPACK Model
    • The TIMS Matrix
    • Triple E Framework
    • ISTE Standards for Students
  • How do I…?
  • Tech Coach Presentations
  • Open Educational Resources (OER)
  • Accessibility

Archives

Parent Portal

Parent and community Information

Student Portal

Student links, tools, and websites

Staff Portal

Staff tools, information and resources

Contact Us

Departments, services, and contact information

© 2025 Dearborn Public Schools | Administration

Scroll to top
  • Accessibility
  • Becoming an Effective Teacher in the Digital Age
  • Bob Harrison
  • Bridging the Gap
  • Early Childhood / Preschool
  • ePortfolios
  • Google Apps
  • Google Apps for Education
  • Google Calendar (updated 4/18/17)
  • Google Chrome (updated 11/14/16)
  • Google Classroom (updated 1/24/17)
  • Google Docs (updated 6/13/17)
  • Google Drawings (updated 11/14/16)
  • Google Drive (updated 11/27/17)
  • Google Forms (updated 2/2/17)
  • Google Hangouts (updated 11/16/16)
  • Google Keep (updated 4/18/17)
  • Google Mail (Gmail) (updated 5/24/17)
  • Google Maps (updated 11/16/16)
  • Google Sheets (updated 5/11/17)
  • Google Slides (updated 11/1/17)
  • Home
  • How do I…?
  • How to import an activity from another Moodle course to your own
  • iBlog
  • Illuminate DnA
  • Meet the Tech Coach
  • Meetings
  • Models of Integration
  • Moodle (iLearn)
  • Open Educational Resources (OER)
  • Preschool Apps
  • Promethean
  • Secondary Level
  • Special Education
  • subscriptions
  • Taking the Next Step
  • Teacher Productivity
  • Tech Coach Appointment (Middle School and High School) with Bob Harrison
  • Tech Coach Presentations
  • The Mahara ePortfolio Workflow
  • Transforming Education
  • What We Do
  • YouTube (updated 11/14/16)
Search