WEBVTT
Kind: captions
Language: en

00:00:08.900 --> 00:00:11.540 align:start position:0%
 
one<00:00:09.900><c> of</c><00:00:10.019><c> the</c><00:00:10.170><c> best</c><00:00:10.500><c> things</c><00:00:10.860><c> about</c><00:00:10.980><c> Excel</c><00:00:11.519><c> is</c>

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

00:00:11.550 --> 00:00:13.459 align:start position:0%
one of the best things about Excel is
that<00:00:11.910><c> it</c><00:00:12.000><c> lets</c><00:00:12.210><c> you</c><00:00:12.300><c> deal</c><00:00:12.599><c> with</c><00:00:12.809><c> really</c><00:00:13.110><c> large</c>

00:00:13.459 --> 00:00:13.469 align:start position:0%
that it lets you deal with really large
 

00:00:13.469 --> 00:00:15.950 align:start position:0%
that it lets you deal with really large
amounts<00:00:13.889><c> of</c><00:00:13.980><c> data</c><00:00:14.160><c> in</c><00:00:14.460><c> fact</c><00:00:15.240><c> if</c><00:00:15.509><c> you</c><00:00:15.660><c> need</c><00:00:15.839><c> it</c>

00:00:15.950 --> 00:00:15.960 align:start position:0%
amounts of data in fact if you need it
 

00:00:15.960 --> 00:00:18.050 align:start position:0%
amounts of data in fact if you need it
to<00:00:15.990><c> you</c><00:00:16.410><c> can</c><00:00:16.560><c> have</c><00:00:16.740><c> billions</c><00:00:17.340><c> of</c><00:00:17.460><c> cells</c><00:00:17.699><c> in</c><00:00:17.970><c> a</c>

00:00:18.050 --> 00:00:18.060 align:start position:0%
to you can have billions of cells in a
 

00:00:18.060 --> 00:00:20.540 align:start position:0%
to you can have billions of cells in a
single<00:00:18.420><c> spreadsheet</c><00:00:19.070><c> but</c><00:00:20.070><c> no</c><00:00:20.189><c> matter</c><00:00:20.369><c> how</c>

00:00:20.540 --> 00:00:20.550 align:start position:0%
single spreadsheet but no matter how
 

00:00:20.550 --> 00:00:22.460 align:start position:0%
single spreadsheet but no matter how
much<00:00:20.699><c> data</c><00:00:20.970><c> you</c><00:00:21.210><c> have</c><00:00:21.420><c> it</c><00:00:21.750><c> can</c><00:00:22.199><c> still</c><00:00:22.439><c> be</c>

00:00:22.460 --> 00:00:22.470 align:start position:0%
much data you have it can still be
 

00:00:22.470 --> 00:00:25.070 align:start position:0%
much data you have it can still be
surprisingly<00:00:23.250><c> easy</c><00:00:23.490><c> to</c><00:00:23.609><c> manage</c><00:00:23.910><c> using</c><00:00:24.810><c> a</c><00:00:24.900><c> very</c>

00:00:25.070 --> 00:00:25.080 align:start position:0%
surprisingly easy to manage using a very
 

00:00:25.080 --> 00:00:27.460 align:start position:0%
surprisingly easy to manage using a very
special<00:00:25.500><c> feature</c><00:00:25.740><c> called</c><00:00:26.189><c> pivot</c><00:00:26.820><c> tables</c>

00:00:27.460 --> 00:00:27.470 align:start position:0%
special feature called pivot tables
 

00:00:27.470 --> 00:00:30.019 align:start position:0%
special feature called pivot tables
pivot<00:00:28.470><c> tables</c><00:00:28.800><c> let</c><00:00:29.010><c> you</c><00:00:29.160><c> summarize</c><00:00:29.699><c> and</c>

00:00:30.019 --> 00:00:30.029 align:start position:0%
pivot tables let you summarize and
 

00:00:30.029 --> 00:00:32.089 align:start position:0%
pivot tables let you summarize and
manipulate<00:00:30.720><c> the</c><00:00:30.869><c> data</c><00:00:30.990><c> without</c><00:00:31.380><c> changing</c><00:00:31.980><c> the</c>

00:00:32.089 --> 00:00:32.099 align:start position:0%
manipulate the data without changing the
 

00:00:32.099 --> 00:00:34.340 align:start position:0%
manipulate the data without changing the
original<00:00:32.189><c> spreadsheet</c><00:00:32.730><c> if</c><00:00:33.200><c> you've</c><00:00:34.200><c> never</c>

00:00:34.340 --> 00:00:34.350 align:start position:0%
original spreadsheet if you've never
 

