WEBVTT
Kind: captions
Language: en

00:00:07.490 --> 00:00:11.509 align:start position:0%
 
in<00:00:08.960><c> part</c><00:00:09.960><c> one</c><00:00:10.200><c> we</c><00:00:10.230><c> talked</c><00:00:10.740><c> about</c><00:00:10.980><c> the</c><00:00:11.130><c> basics</c>

00:00:11.509 --> 00:00:11.519 align:start position:0%
in part one we talked about the basics
 

00:00:11.519 --> 00:00:13.940 align:start position:0%
in part one we talked about the basics
of<00:00:11.639><c> creating</c><00:00:11.910><c> a</c><00:00:12.210><c> pivot</c><00:00:12.389><c> table</c><00:00:12.780><c> and</c><00:00:12.900><c> in</c><00:00:13.860><c> this</c>

00:00:13.940 --> 00:00:13.950 align:start position:0%
of creating a pivot table and in this
 

00:00:13.950 --> 00:00:15.650 align:start position:0%
of creating a pivot table and in this
video<00:00:14.280><c> we're</c><00:00:14.549><c> going</c><00:00:14.700><c> to</c><00:00:14.790><c> look</c><00:00:15.000><c> at</c><00:00:15.179><c> report</c>

00:00:15.650 --> 00:00:15.660 align:start position:0%
video we're going to look at report
 

00:00:15.660 --> 00:00:20.420 align:start position:0%
video we're going to look at report
filters<00:00:16.130><c> slicers</c><00:00:17.130><c> and</c><00:00:17.310><c> pivotcharts</c><00:00:19.430><c> right</c>

00:00:20.420 --> 00:00:20.430 align:start position:0%
filters slicers and pivotcharts right
 

00:00:20.430 --> 00:00:22.609 align:start position:0%
filters slicers and pivotcharts right
now<00:00:20.580><c> this</c><00:00:20.880><c> pivot</c><00:00:21.210><c> table</c><00:00:21.330><c> is</c><00:00:21.660><c> using</c><00:00:22.020><c> data</c><00:00:22.199><c> from</c>

00:00:22.609 --> 00:00:22.619 align:start position:0%
now this pivot table is using data from
 

00:00:22.619 --> 00:00:25.099 align:start position:0%
now this pivot table is using data from
all<00:00:22.830><c> of</c><00:00:23.100><c> the</c><00:00:23.220><c> salespeople</c><00:00:23.660><c> but</c><00:00:24.660><c> let's</c><00:00:24.810><c> say</c><00:00:24.960><c> we</c>

00:00:25.099 --> 00:00:25.109 align:start position:0%
all of the salespeople but let's say we
 

00:00:25.109 --> 00:00:27.230 align:start position:0%
all of the salespeople but let's say we
want<00:00:25.320><c> to</c><00:00:25.410><c> remove</c><00:00:25.710><c> certain</c><00:00:26.010><c> salespeople</c><00:00:26.609><c> to</c>

00:00:27.230 --> 00:00:27.240 align:start position:0%
want to remove certain salespeople to
 

00:00:27.240 --> 00:00:29.290 align:start position:0%
want to remove certain salespeople to
see<00:00:27.449><c> how</c><00:00:27.630><c> their</c><00:00:27.869><c> sales</c><00:00:28.109><c> impact</c><00:00:28.529><c> their</c><00:00:28.859><c> regions</c>

00:00:29.290 --> 00:00:29.300 align:start position:0%
see how their sales impact their regions
 

00:00:29.300 --> 00:00:32.530 align:start position:0%
see how their sales impact their regions
we<00:00:30.300><c> can</c><00:00:30.449><c> do</c><00:00:30.570><c> that</c><00:00:30.720><c> by</c><00:00:30.960><c> adding</c><00:00:31.170><c> a</c><00:00:31.470><c> report</c><00:00:31.859><c> filter</c>

00:00:32.530 --> 00:00:32.540 align:start position:0%
we can do that by adding a report filter
 

00:00:32.540 --> 00:00:35.389 align:start position:0%
we can do that by adding a report filter
just<00:00:33.540><c> drag</c><00:00:33.809><c> the</c><00:00:34.020><c> salesperson</c><00:00:34.680><c> field</c><00:00:34.890><c> into</c><00:00:35.370><c> the</c>

