Sorting and filtering
Put lists in the right order and show only the rows you need.
Lessons
In the order the Roadmap teaches them.
In the full course. Beginner · 8 min
Sort A to Z and by numbers
Put a list in order by name or by amount, keep the header row where it is, and sort by two columns at once.
See the lessonIn the full course. Beginner · 9 min
Filter a list
Show only the rows you need by picking values or setting a condition, and know that the hidden rows still count in your totals.
See the lessonIn the full course. Confident · 9 min
Sort by several columns
Sort a list by two or three columns in the right order, and never break your rows by sorting one column alone.
See the lessonIn the full course. Confident · 10 min
Custom sort order (Low, Medium, High)
Sort a list in an order you set yourself, like High, Medium, Low, instead of A to Z.
See the lessonIn the full course. Confident · 8 min
Filter by color and condition
Show only the rows with a color you pick, and narrow them further with a condition on another column.
See the lessonIn the full course. Advanced · 9 min
Advanced Filter
Filter a list by conditions you type in cells, so you can ask for this or that, and copy the matching rows to another place.
See the lessonIn the full course. Advanced · 8 min
Slicers
Add a slicer to a list, filter it in one click, show several items at once and clear the filter.
See the lessonPaths with these lessons
A path is a short list of lessons from the course, picked for one goal.
Get the full course
Every lesson in the Excel course, with new lessons added as they're written.
- All 217 Excel lessons open today, and every new one as it's written.
- The Roadmap, Skills and all eight paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Google Sheets course for US$49.