Google Sheets
Get Started with Google Sheets
With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Sheets lets you handle task lists, create project plans, analyse data with charts and filters, and more.
Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically.
Google Sheets - Basic course(free version, needs registration)
Google Sheets - Advanced course(free), needs registration.
Sheets Online Courses via Coursera - offered by Google
These are Free courses offered by Google via Coursera website. We encourage you to enrol yourself and learn more about the best features in Google Sheets. Please click here to access the Enrolment guide for the online courses listed below
Spreadsheets for Beginners using Google Sheets is a basic level course.
Doing more with Google sheets is a basic to intermediate level course.
Create charts and dashboards using Google Sheets is a basic level course.
Google Sheet - Online Course introduction
Intro.mp4What can you do with Sheets
How to Create a new file
Add content to your spreadsheet
How to Enter and edit your data
How to Customize your spreadsheet
How to Work with multiple sheets
How to Print your file
How to Make a copy
Share & Collaborate with Sheets
Filters vs. Filter views
Both filters and filter views help you analyse a set of data in a spreadsheet.
Filters can be useful if:
You want everyone viewing your spreadsheet to see a specific filter when they open it.
You want your data to stay sorted after using the filter.
When you add a filter, anyone with access to your spreadsheet will see the filter too. Anyone with permission to edit your spreadsheet will be able to change the filter.
Filter views can be useful if:
You want to save multiple views.
You want to name your view.
You want others to be able to view the data differently. Since filter views need to be turned on by each person viewing a spreadsheet, each person can view a different filter view at the same time.
You want to share different filters with people. You can send different filter view links to different people so everyone will see the most relevant information for them.
You want to make a copy or create another view with similar rules.
You don't have edit access to a spreadsheet and still want to filter or sort. In this case, a temporary filter view will be created.
Note: You can import and export filters, but not filter views.
Learn more about filter views
Use a filter view when:
You want to save your filter and use it later.
You don't want to disrupt others' view of the data.
You want to share a link to a specific filter with others.
You can’t edit a spreadsheet, but you want to filter or sort data.
Rename a filter view
On your computer, open a spreadsheet in Google Sheets.
Click Data Filter views.
Select a filter view.
Click the filter view name in the top left of the black bar and type the new name.
Press Enter.
See an existing filter view
On your computer, open a spreadsheet in Google Sheets.
Click Data Filter views.
Select a filter view.
Your filter will be applied to the spreadsheet.
To close your filter view, go to the top right and click Close .
Save a filter as a filter view
On your computer, open a spreadsheet in Google Sheets.
Apply a filter.
Click Data Filter views Save as filter view.
Use filter view with "view only" access
If you have permission to view a spreadsheet but not edit it, you can still use filter views:
To apply existing filter views, click Data Filter views.
You can create a temporary filter view that only you can use. Because you don’t have "edit" access to the spreadsheet, the filter view won't be saved.
Only users with permission to edit a spreadsheet can create filter views that anyone viewing the spreadsheet can use.