Lists - Sort and filter a list Tutorial

In this video, you will learn about sorting and filtering items in a list.
The video covers how to find specific items using search and how to sort the list by different columns.
It also demonstrates how to filter the list based on specific criteria, such as the name of the person who created the item.
These actions are not permanent, but you can save them as a display for future use.
This tutorial will help you effectively sort and filter lists in Microsoft 365, improving your productivity and organization.

1:39
2342 views

Available in Microsoft365

Objectifs :

Understand how to sort and filter employee data using the column headers in a company list.

Chapitres :

Introduction to Sorting and Filtering
In this section, we will explore how to effectively sort and filter a list of employees using the options available in each column header. This functionality allows for better organization and retrieval of specific data based on various criteria.
Sorting Employee Data
Each column header features a down arrow on the right side, which opens a dropdown menu when clicked. This menu provides several sorting options based on the data type of the column. For example: - **Name Column**: You can sort employee names in two ways: - Ascending order (A to Z) - Descending order (Z to A) - **Date of Birth Column**: Sorting options include: - From oldest to newest - From newest to oldest These sorting options help in quickly locating employees based on their names or birth dates.
Filtering Employee Data
To filter the employee list, click on the 'Filter by' option in the dropdown menu. For instance, if you want to view only employees in specific divisions, follow these steps: 1. Click on the dropdown menu in the 'Division' column. 2. Select 'Filter by'. 3. Check the boxes for the desired divisions, such as 'Fax' and 'Printer'. 4. Click the 'Apply' button to see the filtered results. This feature allows you to narrow down the list to only those employees relevant to your needs.
Grouping Employee Data
In addition to sorting and filtering, you can also group items based on the data in the columns. To group employees by division, follow these steps: 1. Go to the dropdown menu in the 'Division' column. 2. Click on 'Group by Division'. This action will categorize employees into groups based on their respective divisions, such as: - Fax Division Employees - Photo Copier Division Employees - Printer Division Employees Grouping helps in visualizing the data more effectively and allows for easier management of employee information.
Conclusion
Sorting, filtering, and grouping employee data are essential skills for managing a company’s workforce efficiently. By utilizing the dropdown menus in the column headers, users can easily organize and access the information they need, enhancing productivity and data management.

FAQ :

How can I sort the employee list?

You can sort the employee list by clicking on the down arrow next to the column header you wish to sort. Choose either ascending or descending order based on the data type of that column.

What does the filter option do?

The filter option allows you to display only the items that meet specific criteria. For example, you can filter the employee list to show only those in the fax and printer divisions.

Can I group employees by division?

Yes, you can group employees by division by selecting the 'Group By' option from the dropdown menu in the division column. This will categorize employees based on their respective divisions.

What is the difference between ascending and descending order?

Ascending order arranges items from lowest to highest (A to Z or 1 to 10), while descending order arranges items from highest to lowest (Z to A or 10 to 1).

How do I apply filters after selecting options?

After selecting the desired filter options from the dropdown menu, click the 'Apply' button to update the list based on your selections.

Quelques cas d'usages :

Sorting Employee Data for Reports

In a human resources department, sorting employee data by name or date of birth can help in generating reports for annual reviews or birthday celebrations, improving organization and efficiency.

Filtering Employees for Project Assignments

A project manager can filter the employee list to view only those in the fax and printer divisions when assigning tasks related to those specific areas, ensuring the right team members are selected.

Grouping Employees for Team Meetings

By using the 'Group By' function, a team leader can easily organize employees by division for departmental meetings, facilitating better communication and collaboration.

Data Analysis for Workforce Planning

An analyst can sort and filter employee data to identify trends in workforce distribution across divisions, aiding in strategic planning and resource allocation.

Improving Data Management in HR Software

Implementing sorting and filtering features in HR software can enhance data management, allowing HR professionals to quickly access relevant employee information and make informed decisions.

Glossaire :

Sort

The process of arranging items in a specific order based on a selected criterion, such as alphabetical order or numerical value.

Filter

A function that allows users to display only the items that meet certain criteria, effectively hiding the rest.

Dropdown Menu

A graphical control element that allows the user to choose one value from a list. It is typically activated by clicking on a down arrow next to a column header.

Ascending Order

A sorting order where items are arranged from the lowest to the highest value, such as A to Z for text or 1 to 10 for numbers.

Descending Order

A sorting order where items are arranged from the highest to the lowest value, such as Z to A for text or 10 to 1 for numbers.

Group By

A function that organizes items into categories based on a selected column, allowing users to view related items together.

Division

A specific department or section within a company, such as fax, printer, or photocopier divisions.

00:00:04

filtered via each column

00:00:06

headers sort and filter option.

00:00:08

On the right of each column header

00:00:11

there's a down arrow.

00:00:13

By clicking on it you

00:00:15

open the drop down menu.

00:00:17

Here you have several options based

00:00:19

on this company's list of employees

00:00:22

you wish to sort the name column.

00:00:24

You can sort by employees name,

00:00:27

by ascending order from A-Z or

00:00:30

by descending order from Z to A.

00:00:33

And under the date of birth column

00:00:35

you can sort from the oldest

00:00:38

to the newest and vice versa.

00:00:41

Sorting options are related

00:00:42

to the columns data type.

00:00:44

You can further filter the

00:00:45

data by clicking "filter by" in

00:00:47

the dropdown menu example,

00:00:49

