WEBVTT
Kind: captions
Language: en

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

00:00:02.750 --> 00:00:02.760 align:start position:0%
Goodwill Community Foundation
 

00:00:02.760 --> 00:00:10.820 align:start position:0%
Goodwill Community Foundation
creating<00:00:03.000><c> opportunities</c><00:00:03.600><c> for</c><00:00:03.630><c> a</c><00:00:03.870><c> better</c><00:00:03.900><c> life</c>

00:00:10.820 --> 00:00:10.830 align:start position:0%
 
 

00:00:10.830 --> 00:00:13.070 align:start position:0%
 
one<00:00:11.550><c> of</c><00:00:11.670><c> the</c><00:00:11.790><c> best</c><00:00:12.000><c> things</c><00:00:12.240><c> about</c><00:00:12.360><c> Excel</c><00:00:12.870><c> is</c>

00:00:13.070 --> 00:00:13.080 align:start position:0%
one of the best things about Excel is
 

00:00:13.080 --> 00:00:14.780 align:start position:0%
one of the best things about Excel is
the<00:00:13.320><c> fact</c><00:00:13.560><c> that</c><00:00:13.680><c> a</c><00:00:13.830><c> single</c><00:00:14.220><c> worksheet</c><00:00:14.610><c> can</c>

00:00:14.780 --> 00:00:14.790 align:start position:0%
the fact that a single worksheet can
 

00:00:14.790 --> 00:00:17.570 align:start position:0%
the fact that a single worksheet can
hold<00:00:15.030><c> so</c><00:00:15.330><c> much</c><00:00:15.570><c> information</c><00:00:15.930><c> in</c><00:00:16.410><c> fact</c><00:00:17.190><c> you</c>

00:00:17.570 --> 00:00:17.580 align:start position:0%
hold so much information in fact you
 

00:00:17.580 --> 00:00:19.220 align:start position:0%
hold so much information in fact you
could<00:00:17.760><c> fill</c><00:00:17.910><c> billions</c><00:00:18.390><c> of</c><00:00:18.540><c> cells</c><00:00:18.810><c> if</c><00:00:19.110><c> you</c>

00:00:19.220 --> 00:00:19.230 align:start position:0%
could fill billions of cells if you
 

00:00:19.230 --> 00:00:21.769 align:start position:0%
could fill billions of cells if you
needed<00:00:19.439><c> that</c><00:00:19.650><c> much</c><00:00:19.800><c> room</c><00:00:20.070><c> a</c><00:00:20.390><c> file</c><00:00:21.390><c> with</c><00:00:21.630><c> that</c>

00:00:21.769 --> 00:00:21.779 align:start position:0%
needed that much room a file with that
 

00:00:21.779 --> 00:00:23.690 align:start position:0%
needed that much room a file with that
much<00:00:21.990><c> data</c><00:00:22.290><c> could</c><00:00:22.650><c> get</c><00:00:22.860><c> pretty</c><00:00:23.100><c> overwhelming</c>

00:00:23.690 --> 00:00:23.700 align:start position:0%
much data could get pretty overwhelming
 

00:00:23.700 --> 00:00:25.250 align:start position:0%
much data could get pretty overwhelming
but<00:00:24.060><c> there's</c><00:00:24.240><c> a</c><00:00:24.300><c> feature</c><00:00:24.540><c> called</c><00:00:24.840><c> pivot</c>

00:00:25.250 --> 00:00:25.260 align:start position:0%
but there's a feature called pivot
 

00:00:25.260 --> 00:00:28.040 align:start position:0%
but there's a feature called pivot
tables<00:00:25.590><c> that</c><00:00:25.770><c> can</c><00:00:25.890><c> help</c><00:00:26.450><c> pivot</c><00:00:27.450><c> tables</c><00:00:27.810><c> let</c>

00:00:28.040 --> 00:00:28.050 align:start position:0%
tables that can help pivot tables let
 

00:00:28.050 --> 00:00:29.749 align:start position:0%
tables that can help pivot tables let
you<00:00:28.169><c> summarize</c><00:00:28.650><c> and</c><00:00:28.950><c> manipulate</c><00:00:29.460><c> your</c><00:00:29.550><c> data</c>

00:00:29.749 --> 00:00:29.759 align:start position:0%
you summarize and manipulate your data
 

00:00:29.759 --> 00:00:31.729 align:start position:0%
you summarize and manipulate your data
without<00:00:30.239><c> actually</c><00:00:30.810><c> changing</c><00:00:31.050><c> anything</c><00:00:31.470><c> in</c>

00:00:31.729 --> 00:00:31.739 align:start position:0%
without actually changing anything in
 

00:00:31.739 --> 00:00:33.920 align:start position:0%
without actually changing anything in
the<00:00:31.890><c> worksheet</c><00:00:32.279><c> let's</c><00:00:32.520><c> take</c><00:00:33.450><c> a</c><00:00:33.480><c> look</c><00:00:33.690><c> at</c><00:00:33.810><c> how</c>

00:00:33.920 --> 00:00:33.930 align:start position:0%
the worksheet let's take a look at how
 

