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.740 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:08.599><c> one</c><00:00:09.599><c> of</c>

00:00:09.740 --> 00:00:09.750 align:start position:0%
opportunities for a better life one of
 

00:00:09.750 --> 00:00:11.600 align:start position:0%
opportunities for a better life one of
the<00:00:09.870><c> best</c><00:00:10.049><c> things</c><00:00:10.290><c> about</c><00:00:10.410><c> Excel</c><00:00:10.950><c> is</c><00:00:11.160><c> the</c><00:00:11.219><c> fact</c>

00:00:11.600 --> 00:00:11.610 align:start position:0%
the best things about Excel is the fact
 

00:00:11.610 --> 00:00:13.610 align:start position:0%
the best things about Excel is the fact
that<00:00:11.730><c> a</c><00:00:11.910><c> single</c><00:00:12.269><c> worksheet</c><00:00:12.660><c> can</c><00:00:12.839><c> hold</c><00:00:13.080><c> so</c><00:00:13.410><c> much</c>

00:00:13.610 --> 00:00:13.620 align:start position:0%
that a single worksheet can hold so much
 

00:00:13.620 --> 00:00:15.980 align:start position:0%
that a single worksheet can hold so much
information<00:00:14.309><c> in</c><00:00:14.490><c> fact</c><00:00:15.240><c> you</c><00:00:15.629><c> could</c><00:00:15.809><c> fill</c>

00:00:15.980 --> 00:00:15.990 align:start position:0%
information in fact you could fill
 

00:00:15.990 --> 00:00:17.689 align:start position:0%
information in fact you could fill
billions<00:00:16.439><c> of</c><00:00:16.590><c> cells</c><00:00:16.890><c> if</c><00:00:17.160><c> you</c><00:00:17.279><c> needed</c><00:00:17.490><c> that</c>

00:00:17.689 --> 00:00:17.699 align:start position:0%
billions of cells if you needed that
 

00:00:17.699 --> 00:00:20.330 align:start position:0%
billions of cells if you needed that
much<00:00:17.850><c> room</c><00:00:18.119><c> a</c><00:00:18.439><c> file</c><00:00:19.439><c> with</c><00:00:19.680><c> that</c><00:00:19.830><c> much</c><00:00:20.039><c> data</c>

00:00:20.330 --> 00:00:20.340 align:start position:0%
much room a file with that much data
 

00:00:20.340 --> 00:00:22.099 align:start position:0%
much room a file with that much data
could<00:00:20.730><c> get</c><00:00:20.910><c> pretty</c><00:00:21.090><c> overwhelming</c><00:00:21.750><c> but</c>

00:00:22.099 --> 00:00:22.109 align:start position:0%
could get pretty overwhelming but
 

00:00:22.109 --> 00:00:23.630 align:start position:0%
could get pretty overwhelming but
there's<00:00:22.289><c> a</c><00:00:22.350><c> feature</c><00:00:22.590><c> called</c><00:00:22.890><c> pivot</c><00:00:23.189><c> tables</c>

00:00:23.630 --> 00:00:23.640 align:start position:0%
there's a feature called pivot tables
 

00:00:23.640 --> 00:00:26.210 align:start position:0%
there's a feature called pivot tables
that<00:00:23.849><c> can</c><00:00:23.970><c> help</c><00:00:24.470><c> pivot</c><00:00:25.470><c> tables</c><00:00:25.830><c> let</c><00:00:26.099><c> you</c>

00:00:26.210 --> 00:00:26.220 align:start position:0%
that can help pivot tables let you
 

00:00:26.220 --> 00:00:27.740 align:start position:0%
that can help pivot tables let you
summarize<00:00:26.699><c> and</c><00:00:27.000><c> manipulate</c><00:00:27.480><c> your</c><00:00:27.599><c> data</c>

00:00:27.740 --> 00:00:27.750 align:start position:0%
summarize and manipulate your data
 

00:00:27.750 --> 00:00:29.779 align:start position:0%
summarize and manipulate your data
without<00:00:28.320><c> actually</c><00:00:28.500><c> changing</c><00:00:29.099><c> anything</c><00:00:29.490><c> in</c>

00:00:29.779 --> 00:00:29.789 align:start position:0%
without actually changing anything in
 

00:00:29.789 --> 00:00:31.939 align:start position:0%
without actually changing anything in
the<00:00:29.910><c> worksheet</c><00:00:30.330><c> let's</c><00:00:30.570><c> take</c><00:00:31.500><c> a</c><00:00:31.529><c> look</c><00:00:31.740><c> at</c><00:00:31.830><c> how</c>

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

