WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.890><c> Foundation</c><00:00:02.550><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:10.590 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:10.590 --> 00:00:10.600 align:start position:0%
 
 

00:00:10.600 --> 00:00:13.440 align:start position:0%
 
in<00:00:10.800><c> part</c><00:00:11.800><c> one</c><00:00:11.980><c> we</c><00:00:12.250><c> talked</c><00:00:12.610><c> about</c><00:00:12.730><c> the</c><00:00:13.030><c> basics</c>

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

00:00:13.450 --> 00:00:16.230 align:start position:0%
in part one we talked about the basics
of<00:00:13.630><c> creating</c><00:00:14.110><c> a</c><00:00:14.200><c> pivot</c><00:00:14.350><c> table</c><00:00:14.650><c> in</c><00:00:14.980><c> this</c><00:00:15.910><c> video</c>

00:00:16.230 --> 00:00:16.240 align:start position:0%
of creating a pivot table in this video
 

00:00:16.240 --> 00:00:17.790 align:start position:0%
of creating a pivot table in this video
we're<00:00:16.630><c> going</c><00:00:16.720><c> to</c><00:00:16.810><c> take</c><00:00:16.990><c> a</c><00:00:17.020><c> look</c><00:00:17.260><c> at</c><00:00:17.350><c> three</c><00:00:17.620><c> more</c>

00:00:17.790 --> 00:00:17.800 align:start position:0%
we're going to take a look at three more
 

00:00:17.800 --> 00:00:20.190 align:start position:0%
we're going to take a look at three more
features<00:00:18.250><c> called</c><00:00:18.670><c> report</c><00:00:19.090><c> filters</c><00:00:19.450><c> slicers</c>

00:00:20.190 --> 00:00:20.200 align:start position:0%
features called report filters slicers
 

00:00:20.200 --> 00:00:23.700 align:start position:0%
features called report filters slicers
and<00:00:20.380><c> pivotcharts</c><00:00:21.779><c> right</c><00:00:22.779><c> now</c><00:00:22.990><c> this</c><00:00:23.350><c> pivot</c>

00:00:23.700 --> 00:00:23.710 align:start position:0%
and pivotcharts right now this pivot
 

00:00:23.710 --> 00:00:25.320 align:start position:0%
and pivotcharts right now this pivot
table<00:00:23.860><c> is</c><00:00:24.100><c> showing</c><00:00:24.279><c> us</c><00:00:24.520><c> the</c><00:00:24.550><c> regional</c><00:00:25.150><c> sales</c>

00:00:25.320 --> 00:00:25.330 align:start position:0%
table is showing us the regional sales
 

00:00:25.330 --> 00:00:27.240 align:start position:0%
table is showing us the regional sales
totals<00:00:25.810><c> for</c><00:00:26.050><c> all</c><00:00:26.200><c> the</c><00:00:26.410><c> salespeople</c><00:00:26.860><c> in</c><00:00:27.130><c> our</c>

00:00:27.240 --> 00:00:27.250 align:start position:0%
totals for all the salespeople in our
 

00:00:27.250 --> 00:00:29.400 align:start position:0%
totals for all the salespeople in our
worksheet<00:00:27.670><c> however</c><00:00:28.600><c> I'd</c><00:00:28.870><c> like</c><00:00:28.900><c> to</c><00:00:29.080><c> try</c>

00:00:29.400 --> 00:00:29.410 align:start position:0%
worksheet however I'd like to try
 

00:00:29.410 --> 00:00:31.320 align:start position:0%
worksheet however I'd like to try
removing<00:00:29.740><c> certain</c><00:00:30.130><c> people</c><00:00:30.550><c> so</c><00:00:30.880><c> we</c><00:00:31.000><c> can</c><00:00:31.150><c> see</c>

00:00:31.320 --> 00:00:31.330 align:start position:0%
removing certain people so we can see
 

00:00:31.330 --> 00:00:32.760 align:start position:0%
removing certain people so we can see
how<00:00:31.450><c> their</c><00:00:31.630><c> sales</c><00:00:31.900><c> are</c><00:00:32.080><c> impacting</c><00:00:32.620><c> their</c>

00:00:32.760 --> 00:00:32.770 align:start position:0%
how their sales are impacting their
 