if you want to view only the list of

00:00:52

employees in the fax and printer divisions,

00:00:54

use the drop down menu

00:00:56

in the division column,

00:00:57

then click on "filter by".

00:01:00

Check the fax and printer boxes.

00:01:05

And then click the apply button.

00:01:11

From the drop down menu you can also use

00:01:14

the "group by" option to get her items

00:01:17

from the list against the columns data.

00:01:19

For instance, the division column

00:01:22

go to the dropdown menu and

00:01:24

click on "group by division".

00:01:26

First you find the fax division employees,

00:01:30

then the photo copier

00:01:32

division employees and last

00:01:34

the printer division employees.

00:00:04

filtrado através de cada coluna

00:00:06

cabeçalhos classificam e filtram opção.

00:00:08

À direita de cada cabeçalho de coluna

00:00:11

Há uma seta para baixo.

00:00:13

Ao clicar nele

00:00:15

abrir o menu drop down.

00:00:17

Aqui tem várias opções baseadas

00:00:19

na lista de funcionários desta empresa

00:00:22

deseja separar a coluna de nomes.

00:00:24

Pode ordenar pelo nome dos empregados,

00:00:27

por ordem ascendente de A-Z ou

00:00:30

por ordem descendente de Z para A.

00:00:33

E sob a data da coluna de nascimento

00:00:35

pode separar-se do mais antigo

00:00:38

para os mais novos e vice-versa.

00:00:41

As opções de triagem estão relacionadas

00:00:42

para o tipo de dados de colunas.

00:00:44

Pode filtrar ainda mais o

00:00:45

dados clicando em "filter by" em

00:00:47

o exemplo do menu suspenso,

00:00:49

se quiser ver apenas a lista de

00:00:52

funcionários nas divisões de fax e impressora,

00:00:54

usar o menu drop down

00:00:56

na coluna de divisão,

00:00:57

em seguida, clique em "filter by".

00:01:00

Verifique as caixas de fax e impressora.

00:01:05

E, em seguida, clique no botão de aplicar.

00:01:11

A partir do menu drop down você também pode usar

00:01:14

a opção "grupo por" para obter os seus itens

00:01:17

da lista contra os dados das colunas.

00:01:19

Por exemplo, a coluna de divisão

00:01:22

ir para o menu dropdown e

00:01:24

clique em "grupo por divisão".

00:01:26

Primeiro encontra-se os empregados da divisão de faxes,

00:01:30

em seguida, a fotocopiadora

00:01:32

funcionários da divisão e último

00:01:34

os funcionários da divisão de impressoras.

00:00:04

filtrado a través de cada columna

00:00:06

opción de clasificación y filtro de encabezados.

00:00:08

A la derecha de cada encabezado de columna

00:00:11

hay una flecha hacia abajo.

00:00:13

Al hacer clic en él usted

00:00:15

abra el menú desplegable.

00:00:17

Aquí tienes varias opciones basadas

00:00:19

en la lista de empleados de esta empresa

00:00:22

desea ordenar la columna de nombre.

00:00:24

Puede ordenar por nombre de empleado,

00:00:27

por orden ascendente de la A a la Z o

00:00:30

por orden descendente de Z a A.

00:00:33

Y bajo la columna de fecha de nacimiento

00:00:35

Puede ordenar desde el más antiguo

00:00:38

a los más nuevos y viceversa.

00:00:41

Las opciones de clasificación están relacionadas

00:00:42

al tipo de datos columnas.

00:00:44

Puede filtrar aún más el

00:00:45

datos haciendo clic en "filtrar por" en

00:00:47

el ejemplo del menú desplegable,

00:00:49

Si desea ver sólo la lista de

00:00:52

empleados de las divisiones de fax e impresora,

00:00:54

Utilice el menú desplegable

00:00:56

en la columna de división,

00:00:57

luego haga clic en "filtrar por".

00:01:00

Marque las casillas de fax e impresora.

00:01:05

Y luego haga clic en el botón aplicar.

00:01:11

Desde el menú desplegable también puedes usar

00:01:14

la opción "agrupar por" para obtener sus artículos

00:01:17

de la lista contra los datos de las columnas.

00:01:19

Por ejemplo, la columna de división

00:01:22

vaya al menú desplegable y

00:01:24

haga clic en "grupo por división".

00:01:26

Primero encuentra a los empleados de la división de fax,

00:01:30

a continuación, la fotocopiadora

00:01:32

empleados de la división y últimos

00:01:34

los empleados de la división de impresoras.

00:00:04

filtrato per ogni colonna

00:00:06

intestazioni ordinare e filtrare opzione.

00:00:08

A destra di ogni intestazione di colonna

00:00:11

c'è una freccia verso il basso.

00:00:13

Cliccando su di esso si

00:00:15

apri il menu a discesa.

00:00:17

Qui hai diverse opzioni basate su

00:00:19

nell'elenco dei dipendenti di questa azienda

00:00:22

si desidera ordinare la colonna del nome.

00:00:24

È possibile ordinare per nome dei dipendenti,

00:00:27

per ordine crescente dalla A alla Z o

00:00:30

in ordine decrescente dalla Z alla A.

00:00:33

E sotto la colonna della data di nascita

00:00:35

È possibile ordinare dal più vecchio

00:00:38

al più recente e viceversa.

00:00:41

Le opzioni di ordinamento sono correlate

00:00:42

al tipo di dati columns.

