From the course: Excel: Managing and Analyzing Data
Unlock this course with a free trial
Join today to access over 24,700 courses taught by industry experts.
Solution: Sorting and filtering data in Excel - Microsoft Excel Tutorial
From the course: Excel: Managing and Analyzing Data
Solution: Sorting and filtering data in Excel
- [Narrator] Hopefully you didn't just dive in, or if you did dive in and you got bit by a couple other snakes that were in this data set, that's fine as long as you didn't stop and give up. But there are a couple of things to deal with. First of all, column D is empty. That's not going to work for us. Because if I do try to filter, let's go to Data and Filter. Look, I get filter buttons there, not where I need them. So let's get rid of that and get rid of this empty column D. Delete it. And then we have to straighten this out, Virgil Smith. Smith there, and then Virgil. Good. My cursor is in the dataset. Let's sort. I want to sort by, yes, the ID column, sort it on cell color. On top, I want the blue color. As we can see, they are the ones who are complete. I want those on top. Yep. Add a level. Sort by ID again, cell color. On bottom, I want the gold because they are exempt. And then add two more levels because I want to sort by last name and then by first name. Okay, and look at…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Sort with multiple criteria2m 40s
-
(Locked)
Sort by cell color, font color, or cell icon6m 42s
-
(Locked)
Sort by custom list1m 36s
-
(Locked)
Sort in Power Query3m 1s
-
Use dynamic arrays: SORT, SORTBY5m 40s
-
(Locked)
Use the FILTER dynamic array function4m 20s
-
(Locked)
Use text, numeric, and date filters8m 27s
-
(Locked)
Filter in Power Query5m 56s
-
(Locked)
Filter table data interactively with slicers6m 35s
-
(Locked)
Challenge: Sorting and filtering data in Excel52s
-
(Locked)
Solution: Sorting and filtering data in Excel2m 31s
-
(Locked)
-
-
-
-