00:00:34.350 --> 00:00:35.990 align:start position:0%
original spreadsheet if you've never
used<00:00:34.500><c> them</c><00:00:34.860><c> before</c><00:00:34.890><c> they</c><00:00:35.579><c> might</c><00:00:35.760><c> seem</c><00:00:35.969><c> a</c>

00:00:35.990 --> 00:00:36.000 align:start position:0%
used them before they might seem a
 

00:00:36.000 --> 00:00:38.090 align:start position:0%
used them before they might seem a
little<00:00:36.210><c> bit</c><00:00:36.420><c> intimidating</c><00:00:37.020><c> at</c><00:00:37.110><c> first</c><00:00:37.140><c> but</c>

00:00:38.090 --> 00:00:38.100 align:start position:0%
little bit intimidating at first but
 

00:00:38.100 --> 00:00:39.350 align:start position:0%
little bit intimidating at first but
once<00:00:38.309><c> you</c><00:00:38.399><c> get</c><00:00:38.579><c> the</c><00:00:38.670><c> hang</c><00:00:38.850><c> of</c><00:00:38.940><c> it</c><00:00:39.059><c> you'll</c><00:00:39.210><c> be</c>

00:00:39.350 --> 00:00:39.360 align:start position:0%
once you get the hang of it you'll be
 

00:00:39.360 --> 00:00:41.389 align:start position:0%
once you get the hang of it you'll be
able<00:00:39.450><c> to</c><00:00:39.629><c> easily</c><00:00:39.809><c> make</c><00:00:40.230><c> pivot</c><00:00:40.559><c> tables</c><00:00:40.860><c> using</c>

00:00:41.389 --> 00:00:41.399 align:start position:0%
able to easily make pivot tables using
 

00:00:41.399 --> 00:00:44.150 align:start position:0%
able to easily make pivot tables using
just<00:00:41.670><c> a</c><00:00:41.790><c> few</c><00:00:42.059><c> mouse</c><00:00:42.239><c> clicks</c>

00:00:44.150 --> 00:00:44.160 align:start position:0%
just a few mouse clicks
 

00:00:44.160 --> 00:00:46.130 align:start position:0%
just a few mouse clicks
in<00:00:44.220><c> this</c><00:00:44.940><c> example</c><00:00:45.360><c> I</c><00:00:45.660><c> have</c><00:00:45.870><c> some</c><00:00:46.079><c> company</c>

00:00:46.130 --> 00:00:46.140 align:start position:0%
in this example I have some company
 

00:00:46.140 --> 00:00:49.070 align:start position:0%
in this example I have some company
sales<00:00:46.770><c> data</c><00:00:47.070><c> and</c><00:00:47.280><c> there</c><00:00:48.210><c> are</c><00:00:48.390><c> columns</c><00:00:48.750><c> for</c>

00:00:49.070 --> 00:00:49.080 align:start position:0%
sales data and there are columns for
 

00:00:49.080 --> 00:00:53.270 align:start position:0%
sales data and there are columns for
salesperson<00:00:49.980><c> region</c><00:00:50.870><c> account</c><00:00:51.980><c> order</c><00:00:52.980><c> amount</c>

00:00:53.270 --> 00:00:53.280 align:start position:0%
salesperson region account order amount
 

00:00:53.280 --> 00:00:56.390 align:start position:0%
salesperson region account order amount
and<00:00:53.520><c> month</c><00:00:54.420><c> and</c><00:00:54.750><c> I</c><00:00:55.739><c> need</c><00:00:55.800><c> to</c><00:00:56.010><c> answer</c><00:00:56.160><c> the</c>

00:00:56.390 --> 00:00:56.400 align:start position:0%
and month and I need to answer the
 

00:00:56.400 --> 00:00:59.540 align:start position:0%
and month and I need to answer the
question<00:00:56.820><c> what</c><00:00:57.570><c> is</c><00:00:57.600><c> the</c><00:00:57.989><c> amount</c><00:00:58.350><c> sold</c><00:00:58.739><c> by</c><00:00:59.309><c> each</c>

00:00:59.540 --> 00:00:59.550 align:start position:0%
question what is the amount sold by each
 

00:00:59.550 --> 00:01:02.020 align:start position:0%
question what is the amount sold by each
salesperson

00:01:02.020 --> 00:01:02.030 align:start position:0%
salesperson
 

00:01:02.030 --> 00:01:04.479 align:start position:0%
salesperson
now<00:01:02.690><c> because</c><00:01:02.870><c> each</c><00:01:03.170><c> salesperson</c><00:01:03.620><c> appears</c><00:01:04.280><c> on</c>

00:01:04.479 --> 00:01:04.489 align:start position:0%
now because each salesperson appears on
 

