6 hours 3 minutes
this lesson will be about another very useful function off data tab in ribbon. And those are filters
and the filters can do similar things, like sorting data, but
they actually are abused for a rather different purpose.
you have again this same table
and using filters is quite simple. We'll just click inside this stable
in logistical filters
and not Excel does, in this case is automatically finds the portion off the worksheet that is filled with
and adds this dropdown list in every
Uh, and, uh,
it is necessary or makes absolute sense for your table toe. Have Heather
because thes dropdown list will be added to the heather row off the
And there you will be able to select,
uh, what's happening with the rest of the table. So what are filters doing? They're shutting or turning on, viewing off certain parts of the stable.
So in this table we have only one cone that makes sense to be used
on, and this is the shift part. So
when you hope when you click on the drop down list, you have the options to sort,
you can sort it, too. That's that to a or by color.
And you can
also filter out certain
content off that column.
So if you click on morning and be selected
everything that has morning in cell, every road that has morning in income see will be will not be displayed. So
this is it.
Then if we click here
and just want the top three and minded, these three thes entries here automatically sorted. So you, if you want
three highest, you just go to the button,
click, okay, and you get displayed. Only these.
If you want to turn it back,
you just select all.
You look okay.
And this is how the filtering works.
so ah, you can clear the filtering. So you did the filtering. You don't need it anymore. You don't want to save your fire with it. You just get there and you get back.
And also you can do some advanced filtering
in which you can use ah rather complex criteria.
So ah, here's the list.
Use your selecting. So this this is the one
and you can then choose the criteria
range for this table.
And this range doesn't exist on our table. So we're going to cancel this for a moment.
And what we're going to do is we're going to turn the filters off.
we're going to copy this.
I think this role
and we'll put going to put it here just for the
And ah. Then we're going to,
uh, copy morning
here in a shift.
And let's go now to advanced.
So XlV automatically select this
and then we click on criteria range, and then we select this
So what Excel will do is it will look here
and look where we have something entered, which is shift.
And in this shift, it will find morning. So if you click here,
it will have the same effect. Like we have gone too.
the extended regular filters
and selected only morning in the shift column.
So let's clear it, clear it.
And there's something else which you cannot do with regular filtering. So let's hear. Enter the new column, which is going to be
And let's say that
all sense people have to make quota above 30,000
to to do what they're supposed to do.
So we're going to hear put some
and you guys say revenue generated
is greater than 30,000.
And then what we want in this case,
Sorry, it has to be true.
So, um, if,
the cell is about 30,000 it's going to return through.
And then that will tell that this filter, advanced filter and excel to display that role.
If it's smaller than 30,000
it's going to be false that the value of that this, uh, this function is going to be false, in which case that row won't be this plate.
So let's percent there.
Let's now click here. Let's go to the advanced
and then we go to criteria range again. We delete the old one and we just select these two.
And now what we have here are on Lee
those that their greater than 30,000 all the others have bean removed by this filtering advanced filtering function.
So this is how filter works. And this concludes this lesson