00:00:32.770 --> 00:00:35.310 align:start position:0%
how their sales are impacting their
regions<00:00:33.160><c> we</c><00:00:34.120><c> can</c><00:00:34.270><c> do</c><00:00:34.450><c> this</c><00:00:34.629><c> by</c><00:00:34.870><c> adding</c><00:00:35.050><c> a</c>

00:00:35.310 --> 00:00:35.320 align:start position:0%
regions we can do this by adding a
 

00:00:35.320 --> 00:00:37.110 align:start position:0%
regions we can do this by adding a
report<00:00:35.680><c> filter</c><00:00:35.860><c> which</c><00:00:36.489><c> can</c><00:00:36.699><c> be</c><00:00:36.790><c> used</c><00:00:37.000><c> to</c>

00:00:37.110 --> 00:00:37.120 align:start position:0%
report filter which can be used to
 

00:00:37.120 --> 00:00:39.560 align:start position:0%
report filter which can be used to
narrow<00:00:37.390><c> down</c><00:00:37.629><c> the</c><00:00:37.809><c> data</c><00:00:38.020><c> in</c><00:00:38.230><c> your</c><00:00:38.379><c> pivot</c><00:00:38.650><c> table</c>

00:00:39.560 --> 00:00:39.570 align:start position:0%
narrow down the data in your pivot table
 

00:00:39.570 --> 00:00:43.619 align:start position:0%
narrow down the data in your pivot table
first<00:00:40.570><c> drag</c><00:00:40.900><c> the</c><00:00:41.080><c> salesperson</c><00:00:41.800><c> field</c><00:00:42.390><c> to</c><00:00:43.390><c> the</c>

00:00:43.619 --> 00:00:43.629 align:start position:0%
first drag the salesperson field to the
 

00:00:43.629 --> 00:00:47.280 align:start position:0%
first drag the salesperson field to the
filters<00:00:44.019><c> area</c><00:00:45.480><c> then</c><00:00:46.480><c> look</c><00:00:46.690><c> to</c><00:00:46.839><c> your</c><00:00:46.989><c> pivot</c>

00:00:47.280 --> 00:00:47.290 align:start position:0%
filters area then look to your pivot
 

00:00:47.290 --> 00:00:49.170 align:start position:0%
filters area then look to your pivot
table<00:00:47.470><c> and</c><00:00:47.800><c> click</c><00:00:48.309><c> the</c><00:00:48.430><c> filter</c><00:00:48.820><c> that's</c><00:00:48.970><c> been</c>

00:00:49.170 --> 00:00:49.180 align:start position:0%
table and click the filter that's been
 

00:00:49.180 --> 00:00:53.009 align:start position:0%
table and click the filter that's been
added<00:00:49.510><c> to</c><00:00:49.540><c> the</c><00:00:49.750><c> upper</c><00:00:50.050><c> right</c><00:00:50.229><c> corner</c><00:00:52.019><c> next</c>

00:00:53.009 --> 00:00:53.019 align:start position:0%
added to the upper right corner next
 

00:00:53.019 --> 00:00:54.869 align:start position:0%
added to the upper right corner next
check<00:00:53.320><c> the</c><00:00:53.470><c> option</c><00:00:53.860><c> that</c><00:00:53.890><c> says</c><00:00:54.010><c> select</c>

00:00:54.869 --> 00:00:54.879 align:start position:0%
check the option that says select
 

00:00:54.879 --> 00:00:58.079 align:start position:0%
check the option that says select
multiple<00:00:55.390><c> items</c><00:00:56.280><c> now</c><00:00:57.280><c> we</c><00:00:57.339><c> can</c><00:00:57.610><c> check</c><00:00:57.850><c> or</c>

00:00:58.079 --> 00:00:58.089 align:start position:0%
multiple items now we can check or
 

00:00:58.089 --> 00:01:00.090 align:start position:0%
multiple items now we can check or
uncheck<00:00:58.120><c> the</c><00:00:58.720><c> salespeople</c><00:00:59.199><c> above</c><00:00:59.650><c> depending</c>

00:01:00.090 --> 00:01:00.100 align:start position:0%
uncheck the salespeople above depending
 

