WEBVTT
Kind: captions
Language: en

00:00:09.540 --> 00:00:13.760
In Part 1, we talked about the basics of creating
a PivotTable,

00:00:13.760 --> 00:00:20.160
and in this video we're going to
look at Report Filters, Slicers, and PivotCharts.

00:00:20.160 --> 00:00:22.860
Right now, this PivotTable is using data from
all

00:00:22.860 --> 00:00:24.110
of the salespeople.

00:00:24.110 --> 00:00:27.060
But let's say we want to remove certain salespeople

00:00:27.060 --> 00:00:30.290
to see how their sales impact their regions.

00:00:30.290 --> 00:00:33.579
We can do that by adding a Report Filter.

00:00:33.579 --> 00:00:37.790
Just drag the Salesperson field into the Report
Filter area.

00:00:37.790 --> 00:00:42.720
And it will create a filter in the upper-left
corner of the PivotTable.

00:00:42.720 --> 00:00:48.460
Click the drop-down arrow, and click Select
Multiple Items,

00:00:48.460 --> 00:00:52.100
and then just uncheck the ones
that you don't want.

00:00:52.100 --> 00:00:55.621
I'll uncheck Michael Brennan, Richard Dumlao,
and

00:00:55.621 --> 00:00:57.079
Shannon Thompson,

00:00:57.079 --> 00:00:59.530
which will remove their data
from the PivotChart.

00:00:59.530 --> 00:01:09.579
It has changed the totals, and it's also hidden
the regions for the salespeople that we removed.

00:01:09.579 --> 00:01:12.000
If you use filters a lot, you might want to
use

00:01:12.000 --> 00:01:13.040
Slicers,

00:01:13.040 --> 00:01:19.170
which were introduced in Excel 2010 as a
faster, more interactive way to filter.

00:01:19.170 --> 00:01:24.220
From the Options tab, click Insert Slicer.

00:01:24.220 --> 00:01:29.460
And select the field that you want.

00:01:29.460 --> 00:01:34.650
And now you can just click on individual
salespeople,

00:01:34.650 --> 00:01:39.890
or select several adjacent ones by
clicking and dragging.

00:01:39.890 --> 00:01:44.510
And the PivotTable will instantly update after
each change.

00:01:44.510 --> 00:01:46.979
To choose several non-adjacent ones, you can
just

00:01:46.979 --> 00:01:49.460
hold down the Control key on your keyboard
and

00:01:49.460 --> 00:01:51.540
then click.

00:01:51.540 --> 00:01:58.299
And lastly, I want to tell you a little bit
about

00:01:58.299 --> 00:01:59.860
PivotCharts.

00:01:59.860 --> 00:02:02.830
PivotCharts are basically the same as regular
charts,

00:02:02.830 --> 00:02:06.580
except they display data from a
PivotTable.

00:02:06.580 --> 00:02:10.060
Just click any cell in your PivotTable.

00:02:10.060 --> 00:02:16.920
And then from the Options tab, click PivotChart.

00:02:16.920 --> 00:02:27.519
Pick a chart type, and click OK.

00:02:27.519 --> 00:02:31.790
And now any changes you make to the PivotTable
will show up in the PivotChart as well.

00:02:31.790 --> 00:02:34.400
And I'm just going to move these fields around
so

00:02:34.400 --> 00:02:41.849
I can view each person's sales by month.

00:02:41.849 --> 00:02:44.939
With a PivotTable, PivotChart, and Slicer,
we can

00:02:44.939 --> 00:02:47.459
look at the data in so many different ways,

00:02:47.459 --> 00:02:49.720
and all without changing or deleting any of
the

00:02:49.720 --> 00:02:50.989
original data.

00:02:50.989 --> 00:02:54.360
And it's a great way to find the answers to
questions,

00:02:54.360 --> 00:03:18.709
or just to experiment to discover new
things about the data.