hello and welcome to our new video
in this video we are going to learn
how to group things
how to ungroup things
and how to subtotal them
so we have some items
30 items
some of those items are
common and repeated
like i went to market
and bought 4 amazon fire sticks
or 4 speakers
so what is speaker
i have 4 bars
so what can we do
we can group them
and subtotal them
so this is what we are going to see
in excel
so lets open excel
after opening excel
we can see serial numbers
items name and amount
so i have 30 items
which are of different types
like i have keyboard, laptop
i9 processor
speakers, printers, UPS
pen drive, motherboard
like this i have some items
now similar kind of items
i have to hide them
this list should not be seen
so how to hide them
we have to select them
like i select speaker
so where we have to go
we have to go to data tab
where is data tab
here it is
here you can see 3 options
first option is group
second option is ungroup
and third option is subtotal
we can see by group name
which items we have to group
we can see by ungroup name
which items we have to ungroup
subtotal means total
so now what we have to do
we have to select all
similar kind of items
and group them
when you group
it will ask you
who do you want to group
i selected rose
so now
you will see some changes
like here you can see
line and minus sign
and we have two options
first option is show detail
second option is hide detail
now what is this
you can see plus sign
and minus sign
minus sign is also visible
so you will say
speaker is visible
so what we have to do
we have to click on hide detail
now tell me
serial no.7,8,9,10,11,12
where is it
magic
now it is not magic
it is hide
if you want to see them
click on plus sign
on show detail
you can do this from here
or directly from here
from minus and plus sign
i will show you
this detail
from here
i selected it
and group it
when you group
it will ask you
rose and column
now i am not doing it from here
i am doing it from here
click on minus sign
now it is back
i think you understood
how to group items
we are hiding
now second option
you can see here
ungroup
what is ungroup
now i have to ungroup
i will go here
and here i will see
clear outline
i have to click on clear outline
and you will see
minus sign and line
is removed
now if i want to remove this
i will select
from where
i have to remove it
and again i will go to ungroup
and clear outline
now i have clear outline
now we understood group and ungroup
now next thing is
subtotal
we can do subtotal
we have learned it
select whole
and then
do autosum
it is possible
but if i say
i want
one more thing
i want total of
two items
laptop i9
and speaker
so how will you do
we are stuck here
for this we use
subtotal
for subtotal you have to
select whole table
select data
select
go to data
and do subtotal
when you do subtotal
it will show you
at each change in serial number
use function
we have
many functions
so we have to do sum
select
not serial number
item wise
in serial number
it will not show
total
it will show 1 to 1
2 to 2
3 to 3
now i will show you
serial number
first do serial number
and sum
here
1
2
1650
it does not mean
serial number
we have to do
item wise
select
do subtotal
and do items
after items
do simple
ok
use functions
i want to use sum
select sum
now you will see
group
and
amazon fire stick
total
time
coming
1
from here also
and from here also
I hope it will be clear to you
whatever we have done
group, ungroup, subtotal
ok
so I will meet you in next video
if you have any doubt then play this video again
and till then keep practicing