In the previous screencast, I showed you how to filter in Excel. I wanted to also show you an exciting function that's available in Office 365 known as the filter function. So I showed you previously how you can click anywhere here and you can go up here to data and filter. So we've added a filter here, and maybe we wanted to just filter by Section 102. So we want it to only display those students that are in Section 102. So that's how you can apply a typical filter. To remove the filter, we can just do clear filter from section. I wanted to show you a really exciting function that's built into Office 365. Maybe we have a cell here where the user can select the section. And I'm going to use data validation here, and I'm going to make this a list. And we can just type in the five different sections. And I can click OK, and that means we have this drop down menu. And the user can select the section. Now we can use the filter function, again this is only available if you have Office 365. So I'm going to put in my array and I'm just going to select the top row, Control+ Shift+Down. You could also, it's probably better practice to name that something like data. And then the second argument is the condition that we're filtering through. So the condition here is that the section, so I can click there, Control+Shift+Down is equal to, I'm just going to point to this cell there. So that cell F2. Then I can close this, I can press Enter. And it's only extracting the section 101 students. If I didn't want this 101 on the end, if I just wanted the students and maybe their student ID number, I can just go back into this formula. And instead of filtering through A2 to C51, I can change that to B51. And the nice thing about this is if you add students, so maybe you added a student over here, and they are also in section 101, then it automatically updates here. So that's kind of a unique filtering feature in Excel. And we can always go up here and I can change the section and it automatically updates. Another example we worked through previously was we had these batches and we did some various filtering. Maybe we added a bonus. So again, you can go up here to the data tab and we can filter. And maybe we wanted to filter by only those who received a bonus. Then we can do that. Alternatively, let's go ahead and remove the filter. Alternatively I can use the filter function. So I'm going to filter, and maybe all we really care about is the batch ID. So I can do Control+Shift+Down. And then include I'm going to say the last column. So I'm going to just Just highlight that. Highlight that all the way down, is equal to yes. And if that's true, we're going to filter by those. So these are the batch numbers, the batch IDs that received bonuses. So we can track down whoever was in charge of those. I think the bonus in the previous screencast was for shipping within five days. And then we can give those, whoever's in charge of the shipping and packaging, bonuses. So hopefully this screencast gives you a better idea of using that filter function in Office 365. Thanks for watching.