00:00:33.930 --> 00:00:37.069 align:start position:0%
the worksheet let's take a look at how
they<00:00:34.079><c> work</c><00:00:34.260><c> in</c><00:00:34.970><c> this</c><00:00:35.970><c> example</c><00:00:36.329><c> I</c><00:00:36.630><c> have</c><00:00:36.930><c> some</c>

00:00:37.069 --> 00:00:37.079 align:start position:0%
they work in this example I have some
 

00:00:37.079 --> 00:00:39.319 align:start position:0%
they work in this example I have some
company<00:00:37.140><c> sales</c><00:00:37.710><c> data</c><00:00:38.040><c> with</c><00:00:38.670><c> columns</c><00:00:39.060><c> for</c><00:00:39.149><c> the</c>

00:00:39.319 --> 00:00:39.329 align:start position:0%
company sales data with columns for the
 

00:00:39.329 --> 00:00:44.060 align:start position:0%
company sales data with columns for the
salesperson<00:00:40.310><c> region</c><00:00:41.540><c> account</c><00:00:42.829><c> order</c><00:00:43.829><c> amount</c>

00:00:44.060 --> 00:00:44.070 align:start position:0%
salesperson region account order amount
 

00:00:44.070 --> 00:00:47.630 align:start position:0%
salesperson region account order amount
and<00:00:44.370><c> month</c><00:00:45.329><c> and</c><00:00:45.680><c> I</c><00:00:46.680><c> need</c><00:00:46.859><c> to</c><00:00:46.980><c> find</c><00:00:47.129><c> the</c><00:00:47.309><c> answer</c>

00:00:47.630 --> 00:00:47.640 align:start position:0%
and month and I need to find the answer
 

00:00:47.640 --> 00:00:50.479 align:start position:0%
and month and I need to find the answer
to<00:00:47.670><c> a</c><00:00:47.850><c> very</c><00:00:47.940><c> specific</c><00:00:48.449><c> question</c><00:00:49.219><c> what</c><00:00:50.219><c> is</c><00:00:50.340><c> the</c>

00:00:50.479 --> 00:00:50.489 align:start position:0%
to a very specific question what is the
 

00:00:50.489 --> 00:00:56.209 align:start position:0%
to a very specific question what is the
amount<00:00:50.760><c> sold</c><00:00:51.239><c> by</c><00:00:51.390><c> each</c><00:00:51.420><c> salesperson</c><00:00:55.219><c> because</c>

00:00:56.209 --> 00:00:56.219 align:start position:0%
amount sold by each salesperson because
 

00:00:56.219 --> 00:00:58.189 align:start position:0%
amount sold by each salesperson because
each<00:00:56.399><c> salesperson</c><00:00:56.820><c> has</c><00:00:57.300><c> data</c><00:00:57.570><c> on</c><00:00:57.660><c> more</c><00:00:58.050><c> than</c>

00:00:58.189 --> 00:00:58.199 align:start position:0%
each salesperson has data on more than
 

00:00:58.199 --> 00:01:00.139 align:start position:0%
each salesperson has data on more than
one<00:00:58.410><c> row</c><00:00:58.620><c> I'd</c><00:00:58.890><c> normally</c><00:00:59.190><c> have</c><00:00:59.579><c> to</c><00:00:59.730><c> add</c><00:00:59.879><c> these</c>

00:01:00.139 --> 00:01:00.149 align:start position:0%
one row I'd normally have to add these
 

00:01:00.149 --> 00:01:02.569 align:start position:0%
one row I'd normally have to add these
up<00:01:00.390><c> in</c><00:01:00.600><c> order</c><00:01:00.809><c> to</c><00:01:00.989><c> find</c><00:01:01.199><c> the</c><00:01:01.289><c> answer</c><00:01:01.550><c> but</c><00:01:02.550><c> a</c>

00:01:02.569 --> 00:01:02.579 align:start position:0%
up in order to find the answer but a
 

00:01:02.579 --> 00:01:04.040 align:start position:0%
up in order to find the answer but a
pivot<00:01:02.969><c> table</c><00:01:03.089><c> can</c><00:01:03.449><c> do</c><00:01:03.570><c> this</c><00:01:03.749><c> for</c><00:01:04.019><c> us</c>

00:01:04.040 --> 00:01:04.050 align:start position:0%
pivot table can do this for us
 

00:01:04.050 --> 00:01:05.990 align:start position:0%
pivot table can do this for us
automatically<00:01:04.769><c> which</c><00:01:05.339><c> will</c><00:01:05.489><c> make</c><00:01:05.640><c> the</c><00:01:05.790><c> task</c>

00:01:05.990 --> 00:01:06.000 align:start position:0%
automatically which will make the task
 

00:01:06.000 --> 00:01:09.680 align:start position:0%
automatically which will make the task
much<00:01:06.330><c> much</c><00:01:06.570><c> easier</c><00:01:08.210><c> first</c><00:01:09.210><c> you</c><00:01:09.480><c> need</c><00:01:09.659><c> to</c>

00:01:09.680 --> 00:01:09.690 align:start position:0%
much much easier first you need to
 

00:01:09.690 --> 00:01:12.170 align:start position:0%
much much easier first you need to
select<00:01:09.900><c> your</c><00:01:10.170><c> data</c><00:01:10.440><c> you</c><00:01:11.400><c> can</c><00:01:11.550><c> just</c><00:01:11.760><c> click</c><00:01:11.970><c> any</c>