00:00:31.949 --> 00:00:35.120 align:start position:0%
the worksheet let's take a look at how
they<00:00:32.099><c> work</c><00:00:32.310><c> in</c><00:00:32.990><c> this</c><00:00:33.990><c> example</c><00:00:34.380><c> I</c><00:00:34.650><c> have</c><00:00:34.980><c> some</c>

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

00:00:35.130 --> 00:00:37.310 align:start position:0%
they work in this example I have some
company<00:00:35.190><c> sales</c><00:00:35.790><c> data</c><00:00:36.060><c> with</c><00:00:36.720><c> columns</c><00:00:37.110><c> for</c><00:00:37.290><c> the</c>

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

00:00:37.320 --> 00:00:42.080 align:start position:0%
company sales data with columns for the
salesperson<00:00:38.360><c> region</c><00:00:39.560><c> account</c><00:00:40.850><c> order</c><00:00:41.850><c> amount</c>

00:00:42.080 --> 00:00:42.090 align:start position:0%
salesperson region account order amount
 

00:00:42.090 --> 00:00:45.650 align:start position:0%
salesperson region account order amount
and<00:00:42.390><c> month</c><00:00:43.350><c> and</c><00:00:43.730><c> I</c><00:00:44.730><c> need</c><00:00:44.910><c> to</c><00:00:45.000><c> find</c><00:00:45.240><c> the</c><00:00:45.330><c> answer</c>

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

00:00:45.660 --> 00:00:48.500 align:start position:0%
and month and I need to find the answer
to<00:00:45.840><c> a</c><00:00:45.870><c> very</c><00:00:45.960><c> specific</c><00:00:46.470><c> question</c><00:00:47.240><c> what</c><00:00:48.240><c> is</c><00:00:48.360><c> the</c>

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

00:00:48.510 --> 00:00:54.230 align:start position:0%
to a very specific question what is the
amount<00:00:48.780><c> sold</c><00:00:49.200><c> by</c><00:00:49.410><c> each</c><00:00:49.620><c> salesperson</c><00:00:53.240><c> because</c>

00:00:54.230 --> 00:00:54.240 align:start position:0%
amount sold by each salesperson because
 

00:00:54.240 --> 00:00:56.180 align:start position:0%
amount sold by each salesperson because
each<00:00:54.420><c> salesperson</c><00:00:54.840><c> has</c><00:00:55.320><c> data</c><00:00:55.560><c> on</c><00:00:55.680><c> more</c><00:00:56.070><c> than</c>

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

00:00:56.190 --> 00:00:58.130 align:start position:0%
each salesperson has data on more than
one<00:00:56.400><c> row</c><00:00:56.640><c> I'd</c><00:00:56.880><c> normally</c><00:00:57.210><c> have</c><00:00:57.600><c> to</c><00:00:57.750><c> add</c><00:00:57.900><c> these</c>

00:00:58.130 --> 00:00:58.140 align:start position:0%
one row I'd normally have to add these
 

00:00:58.140 --> 00:01:00.590 align:start position:0%
one row I'd normally have to add these
up<00:00:58.200><c> in</c><00:00:58.620><c> order</c><00:00:58.800><c> to</c><00:00:58.980><c> find</c><00:00:59.220><c> the</c><00:00:59.310><c> answer</c><00:00:59.540><c> but</c><00:01:00.540><c> a</c>

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

00:01:00.600 --> 00:01:02.030 align:start position:0%
up in order to find the answer but a
pivot<00:01:00.960><c> table</c><00:01:01.110><c> can</c><00:01:01.440><c> do</c><00:01:01.590><c> this</c><00:01:01.770><c> for</c><00:01:02.010><c> us</c>

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

00:01:02.040 --> 00:01:03.980 align:start position:0%
pivot table can do this for us
automatically<00:01:02.880><c> which</c><00:01:03.330><c> will</c><00:01:03.510><c> make</c><00:01:03.630><c> the</c><00:01:03.780><c> task</c>

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

00:01:03.990 --> 00:01:07.760 align:start position:0%
automatically which will make the task
much<00:01:04.320><c> much</c><00:01:04.590><c> easier</c><00:01:06.230><c> first</c><00:01:07.230><c> you</c><00:01:07.500><c> need</c><00:01:07.680><c> to</c>

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

00:01:07.770 --> 00:01:10.190 align:start position:0%
much much easier first you need to
select<00:01:07.950><c> your</c><00:01:08.160><c> data</c><00:01:08.460><c> you</c><00:01:09.390><c> can</c><00:01:09.420><c> just</c><00:01:09.600><c> click</c><00:01:09.990><c> any</c>

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

