Sort & Filter Reference Guide: Long Description

Sort & Filter Reference Guide

Long Description

• The image is an instructional guide on the topic "Sort & Filter" in Excel. The guide is divided into three sections. Each section includes numbered steps, icons, and screenshots for visual assistance. 

• The top section, "Sort Data," features a sort icon and steps detailing how to sort a data range in ascending or descending order. It includes a screenshot of a spreadsheet with a sorting menu expanded for the "customer_name" column. The option "Sort A to Z" is outlined in red. 

• The middle section, "Filter Data," features a funnel icon and guides how to filter data using the dropdown arrow in a column header and choosing filter criteria. It includes a screenshot of a spreadsheet with menu expanded for the "product_category" column. The filter is only applied to "Hardware" and "Software." 

• The bottom section, "Combine Sort & Filter," is marked with an icon of overlapping squares. It gives instructions on applying filters and then sorting for better data organization, accompanied by a screenshot of a spreadsheet with filter applied to "Electronics" for the "product_category" column. 

• A footer banner reads, "Strengthen your Excel Essentials at sites.google.com/asu.edu/excelessentials."

Transcribed Text

Sort & Filter

Sort Data

1. Select the data range, including headers

2. Click the Data tab and select Filter

3. Click the dropdown arrow on the column you want to sort

4. Choose Sort A to Z for ascending or Sort Z to A for descending

5. For multiple columns, use Sort A to Z or Sort Z to A on each column in priority order

Filter Data

1. Select your data range, including headers

2. Click the Data tab and select Filter

3. Click the dropdown arrow in any column header

4. Choose your filter criteria from the menu options

5. Use custom filters for specific ranges or conditions

Combine Sort & Filter

1. Apply filters first to narrow down your data

2. Then sort the filtered results for better organization

3. Use multiple filter criteria to be more specific

4. Sort by the most relevant column for your analysis

Strengthen your Excel Essentials at sites.google.com/asu.edu/excelessentials