00:01:12.170 --> 00:01:12.180 align:start position:0%
select your data you can just click any
 

00:01:12.180 --> 00:01:13.930 align:start position:0%
select your data you can just click any
cell<00:01:12.300><c> if</c><00:01:12.750><c> it's</c><00:01:12.900><c> formatted</c><00:01:13.320><c> as</c><00:01:13.500><c> a</c><00:01:13.530><c> table</c>

00:01:13.930 --> 00:01:13.940 align:start position:0%
cell if it's formatted as a table
 

00:01:13.940 --> 00:01:16.220 align:start position:0%
cell if it's formatted as a table
otherwise<00:01:14.940><c> you</c><00:01:15.180><c> need</c><00:01:15.330><c> to</c><00:01:15.450><c> select</c><00:01:15.780><c> all</c><00:01:15.990><c> the</c>

00:01:16.220 --> 00:01:16.230 align:start position:0%
otherwise you need to select all the
 

00:01:16.230 --> 00:01:17.930 align:start position:0%
otherwise you need to select all the
cell's<00:01:16.470><c> yourself</c><00:01:16.950><c> and</c><00:01:17.160><c> don't</c><00:01:17.520><c> forget</c><00:01:17.790><c> your</c>

00:01:17.930 --> 00:01:17.940 align:start position:0%
cell's yourself and don't forget your
 

00:01:17.940 --> 00:01:20.990 align:start position:0%
cell's yourself and don't forget your
column<00:01:18.240><c> headers</c><00:01:19.130><c> when</c><00:01:20.130><c> you're</c><00:01:20.310><c> ready</c><00:01:20.490><c> go</c><00:01:20.940><c> to</c>

00:01:20.990 --> 00:01:21.000 align:start position:0%
column headers when you're ready go to
 

00:01:21.000 --> 00:01:23.900 align:start position:0%
column headers when you're ready go to
the<00:01:21.210><c> insert</c><00:01:21.570><c> tab</c><00:01:21.630><c> then</c><00:01:22.580><c> click</c><00:01:23.580><c> the</c><00:01:23.760><c> pivot</c>

00:01:23.900 --> 00:01:23.910 align:start position:0%
the insert tab then click the pivot
 

00:01:23.910 --> 00:01:27.920 align:start position:0%
the insert tab then click the pivot
table<00:01:24.180><c> command</c><00:01:26.270><c> you'll</c><00:01:27.270><c> usually</c><00:01:27.480><c> want</c><00:01:27.690><c> to</c>

00:01:27.920 --> 00:01:27.930 align:start position:0%
table command you'll usually want to
 

00:01:27.930 --> 00:01:29.330 align:start position:0%
table command you'll usually want to
place<00:01:28.140><c> your</c><00:01:28.290><c> pivot</c><00:01:28.590><c> table</c><00:01:28.740><c> on</c><00:01:29.070><c> a</c><00:01:29.100><c> new</c>

00:01:29.330 --> 00:01:29.340 align:start position:0%
place your pivot table on a new
 

00:01:29.340 --> 00:01:31.280 align:start position:0%
place your pivot table on a new
worksheet<00:01:29.580><c> so</c><00:01:30.240><c> make</c><00:01:30.420><c> sure</c><00:01:30.570><c> this</c><00:01:30.720><c> option</c><00:01:31.170><c> is</c>

00:01:31.280 --> 00:01:31.290 align:start position:0%
worksheet so make sure this option is
 

00:01:31.290 --> 00:01:35.960 align:start position:0%
worksheet so make sure this option is
selected<00:01:32.060><c> then</c><00:01:33.060><c> click</c><00:01:33.390><c> OK</c><00:01:33.810><c> and</c><00:01:34.580><c> a</c><00:01:35.580><c> new</c><00:01:35.730><c> sheet</c>

00:01:35.960 --> 00:01:35.970 align:start position:0%
selected then click OK and a new sheet
 

00:01:35.970 --> 00:01:39.290 align:start position:0%
selected then click OK and a new sheet
will<00:01:36.000><c> appear</c><00:01:37.040><c> over</c><00:01:38.040><c> on</c><00:01:38.640><c> the</c><00:01:38.760><c> left</c><00:01:38.970><c> is</c><00:01:39.150><c> our</c>

00:01:39.290 --> 00:01:39.300 align:start position:0%
will appear over on the left is our
 

00:01:39.300 --> 00:01:41.270 align:start position:0%
will appear over on the left is our
blank<00:01:39.360><c> pivot</c><00:01:39.960><c> table</c><00:01:40.290><c> it's</c><00:01:40.650><c> OK</c><00:01:40.950><c> that</c><00:01:40.980><c> there's</c>

00:01:41.270 --> 00:01:41.280 align:start position:0%
blank pivot table it's OK that there's
 

00:01:41.280 --> 00:01:43.790 align:start position:0%
blank pivot table it's OK that there's
nothing<00:01:41.610><c> there</c><00:01:41.790><c> yet</c><00:01:42.020><c> to</c><00:01:43.020><c> the</c><00:01:43.140><c> right</c><00:01:43.320><c> is</c><00:01:43.500><c> a</c><00:01:43.530><c> list</c>