00:00:44

È possibile filtrare ulteriormente il

00:00:45

dati facendo clic su "filtra per" in

00:00:47

l'esempio di menu a discesa,

00:00:49

Se si desidera visualizzare solo l'elenco di

00:00:52

dipendenti delle divisioni fax e stampanti,

00:00:54

Utilizzare il menu a discesa

00:00:56

nella colonna della divisione,

00:00:57

quindi fare clic su "filtra per".

00:01:00

Controllare le caselle fax e stampante.

00:01:05

E quindi fare clic sul pulsante Applica.

00:01:11

Dal menu a tendina puoi anche utilizzare

00:01:14

l'opzione "raggruppa per" per ottenere i suoi oggetti

00:01:17

dall'elenco rispetto ai dati delle colonne.

00:01:19

Ad esempio, la colonna di divisione

00:01:22

vai al menu a tendina e

00:01:24

clicca su "raggruppa per divisione".

00:01:26

Per prima cosa trovi i dipendenti della divisione fax,

00:01:30

poi la fotocopiatrice fotografica

00:01:32

dipendenti della divisione e ultimi

00:01:34

i dipendenti della divisione stampanti.

00:00:04

gefiltert über jede Spalte

00:00:06

Optionen zum Sortieren und Filtern von Headern.

00:00:08

Rechts neben jeder Spaltenüberschrift

00:00:11

Es gibt einen Pfeil nach unten.

00:00:13

Wenn Sie darauf klicken, können Sie

00:00:15

Öffnen Sie das Dropdown-Menü.

00:00:17

Hier haben Sie mehrere Optionen basierend

00:00:19

auf der Mitarbeiterliste dieses Unternehmens

00:00:22

Sie möchten die Namensspalte sortieren.

00:00:24

Sie können nach Mitarbeiternamen sortieren,

00:00:27

in aufsteigender Reihenfolge von A-Z oder

00:00:30

durch absteigende Reihenfolge von Z nach A.

00:00:33

Und unter der Spalte "Geburtsdatum"

00:00:35

Sie können von den ältesten sortieren

00:00:38

zum Neuesten und umgekehrt.

00:00:41

Sortieroptionen sind verwandt

00:00:42

auf den Columns-Datentyp.

00:00:44

Sie können die

00:00:45

Daten durch Klicken auf "Filtern nach" in

00:00:47

das Dropdown-Menübeispiel,

00:00:49

Wenn Sie nur die Liste der

00:00:52

Mitarbeiter in den Bereichen Fax und Drucker,

00:00:54

Verwenden Sie das Dropdown-Menü

00:00:56

in der Spalte Division,

00:00:57

klicken Sie dann auf "Filtern nach".

00:01:00

Überprüfen Sie die Fax- und Druckerboxen.

00:01:05

Klicken Sie dann auf die Schaltfläche Übernehmen.

00:01:11

Aus dem Dropdown-Menü können Sie auch verwenden

00:01:14

die Option "Gruppieren nach", um ihre Artikel zu erhalten

00:01:17

aus der Liste für die Spaltendaten.

00:01:19

Zum Beispiel die Divisionsspalte

00:01:22

gehen Sie zum Dropdown-Menü und

00:01:24

Klicken Sie auf "Gruppe nach Abteilung".

00:01:26

Zuerst finden Sie die Mitarbeiter der Faxabteilung,

00:01:30

dann der Fotokopierer

00:01:32

Bereichsmitarbeiter und letzter

00:01:34

die Mitarbeiter der Druckerabteilung.

00:00:04

通過每個列過濾

00:00:06

頭排序和篩選選項。

00:00:08

每個列頭的右側

00:00:11

有一個向下的箭頭。

00:00:13

點擊它，你

00:00:15

打開下拉功能表。

00:00:17

在這裡，您有幾個選項基於

00:00:19

在公司的員工名單上

00:00:22

您希望對名稱列進行排序。

00:00:24

您可以按員工姓名進行排序，

00:00:27

通過從 A-Z 或提升訂單

00:00:30

通過將訂單從 Z 降低到 A。

00:00:33

並在出生日期列下

00:00:35

你可以從最老的排序

00:00:38

最新的，反之亦然。

00:00:41

排序選項是相關的

00:00:42

到列數據類型。

00:00:44

您可以進一步過濾

00:00:45

數據通過單擊「過濾器」在

00:00:47

下拉功能表示例，

00:00:49

如果您只想查看

00:00:52

傳真和印表機部門的員工，

00:00:54

使用下拉功能表

00:00:56

在部門列中，

00:00:57

然後點擊「過濾器」。

00:01:00

檢查傳真和印表機盒。

00:01:05

然後按兩下應用按鈕。

00:01:11

從下拉功能表，你也可以使用

00:01:14

按組「選項獲取她的專案」。

00:01:17

從清單對列數據。

00:01:19

例如，部門列

00:01:22

去下拉功能表和

00:01:24

按下"按部門分組"。

00:01:26

首先你找到傳真部門的員工，

00:01:30

然後是照片複印機

00:01:32

部門員工和最後

00:01:34

印表機部門的員工。

00:00:04

gefilterd via elke kolom

00:00:06

kopteksten sorteren en filteren optie.

00:00:08

Rechts van elke kolomkop

00:00:11

Er is een pijl-omlaag.

00:00:13

Door erop te klikken

00:00:15

open het vervolgkeuzemenu.