00:01:04.489 --> 00:01:07.000 align:start position:0%
now because each salesperson appears on
multiple<00:01:04.970><c> rows</c><00:01:05.269><c> I</c><00:01:05.600><c> would</c><00:01:06.260><c> need</c><00:01:06.410><c> to</c><00:01:06.530><c> add</c><00:01:06.560><c> up</c><00:01:06.860><c> the</c>

00:01:07.000 --> 00:01:07.010 align:start position:0%
multiple rows I would need to add up the
 

00:01:07.010 --> 00:01:08.230 align:start position:0%
multiple rows I would need to add up the
rows<00:01:07.160><c> to</c><00:01:07.370><c> find</c><00:01:07.580><c> the</c><00:01:07.700><c> answer</c>

00:01:08.230 --> 00:01:08.240 align:start position:0%
rows to find the answer
 

00:01:08.240 --> 00:01:10.330 align:start position:0%
rows to find the answer
but<00:01:09.200><c> a</c><00:01:09.230><c> pivot</c><00:01:09.560><c> table</c><00:01:09.710><c> can</c><00:01:10.040><c> do</c><00:01:10.130><c> this</c>

00:01:10.330 --> 00:01:10.340 align:start position:0%
but a pivot table can do this
 

00:01:10.340 --> 00:01:12.380 align:start position:0%
but a pivot table can do this
automatically

00:01:12.380 --> 00:01:12.390 align:start position:0%
automatically
 

00:01:12.390 --> 00:01:14.800 align:start position:0%
automatically
you'll<00:01:13.110><c> first</c><00:01:13.320><c> need</c><00:01:13.500><c> to</c><00:01:13.560><c> select</c><00:01:13.800><c> the</c><00:01:14.160><c> data</c><00:01:14.370><c> if</c>

00:01:14.800 --> 00:01:14.810 align:start position:0%
you'll first need to select the data if
 

00:01:14.810 --> 00:01:17.390 align:start position:0%
you'll first need to select the data if
it's<00:01:15.810><c> formatted</c><00:01:16.290><c> as</c><00:01:16.380><c> a</c><00:01:16.410><c> table</c><00:01:16.650><c> you</c><00:01:17.070><c> can</c><00:01:17.220><c> just</c>

00:01:17.390 --> 00:01:17.400 align:start position:0%
it's formatted as a table you can just
 

00:01:17.400 --> 00:01:19.730 align:start position:0%
it's formatted as a table you can just
click<00:01:17.640><c> any</c><00:01:17.850><c> cell</c><00:01:17.940><c> and</c><00:01:18.390><c> if</c><00:01:19.170><c> it's</c><00:01:19.290><c> not</c><00:01:19.440><c> you'll</c>

00:01:19.730 --> 00:01:19.740 align:start position:0%
click any cell and if it's not you'll
 

00:01:19.740 --> 00:01:20.870 align:start position:0%
click any cell and if it's not you'll
just<00:01:19.920><c> need</c><00:01:20.040><c> to</c><00:01:20.100><c> make</c><00:01:20.190><c> sure</c><00:01:20.310><c> that</c><00:01:20.580><c> you</c><00:01:20.700><c> select</c>

00:01:20.870 --> 00:01:20.880 align:start position:0%
just need to make sure that you select
 

00:01:20.880 --> 00:01:25.899 align:start position:0%
just need to make sure that you select
everything<00:01:21.630><c> including</c><00:01:22.590><c> the</c><00:01:22.740><c> column</c><00:01:23.070><c> headers</c>

00:01:25.899 --> 00:01:25.909 align:start position:0%
 
 

00:01:25.909 --> 00:01:27.609 align:start position:0%
 
from<00:01:26.060><c> the</c><00:01:26.179><c> insert</c><00:01:26.479><c> tab</c><00:01:26.749><c> click</c><00:01:26.960><c> the</c><00:01:27.380><c> pivot</c>

00:01:27.609 --> 00:01:27.619 align:start position:0%
from the insert tab click the pivot
 

00:01:27.619 --> 00:01:33.260 align:start position:0%
from the insert tab click the pivot
table<00:01:27.829><c> command</c>

00:01:33.260 --> 00:01:33.270 align:start position:0%
 
 

00:01:33.270 --> 00:01:35.179 align:start position:0%
 
and<00:01:33.359><c> you'll</c><00:01:34.259><c> usually</c><00:01:34.439><c> want</c><00:01:34.619><c> to</c><00:01:34.799><c> place</c><00:01:35.009><c> the</c>

00:01:35.179 --> 00:01:35.189 align:start position:0%
and you'll usually want to place the
 

00:01:35.189 --> 00:01:38.469 align:start position:0%
and you'll usually want to place the
PivotTable<00:01:35.729><c> in</c><00:01:35.909><c> a</c><00:01:36.030><c> new</c><00:01:36.240><c> worksheet</c><00:01:36.810><c> and</c><00:01:37.530><c> click</c>