00:01:43.790 --> 00:01:43.800 align:start position:0%
nothing there yet to the right is a list
 

00:01:43.800 --> 00:01:45.530 align:start position:0%
nothing there yet to the right is a list
of<00:01:43.950><c> fields</c><00:01:44.250><c> that</c><00:01:44.640><c> have</c><00:01:44.760><c> actually</c><00:01:45.150><c> been</c><00:01:45.180><c> pulled</c>

00:01:45.530 --> 00:01:45.540 align:start position:0%
of fields that have actually been pulled
 

00:01:45.540 --> 00:01:48.290 align:start position:0%
of fields that have actually been pulled
from<00:01:45.720><c> our</c><00:01:45.870><c> column</c><00:01:46.200><c> headers</c><00:01:46.820><c> this</c><00:01:47.820><c> is</c><00:01:47.970><c> where</c><00:01:48.180><c> we</c>

00:01:48.290 --> 00:01:48.300 align:start position:0%
from our column headers this is where we
 

00:01:48.300 --> 00:01:50.420 align:start position:0%
from our column headers this is where we
control<00:01:48.600><c> what</c><00:01:48.930><c> is</c><00:01:49.140><c> or</c><00:01:49.440><c> isn't</c><00:01:49.650><c> displayed</c><00:01:50.040><c> in</c>

00:01:50.420 --> 00:01:50.430 align:start position:0%
control what is or isn't displayed in
 

00:01:50.430 --> 00:01:52.730 align:start position:0%
control what is or isn't displayed in
the<00:01:50.550><c> pivot</c><00:01:50.850><c> table</c><00:01:51.080><c> but</c><00:01:52.080><c> before</c><00:01:52.440><c> we</c><00:01:52.560><c> continue</c>

00:01:52.730 --> 00:01:52.740 align:start position:0%
the pivot table but before we continue
 

00:01:52.740 --> 00:01:55.660 align:start position:0%
the pivot table but before we continue
let's<00:01:53.550><c> take</c><00:01:53.760><c> another</c><00:01:54.090><c> look</c><00:01:54.360><c> at</c><00:01:54.510><c> that</c><00:01:54.660><c> question</c>

00:01:55.660 --> 00:01:55.670 align:start position:0%
let's take another look at that question
 

00:01:55.670 --> 00:01:58.160 align:start position:0%
let's take another look at that question
what<00:01:56.670><c> is</c><00:01:56.790><c> the</c><00:01:56.940><c> amount</c><00:01:57.330><c> sold</c><00:01:57.990><c> by</c><00:01:58.140><c> each</c>

00:01:58.160 --> 00:01:58.170 align:start position:0%
what is the amount sold by each
 

00:01:58.170 --> 00:02:01.890 align:start position:0%
what is the amount sold by each
salesperson

00:02:01.890 --> 00:02:01.900 align:start position:0%
 
 

00:02:01.900 --> 00:02:04.570 align:start position:0%
 
this<00:02:02.900><c> question</c><00:02:03.410><c> tells</c><00:02:03.650><c> us</c><00:02:03.830><c> exactly</c><00:02:04.340><c> which</c>

00:02:04.570 --> 00:02:04.580 align:start position:0%
this question tells us exactly which
 

00:02:04.580 --> 00:02:07.140 align:start position:0%
this question tells us exactly which
fields<00:02:04.970><c> to</c><00:02:05.120><c> use</c><00:02:05.390><c> to</c><00:02:05.690><c> find</c><00:02:05.930><c> out</c><00:02:06.080><c> the</c><00:02:06.260><c> answer</c>

00:02:07.140 --> 00:02:07.150 align:start position:0%
fields to use to find out the answer
 

00:02:07.150 --> 00:02:11.620 align:start position:0%
fields to use to find out the answer
salesperson<00:02:08.150><c> and</c><00:02:08.300><c> order</c><00:02:09.020><c> amount</c><00:02:10.060><c> all</c><00:02:11.060><c> you</c>

00:02:11.620 --> 00:02:11.630 align:start position:0%
salesperson and order amount all you
 

00:02:11.630 --> 00:02:13.540 align:start position:0%
salesperson and order amount all you
have<00:02:11.810><c> to</c><00:02:11.960><c> do</c><00:02:12.140><c> is</c><00:02:12.350><c> check</c><00:02:12.590><c> the</c><00:02:12.770><c> box</c><00:02:12.980><c> next</c><00:02:13.100><c> to</c><00:02:13.400><c> the</c>

00:02:13.540 --> 00:02:13.550 align:start position:0%
have to do is check the box next to the
 

00:02:13.550 --> 00:02:15.940 align:start position:0%
have to do is check the box next to the
field<00:02:13.790><c> and</c><00:02:14.080><c> it'll</c><00:02:15.080><c> be</c><00:02:15.170><c> added</c><00:02:15.500><c> to</c><00:02:15.620><c> one</c><00:02:15.740><c> of</c><00:02:15.860><c> the</c>

00:02:15.940 --> 00:02:15.950 align:start position:0%
field and it'll be added to one of the
 