00:00:17

Hier heb je verschillende opties gebaseerd

00:00:19

op de lijst van werknemers van dit bedrijf

00:00:22

u de naamkolom wilt sorteren.

00:00:24

U kunt sorteren op naam van werknemers,

00:00:27

door oplopende volgorde van A-Z of

00:00:30

door aflopende volgorde van Z naar A.

00:00:33

En onder de kolom geboortedatum

00:00:35

u kunt sorteren van de oudste

00:00:38

naar de nieuwste en vice versa.

00:00:41

Sorteeropties zijn gerelateerd

00:00:42

naar het gegevenstype kolommen.

00:00:44

U kunt de

00:00:45

gegevens door te klikken op "filter op" in

00:00:47

het vervolgkeuzemenu voorbeeld,

00:00:49

als u alleen de lijst met

00:00:52

werknemers in de fax- en printerafdelingen,

00:00:54

gebruik het vervolgkeuzemenu

00:00:56

in de kolom afdeling,

00:00:57

klik dan op "filter op".

00:01:00

Controleer de fax- en printervakken.

00:01:05

Klik vervolgens op de knop Toepassen.

00:01:11

In het vervolgkeuzemenu kunt u ook

00:01:14

de optie "groeperen op" om haar items te krijgen

00:01:17

uit de lijst ten opzichte van de kolommengegevens.

00:01:19

Bijvoorbeeld de divisiekolom

00:01:22

ga naar het vervolgkeuzemenu en

00:01:24

klik op "groeperen op divisie".

00:01:26

Eerst vindt u de medewerkers van de faxafdeling,

00:01:30

dan het fotokopieerapparaat

00:01:32

divisiemedewerkers en laatste

00:01:34

de medewerkers van de printerdivisie.

00:00:04

được lọc qua từng cột

00:00:06

tùy chọn sắp xếp tiêu đề và lọc.

00:00:08

Ở bên phải của mỗi tiêu đề cột

00:00:11

Có một mũi tên xuống.

00:00:13

Bằng cách nhấp vào nó, bạn

00:00:15

mở menu thả xuống.

00:00:17

Ở đây bạn có một số tùy chọn dựa trên

00:00:19

trong danh sách nhân viên của công ty này

00:00:22

Bạn muốn sắp xếp cột tên.

00:00:24

Bạn có thể sắp xếp theo tên nhân viên,

00:00:27

bằng cách tăng thứ tự từ A-Z hoặc

00:00:30

theo thứ tự giảm dần từ Z đến A.

00:00:33

Và dưới cột ngày sinh

00:00:35

Bạn có thể sắp xếp từ người lớn tuổi nhất

00:00:38

cho người mới nhất và ngược lại.

00:00:41

Các tùy chọn sắp xếp có liên quan

00:00:42

đến kiểu dữ liệu cột.

00:00:44

Bạn có thể lọc thêm

00:00:45

dữ liệu bằng cách nhấp vào "bộ lọc theo" trong

00:00:47

ví dụ menu thả xuống,

00:00:49

Nếu bạn chỉ muốn xem danh sách

00:00:52

nhân viên trong các bộ phận fax và máy in,

00:00:54

sử dụng menu thả xuống

00:00:56

trong cột phân chia,

00:00:57

sau đó nhấp vào "filter by".

00:01:00

Kiểm tra hộp fax và máy in.

00:01:05

Sau đó bấm nút áp dụng.

00:01:11

Từ menu thả xuống bạn cũng có thể sử dụng

00:01:14

tùy chọn "nhóm theo" để có được các mặt hàng của mình

00:01:17

từ danh sách chống lại dữ liệu cột.

00:01:19

Ví dụ, cột phân chia

00:01:22

đi đến menu thả xuống và

00:01:24

nhấp vào "nhóm theo phân chia".

00:01:26

Đầu tiên bạn tìm thấy các nhân viên bộ phận fax,

00:01:30

sau đó là máy photocopy ảnh

00:01:32

nhân viên bộ phận và cuối cùng

00:01:34

nhân viên bộ phận máy in.

00:00:04

difilter melalui setiap kolom

00:00:06

header mengurutkan dan memfilter opsi.

00:00:08

Di sebelah kanan setiap header kolom

00:00:11

Ada panah bawah.

00:00:13

Dengan mengkliknya Anda

00:00:15

buka menu drop down.

00:00:17

Di sini Anda memiliki beberapa pilihan berdasarkan

00:00:19

dalam daftar karyawan perusahaan ini

00:00:22

Anda ingin mengurutkan kolom nama.

00:00:24

Anda dapat mengurutkan berdasarkan nama karyawan,

00:00:27

dengan naik order dari A-Z atau

00:00:30

dengan turun pesanan dari Z ke A.

00:00:33

Dan di bawah kolom tanggal lahir

00:00:35

Anda dapat mengurutkan dari yang tertua

00:00:38

untuk yang terbaru dan sebaliknya.

00:00:41

Opsi pengurutan terkait

00:00:42

ke tipe data kolom.

00:00:44

Anda dapat memfilter lebih lanjut

00:00:45

data dengan mengklik "filter by" di

00:00:47

Contoh menu dropdown,

00:00:49

Jika Anda hanya ingin melihat daftar

00:00:52

karyawan di divisi faks dan printer,

00:00:54

gunakan menu drop down

00:00:56

di kolom pembagian,

00:00:57

