WEBVTT
Kind: captions
Language: en

00:00:01.159 --> 00:00:03.739 align:start position:0%
 
Goodwill<00:00:02.159><c> Community</c><00:00:02.639><c> Foundation</c><00:00:03.300><c> creating</c>

00:00:03.739 --> 00:00:03.749 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.749 --> 00:00:09.890 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.350><c> for</c><00:00:04.560><c> a</c><00:00:04.620><c> better</c><00:00:04.649><c> life</c><00:00:04.980><c> in</c><00:00:08.900><c> part</c>

00:00:09.890 --> 00:00:09.900 align:start position:0%
opportunities for a better life in part
 

00:00:09.900 --> 00:00:11.720 align:start position:0%
opportunities for a better life in part
one<00:00:10.110><c> we</c><00:00:10.349><c> talked</c><00:00:10.710><c> about</c><00:00:10.889><c> the</c><00:00:11.130><c> basics</c><00:00:11.549><c> of</c>

00:00:11.720 --> 00:00:11.730 align:start position:0%
one we talked about the basics of
 

00:00:11.730 --> 00:00:14.329 align:start position:0%
one we talked about the basics of
creating<00:00:12.210><c> a</c><00:00:12.299><c> pivot</c><00:00:12.480><c> table</c><00:00:12.929><c> in</c><00:00:13.080><c> this</c><00:00:13.980><c> video</c>

00:00:14.329 --> 00:00:14.339 align:start position:0%
creating a pivot table in this video
 

00:00:14.339 --> 00:00:15.919 align:start position:0%
creating a pivot table in this video
we're<00:00:14.730><c> going</c><00:00:14.820><c> to</c><00:00:14.879><c> take</c><00:00:15.089><c> a</c><00:00:15.120><c> look</c><00:00:15.299><c> at</c><00:00:15.450><c> three</c><00:00:15.719><c> more</c>

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

00:00:15.929 --> 00:00:18.260 align:start position:0%
we're going to take a look at three more
features<00:00:16.350><c> called</c><00:00:16.770><c> report</c><00:00:17.189><c> filters</c><00:00:17.550><c> slicers</c>

00:00:18.260 --> 00:00:18.270 align:start position:0%
features called report filters slicers
 

00:00:18.270 --> 00:00:21.769 align:start position:0%
features called report filters slicers
and<00:00:18.449><c> pivotcharts</c><00:00:19.820><c> right</c><00:00:20.820><c> now</c><00:00:21.029><c> this</c><00:00:21.449><c> pivot</c>

00:00:21.769 --> 00:00:21.779 align:start position:0%
and pivotcharts right now this pivot
 

00:00:21.779 --> 00:00:23.359 align:start position:0%
and pivotcharts right now this pivot
table<00:00:22.050><c> is</c><00:00:22.140><c> showing</c><00:00:22.439><c> us</c><00:00:22.590><c> the</c><00:00:22.619><c> regional</c><00:00:23.189><c> sales</c>

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

00:00:23.369 --> 00:00:25.310 align:start position:0%
table is showing us the regional sales
totals<00:00:23.849><c> for</c><00:00:24.060><c> all</c><00:00:24.240><c> the</c><00:00:24.449><c> salespeople</c><00:00:24.900><c> in</c><00:00:25.140><c> our</c>

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

00:00:25.320 --> 00:00:27.439 align:start position:0%
totals for all the salespeople in our
worksheet<00:00:25.710><c> however</c><00:00:26.640><c> I'd</c><00:00:26.910><c> like</c><00:00:26.939><c> to</c><00:00:27.119><c> try</c>

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

00:00:27.449 --> 00:00:29.359 align:start position:0%
worksheet however I'd like to try
removing<00:00:27.960><c> certain</c><00:00:28.170><c> people</c><00:00:28.590><c> so</c><00:00:28.920><c> we</c><00:00:29.039><c> can</c><00:00:29.070><c> see</c>

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

00:00:29.369 --> 00:00:30.800 align:start position:0%
removing certain people so we can see
how<00:00:29.519><c> their</c><00:00:29.670><c> sales</c><00:00:29.939><c> are</c><00:00:30.119><c> impacting</c><00:00:30.660><c> their</c>

00:00:30.800 --> 00:00:30.810 align:start position:0%
how their sales are impacting their
 

