Everything Teachers Need to Know to Create, Edit and Share Spreadsheets Using Google Sheets

March 14, 2017
This is the sixth post in a series of posts geared towards helping teachers, educators and students make the best of Google services in education. Today we are featuring Google Sheets, an excellent tool to help you create, edit, format and share a wide variety of spreadsheets with others. Using the guidelines below. you will get to learn almost everything you need to master Sheets from creating and sharing spreadsheets to viewing and editing settings of spreadsheets.

Previous charts we have published so far include: Google Drive Chart, Chromebook chart, YouTube chart, Google Maps guidelines chart, and Google Forms chart.

Google Sheets Guidelines for Teachers

Create, edit and format spreadsheets	How to use Google Sheets Create a spreadsheet Edit and format a spreadsheet Import data sets and spreadsheets Format numbers in a spreadsheet
Work with sheets,	Protect, hide, and edit sheets Edit rows, columns & cells in a spreadsheet
Publish and embed your spreadsheet	Publish and embed Google Docs, Sheets, Slides & Forms
Functions and formulas	Add formulas and functions to a spreadsheet See the sum of cells in a spreadsheet Reference data from other sheets Google spreadsheets function list
Create and edit charts	Create, edit & delete charts Chart types See and use suggested charts and analysis in a spreadsheet Save, print, or import your chart
Tools	Turn on notifications in a spreadsheet Use add-ons & Apps Script Keyboard shortcuts for Google Sheets
Spreadsheets settings, views and printing	Edit and view text from right to left Set a spreadsheet’s location and calculation settings
Work with data	Create and use pivot tables Name a range of cells Sort and filter your data Create an in-cell dropdown list Automatically create a series or list Use conditional formatting rules in Google Sheets Using arrays in Google Sheets Separate cell text into columns