6 hours 3 minutes
in this model, I will be talking about functions that are located in data tab of the ribbon.
And the first thing I'm going to talk to about talk to you about is about sorting data.
And, uh, this is one of the very, very important
capabilities Off Excel
s O. Let's go to
and look a TTE This, uh,
these numbers here, this is representing some kind off sales.
Ah, report you. We have sales people. We have the revenue they have generated. Being a certain time period lets a week. And because this is, um, retail,
they have shifts. So do some people working in the morning shift. Some people were working the afternoon shift
on. We have a calm with the profit they generated. And then we have the average margin. They have
generated basically the percentage off revenue, which is profit.
uh, we're going to talk about sorting.
this, uh, this stable is sorted by
the sales person,
and we can do all sorts of sorting. So when you go to sort portion off the ribbon, it's this one here,
and you have two quick sort buttons, and you have
button that opens this sort window or that lockbox.
So oh, let's say we click here
and we click this one, which is from largest to smallest. Now this is marked from that way, but this will actually do for from largest to smallest. So if it's a text, it will. For example, if it's a text here and click here, it will sort the entire table according to this, come here.
Starting from the
the last letter of alphabet and going back to the 1st 1 to a so from said to a there are no Zedd's. Ah, it will just
sort them in that order.
Let's put it back like this. So if you go here and press it like this, so example, for example, we want to see
ah who has generated the largest
revenue. We see that silly be.
And for example, if you want to sort it by
ah profit, we will still know like this, and then it will be sorted by profit.
And if you just want to look at the margin regardless off the the actual amount of profit, we can click here and you see, so Sally B has the highest ah
revenue and highest, the prophet and the highest average margin. But the other ones are changing every time you
sorted according to different criteria.
Now, when you click on the sword
button, you get this window,
and this allows you to sort
data according to more than one level off sorting.
So let's say the tree sort first by shift
and they will shorten, of course, sell values. And let's say we're going to solve a to Z,
and then we're going to add level and then we're going to sort by, Let's say, profit
and that we want largest the smallest. So we want to separate people from the morning shift to the people from the average shift and see who is the best.
And this one here is my data has Heather is because I have clicked somewhere in a table
and this table has Heather, which is Ah, roll one.
So x l will say, OK, I have, I mean in in part of this cells here, and I will automatically select the portion of the worksheet that has something in it.
But if I you click on my data has headers, then the first throw will be excluded from sorting, which is exactly what we want here.
So I will click on okay
and you will see that now we have it sorted by shift. And then within that shift, we have the average margin. The prophet story, which is the highest one. Ah, and it was done by Lydia. So when you sort the table,
it will sort according to a column in which you selected the criteria.
But together with it all, if 22 rows change place, it will not be just those cells. It will be the entire row, which makes absolute sense.
So this is all about sorting. This is how the certain works
and the let's do the undue here. And let's do one more thing about sorting,
which is that you can select a certain
part off the
And then you can, for example, here
Ah, do sorting And let's say I'm going to sort by First of all I'm going to de select together is because now we're not sorting the entire table so we don't have
Heather's, and now he's going to ask us by which column do we want to sort? So let's say we want to sort by revenue generated, which is called B
and be wanted. Toa largest, the smallest
and ah, we cook. Okay, And then it will sort on Lee those four
rose or only those cells that we selected. So in that case, it will sort just a portion of our table. And sometimes if we want to do that,
this is exactly what Excel will, though.
So this is all about sorting. Why do you need sorting? You need it s so that you can analyze your data so you are not usually doing sorting because it's ah, it's not the function
for some kind of calculation. It's more like something you'd use for
analyzing data looking, uh, who is has generated highest revenue or profit margin over there were now on this small table it you can do it manually. But if you have ah,
100 or 1000 entries, then sort is more than useful. It is essential