00:00:35.389 --> 00:00:35.399 align:start position:0%
just drag the salesperson field into the
 

00:00:35.399 --> 00:00:38.330 align:start position:0%
just drag the salesperson field into the
report<00:00:35.820><c> filter</c><00:00:35.969><c> area</c><00:00:36.510><c> and</c><00:00:36.890><c> it</c><00:00:37.890><c> will</c><00:00:37.980><c> create</c><00:00:38.190><c> a</c>

00:00:38.330 --> 00:00:38.340 align:start position:0%
report filter area and it will create a
 

00:00:38.340 --> 00:00:40.400 align:start position:0%
report filter area and it will create a
filter<00:00:38.610><c> in</c><00:00:39.000><c> the</c><00:00:39.149><c> upper</c><00:00:39.420><c> left</c><00:00:39.629><c> corner</c><00:00:39.899><c> of</c><00:00:40.110><c> the</c>

00:00:40.400 --> 00:00:40.410 align:start position:0%
filter in the upper left corner of the
 

00:00:40.410 --> 00:00:43.369 align:start position:0%
filter in the upper left corner of the
pivot<00:00:40.710><c> table</c><00:00:41.690><c> click</c><00:00:42.690><c> the</c><00:00:42.750><c> drop</c><00:00:43.110><c> down</c><00:00:43.140><c> arrow</c>

00:00:43.369 --> 00:00:43.379 align:start position:0%
pivot table click the drop down arrow
 

00:00:43.379 --> 00:00:48.560 align:start position:0%
pivot table click the drop down arrow
and<00:00:43.829><c> click</c><00:00:45.410><c> select</c><00:00:46.410><c> multiple</c><00:00:46.980><c> items</c><00:00:47.129><c> and</c><00:00:47.579><c> then</c>

00:00:48.560 --> 00:00:48.570 align:start position:0%
and click select multiple items and then
 

00:00:48.570 --> 00:00:50.029 align:start position:0%
and click select multiple items and then
just<00:00:48.780><c> uncheck</c><00:00:49.230><c> the</c><00:00:49.410><c> ones</c><00:00:49.440><c> that</c><00:00:49.770><c> you</c><00:00:49.860><c> don't</c>

00:00:50.029 --> 00:00:50.039 align:start position:0%
just uncheck the ones that you don't
 

00:00:50.039 --> 00:00:51.569 align:start position:0%
just uncheck the ones that you don't
want

00:00:51.569 --> 00:00:51.579 align:start position:0%
want
 

00:00:51.579 --> 00:00:54.360 align:start position:0%
want
I'll<00:00:52.149><c> uncheck</c><00:00:52.450><c> Michael</c><00:00:53.230><c> Brennan</c><00:00:53.620><c> Richard</c>

00:00:54.360 --> 00:00:54.370 align:start position:0%
I'll uncheck Michael Brennan Richard
 

00:00:54.370 --> 00:00:57.299 align:start position:0%
I'll uncheck Michael Brennan Richard
doom<00:00:54.550><c> Lao</c><00:00:54.730><c> and</c><00:00:55.020><c> Shannon</c><00:00:56.020><c> Thompson</c><00:00:56.500><c> which</c><00:00:57.129><c> will</c>

00:00:57.299 --> 00:00:57.309 align:start position:0%
doom Lao and Shannon Thompson which will
 

00:00:57.309 --> 00:00:59.510 align:start position:0%
doom Lao and Shannon Thompson which will
remove<00:00:57.579><c> their</c><00:00:57.820><c> data</c><00:00:58.030><c> from</c><00:00:58.239><c> the</c><00:00:58.449><c> pivot</c><00:00:58.629><c> chart</c>

00:00:59.510 --> 00:00:59.520 align:start position:0%
remove their data from the pivot chart
 

00:00:59.520 --> 00:01:03.119 align:start position:0%
remove their data from the pivot chart
so<00:01:00.520><c> it</c><00:01:00.670><c> has</c><00:01:00.820><c> changed</c><00:01:00.850><c> the</c><00:01:01.420><c> totals</c><00:01:01.780><c> and</c><00:01:02.129><c> it's</c>

