Tag Archives: google drive

Introduction to Google Drive

Register an account with company address

https://accounts.google.com/SignUpWithoutGmail

Familiarize with the navigation

  • folder list “my drive”, “shared with me”
  • file list by icon or list
  • search files
  • creating new documents
  • type of documents supported – e.g. google docs, google sheets

Google Docs

  • create new document
  • change title
  • share docs – enter email and set either can edit, comment or view only
  • basic formatting

Google Sheets

  • create new
  • share
  • freeze rows
  • basic formula – add
  • color
  • sort
  • filter
  • notification rules

Common features

  • File > See revision history
  • Format > Conditional formatting
  • File > Print

Get alerts when someone update Google Sheets

When you have multiple users editing the same Google Sheets, you might want to have an alert or notification when someone in the team make any changes.

You can set the notification as below.

1. Choose Tools > Notification rules…

Screen Shot 2015-05-14 at 4.12.28 PM

 

 

2. Select the options and click on Save button.

Screen Shot 2015-05-14 at 4.12.40 PM

 

That’s it. Once it is done you will receive emails when something is changed on your shared Google Sheets.