00:01:00.100 --> 00:01:03.390 align:start position:0%
uncheck the salespeople above depending
on<00:01:00.460><c> who</c><00:01:00.580><c> we</c><00:01:00.699><c> want</c><00:01:00.909><c> to</c><00:01:01.000><c> include</c><00:01:01.290><c> I'm</c><00:01:02.339><c> going</c><00:01:03.339><c> to</c>

00:01:03.390 --> 00:01:03.400 align:start position:0%
on who we want to include I'm going to
 

00:01:03.400 --> 00:01:06.240 align:start position:0%
on who we want to include I'm going to
remove<00:01:03.699><c> Michael</c><00:01:04.210><c> Brennan</c><00:01:04.860><c> Richard</c><00:01:05.860><c> doom</c><00:01:06.070><c> Lao</c>

00:01:06.240 --> 00:01:06.250 align:start position:0%
remove Michael Brennan Richard doom Lao
 

00:01:06.250 --> 00:01:11.100 align:start position:0%
remove Michael Brennan Richard doom Lao
and<00:01:07.380><c> Shannon</c><00:01:08.380><c> Thompson</c><00:01:09.750><c> when</c><00:01:10.750><c> you're</c><00:01:10.900><c> ready</c>

00:01:11.100 --> 00:01:11.110 align:start position:0%
and Shannon Thompson when you're ready
 

00:01:11.110 --> 00:01:14.280 align:start position:0%
and Shannon Thompson when you're ready
click<00:01:11.380><c> OK</c><00:01:11.560><c> and</c><00:01:12.420><c> the</c><00:01:13.420><c> filter</c><00:01:13.720><c> will</c><00:01:13.870><c> be</c><00:01:13.960><c> applied</c>

00:01:14.280 --> 00:01:14.290 align:start position:0%
click OK and the filter will be applied
 

00:01:14.290 --> 00:01:17.190 align:start position:0%
click OK and the filter will be applied
in<00:01:14.729><c> this</c><00:01:15.729><c> case</c><00:01:15.969><c> that</c><00:01:16.270><c> means</c><00:01:16.450><c> the</c><00:01:16.630><c> totals</c><00:01:16.750><c> have</c>

00:01:17.190 --> 00:01:17.200 align:start position:0%
in this case that means the totals have
 

00:01:17.200 --> 00:01:19.170 align:start position:0%
in this case that means the totals have
changed<00:01:17.649><c> and</c><00:01:17.799><c> two</c><00:01:18.219><c> of</c><00:01:18.340><c> the</c><00:01:18.460><c> regions</c><00:01:18.850><c> have</c><00:01:19.030><c> also</c>

00:01:19.170 --> 00:01:19.180 align:start position:0%
changed and two of the regions have also
 

00:01:19.180 --> 00:01:21.179 align:start position:0%
changed and two of the regions have also
been<00:01:19.479><c> filtered</c><00:01:19.869><c> out</c><00:01:20.049><c> based</c><00:01:20.590><c> on</c><00:01:20.770><c> the</c><00:01:20.890><c> people</c>

00:01:21.179 --> 00:01:21.189 align:start position:0%
been filtered out based on the people
 

00:01:21.189 --> 00:01:24.359 align:start position:0%
been filtered out based on the people
that<00:01:21.219><c> we</c><00:01:21.369><c> unchecked</c><00:01:21.880><c> if</c><00:01:22.890><c> you</c><00:01:23.890><c> like</c><00:01:24.100><c> the</c><00:01:24.250><c> way</c>

00:01:24.359 --> 00:01:24.369 align:start position:0%
that we unchecked if you like the way
 

00:01:24.369 --> 00:01:26.039 align:start position:0%
that we unchecked if you like the way
filters<00:01:24.789><c> work</c><00:01:25.060><c> you</c><00:01:25.450><c> might</c><00:01:25.600><c> want</c><00:01:25.780><c> to</c><00:01:25.840><c> try</c>

00:01:26.039 --> 00:01:26.049 align:start position:0%
filters work you might want to try
 

00:01:26.049 --> 00:01:28.740 align:start position:0%
filters work you might want to try
adding<00:01:26.380><c> a</c><00:01:26.500><c> slicer</c><00:01:26.890><c> next</c><00:01:27.539><c> slicers</c><00:01:28.539><c> make</c>