00:01:38.469 --> 00:01:38.479 align:start position:0%
PivotTable in a new worksheet and click
 

00:01:38.479 --> 00:01:42.390 align:start position:0%
PivotTable in a new worksheet and click
OK

00:01:42.390 --> 00:01:42.400 align:start position:0%
 
 

00:01:42.400 --> 00:01:44.760 align:start position:0%
 
over<00:01:43.180><c> on</c><00:01:43.240><c> the</c><00:01:43.360><c> left</c><00:01:43.570><c> is</c><00:01:43.780><c> our</c><00:01:43.990><c> blank</c><00:01:44.050><c> pivot</c>

00:01:44.760 --> 00:01:44.770 align:start position:0%
over on the left is our blank pivot
 

00:01:44.770 --> 00:01:48.410 align:start position:0%
over on the left is our blank pivot
table<00:01:45.070><c> and</c><00:01:45.360><c> on</c><00:01:46.360><c> the</c><00:01:46.480><c> right</c><00:01:46.720><c> is</c><00:01:46.960><c> the</c><00:01:47.380><c> field</c><00:01:47.620><c> list</c>

00:01:48.410 --> 00:01:48.420 align:start position:0%
table and on the right is the field list
 

00:01:48.420 --> 00:01:51.090 align:start position:0%
table and on the right is the field list
all<00:01:49.420><c> of</c><00:01:49.480><c> these</c><00:01:49.810><c> field</c><00:01:50.140><c> names</c><00:01:50.230><c> are</c><00:01:50.560><c> just</c><00:01:50.680><c> taken</c>

00:01:51.090 --> 00:01:51.100 align:start position:0%
all of these field names are just taken
 

00:01:51.100 --> 00:01:55.690 align:start position:0%
all of these field names are just taken
from<00:01:51.370><c> our</c><00:01:51.610><c> column</c><00:01:52.120><c> headers</c>

00:01:55.690 --> 00:01:55.700 align:start position:0%
 
 

00:01:55.700 --> 00:01:57.999 align:start position:0%
 
below<00:01:56.450><c> that</c><00:01:56.479><c> are</c><00:01:56.900><c> the</c><00:01:56.960><c> four</c><00:01:57.320><c> areas</c><00:01:57.500><c> where</c><00:01:57.860><c> we</c>

00:01:57.999 --> 00:01:58.009 align:start position:0%
below that are the four areas where we
 

00:01:58.009 --> 00:02:02.000 align:start position:0%
below that are the four areas where we
can<00:01:58.159><c> add</c><00:01:58.340><c> fields</c><00:01:59.000><c> to</c><00:01:59.060><c> build</c><00:01:59.450><c> the</c><00:01:59.659><c> pivot</c><00:01:59.960><c> table</c>

00:02:02.000 --> 00:02:02.010 align:start position:0%
can add fields to build the pivot table
 

00:02:02.010 --> 00:02:03.890 align:start position:0%
can add fields to build the pivot table
now<00:02:02.340><c> before</c><00:02:02.700><c> we</c><00:02:02.730><c> select</c><00:02:03.180><c> any</c><00:02:03.390><c> of</c><00:02:03.450><c> the</c><00:02:03.540><c> fields</c>

00:02:03.890 --> 00:02:03.900 align:start position:0%
now before we select any of the fields
 

00:02:03.900 --> 00:02:05.540 align:start position:0%
now before we select any of the fields
let's<00:02:04.380><c> look</c><00:02:04.530><c> at</c><00:02:04.650><c> the</c><00:02:04.740><c> original</c><00:02:04.830><c> question</c>

00:02:05.540 --> 00:02:05.550 align:start position:0%
let's look at the original question
 

00:02:05.550 --> 00:02:09.290 align:start position:0%
let's look at the original question
again<00:02:06.320><c> what</c><00:02:07.320><c> is</c><00:02:07.470><c> the</c><00:02:07.500><c> amount</c><00:02:08.190><c> sold</c><00:02:08.730><c> by</c><00:02:09.030><c> each</c>

00:02:09.290 --> 00:02:09.300 align:start position:0%
again what is the amount sold by each
 

00:02:09.300 --> 00:02:11.380 align:start position:0%
again what is the amount sold by each
salesperson

00:02:11.380 --> 00:02:11.390 align:start position:0%
salesperson
 

00:02:11.390 --> 00:02:13.210 align:start position:0%
salesperson
this<00:02:11.840><c> question</c><00:02:12.290><c> tells</c><00:02:12.500><c> us</c><00:02:12.620><c> exactly</c><00:02:12.800><c> which</c>

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

