Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
in this model, I will be talking about functions that are located in data tab of the ribbon.
00:07
And the first thing I'm going to talk to about talk to you about is about sorting data.
00:14
And, uh, this is one of the very, very important
00:19
capabilities Off Excel
00:21
s O. Let's go to
00:24
excel
00:25
and look a TTE This, uh,
00:28
these numbers here, this is representing some kind off sales.
00:34
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,
00:49
they have shifts. So do some people working in the morning shift. Some people were working the afternoon shift
00:55
on. We have a calm with the profit they generated. And then we have the average margin. They have
01:03
generated basically the percentage off revenue, which is profit.
01:08
So,
01:10
uh, we're going to talk about sorting.
01:14
So, uh,
01:15
this, uh, this stable is sorted by
01:19
the sales person,
01:22
and we can do all sorts of sorting. So when you go to sort portion off the ribbon, it's this one here,
01:30
and you have two quick sort buttons, and you have
01:36
button that opens this sort window or that lockbox.
01:41
So oh, let's say we click here
01:46
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.
02:06
Starting from the
02:08
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
02:19
sort them in that order.
02:21
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
02:29
ah who has generated the largest
02:34
revenue. We see that silly be.
02:37
And for example, if you want to sort it by
02:40
ah profit, we will still know like this, and then it will be sorted by profit.
02:49
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
03:00
revenue and highest, the prophet and the highest average margin. But the other ones are changing every time you
03:07
sorted according to different criteria.
03:12
Now, when you click on the sword
03:16
button, you get this window,
03:21
and this allows you to sort
03:23
data according to more than one level off sorting.
03:28
So let's say the tree sort first by shift
03:31
and they will shorten, of course, sell values. And let's say we're going to solve a to Z,
03:38
and then we're going to add level and then we're going to sort by, Let's say, profit
03:46
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.
03:55
And this one here is my data has Heather is because I have clicked somewhere in a table
04:01
and this table has Heather, which is Ah, roll one.
04:06
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.
04:20
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.
04:29
So I will click on okay
04:31
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,
04:48
it will sort according to a column in which you selected the criteria.
04:55
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.
05:06
So this is all about sorting. This is how the certain works
05:13
and the let's do the undue here. And let's do one more thing about sorting,
05:19
which is that you can select a certain
05:24
part off the
05:26
table.
05:28
And then you can, for example, here
05:30
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
05:44
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
05:53
and be wanted. Toa largest, the smallest
05:57
and ah, we cook. Okay, And then it will sort on Lee those four
06:03
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,
06:14
this is exactly what Excel will, though.
06:16
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
06:30
for some kind of calculation. It's more like something you'd use for
06:39
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,
06:55
100 or 1000 entries, then sort is more than useful. It is essential

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor