0:01
hi and welcome back to my YouTube
0:04
channel today we are learning on how to
0:06
create a pivot table in Exel the first
0:09
thing you need to do is open your
0:11
worksheet load in the data that you
0:14
need for this exercise for example in in
0:17
this example we have product sales and
0:20
region the first step is
0:25
highlight all your data including the
0:31
uh The Next Step sorry click highlight
0:38
click on insert uh on your heading
0:42
you'll have people table on your left
0:44
click on it and then choose from table
0:48
range you'll a popup table will come
0:51
asking you to either choose new
0:53
worksheet or existing worksheet uh just
0:58
worksheet and click on
1:00
okay a right another text box another
1:05
box will come on your right which has
1:08
product sales and region so this is what
1:11
you'll use to create your pivot table
1:14
choose the ones that you only need for
1:16
example in this example we only need
1:18
product and sales uh click and drag your
1:21
product all the way down to row click
1:24
and drag your sales all the way to
1:27
values and here Exel will automatically
1:33
sum uh the values of A and B the sum of
1:37
A and B and here you'll get your pivot
1:41
table ready if need be that you need to
1:44
add something else for this example we
1:46
can drag region to column and here
1:50
you'll get something like this but if
1:52
you don't need the region for example
1:54
you can click and drag it anywhere in
1:57
the worksheet and it will get it will be
2:00
removed from the pivot table so that's
2:02
how you add pivot tables in Exel if you
2:06
like this video please like subscribe
2:09
and share and leave a a comment in the
2:12
comment section uh asking a question or
2:16
just giving us feedback on what you
2:18
think about this thank you for watching