DATA SORTING

DATA SORTING IN EXCEL EASILY.

Here we will learn about doing DATA SORT in EXCEL. Here we will learn how to simplify your work by SORTing in a TABLE or any DATA according to the EXCEL SHEET. And how to save your time by working quickly.

01. TEXT SORTING.

02. NUMBER SORTING.

03. DATE SORTING.

04. ADVANCE SORTING.

For example, we will SORT the TABLE DATA of the photo below.

DATA SORTING
1 - TEXT SORTING

If we want to SORT our TABLE DATA, then we can complete it only by working according to some STEPS.

STEP -1 # First of all we will SELECT a CELL of the TABLE that we want to SORT the TABLE then go to EDITING BLOCK of HOME TAB and click SORT AND FILTER.

DATA SORTING

STEP -2 # After that we will come with the option to SORT DATA.

DATA SORTING

STEP -3  # After that if we want to change our DATA to A TO Z SORT or Z TO A then according to that option we will SELECT and after SELECT our DATA becomes SORT.

DATA SORTING

So in this way we can SORT our DATA or TEXT.

2 - NUMBER SORTING

If we want to SORT our TABLE DATA, then we can complete it only by working according to some STEPS.

STEP -1 # First of all we will SELECT a CELL of the TABLE that we want to SORT the TABLE then go to EDITING BLOCK of HOME TAB and click SORT AND FILTER.

DATA SORTING

STEP -2 # After that we will come with the option to SORT DATA.

DATA SORTING

STEP -3  # After that if we want to make our DATA SMALLEST TO LARGEST SORT or LARGEST TO SMALLEST, then according to that option will SELECT and our SATA becomes SORT as soon as SELECT is done.

So in this way we can SORT our DATA or DATE.

3- DATE SORTING

If we want to SORT our TABLE DATA, then we can complete it only by working according to some STEPS.

STEP -1 # First of all we will SELECT a CELL of the TABLE that we want to SORT the TABLE then go to EDITING BLOCK of HOME TAB and click SORT AND FILTER.

DATA SORTING

STEP -2 # After that we will come with the option to SORT DATA.

DATA SORTING

STEP -3  # After that if we want to change our DATA to A TO Z SORT or Z TO A then according to that option we will SELECT and after SELECT our DATA becomes SORT.

So in this way we can SORT our DATA or DATE.

4- ADVANCE SORTING

In ADVANCE LEVEL SORTING, we can put SORT together twice or more times in our DATA.

Below we see a photo in which we have to sort them according to the name of TEAM and RUN of PLAMER of TEAM. And the TEAM which scored more RUNs came out on top.

STEP -1 # First of all we will select CELL in which CELL we have to put FORMULA of DIVIDE and after that we will PRESS = BUTTON.

DATA SORTING

STEP -1  # First of all we will SELECT any one of the CELLs and then go to the EDITING BLOCK of HOME TAB and click on SORT AND FILTER.

DATA SORTING

STEP -2 # After that we will CLICK on CUSTOM SORTING.

DATA SORTING

STEP -3 # After that we will see a box of CUSTOM SORTING.

DATA SORTING

STEP -4 #  In the option of CUSTOM SORTING, we will first SELECT what we want to SORT, we will SELECT TEAM in SORT BY and put it in A TO Z SORTING.

DATA SORTING

After that we will CLICK on the ADD LEVEL seen above which gives us another option to do the sorting ADD, in that we will SELECT our SECOND OPTION RUN and SELECT it in Z TO A then SORT or LARGEST then SMALLEST so We get the name of TEAM’s highest RUN PLAYER named SORT.

DATA SORTING

As soon as CLICK on OK, we get the name of the PLAYER making the highest RUN of TEAM by SORT.

So in this way you can easily sort your data.

For more information see VIDEO -

Leave a Reply

© 2020 NtOffice.in         ।     All Rights Reserved.

ABOUT US    ।    CONTACT   US   ।    TERMS  OF  USES   ।  DISCLAIMER   ।  PRIVACY  POLICY

WhatsApp
Google+
Facebook
Telegram