00:01:28.740 --> 00:01:28.750 align:start position:0%
adding a slicer next slicers make
 

00:01:28.750 --> 00:01:30.719 align:start position:0%
adding a slicer next slicers make
filtering<00:01:29.200><c> even</c><00:01:29.469><c> faster</c><00:01:29.890><c> and</c><00:01:30.009><c> easier</c><00:01:30.219><c> by</c>

00:01:30.719 --> 00:01:30.729 align:start position:0%
filtering even faster and easier by
 

00:01:30.729 --> 00:01:32.370 align:start position:0%
filtering even faster and easier by
giving<00:01:31.030><c> you</c><00:01:31.119><c> access</c><00:01:31.299><c> to</c><00:01:31.600><c> the</c><00:01:31.840><c> filters</c><00:01:32.200><c> in</c>

00:01:32.370 --> 00:01:32.380 align:start position:0%
giving you access to the filters in
 

00:01:32.380 --> 00:01:35.340 align:start position:0%
giving you access to the filters in
their<00:01:32.560><c> own</c><00:01:32.710><c> separate</c><00:01:33.159><c> pane</c><00:01:34.049><c> first</c><00:01:35.049><c> make</c><00:01:35.320><c> sure</c>

00:01:35.340 --> 00:01:35.350 align:start position:0%
their own separate pane first make sure
 

00:01:35.350 --> 00:01:37.560 align:start position:0%
their own separate pane first make sure
you're<00:01:35.710><c> on</c><00:01:35.859><c> the</c><00:01:35.890><c> analyse</c><00:01:36.430><c> tab</c><00:01:36.460><c> then</c><00:01:37.240><c> click</c><00:01:37.539><c> the</c>

00:01:37.560 --> 00:01:37.570 align:start position:0%
you're on the analyse tab then click the
 

00:01:37.570 --> 00:01:40.469 align:start position:0%
you're on the analyse tab then click the
insert<00:01:38.140><c> slicer</c><00:01:38.500><c> command</c>

00:01:40.469 --> 00:01:40.479 align:start position:0%
insert slicer command
 

00:01:40.479 --> 00:01:42.450 align:start position:0%
insert slicer command
a<00:01:40.509><c> dialog</c><00:01:41.289><c> box</c><00:01:41.530><c> will</c><00:01:41.740><c> appear</c><00:01:41.770><c> where</c><00:01:42.280><c> you</c><00:01:42.340><c> can</c>

00:01:42.450 --> 00:01:42.460 align:start position:0%
a dialog box will appear where you can
 

00:01:42.460 --> 00:01:44.880 align:start position:0%
a dialog box will appear where you can
check<00:01:42.789><c> the</c><00:01:42.939><c> filter</c><00:01:43.240><c> you</c><00:01:43.360><c> want</c><00:01:43.680><c> we'll</c><00:01:44.680><c> use</c>

00:01:44.880 --> 00:01:44.890 align:start position:0%
check the filter you want we'll use
 

00:01:44.890 --> 00:01:51.090 align:start position:0%
check the filter you want we'll use
salesperson<00:01:45.610><c> like</c><00:01:45.729><c> before</c><00:01:46.119><c> now</c><00:01:49.649><c> we</c><00:01:50.649><c> can</c><00:01:50.890><c> just</c>

00:01:51.090 --> 00:01:51.100 align:start position:0%
salesperson like before now we can just
 

00:01:51.100 --> 00:01:52.679 align:start position:0%
salesperson like before now we can just
click<00:01:51.310><c> the</c><00:01:51.520><c> salespeople</c><00:01:51.969><c> we</c><00:01:52.240><c> want</c><00:01:52.450><c> to</c><00:01:52.509><c> see</c>

00:01:52.679 --> 00:01:52.689 align:start position:0%
click the salespeople we want to see
 

00:01:52.689 --> 00:01:54.330 align:start position:0%
click the salespeople we want to see
without<00:01:53.049><c> having</c><00:01:53.380><c> to</c><00:01:53.619><c> go</c><00:01:53.740><c> to</c><00:01:53.799><c> the</c><00:01:54.009><c> filtering</c>

00:01:54.330 --> 00:01:54.340 align:start position:0%
without having to go to the filtering
 