kemudian klik "filter by".

00:01:00

Periksa kotak faks dan printer.

00:01:05

Lalu klik tombol apply.

00:01:11

Dari menu drop down anda juga bisa menggunakan

00:01:14

opsi "grup demi" untuk mendapatkan barang-barangnya

00:01:17

dari daftar terhadap data kolom.

00:01:19

Misalnya, kolom pembagian

00:01:22

Pergi ke menu dropdown dan

00:01:24

Klik pada "grup demi divisi".

00:01:26

Pertama Anda menemukan karyawan divisi faks,

00:01:30

kemudian mesin fotokopi foto

00:01:32

karyawan divisi dan terakhir

00:01:34

karyawan divisi printer.

00:00:04

各列を介してフィルタリング

00:00:06

ヘッダーの並べ替えとフィルタオプション。

00:00:08

各列ヘッダーの右側

00:00:11

下向きの矢印があります。

00:00:13

それをクリックすると、あなた

00:00:15

ドロップダウンメニューを開きます。

00:00:17

ここでは、いくつかのオプションをベースにしています

00:00:19

この会社の従業員リストに

00:00:22

名前列を並べ替えます。

00:00:24

従業員名で並べ替え

00:00:27

A-Z または A から昇順で

00:00:30

Z から A への降順で行います。

00:00:33

そして、生年月日のコラムの下で

00:00:35

最も古いものから並べ替えることができます

00:00:38

最新の場合、またその逆も同様です。

00:00:41

並べ替えオプションは関連しています

00:00:42

を列のデータ型に変換します。

00:00:44

さらにフィルターを適用できます。

00:00:45

で [フィルタ] をクリックしてデータを表示する

00:00:47

ドロップダウンメニューの例

00:00:49

の一覧のみを表示する場合

00:00:52

FAX部門およびプリンタ部門の従業員

00:00:54

ドロップダウンメニューを使用する

00:00:56

分割列に

00:00:57

をクリックしてから「フィルタ」をクリックします。

00:01:00

FAX とプリンタのボックスを確認します。

00:01:05

次に、[適用] ボタンをクリックします。

00:01:11

ドロップダウンメニューからも

00:01:14

彼女のアイテムを取得する「グループ化」オプション

00:01:17

を列データに対してリストから取得します。

00:01:19

たとえば、除算列

00:01:22

ドロップダウンメニューに移動し、

00:01:24

「分割によるグループ化」をクリックします。

00:01:26

まず、FAX部門の従業員を見つけ、

00:01:30

その後、コピー機

00:01:32

部門の従業員と最後

00:01:34

プリンタ部門の従業員。

00:00:04

تمت تصفيته عبر كل عمود

00:00:06

رأس فرز وتصفية الخيار.

00:00:08

على يمين كل رأس عمود

00:00:11

هناك سهم لأسفل

00:00:13

من خلال النقر عليه لك

00:00:15

افتح القائمة المنسدلة.

00:00:17

هنا لديك العديد من الخيارات القائمة

00:00:19

على قائمة موظفي هذه الشركة

00:00:22

ترغب في فرز عمود الاسم.

00:00:24

يمكنك الفرز حسب اسم الموظفين،

00:00:27

بترتيب تصاعدي من A-Z أو

00:00:30

بترتيب تنازلي من Z إلى A.

00:00:33

وتحت عمود تاريخ الميلاد

00:00:35

يمكنك فرز من أقدم

00:00:38

إلى الأحدث والعكس بالعكس.

00:00:41

خيارات الفرز مرتبطة

00:00:42

إلى نوع بيانات الأعمدة.

00:00:44

يمكنك تصفية المزيد من

00:00:45

البيانات بالنقر فوق "تصفية حسب" في

00:00:47

مثال القائمة المنسدلة،

00:00:49

إذا كنت تريد عرض قائمة

00:00:52

العاملين في قسمي الفاكس والطابعة،

00:00:54

استخدام القائمة المنسدلة

00:00:56

في عمود القسمة،

00:00:57

ثم انقر على "تصفية من قبل".

00:01:00

تحقق من مربعات الفاكس والطابعة.

00:01:05

ثم انقر فوق الزر تطبيق.

00:01:11

من القائمة المنسدلة يمكنك أيضا استخدام

00:01:14

خيار "المجموعة حسب" للحصول على عناصرها

00:01:17

من القائمة مقابل بيانات الأعمدة.

00:01:19

على سبيل المثال، عمود القسمة

00:01:22

انتقل إلى القائمة المنسدلة و

00:01:24

انقر على "مجموعة حسب القسمة".

00:01:26

أولا تجد موظفي قسم الفاكس،

00:01:30

ثم ناسخة الصور

00:01:32

موظفي القسم وآخر

00:01:34

موظفي قسم الطابعة.

00:00:04

her sütun üzerinden filtre uygulanmış

00:00:06

üstbilgiler sıralama ve filtreleme seçeneği.

00:00:08

Her sütun başlığının sağında

00:00:11

Aşağı ok var.

00:00:13

Üzerine tıklayarak

00:00:15

açılır menüyü açın.

00:00:17

Burada,

00:00:19

bu şirketin çalışan listesinde

00:00:22

ad sütununu sıralamak istersiniz.

00:00:24

Çalışanların adına göre sıralayabilirsiniz,

00:00:27

A-Z'den artan sırayla veya

00:00:30

Z'den A'ya sipariş indirerek.