00:02:13.220 --> 00:02:15.210 align:start position:0%
this question tells us exactly which
fields<00:02:13.580><c> we</c><00:02:13.700><c> need</c><00:02:13.730><c> to</c><00:02:13.880><c> use</c><00:02:14.150><c> to</c><00:02:14.390><c> answer</c><00:02:14.750><c> it</c>

00:02:15.210 --> 00:02:15.220 align:start position:0%
fields we need to use to answer it
 

00:02:15.220 --> 00:02:19.600 align:start position:0%
fields we need to use to answer it
salesperson<00:02:16.220><c> and</c><00:02:16.370><c> order</c><00:02:17.090><c> amount</c>

00:02:19.600 --> 00:02:19.610 align:start position:0%
 
 

00:02:19.610 --> 00:02:21.310 align:start position:0%
 
when<00:02:20.000><c> you</c><00:02:20.090><c> click</c><00:02:20.270><c> these</c><00:02:20.510><c> they</c><00:02:20.750><c> will</c><00:02:20.870><c> be</c><00:02:20.990><c> added</c>

00:02:21.310 --> 00:02:21.320 align:start position:0%
when you click these they will be added
 

00:02:21.320 --> 00:02:25.800 align:start position:0%
when you click these they will be added
to<00:02:21.500><c> the</c><00:02:21.650><c> row</c><00:02:21.920><c> labels</c><00:02:22.370><c> and</c><00:02:22.640><c> values</c><00:02:23.050><c> areas</c><00:02:24.050><c> below</c>

00:02:25.800 --> 00:02:25.810 align:start position:0%
to the row labels and values areas below
 

00:02:25.810 --> 00:02:28.260 align:start position:0%
to the row labels and values areas below
and<00:02:25.900><c> now</c><00:02:26.830><c> on</c><00:02:26.980><c> the</c><00:02:27.099><c> Left</c><00:02:27.340><c> we</c><00:02:27.550><c> have</c><00:02:27.580><c> a</c><00:02:27.970><c> pivot</c>

00:02:28.260 --> 00:02:28.270 align:start position:0%
and now on the Left we have a pivot
 

00:02:28.270 --> 00:02:30.240 align:start position:0%
and now on the Left we have a pivot
table<00:02:28.420><c> where</c><00:02:29.020><c> we</c><00:02:29.170><c> can</c><00:02:29.319><c> see</c><00:02:29.530><c> the</c><00:02:29.650><c> amount</c><00:02:29.950><c> sold</c>

00:02:30.240 --> 00:02:30.250 align:start position:0%
table where we can see the amount sold
 

00:02:30.250 --> 00:02:33.589 align:start position:0%
table where we can see the amount sold
by<00:02:30.610><c> each</c><00:02:30.819><c> salesperson</c>

00:02:33.589 --> 00:02:33.599 align:start position:0%
 
 

00:02:33.599 --> 00:02:35.750 align:start position:0%
 
so<00:02:34.260><c> now</c><00:02:34.469><c> our</c><00:02:34.499><c> original</c><00:02:35.129><c> question</c><00:02:35.310><c> has</c><00:02:35.640><c> been</c>

00:02:35.750 --> 00:02:35.760 align:start position:0%
so now our original question has been
 

00:02:35.760 --> 00:02:38.270 align:start position:0%
so now our original question has been
answered<00:02:35.969><c> and</c><00:02:36.329><c> if</c><00:02:37.260><c> we</c><00:02:37.379><c> want</c><00:02:37.620><c> we</c><00:02:37.739><c> can</c><00:02:37.980><c> modify</c>

00:02:38.270 --> 00:02:38.280 align:start position:0%
answered and if we want we can modify
 

00:02:38.280 --> 00:02:39.949 align:start position:0%
answered and if we want we can modify
the<00:02:38.459><c> pivot</c><00:02:38.790><c> table</c><00:02:38.939><c> to</c><00:02:39.239><c> answer</c><00:02:39.420><c> more</c><00:02:39.749><c> questions</c>

00:02:39.949 --> 00:02:39.959 align:start position:0%
the pivot table to answer more questions
 

00:02:39.959 --> 00:02:42.979 align:start position:0%
the pivot table to answer more questions
if<00:02:40.849><c> we</c><00:02:41.849><c> want</c><00:02:42.150><c> to</c><00:02:42.209><c> know</c><00:02:42.329><c> how</c><00:02:42.540><c> much</c><00:02:42.689><c> each</c><00:02:42.959><c> person</c>

00:02:42.979 --> 00:02:42.989 align:start position:0%
if we want to know how much each person
 

00:02:42.989 --> 00:02:45.860 align:start position:0%
if we want to know how much each person
sold<00:02:43.680><c> each</c><00:02:43.980><c> month</c><00:02:44.310><c> we</c><00:02:44.999><c> can</c><00:02:45.209><c> drag</c><00:02:45.480><c> the</c><00:02:45.659><c> month</c>