00:01:54.340 --> 00:01:57.120 align:start position:0%
without having to go to the filtering
menu<00:01:54.840><c> you</c><00:01:55.840><c> can</c><00:01:55.990><c> even</c><00:01:56.200><c> select</c><00:01:56.500><c> multiple</c>

00:01:57.120 --> 00:01:57.130 align:start position:0%
menu you can even select multiple
 

00:01:57.130 --> 00:01:58.770 align:start position:0%
menu you can even select multiple
adjacent<00:01:57.399><c> people</c><00:01:57.970><c> by</c><00:01:58.210><c> clicking</c><00:01:58.600><c> and</c><00:01:58.750><c> dragging</c>

00:01:58.770 --> 00:01:58.780 align:start position:0%
adjacent people by clicking and dragging
 

00:01:58.780 --> 00:02:04.499 align:start position:0%
adjacent people by clicking and dragging
your<00:01:59.200><c> mouse</c><00:02:02.340><c> to</c><00:02:03.340><c> select</c><00:02:03.490><c> more</c><00:02:03.939><c> than</c><00:02:04.000><c> one</c><00:02:04.149><c> non</c>

00:02:04.499 --> 00:02:04.509 align:start position:0%
your mouse to select more than one non
 

00:02:04.509 --> 00:02:06.779 align:start position:0%
your mouse to select more than one non
adjacent<00:02:04.840><c> item</c><00:02:05.350><c> hold</c><00:02:05.950><c> ctrl</c><00:02:06.399><c> on</c><00:02:06.429><c> your</c><00:02:06.640><c> keyboard</c>

00:02:06.779 --> 00:02:06.789 align:start position:0%
adjacent item hold ctrl on your keyboard
 

00:02:06.789 --> 00:02:10.080 align:start position:0%
adjacent item hold ctrl on your keyboard
while<00:02:07.299><c> you</c><00:02:07.360><c> click</c><00:02:07.479><c> as</c><00:02:07.929><c> you</c><00:02:08.890><c> can</c><00:02:09.220><c> see</c><00:02:09.429><c> the</c><00:02:09.789><c> pivot</c>

00:02:10.080 --> 00:02:10.090 align:start position:0%
while you click as you can see the pivot
 

00:02:10.090 --> 00:02:12.059 align:start position:0%
while you click as you can see the pivot
table<00:02:10.239><c> changes</c><00:02:10.810><c> each</c><00:02:11.019><c> time</c><00:02:11.049><c> to</c><00:02:11.590><c> reflect</c><00:02:11.950><c> the</c>

00:02:12.059 --> 00:02:12.069 align:start position:0%
table changes each time to reflect the
 

00:02:12.069 --> 00:02:16.680 align:start position:0%
table changes each time to reflect the
data<00:02:12.220><c> you've</c><00:02:12.519><c> selected</c><00:02:15.120><c> the</c><00:02:16.120><c> last</c><00:02:16.390><c> thing</c><00:02:16.569><c> I'd</c>

00:02:16.680 --> 00:02:16.690 align:start position:0%
data you've selected the last thing I'd
 

00:02:16.690 --> 00:02:18.089 align:start position:0%
data you've selected the last thing I'd
like<00:02:16.840><c> to</c><00:02:16.989><c> show</c><00:02:17.200><c> you</c><00:02:17.260><c> is</c><00:02:17.560><c> a</c><00:02:17.590><c> neat</c><00:02:17.890><c> feature</c>

00:02:18.089 --> 00:02:18.099 align:start position:0%
like to show you is a neat feature
 

00:02:18.099 --> 00:02:20.789 align:start position:0%
like to show you is a neat feature
called<00:02:18.519><c> pivot</c><00:02:18.760><c> charts</c><00:02:19.290><c> pivot</c><00:02:20.290><c> charts</c><00:02:20.620><c> are</c>

00:02:20.789 --> 00:02:20.799 align:start position:0%
called pivot charts pivot charts are
 

00:02:20.799 --> 00:02:22.589 align:start position:0%
called pivot charts pivot charts are
basically<00:02:21.250><c> the</c><00:02:21.459><c> same</c><00:02:21.610><c> as</c><00:02:21.819><c> regular</c><00:02:21.849><c> charts</c>

00:02:22.589 --> 00:02:22.599 align:start position:0%
basically the same as regular charts
 