00:00:30.810 --> 00:00:33.350 align:start position:0%
how their sales are impacting their
regions<00:00:31.199><c> we</c><00:00:32.160><c> can</c><00:00:32.310><c> do</c><00:00:32.490><c> this</c><00:00:32.700><c> by</c><00:00:32.910><c> adding</c><00:00:33.090><c> a</c>

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

00:00:33.360 --> 00:00:35.210 align:start position:0%
regions we can do this by adding a
report<00:00:33.720><c> filter</c><00:00:34.080><c> which</c><00:00:34.530><c> can</c><00:00:34.740><c> be</c><00:00:34.830><c> used</c><00:00:35.040><c> to</c>

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

00:00:35.220 --> 00:00:37.510 align:start position:0%
report filter which can be used to
narrow<00:00:35.370><c> down</c><00:00:35.670><c> the</c><00:00:35.850><c> data</c><00:00:35.880><c> in</c><00:00:36.270><c> your</c><00:00:36.420><c> pivot</c><00:00:36.690><c> table</c>

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

00:00:37.520 --> 00:00:41.390 align:start position:0%
narrow down the data in your pivot table
first<00:00:38.520><c> drag</c><00:00:38.940><c> the</c><00:00:39.120><c> salesperson</c><00:00:39.810><c> field</c><00:00:40.160><c> to</c><00:00:41.160><c> the</c>

00:00:41.390 --> 00:00:41.400 align:start position:0%
first drag the salesperson field to the
 

00:00:41.400 --> 00:00:45.050 align:start position:0%
first drag the salesperson field to the
filters<00:00:41.820><c> area</c><00:00:43.220><c> then</c><00:00:44.220><c> look</c><00:00:44.460><c> to</c><00:00:44.610><c> your</c><00:00:44.760><c> pivot</c>

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

00:00:45.060 --> 00:00:46.940 align:start position:0%
filters area then look to your pivot
table<00:00:45.240><c> and</c><00:00:45.570><c> click</c><00:00:46.080><c> the</c><00:00:46.200><c> filter</c><00:00:46.590><c> that's</c><00:00:46.800><c> been</c>

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

00:00:46.950 --> 00:00:51.560 align:start position:0%
table and click the filter that's been
added<00:00:47.160><c> to</c><00:00:47.310><c> the</c><00:00:47.520><c> upper</c><00:00:47.820><c> right</c><00:00:48.000><c> corner</c><00:00:50.570><c> next</c>

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

00:00:51.570 --> 00:00:53.630 align:start position:0%
added to the upper right corner next
check<00:00:52.080><c> the</c><00:00:52.230><c> option</c><00:00:52.620><c> that</c><00:00:52.650><c> says</c><00:00:52.800><c> select</c>

00:00:53.630 --> 00:00:53.640 align:start position:0%
check the option that says select
 

00:00:53.640 --> 00:00:56.840 align:start position:0%
check the option that says select
multiple<00:00:54.150><c> items</c><00:00:55.040><c> now</c><00:00:56.040><c> we</c><00:00:56.100><c> can</c><00:00:56.340><c> check</c><00:00:56.610><c> or</c>

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

00:00:56.850 --> 00:00:58.820 align:start position:0%
multiple items now we can check or
uncheck<00:00:56.880><c> the</c><00:00:57.480><c> salespeople</c><00:00:57.930><c> above</c><00:00:58.380><c> depending</c>

00:00:58.820 --> 00:00:58.830 align:start position:0%
uncheck the salespeople above depending
 

00:00:58.830 --> 00:01:02.150 align:start position:0%
uncheck the salespeople above depending
on<00:00:59.220><c> who</c><00:00:59.340><c> we</c><00:00:59.460><c> want</c><00:00:59.670><c> to</c><00:00:59.730><c> include</c><00:01:00.260><c> I'm</c><00:01:01.260><c> going</c><00:01:02.100><c> to</c>

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

00:01:02.160 --> 00:01:05.150 align:start position:0%
on who we want to include I'm going to
remove<00:01:02.430><c> Michael</c><00:01:02.940><c> Brennan</c><00:01:03.769><c> Richard</c><00:01:04.769><c> Dunne</c><00:01:04.980><c> Lao</c>

00:01:05.150 --> 00:01:05.160 align:start position:0%
remove Michael Brennan Richard Dunne Lao
 

00:01:05.160 --> 00:01:09.830 align:start position:0%
remove Michael Brennan Richard Dunne Lao
and<00:01:06.140><c> Shannon</c><00:01:07.140><c> Thompson</c><00:01:08.480><c> when</c><00:01:09.480><c> you're</c><00:01:09.660><c> ready</c>

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