00:01:10.200 --> 00:01:11.830 align:start position:0%
select your data you can just click any
cell<00:01:10.290><c> if</c><00:01:10.740><c> it's</c><00:01:10.890><c> formatted</c><00:01:11.310><c> as</c><00:01:11.490><c> a</c><00:01:11.520><c> table</c>

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

00:01:11.840 --> 00:01:14.210 align:start position:0%
cell if it's formatted as a table
otherwise<00:01:12.840><c> you</c><00:01:13.170><c> need</c><00:01:13.350><c> to</c><00:01:13.440><c> select</c><00:01:13.620><c> all</c><00:01:13.980><c> the</c>

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

00:01:14.220 --> 00:01:15.920 align:start position:0%
otherwise you need to select all the
cell's<00:01:14.460><c> yourself</c><00:01:14.940><c> and</c><00:01:15.180><c> don't</c><00:01:15.450><c> forget</c><00:01:15.780><c> your</c>

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

00:01:15.930 --> 00:01:18.950 align:start position:0%
cell's yourself and don't forget your
column<00:01:16.230><c> headers</c><00:01:17.120><c> when</c><00:01:18.120><c> you're</c><00:01:18.300><c> ready</c><00:01:18.480><c> go</c><00:01:18.930><c> to</c>

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

00:01:18.960 --> 00:01:22.010 align:start position:0%
column headers when you're ready go to
the<00:01:19.200><c> insert</c><00:01:19.590><c> tab</c><00:01:20.270><c> then</c><00:01:21.270><c> click</c><00:01:21.570><c> the</c><00:01:21.600><c> pivot</c>

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

00:01:22.020 --> 00:01:25.910 align:start position:0%
the insert tab then click the pivot
table<00:01:22.170><c> command</c><00:01:24.260><c> you'll</c><00:01:25.260><c> usually</c><00:01:25.470><c> want</c><00:01:25.680><c> to</c>

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

00:01:25.920 --> 00:01:27.320 align:start position:0%
table command you'll usually want to
place<00:01:26.100><c> your</c><00:01:26.280><c> pivot</c><00:01:26.580><c> table</c><00:01:26.700><c> on</c><00:01:27.030><c> a</c><00:01:27.060><c> new</c>

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

00:01:27.330 --> 00:01:29.270 align:start position:0%
place your pivot table on a new
worksheet<00:01:27.540><c> so</c><00:01:28.230><c> make</c><00:01:28.410><c> sure</c><00:01:28.440><c> this</c><00:01:28.680><c> option</c><00:01:29.159><c> is</c>

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

00:01:29.280 --> 00:01:33.920 align:start position:0%
worksheet so make sure this option is
selected<00:01:30.050><c> then</c><00:01:31.050><c> click</c><00:01:31.380><c> OK</c><00:01:31.740><c> and</c><00:01:32.570><c> a</c><00:01:33.570><c> new</c><00:01:33.720><c> sheet</c>

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

00:01:33.930 --> 00:01:37.250 align:start position:0%
selected then click OK and a new sheet
will<00:01:34.080><c> appear</c><00:01:35.150><c> over</c><00:01:36.150><c> on</c><00:01:36.630><c> the</c><00:01:36.750><c> left</c><00:01:36.930><c> is</c><00:01:37.140><c> our</c>

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

00:01:37.260 --> 00:01:39.260 align:start position:0%
will appear over on the left is our
blank<00:01:37.320><c> pivot</c><00:01:37.920><c> table</c><00:01:38.280><c> it's</c><00:01:38.640><c> OK</c><00:01:38.940><c> that</c><00:01:38.970><c> there's</c>

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

00:01:39.270 --> 00:01:41.720 align:start position:0%
blank pivot table it's OK that there's
nothing<00:01:39.570><c> there</c><00:01:39.780><c> yet</c><00:01:39.980><c> to</c><00:01:40.980><c> the</c><00:01:41.100><c> right</c><00:01:41.280><c> is</c><00:01:41.460><c> a</c><00:01:41.490><c> list</c>

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

00:01:41.730 --> 00:01:43.490 align:start position:0%
nothing there yet to the right is a list
of<00:01:41.909><c> fields</c><00:01:42.210><c> that</c><00:01:42.510><c> have</c><00:01:42.720><c> actually</c><00:01:43.110><c> been</c><00:01:43.140><c> pulled</c>

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

00:01:43.500 --> 00:01:46.250 align:start position:0%
of fields that have actually been pulled
from<00:01:43.680><c> our</c><00:01:43.830><c> column</c><00:01:44.159><c> headers</c><00:01:44.780><c> this</c><00:01:45.780><c> is</c><00:01:45.930><c> where</c><00:01:46.140><c> we</c>

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