00:02:45.860 --> 00:02:45.870 align:start position:0%
sold each month we can drag the month
 

00:02:45.870 --> 00:02:49.520 align:start position:0%
sold each month we can drag the month
field<00:02:46.170><c> into</c><00:02:46.650><c> column</c><00:02:47.099><c> labels</c><00:02:47.489><c> and</c><00:02:48.379><c> this</c><00:02:49.379><c> will</c>

00:02:49.520 --> 00:02:49.530 align:start position:0%
field into column labels and this will
 

00:02:49.530 --> 00:02:53.809 align:start position:0%
field into column labels and this will
add<00:02:49.739><c> columns</c><00:02:50.280><c> for</c><00:02:50.489><c> each</c><00:02:50.670><c> month</c>

00:02:53.809 --> 00:02:53.819 align:start position:0%
 
 

00:02:53.819 --> 00:02:56.000 align:start position:0%
 
or<00:02:54.360><c> if</c><00:02:54.719><c> we</c><00:02:54.870><c> wanted</c><00:02:55.079><c> to</c><00:02:55.200><c> know</c><00:02:55.349><c> how</c><00:02:55.560><c> much</c><00:02:55.769><c> each</c>

00:02:56.000 --> 00:02:56.010 align:start position:0%
or if we wanted to know how much each
 

00:02:56.010 --> 00:02:58.610 align:start position:0%
or if we wanted to know how much each
region<00:02:56.610><c> sold</c><00:02:56.879><c> we</c><00:02:57.629><c> could</c><00:02:57.780><c> just</c><00:02:57.959><c> take</c><00:02:58.170><c> the</c><00:02:58.319><c> month</c>

00:02:58.610 --> 00:02:58.620 align:start position:0%
region sold we could just take the month
 

00:02:58.620 --> 00:03:02.550 align:start position:0%
region sold we could just take the month
and<00:02:58.829><c> salesperson</c><00:02:59.579><c> fields</c><00:02:59.939><c> out</c>

00:03:02.550 --> 00:03:02.560 align:start position:0%
 
 

00:03:02.560 --> 00:03:10.690 align:start position:0%
 
and<00:03:02.650><c> then</c><00:03:03.520><c> drag</c><00:03:03.819><c> region</c><00:03:04.150><c> into</c><00:03:04.900><c> road</c><00:03:05.200><c> labels</c>

00:03:10.690 --> 00:03:10.700 align:start position:0%
 
 

00:03:10.700 --> 00:03:12.910 align:start position:0%
 
so<00:03:11.300><c> each</c><00:03:11.540><c> time</c><00:03:11.750><c> we</c><00:03:11.810><c> change</c><00:03:12.170><c> the</c><00:03:12.410><c> field</c><00:03:12.620><c> the</c>

00:03:12.910 --> 00:03:12.920 align:start position:0%
so each time we change the field the
 

00:03:12.920 --> 00:03:14.920 align:start position:0%
so each time we change the field the
pivot<00:03:13.190><c> table</c><00:03:13.459><c> is</c><00:03:13.580><c> just</c><00:03:13.790><c> combining</c><00:03:14.240><c> and</c><00:03:14.599><c> adding</c>

00:03:14.920 --> 00:03:14.930 align:start position:0%
pivot table is just combining and adding
 

00:03:14.930 --> 00:03:16.780 align:start position:0%
pivot table is just combining and adding
the<00:03:15.020><c> source</c><00:03:15.260><c> data</c><00:03:15.500><c> in</c><00:03:15.709><c> a</c><00:03:15.770><c> different</c><00:03:16.130><c> way</c><00:03:16.250><c> to</c>

00:03:16.780 --> 00:03:16.790 align:start position:0%
the source data in a different way to
 

00:03:16.790 --> 00:03:19.500 align:start position:0%
the source data in a different way to
give<00:03:16.910><c> us</c><00:03:17.030><c> the</c><00:03:17.180><c> answer</c><00:03:17.510><c> that</c><00:03:17.720><c> we</c><00:03:17.840><c> need</c>

00:03:19.500 --> 00:03:19.510 align:start position:0%
give us the answer that we need
 

00:03:19.510 --> 00:03:21.570 align:start position:0%
give us the answer that we need
you<00:03:20.140><c> can</c><00:03:20.290><c> experiment</c><00:03:20.860><c> by</c><00:03:20.980><c> dragging</c><00:03:21.489><c> the</c>

00:03:21.570 --> 00:03:21.580 align:start position:0%
you can experiment by dragging the
 