00:01:09.840 --> 00:01:13.010 align:start position:0%
and Shannon Thompson when you're ready
click<00:01:10.170><c> OK</c><00:01:10.320><c> and</c><00:01:11.180><c> the</c><00:01:12.180><c> filter</c><00:01:12.450><c> will</c><00:01:12.600><c> be</c><00:01:12.630><c> applied</c>

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

00:01:13.020 --> 00:01:16.010 align:start position:0%
click OK and the filter will be applied
in<00:01:13.580><c> this</c><00:01:14.580><c> case</c><00:01:14.820><c> that</c><00:01:15.120><c> means</c><00:01:15.300><c> the</c><00:01:15.480><c> totals</c><00:01:15.600><c> have</c>

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

00:01:16.020 --> 00:01:18.020 align:start position:0%
in this case that means the totals have
changed<00:01:16.470><c> and</c><00:01:16.620><c> two</c><00:01:17.040><c> of</c><00:01:17.190><c> the</c><00:01:17.310><c> regions</c><00:01:17.700><c> have</c><00:01:17.880><c> also</c>

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

00:01:18.030 --> 00:01:20.030 align:start position:0%
changed and two of the regions have also
been<00:01:18.330><c> filtered</c><00:01:18.690><c> out</c><00:01:18.900><c> based</c><00:01:19.410><c> on</c><00:01:19.620><c> the</c><00:01:19.740><c> people</c>

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

00:01:20.040 --> 00:01:21.960 align:start position:0%
been filtered out based on the people
that<00:01:20.070><c> we</c><00:01:20.190><c> unchecked</c>

00:01:21.960 --> 00:01:21.970 align:start position:0%
that we unchecked
 

00:01:21.970 --> 00:01:24.270 align:start position:0%
that we unchecked
if<00:01:22.030><c> you</c><00:01:22.720><c> like</c><00:01:22.930><c> the</c><00:01:23.080><c> way</c><00:01:23.200><c> filters</c><00:01:23.620><c> work</c><00:01:23.890><c> you</c>

00:01:24.270 --> 00:01:24.280 align:start position:0%
if you like the way filters work you
 

00:01:24.280 --> 00:01:26.330 align:start position:0%
if you like the way filters work you
might<00:01:24.460><c> want</c><00:01:24.610><c> to</c><00:01:24.670><c> try</c><00:01:24.820><c> adding</c><00:01:25.210><c> a</c><00:01:25.330><c> slicer</c><00:01:25.720><c> next</c>

00:01:26.330 --> 00:01:26.340 align:start position:0%
might want to try adding a slicer next
 

00:01:26.340 --> 00:01:28.860 align:start position:0%
might want to try adding a slicer next
slicers<00:01:27.340><c> make</c><00:01:27.550><c> filtering</c><00:01:28.030><c> even</c><00:01:28.300><c> faster</c><00:01:28.720><c> and</c>

00:01:28.860 --> 00:01:28.870 align:start position:0%
slicers make filtering even faster and
 

00:01:28.870 --> 00:01:30.660 align:start position:0%
slicers make filtering even faster and
easier<00:01:29.050><c> by</c><00:01:29.560><c> giving</c><00:01:29.590><c> you</c><00:01:29.950><c> access</c><00:01:30.130><c> to</c><00:01:30.430><c> the</c>

00:01:30.660 --> 00:01:30.670 align:start position:0%
easier by giving you access to the
 

00:01:30.670 --> 00:01:33.930 align:start position:0%
easier by giving you access to the
filters<00:01:31.000><c> in</c><00:01:31.210><c> their</c><00:01:31.390><c> own</c><00:01:31.540><c> separate</c><00:01:31.990><c> pane</c><00:01:32.940><c> first</c>

00:01:33.930 --> 00:01:33.940 align:start position:0%
filters in their own separate pane first
 

00:01:33.940 --> 00:01:35.610 align:start position:0%
filters in their own separate pane first
make<00:01:34.150><c> sure</c><00:01:34.330><c> you're</c><00:01:34.540><c> on</c><00:01:34.570><c> the</c><00:01:34.690><c> analyse</c><00:01:35.260><c> tab</c>

00:01:35.610 --> 00:01:35.620 align:start position:0%
make sure you're on the analyse tab
 

