Google Sheets

Google Sheets Level 1

Google Sheets allows you to easily create and share spreadsheets with others from one place. No more tedious uploading a sheet everytime there's a change, or trying to keep track of who changed what when! In this course, we'll focus on key features to use within a shared spreadsheet: conditional formatting, data validation, drop-down menus within cells and data filtering. We will then teach you the basic unique features of Google spreadsheets such as: comments vs. notes, list view, custom change notifications, protecting sheets and assigning different access permissions to sheets within a spreadsheet. We will also include information on consideration when converting to and from Excel.

Custom training is also available - email training@ualberta.ca for details.

Course Details

Prerequisites:

  • Basic computer skills

Duration: 1/2 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

Google Sheets Level 2

Google Sheets is a powerful tool for manipulating data in real-time and from any device. In this course, we’ll build on the skills learned in the Level 1, with the goal of learning how to manipulate your data through the use of basic and intermediate functions. Learn how to write functions, reference cells and ranges, and troubleshoot formulae. Then, discover ways of adjusting how the data is formatted and presented, while including hyperlinks, images, and visualizations alongside it. Finally, sort your data into different presentations, so you can always find the exact information you, or your collaborators, need to see.

Course Details

Prerequisites:

  • Basic computer skills
  • Google Sheets Level 1 or equivalent experience

Duration: 1/2 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes
Contact Us

Technology Training Centre

B-11 Cameron Library
780.492.1397
training@ualberta.ca

Cancellation Policy

Written or on-line cancellation must be received 10 business days prior to the course start date. Registration fees for cancellations less than 10 business days before the course will not be refunded.

Cancellation by the Technology Training Centre

The Technology Training Centre reserves the right to cancel open-enrolment classes at any time. All efforts will be made to give the course registrants 5 business days' notice of cancellation. At the time of cancellation, registrants have the option of being moved to another date, a different course of equal value or be refunded for the course fee. The Technology Training Centre will not be responsible for any travel expenses incurred.