00:01:46.260 --> 00:01:48.380 align:start position:0%
from our column headers this is where we
control<00:01:46.560><c> what</c><00:01:46.890><c> is</c><00:01:47.100><c> or</c><00:01:47.400><c> isn't</c><00:01:47.610><c> displayed</c><00:01:48.180><c> in</c>

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

00:01:48.390 --> 00:01:50.690 align:start position:0%
control what is or isn't displayed in
the<00:01:48.510><c> pivot</c><00:01:48.810><c> table</c><00:01:49.070><c> but</c><00:01:50.070><c> before</c><00:01:50.400><c> we</c><00:01:50.520><c> continue</c>

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

00:01:50.700 --> 00:01:53.200 align:start position:0%
the pivot table but before we continue
let's<00:01:51.510><c> take</c><00:01:51.720><c> another</c><00:01:52.050><c> look</c><00:01:52.320><c> at</c><00:01:52.470><c> that</c><00:01:52.590><c> question</c>

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

00:01:53.210 --> 00:01:55.730 align:start position:0%
let's take another look at that question
what<00:01:54.210><c> is</c><00:01:54.330><c> the</c><00:01:54.510><c> amount</c><00:01:54.870><c> sold</c><00:01:55.530><c> by</c><00:01:55.710><c> each</c>

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

00:01:55.740 --> 00:01:59.420 align:start position:0%
what is the amount sold by each
salesperson

00:01:59.420 --> 00:01:59.430 align:start position:0%
 
 

00:01:59.430 --> 00:02:02.130 align:start position:0%
 
this<00:02:00.430><c> question</c><00:02:00.940><c> tells</c><00:02:01.210><c> us</c><00:02:01.360><c> exactly</c><00:02:01.600><c> which</c>

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

00:02:02.140 --> 00:02:04.670 align:start position:0%
this question tells us exactly which
fields<00:02:02.530><c> to</c><00:02:02.680><c> use</c><00:02:02.950><c> to</c><00:02:03.220><c> find</c><00:02:03.490><c> out</c><00:02:03.640><c> the</c><00:02:03.790><c> answer</c>

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

00:02:04.680 --> 00:02:09.150 align:start position:0%
fields to use to find out the answer
salesperson<00:02:05.680><c> and</c><00:02:05.860><c> order</c><00:02:06.580><c> amount</c><00:02:07.770><c> all</c><00:02:08.770><c> you</c>

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

00:02:09.160 --> 00:02:11.070 align:start position:0%
salesperson and order amount all you
have<00:02:09.369><c> to</c><00:02:09.520><c> do</c><00:02:09.670><c> is</c><00:02:09.910><c> check</c><00:02:10.119><c> the</c><00:02:10.300><c> box</c><00:02:10.510><c> next</c><00:02:10.660><c> to</c><00:02:10.930><c> the</c>

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

00:02:11.080 --> 00:02:13.470 align:start position:0%
have to do is check the box next to the
field<00:02:11.320><c> and</c><00:02:11.560><c> it'll</c><00:02:12.550><c> be</c><00:02:12.730><c> added</c><00:02:13.030><c> to</c><00:02:13.150><c> one</c><00:02:13.270><c> of</c><00:02:13.390><c> the</c>

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

00:02:13.480 --> 00:02:15.600 align:start position:0%
field and it'll be added to one of the
areas<00:02:13.840><c> below</c><00:02:14.020><c> in</c><00:02:14.380><c> this</c><00:02:14.950><c> case</c><00:02:15.010><c> the</c><00:02:15.460><c> rows</c>

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

00:02:15.610 --> 00:02:16.970 align:start position:0%
areas below in this case the rows
category

00:02:16.970 --> 00:02:16.980 align:start position:0%
category
 

00:02:16.980 --> 00:02:19.500 align:start position:0%
category
another<00:02:17.980><c> method</c><00:02:18.220><c> is</c><00:02:18.520><c> to</c><00:02:18.580><c> drag</c><00:02:18.970><c> and</c><00:02:19.180><c> drop</c><00:02:19.360><c> the</c>

00:02:19.500 --> 00:02:19.510 align:start position:0%
another method is to drag and drop the
 

00:02:19.510 --> 00:02:21.360 align:start position:0%
another method is to drag and drop the
field<00:02:19.660><c> into</c><00:02:19.990><c> place</c><00:02:20.200><c> we'll</c><00:02:21.010><c> put</c><00:02:21.160><c> this</c><00:02:21.310><c> one</c>

