Hello and welcome to our new video
In this video we are going to learn
In this video we are going to learn that if a data is given
to us then how to short that data
Now what is the meaning of shorting?
Shorting means that in ascending order if someone has given
you a random name not written in alphabetical order like A
name first, B name first not written in alphabetical order
like in this cell all the names written in this cell
Rahul, Imran, Jishan
Rahul is not given in alphabetical order it comes late so
what we will do if we want to short in alphabetical order
18 comes before 23 so if we want to short this in ascending
order descending means from highest number to lowest number
so we will do all these things after that we will do filter
we will see how filter works so we will do both these
things in home tab in home tab you will find most important
things which will make your work easy so here we will see
in editing group we are given
thing short and filter now how this short and filter will
work so what i do if you click here you will see how to
short
A to Z or Z to A after that we have custom short and here
we have filter we will use this filter first we will select
some data now i will show you the format of date and time
now if we select this and we go to short and filter it is
showing short A to Z short Z to A because what is coming in
A to Z if i put this on numbers will it show me
A to Z or Z to A here it is showing short now how this is
possible how excel knows this is a number in last video we
saw when we were doing number formatting excel was not
knowing when we were setting 0 it was removing 0 so we set
a format when we were not knowing when we were not knowing
when we were not knowing when we were not knowing now excel
knows how to arrange numbers you will arrange numbers like
this smallest to largest and after this time time time now
if we talk about date it shows
to newest it was showing
A to Z or Z to A it is showing oldest to newest old date to
new date new date to old date so we can do short so we have
written this random data now i will try this random data i
have selected this data and i have done A to Z now here two
things will be written expand the selection and continue
with the current selection now what is the meaning of
expand the selection see this cell after imran cell like
this 26 cell or mail cell or mumbai cell this cell is
attached to this cell data of imran is
in this cell if i do expand the selection what it will do
whatever data i have it will take it to
A to Z if i don't do this the cell which i have selected
continue with the current selection if i do short you will
see rest of the data is short but the age is same rest of
the data is same in any cell or column if i do this again
in descending order if i do Z to A it will ask me to expand
the selection or continue with the current selection now we
will do expand the selection now you can see rest of the
adjacent cells their data is also moved so it is better to
do this expand the cell there
very less chances that your data is wrong so it is clear
that how we did this so let's do A to Z after that is age
my age numbers if i select it smallest to largest so i
click on smallest to largest i have to continue with the
current selection so i did short so it showed me the
smallest number then 21 then 23 if i do it again largest to
smallest so it will show me the largest one and 18 is the
smallest so it showed me the lowest so it is clear after
this you will see the option of custom short
see i selected it so in custom short i am getting the same
expand the selection and continue with the current
selection which we were seeing so this is not a new option
it will work like this so after this if we select the date
column so we will get oldest to newest so we select oldest
to newest and current selection because we have to see in
current column so i did short so here you can see nothing
changed
so we have to select the second option newest to oldest and
continue with the current selection so the latest date like
12 february is the latest date so it showed me the new date
and the rest of the date then time if i do it
smallest to largest and continue with the current selection
so here it changed rest of the date is same after this we
have to see how to short the data if someone gave us random
data and we have to set it in ascending or descending order
so we can do it easily one thing is to filter if you put
filter on instagram so it will change so let's see what i
did when i filtered you can see this down arrow and when i
click on it you can see the menu so let's see if i click
here so it is showing what you
to filter so let's remove select all i want the same name
as rahul so i said ok so it showed me the same data so it
showed me the same data
So, it is easy for us to filter the data.
We can get the data we want.
I will bring it back.
Here are other things.
I unchecked it.
I want the data of Aarti.
So, it showed me the data of Aarti.
All these things are happening because of this table.
So, I will not consider this table.
So, I will undo it.
Here is the age.
So, it showed me the age.
So, I will check male and female.
I want the data of female.
So, it showed me the data of female.
So, I unchecked it.
So, it showed me the data of female.
So, I will not consider this table.
So, I will undo it.
I will not consider this table.
So, I will go to city.
I want the people who live in Delhi and Faridabad.
I selected both the places.
So, it showed me the data of Delhi and Faridabad.
So, I think it will be clear to you.
I will show you how to do it.
I have already put the filter.
So, I have to delete it.
Just one second.
Look! It's clear!
It's clear!
It's clear! and by clicking on filter again the filter will
be removed
I think in this video you will be clear how to use filter
and how to use shot so see you in next video till then keep
practicing