00:01:35.620 --> 00:01:39.080 align:start position:0%
make sure you're on the analyse tab
then<00:01:36.070><c> click</c><00:01:36.340><c> the</c><00:01:36.370><c> insert</c><00:01:36.550><c> slicer</c><00:01:37.330><c> command</c><00:01:37.870><c> a</c>

00:01:39.080 --> 00:01:39.090 align:start position:0%
then click the insert slicer command a
 

00:01:39.090 --> 00:01:41.280 align:start position:0%
then click the insert slicer command a
dialog<00:01:40.090><c> box</c><00:01:40.330><c> will</c><00:01:40.570><c> appear</c><00:01:40.600><c> where</c><00:01:41.080><c> you</c><00:01:41.140><c> can</c>

00:01:41.280 --> 00:01:41.290 align:start position:0%
dialog box will appear where you can
 

00:01:41.290 --> 00:01:43.680 align:start position:0%
dialog box will appear where you can
check<00:01:41.590><c> the</c><00:01:41.740><c> filter</c><00:01:42.070><c> you</c><00:01:42.190><c> want</c><00:01:42.480><c> we'll</c><00:01:43.480><c> use</c>

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

00:01:43.690 --> 00:01:49.770 align:start position:0%
check the filter you want we'll use
salesperson<00:01:44.410><c> like</c><00:01:44.560><c> before</c><00:01:44.920><c> now</c><00:01:48.360><c> we</c><00:01:49.360><c> can</c><00:01:49.600><c> just</c>

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

00:01:49.780 --> 00:01:51.360 align:start position:0%
salesperson like before now we can just
click<00:01:50.050><c> the</c><00:01:50.230><c> salespeople</c><00:01:50.680><c> we</c><00:01:50.950><c> want</c><00:01:51.130><c> to</c><00:01:51.220><c> see</c>

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

00:01:51.370 --> 00:01:53.100 align:start position:0%
click the salespeople we want to see
without<00:01:51.760><c> having</c><00:01:52.210><c> to</c><00:01:52.300><c> go</c><00:01:52.450><c> to</c><00:01:52.510><c> the</c><00:01:52.690><c> filtering</c>

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

00:01:53.110 --> 00:01:55.830 align:start position:0%
without having to go to the filtering
menu<00:01:53.520><c> you</c><00:01:54.520><c> can</c><00:01:54.670><c> even</c><00:01:55.000><c> select</c><00:01:55.180><c> multiple</c>

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

00:01:55.840 --> 00:01:57.480 align:start position:0%
menu you can even select multiple
adjacent<00:01:56.110><c> people</c><00:01:56.650><c> by</c><00:01:56.890><c> clicking</c><00:01:57.310><c> and</c><00:01:57.460><c> dragging</c>

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

00:01:57.490 --> 00:02:02.880 align:start position:0%
adjacent people by clicking and dragging
your<00:01:57.910><c> mouse</c><00:02:01.080><c> to</c><00:02:02.080><c> select</c><00:02:02.110><c> more</c><00:02:02.680><c> than</c><00:02:02.740><c> one</c>

00:02:02.880 --> 00:02:02.890 align:start position:0%
your mouse to select more than one
 

00:02:02.890 --> 00:02:05.370 align:start position:0%
your mouse to select more than one
non-adjacent<00:02:03.550><c> item</c><00:02:04.090><c> hold</c><00:02:04.690><c> ctrl</c><00:02:05.140><c> on</c><00:02:05.170><c> your</c>

00:02:05.370 --> 00:02:05.380 align:start position:0%
non-adjacent item hold ctrl on your
 

00:02:05.380 --> 00:02:08.160 align:start position:0%
non-adjacent item hold ctrl on your
keyboard<00:02:05.530><c> while</c><00:02:06.040><c> you</c><00:02:06.070><c> click</c><00:02:06.220><c> as</c><00:02:06.670><c> you</c><00:02:07.600><c> can</c><00:02:07.930><c> see</c>

00:02:08.160 --> 00:02:08.170 align:start position:0%
keyboard while you click as you can see
 

00:02:08.170 --> 00:02:10.320 align:start position:0%
keyboard while you click as you can see
the<00:02:08.530><c> pivot</c><00:02:08.830><c> table</c><00:02:08.950><c> changes</c><00:02:09.550><c> each</c><00:02:09.729><c> time</c><00:02:09.759><c> to</c>