00:02:21.360 --> 00:02:21.370 align:start position:0%
field into place we'll put this one
 

00:02:21.370 --> 00:02:26.790 align:start position:0%
field into place we'll put this one
under<00:02:21.790><c> values</c><00:02:22.860><c> if</c><00:02:24.840><c> we</c><00:02:25.840><c> go</c><00:02:25.990><c> back</c><00:02:26.200><c> to</c><00:02:26.380><c> the</c><00:02:26.500><c> pivot</c>

00:02:26.790 --> 00:02:26.800 align:start position:0%
under values if we go back to the pivot
 

00:02:26.800 --> 00:02:29.340 align:start position:0%
under values if we go back to the pivot
table<00:02:27.060><c> now</c><00:02:28.060><c> we</c><00:02:28.120><c> can</c><00:02:28.360><c> see</c><00:02:28.540><c> the</c><00:02:28.690><c> information</c><00:02:28.930><c> we</c>

00:02:29.340 --> 00:02:29.350 align:start position:0%
table now we can see the information we
 

00:02:29.350 --> 00:02:31.320 align:start position:0%
table now we can see the information we
were<00:02:29.500><c> looking</c><00:02:29.530><c> for</c><00:02:30.010><c> in</c><00:02:30.220><c> other</c><00:02:30.820><c> words</c><00:02:31.060><c> the</c>

00:02:31.320 --> 00:02:31.330 align:start position:0%
were looking for in other words the
 

00:02:31.330 --> 00:02:34.170 align:start position:0%
were looking for in other words the
amount<00:02:31.420><c> sold</c><00:02:31.870><c> by</c><00:02:32.020><c> each</c><00:02:32.050><c> salesperson</c><00:02:33.030><c> so</c><00:02:34.030><c> our</c>

00:02:34.170 --> 00:02:34.180 align:start position:0%
amount sold by each salesperson so our
 

00:02:34.180 --> 00:02:35.790 align:start position:0%
amount sold by each salesperson so our
question<00:02:34.420><c> has</c><00:02:34.720><c> been</c><00:02:34.840><c> answered</c><00:02:35.050><c> just</c><00:02:35.680><c> by</c>

00:02:35.790 --> 00:02:35.800 align:start position:0%
question has been answered just by
 

00:02:35.800 --> 00:02:39.060 align:start position:0%
question has been answered just by
choosing<00:02:36.010><c> what</c><00:02:36.400><c> fields</c><00:02:36.730><c> to</c><00:02:36.880><c> include</c><00:02:38.040><c> one</c><00:02:39.040><c> of</c>

00:02:39.060 --> 00:02:39.070 align:start position:0%
choosing what fields to include one of
 

00:02:39.070 --> 00:02:40.860 align:start position:0%
choosing what fields to include one of
the<00:02:39.280><c> best</c><00:02:39.460><c> things</c><00:02:39.730><c> about</c><00:02:39.880><c> pivot</c><00:02:40.240><c> tables</c><00:02:40.360><c> is</c>

00:02:40.860 --> 00:02:40.870 align:start position:0%
the best things about pivot tables is
 

00:02:40.870 --> 00:02:43.110 align:start position:0%
the best things about pivot tables is
how<00:02:41.140><c> easy</c><00:02:41.380><c> they</c><00:02:41.620><c> are</c><00:02:41.650><c> to</c><00:02:41.890><c> modify</c><00:02:42.340><c> so</c><00:02:42.790><c> you</c><00:02:42.850><c> can</c>

00:02:43.110 --> 00:02:43.120 align:start position:0%
how easy they are to modify so you can
 

00:02:43.120 --> 00:02:46.050 align:start position:0%
how easy they are to modify so you can
view<00:02:43.330><c> and</c><00:02:43.540><c> analyze</c><00:02:43.720><c> different</c><00:02:44.230><c> things</c><00:02:45.060><c> let's</c>

00:02:46.050 --> 00:02:46.060 align:start position:0%
view and analyze different things let's
 

00:02:46.060 --> 00:02:47.640 align:start position:0%
view and analyze different things let's
say<00:02:46.240><c> for</c><00:02:46.450><c> example</c><00:02:46.900><c> that</c><00:02:46.930><c> you</c><00:02:47.140><c> wanted</c><00:02:47.380><c> to</c><00:02:47.530><c> know</c>

00:02:47.640 --> 00:02:47.650 align:start position:0%
say for example that you wanted to know
 

00:02:47.650 --> 00:02:49.710 align:start position:0%
say for example that you wanted to know
each<00:02:47.860><c> person's</c><00:02:48.340><c> monthly</c><00:02:48.790><c> sales</c><00:02:49.030><c> not</c><00:02:49.480><c> just</c>