00:02:15.950 --> 00:02:18.070 align:start position:0%
field and it'll be added to one of the
areas<00:02:16.280><c> below</c><00:02:16.490><c> in</c><00:02:16.850><c> this</c><00:02:17.420><c> case</c><00:02:17.480><c> the</c><00:02:17.900><c> rows</c>

00:02:18.070 --> 00:02:18.080 align:start position:0%
areas below in this case the rows
 

00:02:18.080 --> 00:02:21.460 align:start position:0%
areas below in this case the rows
category<00:02:19.450><c> another</c><00:02:20.450><c> method</c><00:02:20.690><c> is</c><00:02:20.990><c> to</c><00:02:21.050><c> drag</c><00:02:21.440><c> and</c>

00:02:21.460 --> 00:02:21.470 align:start position:0%
category another method is to drag and
 

00:02:21.470 --> 00:02:23.770 align:start position:0%
category another method is to drag and
drop<00:02:21.830><c> the</c><00:02:21.980><c> field</c><00:02:22.130><c> into</c><00:02:22.460><c> place</c><00:02:22.670><c> we'll</c><00:02:23.480><c> put</c><00:02:23.630><c> this</c>

00:02:23.770 --> 00:02:23.780 align:start position:0%
drop the field into place we'll put this
 

00:02:23.780 --> 00:02:28.990 align:start position:0%
drop the field into place we'll put this
one<00:02:24.020><c> under</c><00:02:24.260><c> values</c><00:02:25.720><c> if</c><00:02:27.310><c> we</c><00:02:28.310><c> go</c><00:02:28.460><c> back</c><00:02:28.670><c> to</c>

00:02:28.990 --> 00:02:29.000 align:start position:0%
one under values if we go back to
 

00:02:29.000 --> 00:02:31.150 align:start position:0%
one under values if we go back to
PivotTable<00:02:29.600><c> now</c><00:02:30.530><c> we</c><00:02:30.590><c> can</c><00:02:30.830><c> see</c><00:02:31.010><c> the</c>

00:02:31.150 --> 00:02:31.160 align:start position:0%
PivotTable now we can see the
 

00:02:31.160 --> 00:02:33.250 align:start position:0%
PivotTable now we can see the
information<00:02:31.700><c> we</c><00:02:31.820><c> were</c><00:02:31.970><c> looking</c><00:02:32.000><c> for</c><00:02:32.480><c> in</c><00:02:32.720><c> other</c>

00:02:33.250 --> 00:02:33.260 align:start position:0%
information we were looking for in other
 

00:02:33.260 --> 00:02:34.660 align:start position:0%
information we were looking for in other
words<00:02:33.560><c> the</c><00:02:33.830><c> amount</c><00:02:33.920><c> sold</c><00:02:34.370><c> by</c><00:02:34.520><c> each</c>

00:02:34.660 --> 00:02:34.670 align:start position:0%
words the amount sold by each
 

00:02:34.670 --> 00:02:37.330 align:start position:0%
words the amount sold by each
salesperson<00:02:35.530><c> so</c><00:02:36.530><c> our</c><00:02:36.680><c> question</c><00:02:37.040><c> has</c><00:02:37.190><c> been</c>

00:02:37.330 --> 00:02:37.340 align:start position:0%
salesperson so our question has been
 

00:02:37.340 --> 00:02:39.370 align:start position:0%
salesperson so our question has been
answered<00:02:37.520><c> just</c><00:02:38.150><c> by</c><00:02:38.210><c> choosing</c><00:02:38.570><c> what</c><00:02:38.870><c> fields</c><00:02:39.230><c> to</c>

00:02:39.370 --> 00:02:39.380 align:start position:0%
answered just by choosing what fields to
 

00:02:39.380 --> 00:02:42.340 align:start position:0%
answered just by choosing what fields to
include<00:02:40.510><c> one</c><00:02:41.510><c> of</c><00:02:41.660><c> the</c><00:02:41.750><c> best</c><00:02:41.960><c> things</c><00:02:42.230><c> about</c>

00:02:42.340 --> 00:02:42.350 align:start position:0%
include one of the best things about
 

00:02:42.350 --> 00:02:44.290 align:start position:0%
include one of the best things about
pivot<00:02:42.710><c> tables</c><00:02:42.860><c> is</c><00:02:43.370><c> how</c><00:02:43.610><c> easy</c><00:02:43.880><c> they</c><00:02:44.120><c> are</c><00:02:44.150><c> to</c>

00:02:44.290 --> 00:02:44.300 align:start position:0%
pivot tables is how easy they are to
 

00:02:44.300 --> 00:02:46.210 align:start position:0%
pivot tables is how easy they are to
modify<00:02:44.840><c> so</c><00:02:45.290><c> you</c><00:02:45.350><c> can</c><00:02:45.620><c> view</c><00:02:45.830><c> and</c><00:02:46.010><c> analyze</c>

00:02:46.210 --> 00:02:46.220 align:start position:0%
modify so you can view and analyze
 

00:02:46.220 --> 00:02:48.970 align:start position:0%
modify so you can view and analyze
different<00:02:46.910><c> things</c><00:02:47.560><c> let's</c><00:02:48.560><c> say</c><00:02:48.740><c> for</c><00:02:48.950><c> example</c>