00:00:33

Ve doğum tarihinin altında

00:00:35

en eskisinden sıralayabilirsiniz

00:00:38

en yenisine ve tersi yönde.

00:00:41

Sıralama seçenekleri ilişkilidir

00:00:42

sütun veri türüne.

00:00:44

Ayrıca,

00:00:45

'de "filtre uygula"

00:00:47

açılır menü örneği,

00:00:49

yalnızca listesini görüntülemek istiyorsanız,

00:00:52

faks ve yazıcı bölümlerinde çalışanlar,

00:00:54

açılır menüyü kullanma

00:00:56

bölüm sütununda,

00:00:57

ardından "filtrele" ye tıklayın.

00:01:00

Faks ve yazıcı kutularını işaretleyin.

00:01:05

Ardından uygula düğmesine tıklayın.

00:01:11

Açılır menüden de kullanabilirsiniz

00:01:14

öğelerini almak için "grupla" seçeneği

00:01:17

sütun verilerine karşı listeden.

00:01:19

Örneğin, bölme sütunu

00:01:22

açılır menüye gidin ve

00:01:24

"bölüme göre grupla" yı tıklayın.

00:01:26

Önce faks bölümü çalışanlarını bul.

00:01:30

sonra fotoğraf fotokopi makinesi

00:01:32

bölüm çalışanları ve son

00:01:34

yazıcı bölümü çalışanları.

00:00:04

각 열을 통해 필터링

00:00:06

헤더정렬 및 필터 옵션입니다.

00:00:08

각 열 헤더의 오른쪽에

00:00:11

다운 화살표가 있습니다.

00:00:13

그것을 클릭하여 당신

00:00:15

드롭다운 메뉴를 엽니다.

00:00:17

여기에 는 여러 가지 옵션을 기반으로 합니다.

00:00:19

이 회사의 직원 목록에

00:00:22

이름 열을 정렬하려고 합니다.

00:00:24

직원 이름으로 정렬할 수 있습니다.

00:00:27

A-Z에서 오름차순으로 또는

00:00:30

Z에서 A로 내려오는 순서를 내림차순으로.

00:00:33

그리고 생년월일 의 날짜 미만

00:00:35

당신은 가장 오래된에서 정렬 할 수 있습니다

00:00:38

최신 및 그 반대의 경우도 마찬가지입니다.

00:00:41

정렬 옵션은 관련되어 있습니다.

00:00:42

열 데이터 형식에 대해.

00:00:44

추가 필터링할 수 있습니다.

00:00:45

에서 "필터로"를 클릭하여 데이터

00:00:47

드롭다운 메뉴 예제는

00:00:49

목록만 보려면

00:00:52

팩스 및 프린터 부서의 직원,

00:00:54

드롭다운 메뉴 사용

00:00:56

분할 열에서,

00:00:57

그런 다음 "필터로"를 클릭합니다.

00:01:00

팩스 와 프린터 상자를 확인합니다.

00:01:05

그런 다음 적용 버튼을 클릭합니다.

00:01:11

드롭다운 메뉴에서 사용할 수도 있습니다.

00:01:14

그녀의 항목을 얻을 수있는 "그룹별"옵션

00:01:17

열 데이터에 대한 목록에서.

00:01:19

예를 들어 분할 열

00:01:22

드롭다운 메뉴로 이동하여

00:01:24

"분할별 그룹"을 클릭합니다.

00:01:26

먼저 팩스 부서 직원을 찾을 수 있습니다.

00:01:30

그런 다음 사진 복사기

00:01:32

부서 직원 및 마지막

00:01:34

프린터 부서 직원.

00:00:04

通过每列过滤

00:00:06

标头排序和筛选选项。

00:00:08

在每列标题的右侧

00:00:11

有一个向下箭头。

00:00:13

通过单击它，您可以

00:00:15

打开下拉菜单。

00:00:17

在这里，您有几个选项

00:00:19

在该公司的员工名单上

00:00:22

您希望对名称列进行排序。

00:00:24

您可以按员工姓名排序，

00:00:27

按从 A 到 Z 的升序排列，或

00:00:30

通过从 Z 到 A 的降序。

00:00:33

并在出生日期列下

00:00:35

您可以从最旧的排序

00:00:38

到最新的，反之亦然。

00:00:41

排序选项是相关的

00:00:42

到列数据类型。

00:00:44

您可以进一步过滤

00:00:45

数据，点击"过滤依据"

00:00:47

下拉菜单示例，

00:00:49

如果您只想查看

00:00:52

传真和打印机部门的员工，

00:00:54

使用下拉菜单

00:00:56

在除法列中，

00:00:57

然后点击"过滤依据"。

00:01:00

选中传真和打印机框。

00:01:05

然后单击应用按钮。

00:01:11

从下拉菜单中，您还可以使用

00:01:14

"分组依据"选项以获取她的项目

00:01:17

从列表中针对列数据。

00:01:19

例如，除法列

00:01:22

转到下拉菜单，然后

00:01:24

点击"按部门分组"。

00:01:26

首先你找到传真部门的员工，

00:01:30

然后使用照片复印机

00:01:32

部门员工和最后

00:01:34

打印机部门员工。

00:00:04

filtrate prin fiecare coloană

00:00:06

opțiunea de sortare și filtrare a anteturilor.

00:00:08

În partea dreaptă a fiecărui antet de coloană

00:00:11

