1
00:00:04,470 --> 00:00:08,220
Pivot tables let you get quick insights from your data.

2
00:00:08,220 --> 00:00:13,200
Imagine you have this data set and you need to quickly answer these questions:

3
00:00:13,200 --> 00:00:15,130
Which company sells the most?

4
00:00:15,210 --> 00:00:21,240
Which product generates the most sales? And which customer accounts for the highest percentage of total

5
00:00:21,240 --> 00:00:21,980
sales?

6
00:00:21,990 --> 00:00:25,130
Sounds like a lot of work but it's actually quite easy.

7
00:00:25,140 --> 00:00:32,340
If you use a pivot table. So let's go over the benefits of pivot tables. A pivot table helps you get answers

8
00:00:32,400 --> 00:00:37,890
from your data without having to write complex calculations.

9
00:00:37,890 --> 00:00:42,930
It's very fast to create a pivot table and it's very easy to use one.

10
00:00:42,990 --> 00:00:48,840
It helps you find relationships between data. And visualize data with dynamic charts.

11
00:00:48,960 --> 00:00:55,230
Before you start creating your pivot table, you need to make sure you have a proper data set. Which means

12
00:00:55,530 --> 00:00:57,290
each column has a header.

13
00:00:57,300 --> 00:01:03,630
There are no empty columns in between and there are no totals in the middle of your data set. Once these

14
00:01:03,630 --> 00:01:04,459
are checked off

15
00:01:04,470 --> 00:01:07,610
you can insert your pivot table. Let's do that next.