WEBVTT
Kind: captions
Language: en

00:00:11.000 --> 00:00:16.700
In Part 1, we talked about the basics of creating a PivotTable. In this video, we're going to

00:00:16.770 --> 00:00:22.750
take a look at three more features called
Report Filters, Slicers, and PivotCharts.

00:00:22.750 --> 00:00:26.960
Right now, this PivotTable is showing us the
regional sales totals for all the salespeople

00:00:26.960 --> 00:00:31.440
in our worksheet. However, I'd like to try
removing certain people, so we can see how

00:00:31.440 --> 00:00:34.070
their sales are impacting their regions.

00:00:34.070 --> 00:00:38.030
We can do this by adding a Report Filter,
which can be used to narrow down the data

00:00:38.030 --> 00:00:40.440
in your PivotTable.

00:00:40.440 --> 00:00:47.440
First drag the Salesperson field... to the
Filters area. Then look to your PivotTable,

00:00:48.030 --> 00:00:51.460
and click the filter that's been added to
the upper right corner.

00:00:51.460 --> 00:00:58.460
Next, check the option that says Select Multiple
Items. Now we can check or uncheck the salespeople

00:00:59.360 --> 00:01:03.000
above, depending on who we want to include.

00:01:03.000 --> 00:01:10.000
I'm going to remove Michael Brennan... Richard
Dumlao... and Shannon Thompson.

00:01:10.749 --> 00:01:15.569
When you're ready, click OK... and the filter
will be applied.

00:01:15.569 --> 00:01:19.909
In this case, that means the totals have changed,
and two of the regions have also been filtered

00:01:19.909 --> 00:01:23.740
out, based on the people that we unchecked.

00:01:23.740 --> 00:01:28.509
If you like the way filters work, you might
want to try adding a Slicer next. Slicers

00:01:28.509 --> 00:01:33.249
make filtering even faster and easier by giving
you access to the filters in their own separate

00:01:33.249 --> 00:01:34.979
pane.

00:01:34.979 --> 00:01:41.249
First make sure you're on the Analyze tab,
then click the Insert Slicer command. A dialog

00:01:41.249 --> 00:01:48.249
box will appear where you can check the filter
you want—we'll use Salesperson like before.

00:01:50.450 --> 00:01:54.419
Now we can just click the salespeople we want
to see, without having to go to the filtering

00:01:54.419 --> 00:01:55.819
menu.

00:01:55.819 --> 00:02:01.469
You can even select multiple adjacent people
by clicking and dragging your mouse.

00:02:01.469 --> 00:02:08.469
To select more than one non-adjacent item,
hold CTRL on your keyboard while you click.

00:02:08.910 --> 00:02:15.910
As you can see, the PivotTable changes each
time to reflect the data you've selected.

00:02:16.100 --> 00:02:20.790
The last thing I'd like to show you is a neat
feature called PivotCharts. PivotCharts are

00:02:20.790 --> 00:02:26.390
basically the same as regular charts, except
they show whatever is in your PivotTable.

00:02:26.390 --> 00:02:33.390
To get started, click any cell in your PivotTable...
then go to the Insert tab... and click the

00:02:35.470 --> 00:02:38.300
PivotChart command.

00:02:38.300 --> 00:02:44.160
A dialog box will appear where you can select
the chart type you want... then go ahead and

00:02:44.160 --> 00:02:47.790
click OK.

00:02:47.790 --> 00:02:51.880
Now any changes you make to the PivotTable
will show up in the PivotChart as well.

00:02:51.880 --> 00:02:56.200
For example, let's see what happens when we
move these fields around a bit, so we can

00:02:56.200 --> 00:03:03.200
view each person's monthly sales data.

00:03:05.310 --> 00:03:10.460
With a PivotTable, a PivotChart, and a Slicer,
we can look at the data in so many different

00:03:10.460 --> 00:03:15.460
ways—all without changing or deleting any
of the original content. It's a great way

00:03:15.460 --> 00:03:19.720
to find whatever information you're looking
for, or you can just experiment to see if

00:03:19.720 --> 00:03:20.960
you discover something new.