Finding, Sorting & Filtering Data
Google Sheets 2020
| Intermediate
- 10 Videos | 37m 32s
- Includes Assessment
- Earns a Badge
There are times you may only want to work with particular data in a spreadsheet. Discover how to use the Google Sheets tools to easily find and replace data. You will also learn how to sort your data and use filters to display only the data you need. Google Sheets includes other advanced options for sorting and filtering data with colors and conditions. In this course, you will discover other tools for filtering your data, such as filter views and slicers. Finally, learn how to group and ungroup your data to choose the information you want to display.
WHAT YOU WILL LEARN
-
find and replace data in a spreadsheet
find and replace functions in formulas
sort data in a spreadsheet
apply filters in a spreadsheet
use advanced filter options in a spreadsheet -
sort and filter data using colors
create and manage filter views
add slicers to filter your data
customize slicers colors and formats
group and ungroup data in a spreadsheet
IN THIS COURSE
-
1.Using the Find & Replace tool4m 6sUP NEXT
-
2.Using the Find & Replace tools in a formula3m 14s
-
3.Sorting the data in your spreadsheet4m 17s
-
4.Filtering the data in your spreadsheet2m 51s
-
5.Using the advanced filtering options2m 58s
-
6.Sorting and filtering data with colors2m 24s
-
7.Using filtered views4m 26s
-
8.Using slicers3m 53s
-
9.Customizing slicers4m 35s
-
10.Grouping data4m 48s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.