00:02:10.320 --> 00:02:10.330 align:start position:0%
the pivot table changes each time to
 

00:02:10.330 --> 00:02:14.970 align:start position:0%
the pivot table changes each time to
reflect<00:02:10.540><c> the</c><00:02:10.810><c> data</c><00:02:10.990><c> you've</c><00:02:11.260><c> selected</c><00:02:13.980><c> the</c>

00:02:14.970 --> 00:02:14.980 align:start position:0%
reflect the data you've selected the
 

00:02:14.980 --> 00:02:16.440 align:start position:0%
reflect the data you've selected the
last<00:02:15.220><c> thing</c><00:02:15.430><c> I'd</c><00:02:15.550><c> like</c><00:02:15.670><c> to</c><00:02:15.730><c> show</c><00:02:16.030><c> you</c><00:02:16.060><c> is</c><00:02:16.420><c> a</c>

00:02:16.440 --> 00:02:16.450 align:start position:0%
last thing I'd like to show you is a
 

00:02:16.450 --> 00:02:19.110 align:start position:0%
last thing I'd like to show you is a
neat<00:02:16.750><c> feature</c><00:02:16.959><c> called</c><00:02:17.350><c> pivot</c><00:02:17.620><c> charts</c><00:02:18.120><c> pivot</c>

00:02:19.110 --> 00:02:19.120 align:start position:0%
neat feature called pivot charts pivot
 

00:02:19.120 --> 00:02:20.820 align:start position:0%
neat feature called pivot charts pivot
charts<00:02:19.450><c> are</c><00:02:19.630><c> basically</c><00:02:20.110><c> the</c><00:02:20.290><c> same</c><00:02:20.320><c> as</c><00:02:20.680><c> regular</c>

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

00:02:20.830 --> 00:02:22.980 align:start position:0%
charts are basically the same as regular
charts<00:02:21.430><c> except</c><00:02:22.060><c> they</c><00:02:22.150><c> show</c><00:02:22.360><c> whatever</c><00:02:22.570><c> is</c><00:02:22.870><c> in</c>

00:02:22.980 --> 00:02:22.990 align:start position:0%
charts except they show whatever is in
 

00:02:22.990 --> 00:02:26.160 align:start position:0%
charts except they show whatever is in
your<00:02:23.140><c> pivot</c><00:02:23.440><c> table</c><00:02:24.270><c> to</c><00:02:25.270><c> get</c><00:02:25.450><c> started</c><00:02:25.930><c> click</c>

00:02:26.160 --> 00:02:26.170 align:start position:0%
your pivot table to get started click
 

00:02:26.170 --> 00:02:30.600 align:start position:0%
your pivot table to get started click
any<00:02:26.470><c> cell</c><00:02:26.590><c> in</c><00:02:26.860><c> your</c><00:02:27.100><c> pivot</c><00:02:27.400><c> table</c><00:02:29.310><c> then</c><00:02:30.310><c> go</c><00:02:30.550><c> to</c>

00:02:30.600 --> 00:02:30.610 align:start position:0%
any cell in your pivot table then go to
 

00:02:30.610 --> 00:02:34.590 align:start position:0%
any cell in your pivot table then go to
the<00:02:30.760><c> insert</c><00:02:31.150><c> tab</c><00:02:31.209><c> and</c><00:02:32.850><c> click</c><00:02:33.850><c> the</c><00:02:33.880><c> pivot</c><00:02:34.180><c> chart</c>

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

00:02:34.600 --> 00:02:38.640 align:start position:0%
the insert tab and click the pivot chart
command<00:02:34.959><c> a</c><00:02:36.600><c> dialog</c><00:02:37.600><c> box</c><00:02:37.780><c> will</c><00:02:38.080><c> appear</c><00:02:38.110><c> where</c>

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

00:02:38.650 --> 00:02:41.180 align:start position:0%
command a dialog box will appear where
you<00:02:38.709><c> can</c><00:02:38.800><c> select</c><00:02:39.130><c> the</c><00:02:39.459><c> chart</c><00:02:39.700><c> type</c><00:02:39.910><c> you</c><00:02:40.060><c> want</c>

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

00:02:41.190 --> 00:02:46.530 align:start position:0%
you can select the chart type you want
then<00:02:42.190><c> go</c><00:02:42.519><c> ahead</c><00:02:42.640><c> and</c><00:02:42.850><c> click</c><00:02:43.120><c> OK</c><00:02:45.300><c> now</c><00:02:46.300><c> any</c>

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