00:02:22.599 --> 00:02:24.180 align:start position:0%
basically the same as regular charts
except<00:02:23.170><c> they</c><00:02:23.290><c> show</c><00:02:23.500><c> whatever</c><00:02:23.739><c> is</c><00:02:24.010><c> in</c><00:02:24.160><c> your</c>

00:02:24.180 --> 00:02:24.190 align:start position:0%
except they show whatever is in your
 

00:02:24.190 --> 00:02:27.600 align:start position:0%
except they show whatever is in your
pivot<00:02:24.579><c> table</c><00:02:25.440><c> to</c><00:02:26.440><c> get</c><00:02:26.590><c> started</c><00:02:27.069><c> click</c><00:02:27.370><c> any</c>

00:02:27.600 --> 00:02:27.610 align:start position:0%
pivot table to get started click any
 

00:02:27.610 --> 00:02:31.920 align:start position:0%
pivot table to get started click any
cell<00:02:27.760><c> in</c><00:02:28.000><c> your</c><00:02:28.269><c> pivot</c><00:02:28.569><c> table</c><00:02:30.480><c> then</c><00:02:31.480><c> go</c><00:02:31.690><c> to</c><00:02:31.750><c> the</c>

00:02:31.920 --> 00:02:31.930 align:start position:0%
cell in your pivot table then go to the
 

00:02:31.930 --> 00:02:35.520 align:start position:0%
cell in your pivot table then go to the
insert<00:02:32.290><c> tab</c><00:02:32.349><c> and</c><00:02:34.019><c> click</c><00:02:35.019><c> the</c><00:02:35.049><c> pivot</c><00:02:35.500><c> chart</c>

00:02:35.520 --> 00:02:35.530 align:start position:0%
insert tab and click the pivot chart
 

00:02:35.530 --> 00:02:39.900 align:start position:0%
insert tab and click the pivot chart
command<00:02:36.160><c> a</c><00:02:37.829><c> dialog</c><00:02:38.829><c> box</c><00:02:39.010><c> will</c><00:02:39.310><c> appear</c><00:02:39.340><c> where</c>

00:02:39.900 --> 00:02:39.910 align:start position:0%
command a dialog box will appear where
 

00:02:39.910 --> 00:02:42.410 align:start position:0%
command a dialog box will appear where
you<00:02:40.000><c> can</c><00:02:40.180><c> select</c><00:02:40.360><c> the</c><00:02:40.690><c> chart</c><00:02:40.959><c> type</c><00:02:41.140><c> you</c><00:02:41.290><c> want</c>

00:02:42.410 --> 00:02:42.420 align:start position:0%
you can select the chart type you want
 

00:02:42.420 --> 00:02:48.120 align:start position:0%
you can select the chart type you want
then<00:02:43.420><c> go</c><00:02:43.750><c> ahead</c><00:02:43.900><c> and</c><00:02:44.079><c> click</c><00:02:44.349><c> OK</c><00:02:46.889><c> now</c><00:02:47.889><c> any</c>

00:02:48.120 --> 00:02:48.130 align:start position:0%
then go ahead and click OK now any
 

00:02:48.130 --> 00:02:49.920 align:start position:0%
then go ahead and click OK now any
changes<00:02:48.609><c> you</c><00:02:48.700><c> make</c><00:02:48.730><c> to</c><00:02:48.910><c> the</c><00:02:49.030><c> pivottable</c><00:02:49.150><c> will</c>

00:02:49.920 --> 00:02:49.930 align:start position:0%
changes you make to the pivottable will
 

00:02:49.930 --> 00:02:52.620 align:start position:0%
changes you make to the pivottable will
show<00:02:50.139><c> up</c><00:02:50.290><c> in</c><00:02:50.410><c> the</c><00:02:50.530><c> pivot</c><00:02:50.799><c> chart</c><00:02:50.829><c> as</c><00:02:51.190><c> well</c><00:02:51.630><c> for</c>

00:02:52.620 --> 00:02:52.630 align:start position:0%
show up in the pivot chart as well for
 

00:02:52.630 --> 00:02:54.210 align:start position:0%
show up in the pivot chart as well for
example<00:02:52.690><c> let's</c><00:02:53.350><c> see</c><00:02:53.530><c> what</c><00:02:53.650><c> happens</c><00:02:53.980><c> when</c><00:02:54.160><c> we</c>