00:02:49.710 --> 00:02:49.720 align:start position:0%
each person's monthly sales not just
 

00:02:49.720 --> 00:02:52.620 align:start position:0%
each person's monthly sales not just
their<00:02:49.870><c> total</c><00:02:50.200><c> sales</c><00:02:50.880><c> just</c><00:02:51.880><c> drag</c><00:02:52.180><c> the</c><00:02:52.390><c> month</c>

00:02:52.620 --> 00:02:52.630 align:start position:0%
their total sales just drag the month
 

00:02:52.630 --> 00:02:57.240 align:start position:0%
their total sales just drag the month
field<00:02:53.459><c> down</c><00:02:54.459><c> here</c><00:02:54.490><c> to</c><00:02:55.000><c> columns</c><00:02:55.450><c> and</c><00:02:56.070><c> this</c><00:02:57.070><c> will</c>

00:02:57.240 --> 00:02:57.250 align:start position:0%
field down here to columns and this will
 

00:02:57.250 --> 00:02:58.860 align:start position:0%
field down here to columns and this will
add<00:02:57.430><c> a</c><00:02:57.459><c> column</c><00:02:57.820><c> for</c><00:02:58.180><c> each</c><00:02:58.300><c> month</c><00:02:58.600><c> in</c><00:02:58.780><c> the</c>

00:02:58.860 --> 00:02:58.870 align:start position:0%
add a column for each month in the
 

00:02:58.870 --> 00:03:02.100 align:start position:0%
add a column for each month in the
worksheet<00:02:59.230><c> if</c><00:03:00.209><c> we</c><00:03:01.209><c> wanted</c><00:03:01.480><c> to</c><00:03:01.540><c> know</c><00:03:01.660><c> what</c><00:03:01.959><c> each</c>

00:03:02.100 --> 00:03:02.110 align:start position:0%
worksheet if we wanted to know what each
 

00:03:02.110 --> 00:03:04.229 align:start position:0%
worksheet if we wanted to know what each
region<00:03:02.620><c> sold</c><00:03:02.890><c> we</c><00:03:03.340><c> could</c><00:03:03.520><c> take</c><00:03:03.700><c> out</c><00:03:03.850><c> the</c><00:03:04.000><c> month</c>

00:03:04.229 --> 00:03:04.239 align:start position:0%
region sold we could take out the month
 

00:03:04.239 --> 00:03:09.180 align:start position:0%
region sold we could take out the month
in<00:03:04.420><c> salesperson</c><00:03:05.110><c> fields</c><00:03:05.500><c> and</c><00:03:07.890><c> then</c><00:03:08.890><c> drag</c>

00:03:09.180 --> 00:03:09.190 align:start position:0%
in salesperson fields and then drag
 

00:03:09.190 --> 00:03:15.330 align:start position:0%
in salesperson fields and then drag
region<00:03:10.560><c> down</c><00:03:11.560><c> to</c><00:03:11.920><c> rows</c><00:03:13.680><c> so</c><00:03:14.680><c> each</c><00:03:14.890><c> time</c><00:03:15.160><c> we</c>

00:03:15.330 --> 00:03:15.340 align:start position:0%
region down to rows so each time we
 

00:03:15.340 --> 00:03:17.280 align:start position:0%
region down to rows so each time we
change<00:03:15.640><c> the</c><00:03:15.730><c> fields</c><00:03:15.880><c> the</c><00:03:16.540><c> pivot</c><00:03:16.870><c> table</c><00:03:17.170><c> is</c>

00:03:17.280 --> 00:03:17.290 align:start position:0%
change the fields the pivot table is
 

00:03:17.290 --> 00:03:18.900 align:start position:0%
change the fields the pivot table is
just<00:03:17.560><c> combining</c><00:03:17.950><c> the</c><00:03:18.160><c> source</c><00:03:18.400><c> data</c><00:03:18.640><c> in</c><00:03:18.850><c> a</c>

00:03:18.900 --> 00:03:18.910 align:start position:0%
just combining the source data in a
 

00:03:18.910 --> 00:03:20.490 align:start position:0%
just combining the source data in a
different<00:03:19.060><c> way</c><00:03:19.390><c> so</c><00:03:19.630><c> we</c><00:03:20.050><c> can</c><00:03:20.200><c> view</c><00:03:20.350><c> the</c>

00:03:20.490 --> 00:03:20.500 align:start position:0%
different way so we can view the
 