00:03:21.580 --> 00:03:24.449 align:start position:0%
you can experiment by dragging the
fields<00:03:21.970><c> into</c><00:03:22.180><c> different</c><00:03:22.540><c> areas</c><00:03:23.190><c> but</c><00:03:24.190><c> you</c><00:03:24.310><c> may</c>

00:03:24.449 --> 00:03:24.459 align:start position:0%
fields into different areas but you may
 

00:03:24.459 --> 00:03:26.250 align:start position:0%
fields into different areas but you may
find<00:03:24.670><c> that</c><00:03:24.909><c> some</c><00:03:25.090><c> combinations</c><00:03:25.720><c> don't</c><00:03:26.019><c> work</c>

00:03:26.250 --> 00:03:26.260 align:start position:0%
find that some combinations don't work
 

00:03:26.260 --> 00:03:28.920 align:start position:0%
find that some combinations don't work
as<00:03:26.440><c> well</c><00:03:26.470><c> for</c><00:03:27.000><c> example</c><00:03:28.000><c> if</c><00:03:28.180><c> I</c><00:03:28.360><c> move</c><00:03:28.569><c> order</c>

00:03:28.920 --> 00:03:28.930 align:start position:0%
as well for example if I move order
 

00:03:28.930 --> 00:03:31.470 align:start position:0%
as well for example if I move order
amount<00:03:29.200><c> to</c><00:03:29.440><c> column</c><00:03:29.920><c> labels</c><00:03:30.280><c> or</c><00:03:30.489><c> row</c><00:03:30.819><c> labels</c><00:03:31.239><c> it</c>

00:03:31.470 --> 00:03:31.480 align:start position:0%
amount to column labels or row labels it
 

00:03:31.480 --> 00:03:33.890 align:start position:0%
amount to column labels or row labels it
doesn't<00:03:32.319><c> really</c><00:03:32.409><c> give</c><00:03:32.620><c> me</c><00:03:32.769><c> any</c><00:03:32.799><c> useful</c><00:03:32.980><c> data</c>

00:03:33.890 --> 00:03:33.900 align:start position:0%
doesn't really give me any useful data
 

00:03:33.900 --> 00:03:36.600 align:start position:0%
doesn't really give me any useful data
since<00:03:34.900><c> order</c><00:03:35.200><c> amount</c><00:03:35.409><c> contains</c><00:03:35.920><c> numerical</c>

00:03:36.600 --> 00:03:36.610 align:start position:0%
since order amount contains numerical
 

00:03:36.610 --> 00:03:39.059 align:start position:0%
since order amount contains numerical
values<00:03:37.090><c> it</c><00:03:37.750><c> really</c><00:03:38.049><c> works</c><00:03:38.230><c> best</c><00:03:38.500><c> in</c><00:03:38.769><c> the</c>

00:03:39.059 --> 00:03:39.069 align:start position:0%
values it really works best in the
 

00:03:39.069 --> 00:03:42.740 align:start position:0%
values it really works best in the
values<00:03:39.459><c> field</c>

00:03:42.740 --> 00:03:42.750 align:start position:0%
 
 

00:03:42.750 --> 00:03:45.600 align:start position:0%
 
finally<00:03:43.750><c> if</c><00:03:43.900><c> you</c><00:03:44.410><c> click</c><00:03:44.680><c> on</c><00:03:44.800><c> the</c><00:03:44.950><c> order</c><00:03:45.160><c> amount</c>

00:03:45.600 --> 00:03:45.610 align:start position:0%
finally if you click on the order amount
 

00:03:45.610 --> 00:03:49.589 align:start position:0%
finally if you click on the order amount
field<00:03:46.000><c> and</c><00:03:46.330><c> go</c><00:03:46.989><c> to</c><00:03:47.050><c> value</c><00:03:47.709><c> field</c><00:03:48.069><c> settings</c><00:03:48.670><c> you</c>

00:03:49.589 --> 00:03:49.599 align:start position:0%
field and go to value field settings you
 

00:03:49.599 --> 00:03:51.960 align:start position:0%
field and go to value field settings you
can<00:03:49.720><c> change</c><00:03:50.020><c> the</c><00:03:50.260><c> function</c><00:03:50.459><c> so</c><00:03:51.459><c> that</c><00:03:51.489><c> instead</c>

00:03:51.960 --> 00:03:51.970 align:start position:0%
can change the function so that instead
 

00:03:51.970 --> 00:03:54.089 align:start position:0%
can change the function so that instead
of<00:03:52.030><c> calculating</c><00:03:52.330><c> the</c><00:03:52.810><c> sum</c><00:03:53.110><c> it</c><00:03:53.349><c> can</c><00:03:53.680><c> count</c><00:03:53.920><c> the</c>