00:01:03.119 --> 00:01:03.129 align:start position:0%
so it has changed the totals and it's
 

00:01:03.129 --> 00:01:04.530 align:start position:0%
so it has changed the totals and it's
also<00:01:03.309><c> hidden</c><00:01:03.760><c> the</c><00:01:03.940><c> regions</c><00:01:04.269><c> for</c><00:01:04.449><c> the</c>

00:01:04.530 --> 00:01:04.540 align:start position:0%
also hidden the regions for the
 

00:01:04.540 --> 00:01:08.980 align:start position:0%
also hidden the regions for the
salespeople<00:01:05.019><c> that</c><00:01:05.350><c> we</c><00:01:05.470><c> removed</c>

00:01:08.980 --> 00:01:08.990 align:start position:0%
 
 

00:01:08.990 --> 00:01:11.590 align:start position:0%
 
if<00:01:09.049><c> you</c><00:01:09.799><c> use</c><00:01:09.979><c> filters</c><00:01:10.400><c> a</c><00:01:10.430><c> lot</c><00:01:10.729><c> you</c><00:01:11.210><c> might</c><00:01:11.390><c> want</c>

00:01:11.590 --> 00:01:11.600 align:start position:0%
if you use filters a lot you might want
 

00:01:11.600 --> 00:01:13.899 align:start position:0%
if you use filters a lot you might want
to<00:01:11.630><c> use</c><00:01:11.840><c> slicers</c><00:01:12.500><c> which</c><00:01:13.070><c> were</c><00:01:13.280><c> introduced</c><00:01:13.729><c> in</c>

00:01:13.899 --> 00:01:13.909 align:start position:0%
to use slicers which were introduced in
 

00:01:13.909 --> 00:01:17.170 align:start position:0%
to use slicers which were introduced in
Excel<00:01:14.270><c> 2010</c><00:01:14.869><c> as</c><00:01:15.229><c> a</c><00:01:15.290><c> faster</c><00:01:16.250><c> more</c><00:01:16.579><c> interactive</c>

00:01:17.170 --> 00:01:17.180 align:start position:0%
Excel 2010 as a faster more interactive
 

00:01:17.180 --> 00:01:20.380 align:start position:0%
Excel 2010 as a faster more interactive
way<00:01:17.299><c> to</c><00:01:17.330><c> filter</c><00:01:18.159><c> from</c><00:01:19.159><c> the</c><00:01:19.220><c> options</c><00:01:19.729><c> tab</c><00:01:19.970><c> click</c>

00:01:20.380 --> 00:01:20.390 align:start position:0%
way to filter from the options tab click
 

00:01:20.390 --> 00:01:23.230 align:start position:0%
way to filter from the options tab click
insert<00:01:20.930><c> slicer</c>

00:01:23.230 --> 00:01:23.240 align:start position:0%
insert slicer
 

00:01:23.240 --> 00:01:28.580 align:start position:0%
insert slicer
and<00:01:23.530><c> select</c><00:01:24.530><c> the</c><00:01:24.740><c> field</c><00:01:25.009><c> that</c><00:01:25.100><c> you</c><00:01:25.310><c> want</c>

00:01:28.580 --> 00:01:28.590 align:start position:0%
 
 

00:01:28.590 --> 00:01:31.130 align:start position:0%
 
and<00:01:28.679><c> now</c><00:01:29.579><c> you</c><00:01:29.640><c> can</c><00:01:29.939><c> just</c><00:01:29.969><c> click</c><00:01:30.179><c> on</c><00:01:30.390><c> individual</c>

00:01:31.130 --> 00:01:31.140 align:start position:0%
and now you can just click on individual
 

00:01:31.140 --> 00:01:34.940 align:start position:0%
and now you can just click on individual
salespeople

00:01:34.940 --> 00:01:34.950 align:start position:0%
 
 

00:01:34.950 --> 00:01:36.709 align:start position:0%
 
select<00:01:35.340><c> several</c><00:01:35.610><c> adjacent</c><00:01:36.210><c> ones</c><00:01:36.390><c> by</c>

00:01:36.709 --> 00:01:36.719 align:start position:0%
select several adjacent ones by
 