00:02:48.970 --> 00:02:48.980 align:start position:0%
different things let's say for example
 

00:02:48.980 --> 00:02:50.830 align:start position:0%
different things let's say for example
that<00:02:49.520><c> you</c><00:02:49.610><c> wanted</c><00:02:49.880><c> to</c><00:02:50.030><c> know</c><00:02:50.060><c> each</c><00:02:50.360><c> person's</c>

00:02:50.830 --> 00:02:50.840 align:start position:0%
that you wanted to know each person's
 

00:02:50.840 --> 00:02:53.370 align:start position:0%
that you wanted to know each person's
monthly<00:02:51.290><c> sales</c><00:02:51.530><c> not</c><00:02:51.980><c> just</c><00:02:52.220><c> their</c><00:02:52.370><c> total</c><00:02:52.700><c> sales</c>

00:02:53.370 --> 00:02:53.380 align:start position:0%
monthly sales not just their total sales
 

00:02:53.380 --> 00:02:57.490 align:start position:0%
monthly sales not just their total sales
just<00:02:54.380><c> drag</c><00:02:54.680><c> the</c><00:02:54.890><c> month</c><00:02:55.130><c> field</c><00:02:55.959><c> down</c><00:02:56.959><c> here</c><00:02:56.990><c> to</c>

00:02:57.490 --> 00:02:57.500 align:start position:0%
just drag the month field down here to
 

00:02:57.500 --> 00:03:00.490 align:start position:0%
just drag the month field down here to
columns<00:02:57.950><c> and</c><00:02:58.540><c> this</c><00:02:59.540><c> will</c><00:02:59.750><c> add</c><00:02:59.959><c> a</c><00:02:59.990><c> column</c><00:03:00.320><c> for</c>

00:03:00.490 --> 00:03:00.500 align:start position:0%
columns and this will add a column for
 

00:03:00.500 --> 00:03:04.030 align:start position:0%
columns and this will add a column for
each<00:03:00.800><c> month</c><00:03:01.100><c> in</c><00:03:01.310><c> the</c><00:03:01.370><c> worksheet</c><00:03:01.790><c> if</c><00:03:02.739><c> we</c><00:03:03.739><c> wanted</c>

00:03:04.030 --> 00:03:04.040 align:start position:0%
each month in the worksheet if we wanted
 

00:03:04.040 --> 00:03:06.010 align:start position:0%
each month in the worksheet if we wanted
to<00:03:04.160><c> know</c><00:03:04.280><c> what</c><00:03:04.459><c> each</c><00:03:04.640><c> region</c><00:03:05.120><c> sold</c><00:03:05.420><c> we</c><00:03:05.840><c> could</c>

00:03:06.010 --> 00:03:06.020 align:start position:0%
to know what each region sold we could
 

00:03:06.020 --> 00:03:09.220 align:start position:0%
to know what each region sold we could
take<00:03:06.230><c> out</c><00:03:06.380><c> the</c><00:03:06.530><c> month</c><00:03:06.770><c> in</c><00:03:06.950><c> salesperson</c><00:03:07.640><c> fields</c>

00:03:09.220 --> 00:03:09.230 align:start position:0%
take out the month in salesperson fields
 

00:03:09.230 --> 00:03:17.199 align:start position:0%
take out the month in salesperson fields
and<00:03:10.420><c> then</c><00:03:11.420><c> drag</c><00:03:11.720><c> region</c><00:03:13.090><c> down</c><00:03:14.090><c> to</c><00:03:14.450><c> rows</c><00:03:16.209><c> so</c>

00:03:17.199 --> 00:03:17.209 align:start position:0%
and then drag region down to rows so
 

00:03:17.209 --> 00:03:19.390 align:start position:0%
and then drag region down to rows so
each<00:03:17.420><c> time</c><00:03:17.690><c> we</c><00:03:17.870><c> change</c><00:03:18.170><c> the</c><00:03:18.230><c> fields</c><00:03:18.560><c> the</c><00:03:19.069><c> pivot</c>

00:03:19.390 --> 00:03:19.400 align:start position:0%
each time we change the fields the pivot
 

00:03:19.400 --> 00:03:21.160 align:start position:0%
each time we change the fields the pivot
table<00:03:19.700><c> is</c><00:03:19.819><c> just</c><00:03:20.090><c> combining</c><00:03:20.480><c> the</c><00:03:20.690><c> source</c><00:03:20.930><c> data</c>

00:03:21.160 --> 00:03:21.170 align:start position:0%
table is just combining the source data
 

00:03:21.170 --> 00:03:23.050 align:start position:0%
table is just combining the source data
in<00:03:21.379><c> a</c><00:03:21.440><c> different</c><00:03:21.800><c> way</c><00:03:21.920><c> so</c><00:03:22.459><c> we</c><00:03:22.580><c> can</c><00:03:22.700><c> view</c><00:03:22.910><c> the</c>

00:03:23.050 --> 00:03:23.060 align:start position:0%
in a different way so we can view the
 

00:03:23.060 --> 00:03:25.420 align:start position:0%
in a different way so we can view the
information<00:03:23.150><c> we</c><00:03:23.720><c> need</c><00:03:23.959><c> and</c><00:03:24.200><c> we're</c><00:03:24.950><c> doing</c><00:03:25.040><c> all</c>

