image
Data Lists - Sorted and Filtered
Start course
Difficulty
Beginner
Duration
33m
Students
317
Ratings
4.8/5
starstarstarstarstar-half
Description

Additional information

Transcript

Another new improvement to Excel is the way data can be filtered and sorted. Filtering can be sorted on any table by going to the home tab, going across to sort and filter, and selecting filter. The filter icons appear at the top of each column. By clicking each of these arrows, we can determine what we'd like to filter by. We can use traditional sorts to sort the column alphabetically, or in reverse alphabetical order. We can also display data that matches certain items. 

So in this department, we can take off select all, and which department we want to keep the data for. I can also search certain values or parts of values. For example, I can click the drop-down arrow, type MA, and it will only find things that begin with MA, such as manufacturing and marketing. Different columns will give different features based on the type of information that we're viewing. Here, where I'm clicking the hours-per-week column, I'm able to do number filters. These filters are greater than 25; for example, I can now click a date column and get more options still.

About the Author
Students
39317
Labs
161
Courses
1561
Learning Paths
41

A world-leading tech and digital skills organization, we help many of the world’s leading companies to build their tech and digital capabilities via our range of world-class training courses, reskilling bootcamps, work-based learning programs, and apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.