00:01:36.719 --> 00:01:39.440 align:start position:0%
select several adjacent ones by
clicking-and-dragging

00:01:39.440 --> 00:01:39.450 align:start position:0%
 
 

00:01:39.450 --> 00:01:41.120 align:start position:0%
 
and<00:01:39.539><c> the</c><00:01:39.930><c> PivotTable</c><00:01:40.439><c> will</c><00:01:40.590><c> instantly</c><00:01:41.039><c> update</c>

00:01:41.120 --> 00:01:41.130 align:start position:0%
and the PivotTable will instantly update
 

00:01:41.130 --> 00:01:44.190 align:start position:0%
and the PivotTable will instantly update
after<00:01:41.759><c> each</c><00:01:41.909><c> change</c>

00:01:44.190 --> 00:01:44.200 align:start position:0%
after each change
 

00:01:44.200 --> 00:01:46.620 align:start position:0%
after each change
to<00:01:44.530><c> choose</c><00:01:44.799><c> several</c><00:01:45.100><c> non</c><00:01:45.400><c> adjacent</c><00:01:45.729><c> ones</c><00:01:46.119><c> you</c>

00:01:46.620 --> 00:01:46.630 align:start position:0%
to choose several non adjacent ones you
 

00:01:46.630 --> 00:01:48.330 align:start position:0%
to choose several non adjacent ones you
can<00:01:46.780><c> just</c><00:01:46.960><c> hold</c><00:01:47.170><c> down</c><00:01:47.439><c> the</c><00:01:47.590><c> control</c><00:01:47.979><c> key</c><00:01:48.189><c> on</c>

00:01:48.330 --> 00:01:48.340 align:start position:0%
can just hold down the control key on
 

00:01:48.340 --> 00:01:54.950 align:start position:0%
can just hold down the control key on
your<00:01:48.460><c> keyboard</c><00:01:48.670><c> and</c><00:01:49.030><c> then</c><00:01:49.119><c> click</c>

00:01:54.950 --> 00:01:54.960 align:start position:0%
 
 

00:01:54.960 --> 00:01:57.020 align:start position:0%
 
and<00:01:55.049><c> lastly</c><00:01:56.010><c> I</c><00:01:56.280><c> want</c><00:01:56.490><c> to</c><00:01:56.520><c> tell</c><00:01:56.700><c> you</c><00:01:56.820><c> a</c><00:01:56.850><c> little</c>

00:01:57.020 --> 00:01:57.030 align:start position:0%
and lastly I want to tell you a little
 

00:01:57.030 --> 00:01:59.899 align:start position:0%
and lastly I want to tell you a little
bit<00:01:57.180><c> about</c><00:01:57.390><c> pivot</c><00:01:57.990><c> charts</c><00:01:58.350><c> a</c><00:01:58.610><c> pivot</c><00:01:59.610><c> charts</c>

00:01:59.899 --> 00:01:59.909 align:start position:0%
bit about pivot charts a pivot charts
 

00:01:59.909 --> 00:02:02.180 align:start position:0%
bit about pivot charts a pivot charts
are<00:02:00.119><c> basically</c><00:02:00.630><c> the</c><00:02:00.810><c> same</c><00:02:00.840><c> as</c><00:02:01.320><c> regular</c><00:02:01.350><c> charts</c>

00:02:02.180 --> 00:02:02.190 align:start position:0%
are basically the same as regular charts
 

00:02:02.190 --> 00:02:04.580 align:start position:0%
are basically the same as regular charts
except<00:02:02.970><c> they</c><00:02:03.060><c> display</c><00:02:03.450><c> data</c><00:02:03.690><c> from</c><00:02:04.020><c> a</c><00:02:04.170><c> pivot</c>

00:02:04.580 --> 00:02:04.590 align:start position:0%
except they display data from a pivot
 

00:02:04.590 --> 00:02:08.180 align:start position:0%
except they display data from a pivot
table<00:02:05.570><c> just</c><00:02:06.570><c> click</c><00:02:06.840><c> any</c><00:02:07.080><c> cell</c><00:02:07.229><c> in</c><00:02:07.770><c> your</c><00:02:07.890><c> pivot</c>