00:03:25.420 --> 00:03:25.430 align:start position:0%
information we need and we're doing all
 

00:03:25.430 --> 00:03:27.160 align:start position:0%
information we need and we're doing all
this<00:03:25.700><c> without</c><00:03:26.120><c> adding</c><00:03:26.360><c> or</c><00:03:26.690><c> changing</c><00:03:26.720><c> anything</c>

00:03:27.160 --> 00:03:27.170 align:start position:0%
this without adding or changing anything
 

00:03:27.170 --> 00:03:30.400 align:start position:0%
this without adding or changing anything
in<00:03:27.620><c> the</c><00:03:27.739><c> original</c><00:03:28.160><c> worksheet</c><00:03:29.110><c> you</c><00:03:30.110><c> can</c><00:03:30.260><c> even</c>

00:03:30.400 --> 00:03:30.410 align:start position:0%
in the original worksheet you can even
 

00:03:30.410 --> 00:03:32.320 align:start position:0%
in the original worksheet you can even
experiment<00:03:31.130><c> by</c><00:03:31.370><c> dragging</c><00:03:31.790><c> the</c><00:03:31.880><c> fields</c><00:03:32.209><c> into</c>

00:03:32.320 --> 00:03:32.330 align:start position:0%
experiment by dragging the fields into
 

00:03:32.330 --> 00:03:34.660 align:start position:0%
experiment by dragging the fields into
different<00:03:32.720><c> areas</c><00:03:33.080><c> but</c><00:03:33.680><c> some</c><00:03:34.010><c> combinations</c>

00:03:34.660 --> 00:03:34.670 align:start position:0%
different areas but some combinations
 

00:03:34.670 --> 00:03:37.210 align:start position:0%
different areas but some combinations
work<00:03:34.880><c> better</c><00:03:35.060><c> than</c><00:03:35.269><c> others</c><00:03:35.540><c> for</c><00:03:35.980><c> instance</c><00:03:36.980><c> if</c>

00:03:37.210 --> 00:03:37.220 align:start position:0%
work better than others for instance if
 

00:03:37.220 --> 00:03:39.610 align:start position:0%
work better than others for instance if
I<00:03:37.370><c> move</c><00:03:37.580><c> order</c><00:03:38.000><c> amount</c><00:03:38.209><c> over</c><00:03:38.540><c> to</c><00:03:38.930><c> columns</c><00:03:39.379><c> or</c>

00:03:39.610 --> 00:03:39.620 align:start position:0%
I move order amount over to columns or
 

00:03:39.620 --> 00:03:42.250 align:start position:0%
I move order amount over to columns or
rows<00:03:40.000><c> you</c><00:03:41.000><c> can</c><00:03:41.030><c> see</c><00:03:41.420><c> that</c><00:03:41.599><c> it</c><00:03:41.690><c> doesn't</c><00:03:41.930><c> really</c>

00:03:42.250 --> 00:03:42.260 align:start position:0%
rows you can see that it doesn't really
 

00:03:42.260 --> 00:03:45.370 align:start position:0%
rows you can see that it doesn't really
give<00:03:42.500><c> us</c><00:03:42.530><c> any</c><00:03:42.769><c> useful</c><00:03:43.280><c> data</c><00:03:44.019><c> since</c><00:03:45.019><c> order</c>

00:03:45.370 --> 00:03:45.380 align:start position:0%
give us any useful data since order
 

00:03:45.380 --> 00:03:47.380 align:start position:0%
give us any useful data since order
amount<00:03:45.620><c> contains</c><00:03:46.160><c> numerical</c><00:03:46.760><c> values</c><00:03:47.120><c> it</c>

00:03:47.380 --> 00:03:47.390 align:start position:0%
amount contains numerical values it
 

00:03:47.390 --> 00:03:51.930 align:start position:0%
amount contains numerical values it
really<00:03:47.840><c> does</c><00:03:48.049><c> work</c><00:03:48.230><c> best</c><00:03:48.470><c> in</c><00:03:48.739><c> the</c><00:03:48.769><c> values</c><00:03:48.860><c> area</c>

00:03:51.930 --> 00:03:51.940 align:start position:0%
 
 

00:03:51.940 --> 00:03:54.460 align:start position:0%
 
finally<00:03:52.940><c> if</c><00:03:53.120><c> we</c><00:03:53.480><c> click</c><00:03:53.720><c> the</c><00:03:53.870><c> arrow</c><00:03:54.049><c> next</c><00:03:54.170><c> to</c>

00:03:54.460 --> 00:03:54.470 align:start position:0%
finally if we click the arrow next to
 

00:03:54.470 --> 00:03:57.370 align:start position:0%
finally if we click the arrow next to
order<00:03:54.769><c> amount</c><00:03:55.099><c> and</c><00:03:55.390><c> go</c><00:03:56.390><c> to</c><00:03:56.450><c> value</c><00:03:57.140><c> field</c>

00:03:57.370 --> 00:03:57.380 align:start position:0%
order amount and go to value field
 

