Platform Banner

Lists - Clear insights through filters and sorting Tutorial

Unlock the power of organization with "Clear Insights Through Filters and Sorting." This video dives into how to effortlessly sort and filter lists, making item discovery a breeze. Learn to streamline your collaboration processes and enhance readability with grouping options that help focus on what really matters. Don’t miss out on these essential tips for maximizing productivity!

02:06
291 views
Share

Available in Microsoft365

00:00:04

it is extremely easy to sort items or

00:00:07

display only those of interest by filtering them.

00:00:10

From a column header I can directly access via the dropdown menu,

00:00:14

the option to sort alphabetically or in reverse alphabetical order

00:00:18

with a single click.

00:00:21

The list is instantly sorted.

00:00:23

In the case of a shared list,

00:00:24

the active sorts and filters do not apply to other users.

00:00:28

Depending on the type of column being sorted,

00:00:30

Microsoft Lists will offer chronological sorting for date

00:00:33

columns or ascending descending sorting for numeric columns.

00:00:39

Another available option is filtering,

00:00:41

which allows me to display only the items that interest me.

00:00:45

By clicking on the header of a column.

00:00:47

The filter by option opens a pane on the right,

00:00:50

enabling me to select which items to include.

00:00:53

The active filter will appear in the top left

00:00:56

with a cross icon to remove the criterion.

00:01:00

When multiple filters are applied.

00:01:04

They are displayed the same way in the top left,

00:01:06

with an option to clear all filters at once with a single click.

00:01:11

To improve readability,

00:01:13

it is also possible to visually group items.

00:01:16

For example,

00:01:17

in this case,

00:01:17

I find the group by rating option.

00:01:21

I can then use the small arrow to collapse certain groups

00:01:24

and display a total number of items in my list,

00:01:26

in addition to the number already shown beside each group.

00:01:32

I also have the option to collapse or expand all groups with a single click.

00:01:38

To ungroup,

00:01:39

I simply deactivate the option in the corresponding column.

00:01:44

To sort and filter more quickly or globally,

00:01:47

it is also possible to use the icons located on the right hand side.

00:01:52

The filter pane will then display all filterable criteria

00:01:56

regardless of the column.

00:01:58

And for sorting and grouping,

00:02:00

a direct access to the list of fields for instant application.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

Microsoft Lists - Getting started

E-learning Discovery

Vu 611 fois

Microsoft Lists - Getting started

Discover how Microsoft Lists simplifies data organization with powerful customization and collaboration features far beyond a basic spreadsheet.

ALL COURSES