Wednesday, May 3, 2017

5 Google Sheets Tips for the Novice

Often times when I visit with teachers I find that most use spreadsheets to organize data and sometimes create charts.  Using these 5 tips will make the experience even better the next time you are dealing with data.  This video will show you the following:

  • how to alternate the color of rows automatically
  • how to rotate text such as vertically (pretty new feature)
  • copy and paste the format of one cell into another
  • setup a notification each time someone changes data in the spreadsheet
  • protect a sheet or cell range of data
Here is the video below.



Tuesday, May 2, 2017

Setup a Table of Contents in Google Docs

Is your lesson plan or project too many pages to easily navigate?  Have you tried to setup a table of contents in Google Docs?  It's pretty easy.

  1. Add headings for each section of your document.
  2. Highlight each heading and set the style.

  3. Click Insert>Table of Contents.
This video may help with the process further.