00:03:57.380 --> 00:04:00.400 align:start position:0%
order amount and go to value field
settings<00:03:58.120><c> we</c><00:03:59.120><c> can</c><00:03:59.150><c> change</c><00:03:59.329><c> the</c><00:03:59.780><c> function</c><00:03:59.959><c> to</c>

00:04:00.400 --> 00:04:00.410 align:start position:0%
settings we can change the function to
 

00:04:00.410 --> 00:04:03.280 align:start position:0%
settings we can change the function to
something<00:04:00.829><c> other</c><00:04:00.980><c> than</c><00:04:01.130><c> sum</c><00:04:02.019><c> instead</c><00:04:03.019><c> we</c>

00:04:03.280 --> 00:04:03.290 align:start position:0%
something other than sum instead we
 

00:04:03.290 --> 00:04:04.710 align:start position:0%
something other than sum instead we
could<00:04:03.440><c> count</c><00:04:03.650><c> the</c><00:04:03.860><c> number</c><00:04:03.890><c> of</c><00:04:04.280><c> cells</c>

00:04:04.710 --> 00:04:04.720 align:start position:0%
could count the number of cells
 

00:04:04.720 --> 00:04:07.660 align:start position:0%
could count the number of cells
calculate<00:04:05.720><c> the</c><00:04:05.840><c> average</c><00:04:06.290><c> or</c><00:04:06.890><c> use</c><00:04:07.130><c> any</c><00:04:07.400><c> of</c><00:04:07.579><c> the</c>

00:04:07.660 --> 00:04:07.670 align:start position:0%
calculate the average or use any of the
 

00:04:07.670 --> 00:04:10.180 align:start position:0%
calculate the average or use any of the
other<00:04:07.819><c> options</c><00:04:08.090><c> here</c><00:04:08.950><c> some</c><00:04:09.950><c> of</c><00:04:09.980><c> these</c>

00:04:10.180 --> 00:04:10.190 align:start position:0%
other options here some of these
 

00:04:10.190 --> 00:04:11.710 align:start position:0%
other options here some of these
functions<00:04:10.670><c> will</c><00:04:10.819><c> be</c><00:04:10.940><c> more</c><00:04:11.150><c> useful</c><00:04:11.360><c> than</c>

00:04:11.710 --> 00:04:11.720 align:start position:0%
functions will be more useful than
 

00:04:11.720 --> 00:04:13.690 align:start position:0%
functions will be more useful than
others<00:04:11.810><c> depending</c><00:04:12.170><c> on</c><00:04:12.620><c> your</c><00:04:12.739><c> data</c><00:04:12.920><c> so</c><00:04:13.519><c> that's</c>

00:04:13.690 --> 00:04:13.700 align:start position:0%
others depending on your data so that's
 

00:04:13.700 --> 00:04:18.699 align:start position:0%
others depending on your data so that's
just<00:04:13.910><c> something</c><00:04:14.150><c> to</c><00:04:14.329><c> keep</c><00:04:14.420><c> in</c><00:04:14.660><c> mind</c><00:04:14.829><c> in</c><00:04:17.709><c> part</c>

00:04:18.699 --> 00:04:18.709 align:start position:0%
just something to keep in mind in part
 

00:04:18.709 --> 00:04:20.379 align:start position:0%
just something to keep in mind in part
two<00:04:18.889><c> of</c><00:04:18.919><c> this</c><00:04:19.100><c> video</c><00:04:19.400><c> we're</c><00:04:19.970><c> going</c><00:04:20.120><c> to</c><00:04:20.209><c> talk</c>

00:04:20.379 --> 00:04:20.389 align:start position:0%
two of this video we're going to talk
 

00:04:20.389 --> 00:04:23.020 align:start position:0%
two of this video we're going to talk
about<00:04:20.450><c> report</c><00:04:21.109><c> filters</c><00:04:21.470><c> we'll</c><00:04:22.430><c> also</c><00:04:22.639><c> take</c><00:04:22.970><c> a</c>

00:04:23.020 --> 00:04:23.030 align:start position:0%
about report filters we'll also take a
 

00:04:23.030 --> 00:04:25.270 align:start position:0%
about report filters we'll also take a
look<00:04:23.120><c> at</c><00:04:23.419><c> slicers</c><00:04:23.960><c> and</c><00:04:23.990><c> pivotcharts</c><00:04:24.280><c> which</c>

00:04:25.270 --> 00:04:25.280 align:start position:0%
look at slicers and pivotcharts which
 

00:04:25.280 --> 00:04:26.980 align:start position:0%
look at slicers and pivotcharts which
can<00:04:25.490><c> give</c><00:04:25.639><c> you</c><00:04:25.729><c> even</c><00:04:25.910><c> more</c><00:04:26.210><c> ways</c><00:04:26.450><c> to</c><00:04:26.479><c> work</c><00:04:26.840><c> with</c>

00:04:26.980 --> 00:04:26.990 align:start position:0%
can give you even more ways to work with
 

00:04:26.990 --> 00:04:30.320 align:start position:0%
can give you even more ways to work with
your<00:04:27.110><c> pivot</c><00:04:27.410><c> table</c>

00:04:30.320 --> 00:04:30.330 align:start position:0%
 
 

00:04:30.330 --> 00:04:32.389 align:start position:0%
 
you