From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Filter and sort table data

Filter and sort table data

From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Start my 1-month free trial

Filter and sort table data

“

- [Instructor] One of the biggest benefits of converting data into a table format, is the ability to quickly analyze your data. After watching this video, you'll know how to filter records in a table, and how to sort data by multiple columns. Let's jump right in to our Filter_Sort workbook. There's a lot of data in this workbook and it will be great that we'll be able to filter the information and sort it to easily find the data that we're looking for. Let's start by sorting the information by region. I'll select the Region dropdown menu. And notice that we have Sort A to Z or Z to A. Let's sort it A to Z. And now all of our regions are grouped together. Now that we have it sorted, let's do some filtering. What if we just wanted to see one region? I'll go back to my Sort and Filter menu, and I want to show you two ways that you can filter. First we have our Text Filters in the middle of this window. We can choose Equals and select North or we can say Does Not Equal, and if we select…

Contents