From the course: Google Sheets Essential Training (2021)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using filters and creating filter views - Google Sheets Tutorial
From the course: Google Sheets Essential Training (2021)
Using filters and creating filter views
- [Instructor] If your spreadsheet contains a lot of content, it can be difficult to find information quickly. Use the Filter feature in Google sheets to hide data that you temporarily want to take out of view and save your filter settings as filter views to access them later. Let's take a look at how to enable a filter in a Google sheets spreadsheet. I'll show you how to enable the Google sheets' Auto Filter Feature on this sales spreadsheet. You'll find this file named filter in the Exercise Files, Chapter four folder. Start by selecting the range of data you'd like to filter on. I want to filter by item type, so I'll select the item type column. Next, select Filter from the data menu or click the Filter toolbar icon. The filter will be applied to the column. You'll also notice that the row and column labels, where the filter is applied, are colored green to help show what cell ranges have a filter applied. Also…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.