există o săgeată în jos.

00:00:13

Făcând clic pe ea vă

00:00:15

deschideți meniul derulant.

00:00:17

Aici aveți mai multe opțiuni bazate pe

00:00:19

pe lista de angajati a acestei companii

00:00:22

doriți să sortați coloana de nume.

00:00:24

Puteți sorta după numele angajaților,

00:00:27

în ordine crescătoare de la A-Z sau

00:00:30

în ordine descrescătoare de la Z la A.

00:00:33

Și sub coloana data nașterii

00:00:35

puteți sorta de la cel mai vechi

00:00:38

la cele mai noi și invers.

00:00:41

Opțiunile de sortare sunt legate de

00:00:42

la tipul de date coloane.

00:00:44

Puteți filtra în continuare

00:00:45

date făcând clic pe "filtrați după" în

00:00:47

exemplu de meniu vertical,

00:00:49

dacă doriți să vizualizați numai lista de

00:00:52

angajații din diviziile de fax și imprimantă;

00:00:54

utilizați meniul vertical

00:00:56

în coloana de diviziune,

00:00:57

apoi faceți clic pe "filtrați după".

00:01:00

Bifați casetele fax și imprimantă.

00:01:05

Și apoi faceți clic pe butonul se aplică.

00:01:11

Din meniul derulant pe care îl puteți utiliza, de asemenea,

00:01:14

opțiunea "grup după" pentru a obține articolele ei

00:01:17

din listă în raport cu datele coloanelor.

00:01:19

De exemplu, coloana de diviziune

00:01:22

accesați meniul vertical și

00:01:24

faceți clic pe "grup după împărțire".

00:01:26

Mai întâi găsiți angajații diviziei de fax,

00:01:30

apoi copiatorul de fotografii

00:01:32

angajații diviziei și ultimul

00:01:34

angajații diviziei de imprimante.

00:00:04

filtrado através de cada coluna

00:00:06

cabeçalhos classificam e filtram opção.

00:00:08

À direita de cada cabeçalho de coluna

00:00:11

há uma flecha para baixo.

00:00:13

Clicando nele você

00:00:15

abrir o menu suspenso.

00:00:17

Aqui você tem várias opções baseadas

00:00:19

na lista de funcionários desta empresa

00:00:22

você deseja classificar a coluna de nomes.

00:00:24

Você pode classificar pelo nome dos funcionários,

00:00:27

por ordem ascendente de A-Z ou

00:00:30

descendo a ordem de Z para A.

00:00:33

E sob a data de nascimento coluna

00:00:35

você pode classificar a partir do mais velho

00:00:38

para o mais novo e vice-versa.

00:00:41

As opções de classificação estão relacionadas

00:00:42

para o tipo de dados das colunas.

00:00:44

Você pode filtrar ainda mais o

00:00:45

dados clicando em "filtrar por" em

00:00:47

o exemplo do menu suspenso,

00:00:49

se você quiser ver apenas a lista de

00:00:52

funcionários nas divisões de fax e impressora,

00:00:54

usar o menu suspenso

00:00:56

na coluna de divisão,

00:00:57

em seguida, clique em "filtrar por".

00:01:00

Verifique as caixas de fax e impressora.

00:01:05

E então clique no botão aplicar.

00:01:11

A partir do menu suspenso você também pode usar

00:01:14

a opção "grupo por" para obter seus itens

00:01:17

da lista contra os dados das colunas.

00:01:19

Por exemplo, a coluna de divisão

00:01:22

ir para o menu suspenso e

00:01:24

clique em "grupo por divisão".

00:01:26

Primeiro você encontra os funcionários da divisão de fax,

00:01:30

em seguida, a copiadora de fotos

00:01:32

funcionários da divisão e último

00:01:34

os funcionários da divisão de impressoras.

00:00:04

фильтруется через каждый столбец

00:00:06

параметр сортировки и фильтрации заголовков.

00:00:08

Справа от заголовка каждого столбца

00:00:11

есть стрелка вниз.

00:00:13

Нажав на него, вы

00:00:15

откройте раскрывающееся меню.

00:00:17

Здесь у вас есть несколько вариантов на основе

00:00:19

в списке сотрудников данной компании

00:00:22

Вы хотите отсортировать столбец имени.

00:00:24

Вы можете сортировать по имени сотрудника,

00:00:27

в порядке возрастания от A до Z или

00:00:30

в порядке убывания от Z до A.

00:00:33

И под колонкой даты рождения

00:00:35

Вы можете сортировать от самых старых

00:00:38

к новейшим и наоборот.

00:00:41

Параметры сортировки связаны

00:00:42

к типу данных столбцов.

00:00:44

Вы можете дополнительно отфильтровать

00:00:45

данные, нажав «фильтровать по» в

00:00:47

пример раскрывающегося меню,

00:00:49

если вы хотите просмотреть только список

00:00:52

сотрудники отделов факсов и принтеров,

00:00:54

Воспользуйтесь раскрывающимся меню

00:00:56

в столбце деления,

00:00:57

затем нажмите «фильтровать по».

00:01:00

Проверьте факс и принтеры.

00:01:05

Затем нажмите кнопку применить.

00:01:11

Из выпадающего меню вы также можете использовать

00:01:14

опция «Группировать по», чтобы получить ее элементы

00:01:17

из списка по отношению к данным столбцов.

00:01:19

Например, столбец деления

00:01:22

