Excel is an amazing tool for analyzing data. And Sort and Filter are some of the most commonly used features to help you. To change the order of your data, you’ll want to sort it. To focus on a specific set of your data, you can filter a range of cells or a table. Take this course to learn more.
Inside this course:
Sort and filter data (1:54)
Sort data in Excel quickly, in just a few clicks. To change the order of your data, sort it. To focus on a specific set of data, filter a range of cells or a table.
Sort details (5:14)
We sorted numbers in the previous video. You can also sort text and dates, either alphabetically, by format (such as color), or by a custom list you create.
AutoFilter details (3:55)
Filter for blank cells, non-blank cells, use criteria to filter, filter by cell or font color, just to name a few. Watch this video for more details.
Advanced filter details (4:29)
You can use the Advanced Filter to create more powerful filters, such as filtering for unique records and using operators such as OR.
A brief reminder of the key points in this course.
More courses available at Microsoft Office Training.