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
  • 2552 views

Objectifs :

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

Chapitres :

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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
印表機部門的員工。

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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
プリンタ部門の従業員。

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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
موظفي قسم الطابعة.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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ı.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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
프린터 부서 직원.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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
打印机部门员工。

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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
сотрудники отдела печати.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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
พนักงานแผนกเครื่องพิมพ์

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This tutorial is part of the following courses

3316 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

An Error Has Occurred

Impossible de sauvegarder votre progression. Veuillez recharger la page, vous connecter, et essayer de nouveau. Si le problème persiste, merci de contacter un administrateur.

Close

Reminder

Show

/

Join Live Training Session