00:02:54.210 --> 00:02:54.220 align:start position:0%
example let's see what happens when we
 

00:02:54.220 --> 00:02:56.190 align:start position:0%
example let's see what happens when we
move<00:02:54.489><c> these</c><00:02:54.670><c> fields</c><00:02:55.000><c> around</c><00:02:55.120><c> a</c><00:02:55.389><c> bit</c><00:02:55.540><c> so</c><00:02:55.930><c> we</c><00:02:55.959><c> can</c>

00:02:56.190 --> 00:02:56.200 align:start position:0%
move these fields around a bit so we can
 

00:02:56.200 --> 00:03:04.320 align:start position:0%
move these fields around a bit so we can
view<00:02:56.350><c> each</c><00:02:56.500><c> person's</c><00:02:56.950><c> monthly</c><00:02:57.370><c> sales</c><00:02:57.609><c> data</c>

00:03:04.320 --> 00:03:04.330 align:start position:0%
 
 

00:03:04.330 --> 00:03:07.750 align:start position:0%
 
with<00:03:05.330><c> a</c><00:03:05.360><c> pivot</c><00:03:05.600><c> table</c><00:03:05.900><c> a</c><00:03:06.200><c> pivot</c><00:03:06.800><c> chart</c><00:03:06.830><c> and</c><00:03:07.340><c> a</c>

00:03:07.750 --> 00:03:07.760 align:start position:0%
with a pivot table a pivot chart and a
 

00:03:07.760 --> 00:03:09.820 align:start position:0%
with a pivot table a pivot chart and a
slicer<00:03:08.180><c> we</c><00:03:08.660><c> can</c><00:03:08.810><c> look</c><00:03:08.960><c> at</c><00:03:09.050><c> the</c><00:03:09.170><c> data</c><00:03:09.350><c> in</c><00:03:09.560><c> so</c>

00:03:09.820 --> 00:03:09.830 align:start position:0%
slicer we can look at the data in so
 

00:03:09.830 --> 00:03:12.130 align:start position:0%
slicer we can look at the data in so
many<00:03:09.980><c> different</c><00:03:10.400><c> ways</c><00:03:10.520><c> all</c><00:03:10.940><c> without</c><00:03:11.690><c> changing</c>

00:03:12.130 --> 00:03:12.140 align:start position:0%
many different ways all without changing
 

00:03:12.140 --> 00:03:14.050 align:start position:0%
many different ways all without changing
or<00:03:12.260><c> deleting</c><00:03:12.290><c> any</c><00:03:12.860><c> of</c><00:03:13.040><c> the</c><00:03:13.160><c> original</c><00:03:13.580><c> content</c>

00:03:14.050 --> 00:03:14.060 align:start position:0%
or deleting any of the original content
 

00:03:14.060 --> 00:03:16.060 align:start position:0%
or deleting any of the original content
it's<00:03:15.020><c> a</c><00:03:15.140><c> great</c><00:03:15.350><c> way</c><00:03:15.500><c> to</c><00:03:15.530><c> find</c><00:03:15.800><c> whatever</c>

00:03:16.060 --> 00:03:16.070 align:start position:0%
it's a great way to find whatever
 

00:03:16.070 --> 00:03:18.010 align:start position:0%
it's a great way to find whatever
information<00:03:16.790><c> you're</c><00:03:16.940><c> looking</c><00:03:16.970><c> for</c><00:03:17.270><c> or</c><00:03:17.780><c> you</c>

00:03:18.010 --> 00:03:18.020 align:start position:0%
information you're looking for or you
 

00:03:18.020 --> 00:03:19.840 align:start position:0%
information you're looking for or you
can<00:03:18.350><c> just</c><00:03:18.530><c> experiment</c><00:03:19.250><c> to</c><00:03:19.490><c> see</c><00:03:19.640><c> if</c><00:03:19.730><c> you</c>

00:03:19.840 --> 00:03:19.850 align:start position:0%
can just experiment to see if you
 

00:03:19.850 --> 00:03:22.810 align:start position:0%
can just experiment to see if you
discover<00:03:20.240><c> something</c><00:03:20.540><c> new</c>