You are now in the main content area

Working with Google Sheets

Cost: Free
No Show Fee: $50
Manager Approval: Required

Google Sheets is available to all Ryerson students, faculty and staff. It provides a web-based interface for creating, modifying, and sharing spreadsheets. In addition to the core spreadsheet functionality, it offers unparalleled web-based collaboration features making it easier than ever to work as a team. Due to integration with Google Drive, your Google Sheets are always available on any internet-connected device. 

This 2 hour training course will demonstrate the key features of Google Sheets, including:

  • An overview of Google Sheets and how its features differentiate it from Microsoft Excel
  • Converting between the Google Sheets format and Microsoft Excel
  • Overview of the interface and basic features necessary to create your own spreadsheets
  • Collaboration features:
  • Sharing
  • Comments
  • Version history
  • Notification rules
  • Protected sheets & ranges
  • Importing data from other Google Sheets in real-time
  • Basic use of functions and formulas
  • Named ranges
  • Filtering
  • Data validation
  • Pivot Tables
  • Charts

Prerequisites: This course does not cover some core spreadsheet functionality in depth, such as functions and formulas. Instead, the focus is on features that make Google Sheets unique. For those already familiar with the collaborative features of Google sheets, or those looking to learn more core spreadsheet functionality like functions and formulas, “Google Sheets Functions & Formulas” is the recommended intro course.

***Please Note***: This hands-on course will require you to log into your own Ryerson Google Apps account (Ryerson Gmail, Google Calendar, or Google Drive, depending on the course). If you have enabled two-factor authentication for your Ryerson account, be sure to bring your device to this training to generate the one-time verification code so you can log in. This device is either your cell phone, or your one-time verification (OTV) device.

Looking for other G Suite training opportunities? Visit the Gmail and G Suite Training page.