EXCEL - 6
SORTING & APPLYING FILTER
Sorting and filtering are powerful tools in Excel that help you organise and analyse data efficiently. Whether you need to arrange data in a specific order or focus on specific subsets of information, these features enhance your ability to work with large datasets.
Sorting :-
Sorting in Excel is the process of arranging data in a specified order, such as alphabetical or numerical. You can sort data in ascending or descending order based on one or more columns.
Example: Sorting Alphabetically
Select the Range:
Highlight the range of cells you want to sort. This can be a single column or a group of columns.
Access the Sort Dialog:
Go to the "Data" tab on the Ribbon.
In the "Sort & Filter" group, click on "Sort."
Choose Sorting Criteria:
In the Sort dialog box, specify the column you want to sort by from the "Sort by" dropdown menu.
Choose Sort Order:
Select the sort order, either "A to Z" (ascending) or "Z to A" (descending).
Additional Levels (Optional):
If you have multiple columns and want to sort by more than one criterion, you can add additional sorting levels.
Sort:
Click "OK" to apply the sort.
Filtering :
Filtering in Excel allows you to display only the data that meets specific criteria. This is particularly useful when working with large datasets, as it helps you focus on relevant information.
Example: Filtering Data
Select the Range:
Highlight the range of cells containing your data.
Access the Filter:
Go to the "Data" tab on the Ribbon.
In the "Sort & Filter" group, click on "Filter."
Dropdown Arrows:
Small dropdown arrows will appear next to each column header. Click on the arrow for the column you want to filter.
Filter Criteria:
In the dropdown menu, you can choose specific criteria to filter the data. For example, you can select specific values, sort in ascending or descending order, or apply date filters.
Multiple Criteria (Advanced Filter):
You can use the "Filter" option to filter data based on multiple criteria or use the "Advanced Filter" for more complex conditions.
Clearing Filters:
To clear filters, go back to the "Filter" option and click "Clear."
Advanced Filtering (AutoFilter):
AutoFilter allows you to quickly filter data based on a single criterion without using the Filter dropdown for each column.
Enable AutoFilter:
Highlight the range.
Go to the "Data" tab and click "Filter."
Use Filter Arrows:
Click on the filter arrow in the column header.
Choose criteria from the dropdown menu.
Multiple Criteria:
Use multiple filter criteria in different columns to refine your data.
LEARNING IS AN EVERYDAY PROCESS SO, i will be updating previous learning with new tips and tricks.
Follow me on this where every day will be added if i learn something new about it :- https://dev.to/nitinbhatt46
Thank you for your time.
Top comments (0)