перейдите в выпадающее меню и

00:01:24

нажмите на "группировка по подразделениям".

00:01:26

Сначала вы найдете сотрудников факсимильного отдела,

00:01:30

затем фотокопировальный аппарат

00:01:32

сотрудники подразделения и последние

00:01:34

сотрудники отдела печати.

00:00:04

กรองผ่านแต่ละคอลัมน์

00:00:06

ตัวเลือกการเรียงลําดับและตัวกรองส่วนหัว

00:00:08

ทางด้านขวาของส่วนหัวของคอลัมน์แต่ละอัน

00:00:11

มีลูกศรลง

00:00:13

โดยคลิกที่มันคุณ

00:00:15

เปิดเมนูแบบหล่นลง

00:00:17

ที่นี่คุณมีหลายตัวเลือกตาม

00:00:19

ในรายชื่อพนักงานของบริษัทนี้

00:00:22

คุณต้องการเรียงลําดับคอลัมน์ชื่อ

00:00:24

คุณสามารถเรียงลําดับตามชื่อพนักงาน

00:00:27

โดยลําดับจากน้อยไปหามากจาก A-Z หรือ

00:00:30

โดยลําดับจากมากไปหาน้อยจาก Z ถึง A

00:00:33

และภายใต้คอลัมน์วันเกิด

00:00:35

คุณสามารถเรียงลําดับจากที่เก่าที่สุด

00:00:38

ใหม่ล่าสุดและในทางกลับกัน

00:00:41

ตัวเลือกการเรียงลําดับมีความเกี่ยวข้องกัน

00:00:42

ไปยังชนิดข้อมูลของคอลัมน์

00:00:44

คุณสามารถกรองเพิ่มเติม

00:00:45

ข้อมูลโดยคลิก "กรองตาม" ใน

00:00:47

ตัวอย่างเมนูแบบหล่นลง

00:00:49

ถ้าคุณต้องการดูเฉพาะรายการของ

00:00:52

พนักงานในแผนกโทรสารและเครื่องพิมพ์

00:00:54

ใช้เมนูแบบหล่นลง

00:00:56

ในคอลัมน์ส่วน

00:00:57

จากนั้นคลิกที่ "กรองโดย"

00:01:00

เลือกกล่องโทรสารและเครื่องพิมพ์

00:01:05

แล้วคลิกปุ่มนําไปใช้

00:01:11

จากเมนูแบบเลื่อนลงคุณยังสามารถใช้

00:01:14

ตัวเลือก "จัดกลุ่มตาม" เพื่อรับรายการของเธอ

00:01:17

จากรายการกับข้อมูลคอลัมน์

00:01:19

ตัวอย่างเช่น คอลัมน์หาร

00:01:22

ไปที่เมนูแบบหล่นลงและ

00:01:24

คลิกที่ "จัดกลุ่มตามการหาร"

00:01:26

ก่อนอื่นคุณพบพนักงานแผนกแฟกซ์

00:01:30

จากนั้นเครื่องถ่ายเอกสารรูปถ่าย

00:01:32

พนักงานส่วนงานและคนสุดท้าย

00:01:34

พนักงานแผนกเครื่องพิมพ์

00:00:04

filtrirano preko svake kolone

00:00:06

zaglavlja sortiraju i filtriraju.

00:00:08

Sa desne strane zaglavlja svake kolone

00:00:11

Dole je strela.

00:00:13

Klikom na njega ti

00:00:15

otvorite pašišni meni.

00:00:17

Ovde imate nekoliko opcija zasnovanih na

00:00:19

na listi zaposlenih ovog preduzeća

00:00:22

želite da sortirate kolonu sa imenom.

00:00:24

Možete sortirati po imenu zaposlenih,

00:00:27

rastućim redosledom od A-Z ili

00:00:30

opadajućim redosledom od Z do A.

00:00:33

I ispod datuma rođenja kolumna

00:00:35

možete sortirati od najstarijeg

00:00:38

do najnovijih i obrnuto.

00:00:41

Opcije sortiranja su povezane

00:00:42

u tip podataka kolona.

00:00:44

Dalje možete filtrirati

00:00:45

podatke klikom na dugme "filtriraj po" u

00:00:47

primer padajućeg menija,

00:00:49

ako želite da prikažete samo listu

00:00:52

zaposlenima u odeljenjima za faks i štampače,

00:00:54

korišćenje padajućeg menija

00:00:56

u koloni podele,

00:00:57

zatim kliknite na dugme "filtriraj po".

00:01:00

Proverite polja za faks i štampač.

00:01:05

A zatim kliknite na dugme "Primeni".

00:01:11

Iz padajućeg menija možete koristiti i

00:01:14

opcija "grupiši po" da bi dobila svoje predmete

00:01:17

sa liste u odnosu na podatke kolona.

00:01:19

Na primer, kolona podele

00:01:22

idite na pašni meni i

00:01:24

kliknite na "grupiši po diviziji".

00:01:26

Prvo nađite zaposlene u faks odeljenju,

00:01:30

zatim foto kopir

00:01:32

zaposleni u odeljenju i poslednji

00:01:34

zaposleni u odeljenju štampača.

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This tutorial is part of the following courses

2930 Views

Microsoft Lists Video Training - Create Smart Lists

Learn about Microsoft Lists, the latest app in the Microsoft 365 solution, which allows you to create smart lists to track and collect infor...

ALL COURSES