Introduce

Why a Google Sheet?

With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically.

Interact

Google Sheets Tutorial Video

Navigate through the video using the list of topics below . Click on the link to be taken directly to the section of the video that addresses your chosen topic.

Introduction 0:03

Start Page 0:28

Interface 2:10

Search the Menus 3:46

Navigating and Selecting Cells 5:51

Entering and Editing Data 8:37

Explore 11:49

Performing Simple Calculations 17:03

Saving 19:57

Introduction to Google Drive 21:04

Building Basic Formulas 24:22

Using Simple Functions 28:03

Copying Formulas and Functions with AutoFill 32:50

Relative vs Absolute Reference 37:15

Inserting Rows and Columns 43:30

Moving, Copying, and Pasting Data 46:57

Using AutoFill to Complete a Series of Values 49:54

Cell Formatting - Align, Text Rotation, Text Wrapping 53:07

Formatting Worksheet Data and Using Cell Design 57:19

Using Sheets Templates 1:00:29

Inserting, Deleting, Renaming, Moving, and Copying Worksheets 1:02:02

Freeze Panes 1:04:49

Currency Formatting 1:07:44

Hiding Rows and Columns 1:08:34

Spell Check 1:10:39

Using the Full-Screen View 1:12:00

Printing 1:12:55

Download Options 1:14:31

Publishing Sheets to the Web 1:15:16

Sending Sheets as Emails 1:16:21

Conclusion 1:18:14

Implement

Conditional Formatting

Create a Self Checking Google Sheet

Use Google Sheets to Paint by Number

Google Sheets Math Activity

Resources

Page updated

Report abuse