Sort and Filter Lists

Excel icon

Download this .pdf tutorial and learn to use lists to find the information you’re looking for.

Level:
Length:
Rating:
Applies to:
File Size:

Inside this course:

Excel is an excellent number cruncher, but it's also great for creating and managing lists. You can track everything from e-mail addresses to inventory items in a list, but for lists to be useful, you need to be able to quickly find the information that you're looking for.

Before you begin
1. Prepare your worksheet
2. Sort information in a list
3. Sort by several columns at once
4. Filter a list
5. Filter by custom criteria
6. Reset filters
Quick Reference Card

Practice file

Tutorial lessons are designed to be viewed in order. Download and use this practice file for hands-on experience while taking the tutorial.

Excel practice file SortFilterLists.xlsx (92 KB)


More courses available at Microsoft Office Training.