00:02:08.180 --> 00:02:08.190 align:start position:0%
table just click any cell in your pivot
 

00:02:08.190 --> 00:02:09.650 align:start position:0%
table just click any cell in your pivot
table

00:02:09.650 --> 00:02:09.660 align:start position:0%
table
 

00:02:09.660 --> 00:02:11.810 align:start position:0%
table
and<00:02:09.750><c> then</c><00:02:10.200><c> from</c><00:02:10.380><c> the</c><00:02:10.500><c> options</c><00:02:11.010><c> tab</c><00:02:11.250><c> click</c>

00:02:11.810 --> 00:02:11.820 align:start position:0%
and then from the options tab click
 

00:02:11.820 --> 00:02:16.300 align:start position:0%
and then from the options tab click
pivot<00:02:12.210><c> chart</c>

00:02:16.300 --> 00:02:16.310 align:start position:0%
 
 

00:02:16.310 --> 00:02:18.830 align:start position:0%
 
pick<00:02:16.970><c> a</c><00:02:17.000><c> chart</c><00:02:17.360><c> type</c>

00:02:18.830 --> 00:02:18.840 align:start position:0%
pick a chart type
 

00:02:18.840 --> 00:02:25.190 align:start position:0%
pick a chart type
and<00:02:18.930><c> click</c><00:02:19.500><c> okay</c>

00:02:25.190 --> 00:02:25.200 align:start position:0%
 
 

00:02:25.200 --> 00:02:29.059 align:start position:0%
 
and<00:02:26.660><c> now</c><00:02:27.660><c> any</c><00:02:27.900><c> changes</c><00:02:28.020><c> that</c><00:02:28.410><c> you</c><00:02:28.560><c> make</c><00:02:28.800><c> to</c><00:02:28.830><c> the</c>

00:02:29.059 --> 00:02:29.069 align:start position:0%
and now any changes that you make to the
 

00:02:29.069 --> 00:02:30.890 align:start position:0%
and now any changes that you make to the
pivottable<00:02:29.099><c> will</c><00:02:29.880><c> show</c><00:02:30.180><c> up</c><00:02:30.330><c> in</c><00:02:30.510><c> the</c><00:02:30.630><c> pivot</c>

00:02:30.890 --> 00:02:30.900 align:start position:0%
pivottable will show up in the pivot
 

00:02:30.900 --> 00:02:33.260 align:start position:0%
pivottable will show up in the pivot
chart<00:02:31.110><c> as</c><00:02:31.230><c> well</c><00:02:31.610><c> and</c><00:02:32.610><c> I'm</c><00:02:32.700><c> just</c><00:02:32.910><c> going</c><00:02:33.060><c> to</c><00:02:33.120><c> move</c>

00:02:33.260 --> 00:02:33.270 align:start position:0%
chart as well and I'm just going to move
 

00:02:33.270 --> 00:02:35.059 align:start position:0%
chart as well and I'm just going to move
these<00:02:33.450><c> fields</c><00:02:33.840><c> around</c><00:02:33.959><c> so</c><00:02:34.440><c> I</c><00:02:34.470><c> can</c><00:02:34.680><c> view</c><00:02:34.830><c> each</c>

00:02:35.059 --> 00:02:35.069 align:start position:0%
these fields around so I can view each
 

00:02:35.069 --> 00:02:41.240 align:start position:0%
these fields around so I can view each
person's<00:02:35.550><c> sales</c><00:02:35.880><c> by</c><00:02:36.209><c> month</c>

00:02:41.240 --> 00:02:41.250 align:start position:0%
 
 

00:02:41.250 --> 00:02:43.490 align:start position:0%
 
with<00:02:41.850><c> a</c><00:02:41.880><c> pivot</c><00:02:42.150><c> table</c><00:02:42.420><c> pivot</c><00:02:43.020><c> chart</c><00:02:43.320><c> and</c>

00:02:43.490 --> 00:02:43.500 align:start position:0%
with a pivot table pivot chart and
 

00:02:43.500 --> 00:02:46.040 align:start position:0%
with a pivot table pivot chart and
slicer<00:02:44.160><c> we</c><00:02:44.820><c> can</c><00:02:44.940><c> look</c><00:02:45.090><c> at</c><00:02:45.180><c> the</c><00:02:45.270><c> data</c><00:02:45.480><c> in</c><00:02:45.720><c> so</c>