00:03:20.500 --> 00:03:22.860 align:start position:0%
different way so we can view the
information<00:03:20.620><c> we</c><00:03:21.190><c> need</c><00:03:21.430><c> and</c><00:03:21.670><c> we're</c><00:03:22.420><c> doing</c><00:03:22.510><c> all</c>

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

00:03:22.870 --> 00:03:24.630 align:start position:0%
information we need and we're doing all
this<00:03:23.170><c> without</c><00:03:23.560><c> adding</c><00:03:23.830><c> or</c><00:03:24.160><c> changing</c><00:03:24.190><c> anything</c>

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

00:03:24.640 --> 00:03:27.870 align:start position:0%
this without adding or changing anything
in<00:03:25.090><c> the</c><00:03:25.209><c> original</c><00:03:25.630><c> worksheet</c><00:03:26.550><c> you</c><00:03:27.550><c> can</c><00:03:27.580><c> even</c>

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

00:03:27.880 --> 00:03:29.880 align:start position:0%
in the original worksheet you can even
experiment<00:03:28.420><c> by</c><00:03:28.840><c> dragging</c><00:03:29.260><c> the</c><00:03:29.350><c> fields</c><00:03:29.650><c> into</c>

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

00:03:29.890 --> 00:03:32.100 align:start position:0%
experiment by dragging the fields into
different<00:03:30.130><c> areas</c><00:03:30.310><c> but</c><00:03:31.180><c> some</c><00:03:31.450><c> combinations</c>

00:03:32.100 --> 00:03:32.110 align:start position:0%
different areas but some combinations
 

00:03:32.110 --> 00:03:34.650 align:start position:0%
different areas but some combinations
work<00:03:32.320><c> better</c><00:03:32.530><c> than</c><00:03:32.739><c> others</c><00:03:33.060><c> for</c><00:03:34.060><c> instance</c><00:03:34.450><c> if</c>

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

00:03:34.660 --> 00:03:37.080 align:start position:0%
work better than others for instance if
I<00:03:34.810><c> move</c><00:03:35.019><c> order</c><00:03:35.440><c> amount</c><00:03:35.650><c> over</c><00:03:35.980><c> to</c><00:03:36.370><c> columns</c><00:03:36.850><c> or</c>

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

00:03:37.090 --> 00:03:39.690 align:start position:0%
I move order amount over to columns or
rows<00:03:37.440><c> you</c><00:03:38.440><c> can</c><00:03:38.650><c> see</c><00:03:38.860><c> that</c><00:03:39.040><c> it</c><00:03:39.160><c> doesn't</c><00:03:39.550><c> really</c>

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

00:03:39.700 --> 00:03:42.810 align:start position:0%
rows you can see that it doesn't really
give<00:03:39.940><c> us</c><00:03:39.970><c> any</c><00:03:40.209><c> useful</c><00:03:40.720><c> data</c><00:03:41.489><c> since</c><00:03:42.489><c> order</c>

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

00:03:42.820 --> 00:03:44.820 align:start position:0%
give us any useful data since order
amount<00:03:43.060><c> contains</c><00:03:43.600><c> numerical</c><00:03:44.200><c> values</c><00:03:44.560><c> it</c>

00:03:44.820 --> 00:03:44.830 align:start position:0%
amount contains numerical values it
 

00:03:44.830 --> 00:03:49.390 align:start position:0%
amount contains numerical values it
really<00:03:45.310><c> does</c><00:03:45.489><c> work</c><00:03:45.670><c> best</c><00:03:45.940><c> in</c><00:03:46.180><c> the</c><00:03:46.209><c> values</c><00:03:46.330><c> area</c>

00:03:49.390 --> 00:03:49.400 align:start position:0%
 
 

00:03:49.400 --> 00:03:51.920 align:start position:0%
 
finally<00:03:50.400><c> if</c><00:03:50.580><c> we</c><00:03:50.940><c> click</c><00:03:51.180><c> the</c><00:03:51.300><c> arrow</c><00:03:51.480><c> next</c><00:03:51.600><c> to</c>

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

00:03:51.930 --> 00:03:54.800 align:start position:0%
finally if we click the arrow next to
order<00:03:52.230><c> amount</c><00:03:52.470><c> and</c><00:03:52.820><c> go</c><00:03:53.820><c> to</c><00:03:53.880><c> value</c><00:03:54.570><c> field</c>

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

00:03:54.810 --> 00:03:57.830 align:start position:0%
order amount and go to value field
settings<00:03:55.580><c> we</c><00:03:56.580><c> can</c><00:03:56.610><c> change</c><00:03:57.000><c> the</c><00:03:57.210><c> function</c><00:03:57.390><c> to</c>

