Complete Excel Course for Beginners

4.25

(16)

37 pages

All courses > Information Technology > Excel, Word, LibreOffice and more ( Office ) ::

Data sorting and filtering

Capítulo 15

Estimated reading time: 2 minutes

Listen in audio

0:00 / 0:00

Sorting and filtering data in Excel are two powerful tools that help organize and analyze large amounts of information. Sorting lets you sort your data based on specific criteria, while filtering lets you show only data that meets certain criteria.

Data Classification

Sort can be useful for organizing data in a variety of ways, such as alphabetically, numerically, or by date. To sort data in a worksheet, follow these steps:

Select the column you want to sort by
Click the "Data" tab on the toolbar
Select "Sort" and choose the desired sorting criteria

For example, if you want to sort a list of names alphabetically, select the column with the names and choose "Sort A to Z". If you want to sort a list of dates in ascending order, select the column with the dates and choose "Sort from oldest to newest".

Data filtering

Filtering can be useful to view only data that meets certain criteria. For example, if you have a spreadsheet with customer information, you can filter the data to only show customers who live in a certain city.

To filter data in a spreadsheet, follow these steps:

Continue in our app.

You can listen to the audiobook with the screen off, receive a free certificate for this course, and also have access to 5,000 other free online courses.

Or continue reading below...

Download the app

Select the column you want to filter
Click the "Data" tab on the toolbar
Select "Filter" and choose the desired filtering criteria

For example, if you want to filter customers who live in a certain city, select the column with the cities and choose "Filter". Then select the desired city from the drop-down list of filter options.

In addition, you can use advanced filters to create more complex filtering criteria. For example, you can filter the data to only show customers who live in a certain city and who have spent more than a certain amount on purchases.

Overall, sorting and filtering data are essential tools for organizing and analyzing large amounts of information in Excel. With these tools, you can easily find and visualize the data that is relevant to you.

Now answer the exercise about the content:

_What is the difference between sorting and filtering data in Excel?

You are right! Congratulations, now go to the next page

You missed! Try again.

Sorting allows you to organize data based on specific criteria, such as alphabetically or numerically. In contrast, filtering enables you to display only the data that meets certain conditions. These functions are distinct and serve different purposes in data management within Excel.

Next chapter

data validation