00:02:46.040 --> 00:02:46.050 align:start position:0%
slicer we can look at the data in so
 

00:02:46.050 --> 00:02:47.840 align:start position:0%
slicer we can look at the data in so
many<00:02:46.170><c> different</c><00:02:46.350><c> ways</c><00:02:46.560><c> and</c><00:02:46.980><c> all</c><00:02:47.640><c> without</c>

00:02:47.840 --> 00:02:47.850 align:start position:0%
many different ways and all without
 

00:02:47.850 --> 00:02:50.120 align:start position:0%
many different ways and all without
changing<00:02:48.600><c> or</c><00:02:48.750><c> deleting</c><00:02:48.780><c> any</c><00:02:49.440><c> of</c><00:02:49.620><c> the</c><00:02:49.740><c> original</c>

00:02:50.120 --> 00:02:50.130 align:start position:0%
changing or deleting any of the original
 

00:02:50.130 --> 00:02:52.700 align:start position:0%
changing or deleting any of the original
data<00:02:50.840><c> it's</c><00:02:51.840><c> a</c><00:02:51.930><c> great</c><00:02:52.140><c> way</c><00:02:52.260><c> to</c><00:02:52.290><c> find</c><00:02:52.530><c> the</c>

00:02:52.700 --> 00:02:52.710 align:start position:0%
data it's a great way to find the
 

00:02:52.710 --> 00:02:54.830 align:start position:0%
data it's a great way to find the
answers<00:02:53.100><c> to</c><00:02:53.250><c> questions</c><00:02:53.330><c> or</c><00:02:54.330><c> just</c><00:02:54.390><c> to</c>

00:02:54.830 --> 00:02:54.840 align:start position:0%
answers to questions or just to
 

00:02:54.840 --> 00:02:56.720 align:start position:0%
answers to questions or just to
experiment<00:02:55.470><c> to</c><00:02:55.590><c> discover</c><00:02:55.950><c> new</c><00:02:56.220><c> things</c><00:02:56.250><c> about</c>

00:02:56.720 --> 00:02:56.730 align:start position:0%
experiment to discover new things about
 

00:02:56.730 --> 00:03:01.280 align:start position:0%
experiment to discover new things about
the<00:02:57.030><c> data</c><00:02:57.890><c> like</c><00:02:58.890><c> what</c><00:02:59.070><c> you</c><00:02:59.220><c> just</c><00:02:59.250><c> saw</c><00:03:00.290><c> radix</c>

00:03:01.280 --> 00:03:01.290 align:start position:0%
the data like what you just saw radix
 

00:03:01.290 --> 00:03:03.940 align:start position:0%
the data like what you just saw radix
add<00:03:01.800><c> a</c><00:03:01.860><c> comment</c><00:03:02.400><c> subscribe</c><00:03:02.910><c> to</c><00:03:03.210><c> our</c><00:03:03.480><c> Channel</c>

00:03:03.940 --> 00:03:03.950 align:start position:0%
add a comment subscribe to our Channel
 

00:03:03.950 --> 00:03:08.990 align:start position:0%
add a comment subscribe to our Channel
the<00:03:04.950><c> freedom</c><00:03:05.400><c> to</c><00:03:05.520><c> learn</c><00:03:06.320><c> what</c><00:03:07.320><c> you</c><00:03:07.530><c> want</c><00:03:08.000><c> when</c>

00:03:08.990 --> 00:03:09.000 align:start position:0%
the freedom to learn what you want when
 

00:03:09.000 --> 00:03:11.060 align:start position:0%
the freedom to learn what you want when
you<00:03:09.240><c> want</c>

00:03:11.060 --> 00:03:11.070 align:start position:0%
you want
 

00:03:11.070 --> 00:03:15.580 align:start position:0%
you want
absolutely<00:03:12.070><c> free</c>

00:03:15.580 --> 00:03:15.590 align:start position:0%
 
 

00:03:15.590 --> 00:03:19.220 align:start position:0%
 
GCF<00:03:16.590><c> learn</c><00:03:17.190><c> free.org</c>