00:03:57.830 --> 00:03:57.840 align:start position:0%
settings we can change the function to
 

00:03:57.840 --> 00:04:00.710 align:start position:0%
settings we can change the function to
something<00:03:58.050><c> other</c><00:03:58.410><c> than</c><00:03:58.560><c> sum</c><00:03:59.420><c> instead</c><00:04:00.420><c> we</c>

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

00:04:00.720 --> 00:04:02.140 align:start position:0%
something other than sum instead we
could<00:04:00.870><c> count</c><00:04:01.140><c> the</c><00:04:01.290><c> number</c><00:04:01.320><c> of</c><00:04:01.620><c> cells</c>

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

00:04:02.150 --> 00:04:05.090 align:start position:0%
could count the number of cells
calculate<00:04:03.150><c> the</c><00:04:03.270><c> average</c><00:04:03.720><c> or</c><00:04:04.020><c> use</c><00:04:04.560><c> any</c><00:04:04.830><c> of</c><00:04:04.950><c> the</c>

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

00:04:05.100 --> 00:04:07.610 align:start position:0%
calculate the average or use any of the
other<00:04:05.250><c> options</c><00:04:05.730><c> here</c><00:04:06.380><c> some</c><00:04:07.380><c> of</c><00:04:07.500><c> these</c>

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

00:04:07.620 --> 00:04:09.110 align:start position:0%
other options here some of these
functions<00:04:08.070><c> will</c><00:04:08.220><c> be</c><00:04:08.280><c> more</c><00:04:08.580><c> useful</c><00:04:08.790><c> than</c>

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

00:04:09.120 --> 00:04:11.120 align:start position:0%
functions will be more useful than
others<00:04:09.210><c> depending</c><00:04:09.870><c> on</c><00:04:10.020><c> your</c><00:04:10.140><c> data</c><00:04:10.320><c> so</c><00:04:10.950><c> that's</c>

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

00:04:11.130 --> 00:04:15.380 align:start position:0%
others depending on your data so that's
just<00:04:11.310><c> something</c><00:04:11.580><c> to</c><00:04:11.730><c> keep</c><00:04:11.850><c> in</c><00:04:12.060><c> mind</c><00:04:12.120><c> in</c><00:04:14.390><c> our</c>

00:04:15.380 --> 00:04:15.390 align:start position:0%
just something to keep in mind in our
 

00:04:15.390 --> 00:04:17.570 align:start position:0%
just something to keep in mind in our
next<00:04:15.690><c> video</c><00:04:15.960><c> doing</c><00:04:16.440><c> more</c><00:04:16.769><c> with</c><00:04:16.890><c> pivot</c><00:04:17.220><c> tables</c>

00:04:17.570 --> 00:04:17.580 align:start position:0%
next video doing more with pivot tables
 

00:04:17.580 --> 00:04:19.460 align:start position:0%
next video doing more with pivot tables
we're<00:04:17.970><c> going</c><00:04:18.180><c> to</c><00:04:18.269><c> talk</c><00:04:18.420><c> about</c><00:04:18.450><c> report</c><00:04:19.110><c> filters</c>

00:04:19.460 --> 00:04:19.470 align:start position:0%
we're going to talk about report filters
 

00:04:19.470 --> 00:04:21.979 align:start position:0%
we're going to talk about report filters
we'll<00:04:20.430><c> also</c><00:04:20.640><c> take</c><00:04:20.970><c> a</c><00:04:21.030><c> look</c><00:04:21.239><c> at</c><00:04:21.420><c> slicers</c><00:04:21.959><c> and</c>

00:04:21.979 --> 00:04:21.989 align:start position:0%
we'll also take a look at slicers and
 

00:04:21.989 --> 00:04:24.200 align:start position:0%
we'll also take a look at slicers and
pivotcharts<00:04:22.280><c> which</c><00:04:23.280><c> can</c><00:04:23.490><c> give</c><00:04:23.640><c> you</c><00:04:23.730><c> even</c><00:04:23.910><c> more</c>

00:04:24.200 --> 00:04:24.210 align:start position:0%
pivotcharts which can give you even more
 

00:04:24.210 --> 00:04:30.500 align:start position:0%
pivotcharts which can give you even more
ways<00:04:24.450><c> to</c><00:04:24.660><c> work</c><00:04:24.840><c> with</c><00:04:24.990><c> your</c><00:04:25.140><c> pivot</c><00:04:25.410><c> table</c>

00:04:30.500 --> 00:04:30.510 align:start position:0%
 
 

00:04:30.510 --> 00:04:32.570 align:start position:0%
 
you