00:03:54.089 --> 00:03:54.099 align:start position:0%
of calculating the sum it can count the
 

00:03:54.099 --> 00:03:57.170 align:start position:0%
of calculating the sum it can count the
cells<00:03:54.310><c> or</c><00:03:54.640><c> find</c><00:03:55.480><c> the</c><00:03:55.630><c> average</c>

00:03:57.170 --> 00:03:57.180 align:start position:0%
cells or find the average
 

00:03:57.180 --> 00:03:59.149 align:start position:0%
cells or find the average
and<00:03:57.269><c> there</c><00:03:58.079><c> are</c><00:03:58.200><c> many</c><00:03:58.319><c> other</c><00:03:58.530><c> functions</c><00:03:58.799><c> that</c>

00:03:59.149 --> 00:03:59.159 align:start position:0%
and there are many other functions that
 

00:03:59.159 --> 00:04:04.500 align:start position:0%
and there are many other functions that
you<00:03:59.280><c> can</c><00:03:59.310><c> use</c>

00:04:04.500 --> 00:04:04.510 align:start position:0%
 
 

00:04:04.510 --> 00:04:06.630 align:start position:0%
 
in<00:04:04.569><c> part</c><00:04:05.409><c> two</c><00:04:05.650><c> we're</c><00:04:06.040><c> going</c><00:04:06.159><c> to</c><00:04:06.250><c> talk</c><00:04:06.489><c> about</c>

00:04:06.630 --> 00:04:06.640 align:start position:0%
in part two we're going to talk about
 

00:04:06.640 --> 00:04:09.420 align:start position:0%
in part two we're going to talk about
report<00:04:07.239><c> filters</c><00:04:07.629><c> and</c><00:04:07.870><c> we'll</c><00:04:08.590><c> also</c><00:04:08.769><c> talk</c><00:04:09.129><c> about</c>

00:04:09.420 --> 00:04:09.430 align:start position:0%
report filters and we'll also talk about
 

00:04:09.430 --> 00:04:12.479 align:start position:0%
report filters and we'll also talk about
how<00:04:09.670><c> to</c><00:04:09.730><c> add</c><00:04:09.970><c> slicers</c><00:04:10.659><c> and</c><00:04:10.689><c> pivotcharts</c><00:04:11.489><c> which</c>

00:04:12.479 --> 00:04:12.489 align:start position:0%
how to add slicers and pivotcharts which
 

00:04:12.489 --> 00:04:13.740 align:start position:0%
how to add slicers and pivotcharts which
will<00:04:12.670><c> give</c><00:04:12.819><c> you</c><00:04:12.909><c> even</c><00:04:13.120><c> more</c><00:04:13.480><c> ways</c><00:04:13.720><c> to</c>

00:04:13.740 --> 00:04:13.750 align:start position:0%
will give you even more ways to
 

00:04:13.750 --> 00:04:18.270 align:start position:0%
will give you even more ways to
manipulate<00:04:14.290><c> the</c><00:04:14.739><c> pivot</c><00:04:15.010><c> table</c><00:04:16.949><c> like</c><00:04:17.949><c> what</c><00:04:18.130><c> you</c>

00:04:18.270 --> 00:04:18.280 align:start position:0%
manipulate the pivot table like what you
 

00:04:18.280 --> 00:04:21.960 align:start position:0%
manipulate the pivot table like what you
just<00:04:18.310><c> saw</c><00:04:19.169><c> rate</c><00:04:20.169><c> it</c><00:04:20.350><c> add</c><00:04:20.859><c> a</c><00:04:20.919><c> comment</c><00:04:21.250><c> subscribe</c>

00:04:21.960 --> 00:04:21.970 align:start position:0%
just saw rate it add a comment subscribe
 

00:04:21.970 --> 00:04:26.370 align:start position:0%
just saw rate it add a comment subscribe
to<00:04:22.270><c> our</c><00:04:22.510><c> chin</c><00:04:23.010><c> the</c><00:04:24.010><c> freedom</c><00:04:24.460><c> to</c><00:04:24.490><c> learn</c><00:04:25.380><c> what</c>

00:04:26.370 --> 00:04:26.380 align:start position:0%
to our chin the freedom to learn what
 

00:04:26.380 --> 00:04:34.640 align:start position:0%
to our chin the freedom to learn what
you<00:04:26.590><c> want</c><00:04:27.090><c> when</c><00:04:28.090><c> you</c><00:04:28.270><c> want</c><00:04:30.030><c> absolutely</c><00:04:31.030><c> free</c>

00:04:34.640 --> 00:04:34.650 align:start position:0%
 
 

00:04:34.650 --> 00:04:38.280 align:start position:0%
 
GCF<00:04:35.650><c> learn</c><00:04:36.250><c> free.org</c>