00:02:46.540 --> 00:02:48.330 align:start position:0%
then go ahead and click OK now any
changes<00:02:46.989><c> you</c><00:02:47.110><c> make</c><00:02:47.140><c> to</c><00:02:47.290><c> the</c><00:02:47.440><c> pivottable</c><00:02:47.530><c> will</c>

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

00:02:48.340 --> 00:02:51.000 align:start position:0%
changes you make to the pivottable will
show<00:02:48.519><c> up</c><00:02:48.670><c> in</c><00:02:48.820><c> the</c><00:02:48.910><c> pivot</c><00:02:49.180><c> chart</c><00:02:49.209><c> as</c><00:02:49.600><c> well</c><00:02:50.010><c> for</c>

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

00:02:51.010 --> 00:02:52.710 align:start position:0%
show up in the pivot chart as well for
example<00:02:51.430><c> let's</c><00:02:51.730><c> see</c><00:02:51.910><c> what</c><00:02:52.060><c> happens</c><00:02:52.390><c> when</c><00:02:52.570><c> we</c>

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

00:02:52.720 --> 00:02:54.600 align:start position:0%
example let's see what happens when we
move<00:02:52.870><c> these</c><00:02:53.049><c> fields</c><00:02:53.380><c> around</c><00:02:53.650><c> a</c><00:02:53.769><c> bit</c><00:02:53.920><c> so</c><00:02:54.340><c> we</c><00:02:54.370><c> can</c>

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

00:02:54.610 --> 00:03:02.710 align:start position:0%
move these fields around a bit so we can
view<00:02:54.730><c> each</c><00:02:54.910><c> person's</c><00:02:55.330><c> monthly</c><00:02:55.750><c> sales</c><00:02:55.989><c> data</c>

00:03:02.710 --> 00:03:02.720 align:start position:0%
 
 

00:03:02.720 --> 00:03:06.140 align:start position:0%
 
with<00:03:03.720><c> a</c><00:03:03.750><c> pivot</c><00:03:04.140><c> table</c><00:03:04.290><c> a</c><00:03:04.620><c> pivot</c><00:03:05.190><c> chart</c><00:03:05.220><c> and</c><00:03:05.730><c> a</c>

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

00:03:06.150 --> 00:03:08.240 align:start position:0%
with a pivot table a pivot chart and a
slicer<00:03:06.599><c> we</c><00:03:07.050><c> can</c><00:03:07.200><c> look</c><00:03:07.349><c> at</c><00:03:07.470><c> the</c><00:03:07.560><c> data</c><00:03:07.770><c> in</c><00:03:07.980><c> so</c>

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

00:03:08.250 --> 00:03:10.520 align:start position:0%
slicer we can look at the data in so
many<00:03:08.370><c> different</c><00:03:08.610><c> ways</c><00:03:08.849><c> all</c><00:03:09.300><c> without</c><00:03:10.080><c> changing</c>

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

00:03:10.530 --> 00:03:12.610 align:start position:0%
many different ways all without changing
or<00:03:10.650><c> deleting</c><00:03:10.680><c> any</c><00:03:11.280><c> of</c><00:03:11.459><c> the</c><00:03:11.550><c> original</c><00:03:12.000><c> content</c>

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

00:03:12.620 --> 00:03:14.630 align:start position:0%
or deleting any of the original content
it's<00:03:13.620><c> a</c><00:03:13.739><c> great</c><00:03:13.920><c> way</c><00:03:14.100><c> to</c><00:03:14.130><c> find</c><00:03:14.459><c> whatever</c>

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

00:03:14.640 --> 00:03:16.760 align:start position:0%
it's a great way to find whatever
information<00:03:15.360><c> you're</c><00:03:15.510><c> looking</c><00:03:15.540><c> for</c><00:03:15.840><c> or</c><00:03:16.530><c> you</c>

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

00:03:16.770 --> 00:03:18.440 align:start position:0%
information you're looking for or you
can<00:03:16.950><c> just</c><00:03:17.130><c> experiment</c><00:03:17.819><c> to</c><00:03:18.060><c> see</c><00:03:18.209><c> if</c><00:03:18.330><c> you</c>

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

00:03:18.450 --> 00:03:21.410 align:start position:0%
can just experiment to see if you
discover<00:03:18.810><c> something</c><00:03:18.900><c> new</c>