0:00
welcome everyone today we're going to
0:02
dive into a very useful skill in excel
0:04
how to sort rows based on multiple
0:06
criteria this is an essential technique
0:08
that helps you organize your data in a
0:09
more refined way making it easier to
0:11
analyze and draw conclusions from
0:12
complex data sets let's get started
0:15
first select the range of data that you
0:17
want to sort you can highlight the
0:18
entire table or simply click on a cell
0:20
inside the data set after that go to the
0:23
data tab in excel and click on the sort
0:25
option in the sort dialogue you'll see a
0:27
list of columns available for sorting
0:29
for example if your table includes
0:31
information about countries and revenues
0:33
you might first want to sort the data by
0:34
country select country as the first
0:36
criterion and click okay excel will
0:38
rearrange the data listing the rows by
0:40
country names in alphabetical order now
0:43
if you want to sort the data by multiple
0:44
criteria you can do that too click the
0:47
add level button the little plus sign in
0:49
the sorting dialogue to add another
0:50
criterion for example after sorting by
0:53
country you may want to sort by revenue
0:55
choose revenue as the second criterion
0:57
and decide whether to sort it from
0:58
smallest to largest or largest to
1:00
smallest click okay and excel will
1:02
neatly organize your data first by
1:04
country name and within each country by
1:06
revenue this feature allows you to
1:09
create layered sorting orders that make
1:11
your data easier to read and more
1:12
logical to work with whether you're
1:15
analyzing sales data customer
1:17
information or any other kind of data
1:19
set sorting by multiple criteria helps
1:22
you see the patterns clearly and spot
1:24
the key insights more effectively once
1:26
your data is sorted you'll notice how
1:28
much easier it is to navigate large
1:30
tables it's a simple yet powerful
1:32
technique that can save you a lot of
1:33
time and effort when managing