1. Home
  2. Training Library
  3. Additional Resource Videos

Data Lists - Sorted and Filtered

Developed with
QA
Start course
Overview
Difficulty
Beginner
Duration
33m
Students
229
Ratings
4.7/5
starstarstarstarstar-half
Description

Additional information

Transcript

- [Instructor] 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
Avatar
QA
Training Provider
Students
8839
Labs
31
Courses
54
Learning Paths
33

QA: A world-leading tech and digital skills organisation

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 programmes and Apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.