Filtering and sorting data in Excel 365
Excel Microsoft 365 (2021)
| Intermediate
- 11 Videos | 34m 33s
- Includes Assessment
- Earns a Badge
- CPE
- PMI PDU
Excel 365 includes various sort and filtering tools, which you can use to analyze the data in a worksheet. You can use these tools to organize and choose what values are shown in a range. The key concepts in this course include how to use filter tools and how to remove duplicate values in a data range. See how to use column filters to filter data and apply multiple filters to values in a worksheet. Create filter arguments using text and number data types to show values that meet defined filter criteria. Finally, you will learn how to sort and filter data according to their background fill color; sort data in a worksheet according to a specific data type; customize the sort options; apply multiple criteria and sort levels, and create and use custom sort lists.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this Microsoft 365: Filtering and sorting data in Excel 365 courseuse column filters to filter worksheet data in Excel 365apply multiple filters to worksheet data in Excel 365create filter arguments in Excel 365use the advanced filter tools in Excel 365filter and sort data by color in Excel 365
-
sort data in a worksheet in Excel 365sort data using multiple sort levels in Excel 365create and use a custom sort list in Excel 365perform an advanced sort in Excel 365remove duplicate values from a range in Excel 365
IN THIS COURSE
-
1.Course Overview: Filtering and sorting data in Excel 36550sUP NEXT
-
2.Filtering the data3m 29s
-
3.Applying multiple filters2m 52s
-
4.Building filter arguments4m 26s
-
5.Performing advanced filtering2m 58s
-
6.Filtering and sorting using colors2m 53s
-
7.Sorting the data3m 14s
-
8.Applying multiple sort levels3m 59s
-
9.Using custom sort lists4m 8s
-
10.Performing advanced sorting2m 55s
-
11.Hiding and removing duplicate values in Excel 3652m 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.