1
00:00:03,930 --> 00:00:10,020
This time we're going to do the same analysis we did before except we're going to use a table as our

2
00:00:10,020 --> 00:00:10,740
source.

3
00:00:10,740 --> 00:00:17,160
All we have to do as a first step is to turn this data set into an official Excel table.

4
00:00:17,160 --> 00:00:25,860
I can do that by going to insert table. Or, I can use the shortcut key Control+t. Excel has correctly detected

5
00:00:25,950 --> 00:00:28,730
my data set. The table has headers.

6
00:00:28,830 --> 00:00:30,000
I'm just going to go with ok.

7
00:00:30,000 --> 00:00:36,660
I get the table design tab up here, first thing I'm going to do is take away my table style to go

8
00:00:36,660 --> 00:00:43,220
back to my original table style. And the second thing I'm going to do is to give this table a name.

9
00:00:43,230 --> 00:00:46,170
This way when I use it as a data source for my pivot table.

10
00:00:46,170 --> 00:00:50,260
It's easier for me to recognize what type of data it is.

11
00:00:50,290 --> 00:00:54,230
I'll just call this "TableSales" and press enter.

12
00:00:54,240 --> 00:00:57,750
Now I'm just gonna go ahead and insert a pivot table.

13
00:00:57,960 --> 00:01:04,080
I can do it directly from the table design tab by selecting summarize with pivot table. Or, I can go back

14
00:01:04,080 --> 00:01:11,880
to insert and insert the pivot table. This time Excel recognizes that it's a table so it gives me the

15
00:01:11,880 --> 00:01:19,180
table name instead of a specific range. I'm gonna go and insert this on the existing worksheet. I'll

16
00:01:19,200 --> 00:01:21,460
go with this cell and click on ok.

17
00:01:21,470 --> 00:01:25,970
Now I get to do the same thing like before.

18
00:01:25,970 --> 00:01:28,880
So we just have to drag and drop what we need.

19
00:01:28,880 --> 00:01:36,320
Let's just go with company name, quantity, and sales USD. Now here's the difference between using

20
00:01:36,320 --> 00:01:38,630
a table and a fixed range.

21
00:01:38,630 --> 00:01:40,950
It's when it comes to adding new data.

22
00:01:40,970 --> 00:01:45,560
Let's go to the bottom of this and add in a new row to this.

23
00:01:45,570 --> 00:01:54,950
I'm gonna go with "1090DE" "Leila basics" and for the rest let's just copy the information from above.

24
00:01:55,370 --> 00:02:02,990
And notice one thing down here. On this side, you get this special table icon that shows where the table

25
00:02:03,110 --> 00:02:05,150
is officially ending.

26
00:02:05,300 --> 00:02:13,430
Now I don't need to update any data source. All I have to do is come here, right mouse click and refresh

27
00:02:13,820 --> 00:02:18,540
my list and "Leila basics" data is already there.

28
00:02:18,710 --> 00:02:18,950
Right?

29
00:02:18,950 --> 00:02:26,330
So whenever you work with pivot tables it's always best to turn your original data set into an official

30
00:02:26,510 --> 00:02:27,690
Excel table.

31
00:02:27,800 --> 00:02:33,530
This way you don't have to worry about updating your data source range as new data come in.