Sorting data is important when analyzing data. Data can be sorted alphabetically, from highest to lowest, by dates and times, etc. Sorting data helps you quickly visualize and understand your data better, organize and find the data that you want, and ultimately make more effective decisions. You can also sort by a custom list you create (such as Large, Medium, and Small) or by format, including cell color, font color, or icon set. To find the top or bottom values in a range of cells or table, such as the top 10 grades or the bottom 5 sales amounts, use AutoFilter or conditional formatting. To learn more about how to sort data, click this link to visit the Microsoft support article: Sort data in a range or table - Microsoft Support.
Use AutoFilter in Excel can be used to show the data you want while hiding what you do not want. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data. To learn more about how to AutoFilter data, click this link to visit the Microsoft support article: Filter data in a range or table - Microsoft Support.