WEBVTT
Kind: captions
Language: en

00:00:07.490 --> 00:00:10.190 align:start position:0%
 
right<00:00:08.490><c> now</c><00:00:08.760><c> we're</c><00:00:09.090><c> working</c><00:00:09.240><c> with</c><00:00:09.570><c> our</c><00:00:09.690><c> candle</c>

00:00:10.190 --> 00:00:10.200 align:start position:0%
right now we're working with our candle
 

00:00:10.200 --> 00:00:12.919 align:start position:0%
right now we're working with our candle
company<00:00:10.380><c> sales</c><00:00:10.800><c> spreadsheets</c><00:00:11.730><c> it</c><00:00:11.969><c> has</c><00:00:12.599><c> less</c>

00:00:12.919 --> 00:00:12.929 align:start position:0%
company sales spreadsheets it has less
 

00:00:12.929 --> 00:00:14.959 align:start position:0%
company sales spreadsheets it has less
than<00:00:13.139><c> 100</c><00:00:13.650><c> rows</c><00:00:13.830><c> but</c><00:00:14.190><c> imagine</c><00:00:14.730><c> that</c><00:00:14.759><c> this</c>

00:00:14.959 --> 00:00:14.969 align:start position:0%
than 100 rows but imagine that this
 

00:00:14.969 --> 00:00:17.090 align:start position:0%
than 100 rows but imagine that this
Excel<00:00:15.330><c> spreadsheets</c><00:00:15.929><c> contains</c><00:00:16.410><c> thousands</c><00:00:16.949><c> of</c>

00:00:17.090 --> 00:00:17.100 align:start position:0%
Excel spreadsheets contains thousands of
 

00:00:17.100 --> 00:00:19.519 align:start position:0%
Excel spreadsheets contains thousands of
rows<00:00:17.279><c> of</c><00:00:17.310><c> information</c><00:00:17.869><c> with</c><00:00:18.869><c> information</c>

00:00:19.519 --> 00:00:19.529 align:start position:0%
rows of information with information
 

00:00:19.529 --> 00:00:21.890 align:start position:0%
rows of information with information
about<00:00:19.619><c> all</c><00:00:20.010><c> the</c><00:00:20.220><c> salespeople</c><00:00:20.609><c> how</c><00:00:21.420><c> much</c><00:00:21.660><c> each</c>

00:00:21.890 --> 00:00:21.900 align:start position:0%
about all the salespeople how much each
 

00:00:21.900 --> 00:00:24.290 align:start position:0%
about all the salespeople how much each
sold<00:00:22.289><c> the</c><00:00:22.710><c> dates</c><00:00:22.980><c> they</c><00:00:23.250><c> sold</c><00:00:23.519><c> its</c><00:00:23.730><c> accounts</c>

00:00:24.290 --> 00:00:24.300 align:start position:0%
sold the dates they sold its accounts
 

00:00:24.300 --> 00:00:26.750 align:start position:0%
sold the dates they sold its accounts
numbers<00:00:24.630><c> and</c><00:00:24.900><c> more</c><00:00:25.170><c> it</c><00:00:25.439><c> is</c><00:00:26.099><c> almost</c><00:00:26.460><c> too</c><00:00:26.730><c> much</c>

00:00:26.750 --> 00:00:26.760 align:start position:0%
numbers and more it is almost too much
 

00:00:26.760 --> 00:00:29.419 align:start position:0%
numbers and more it is almost too much
to<00:00:27.119><c> read</c><00:00:27.300><c> and</c><00:00:27.480><c> comprehend</c><00:00:28.050><c> if</c><00:00:28.320><c> I</c><00:00:28.949><c> wanted</c><00:00:29.279><c> to</c>

00:00:29.419 --> 00:00:29.429 align:start position:0%
to read and comprehend if I wanted to
 

00:00:29.429 --> 00:00:31.580 align:start position:0%
to read and comprehend if I wanted to
know<00:00:29.609><c> who</c><00:00:29.880><c> sold</c><00:00:30.179><c> the</c><00:00:30.510><c> most</c><00:00:30.750><c> in</c><00:00:30.929><c> February</c>

00:00:31.580 --> 00:00:31.590 align:start position:0%
know who sold the most in February
 

00:00:31.590 --> 00:00:34.729 align:start position:0%
know who sold the most in February
how<00:00:32.099><c> much</c><00:00:32.369><c> March</c><00:00:32.759><c> sales</c><00:00:33.180><c> there</c><00:00:33.540><c> were</c><00:00:33.719><c> or</c><00:00:34.050><c> which</c>

00:00:34.729 --> 00:00:34.739 align:start position:0%
how much March sales there were or which
 

00:00:34.739 --> 00:00:36.770 align:start position:0%
how much March sales there were or which
account<00:00:35.130><c> bought</c><00:00:35.370><c> the</c><00:00:35.579><c> most</c><00:00:35.820><c> emergen</c><00:00:36.329><c> dice</c><00:00:36.510><c> a</c>

00:00:36.770 --> 00:00:36.780 align:start position:0%
account bought the most emergen dice a
 

00:00:36.780 --> 00:00:38.930 align:start position:0%
account bought the most emergen dice a
pivot<00:00:37.500><c> table</c><00:00:37.710><c> would</c><00:00:38.040><c> help</c><00:00:38.280><c> me</c><00:00:38.399><c> answer</c><00:00:38.790><c> these</c>

00:00:38.930 --> 00:00:38.940 align:start position:0%
pivot table would help me answer these
 

00:00:38.940 --> 00:00:42.170 align:start position:0%
pivot table would help me answer these
questions<00:00:39.420><c> quickly</c><00:00:40.129><c> sure</c><00:00:41.129><c> I</c><00:00:41.460><c> might</c><00:00:41.879><c> be</c><00:00:42.059><c> able</c>

00:00:42.170 --> 00:00:42.180 align:start position:0%
questions quickly sure I might be able
 

00:00:42.180 --> 00:00:44.150 align:start position:0%
questions quickly sure I might be able
to<00:00:42.360><c> find</c><00:00:42.660><c> the</c><00:00:42.809><c> answers</c><00:00:43.200><c> by</c><00:00:43.230><c> creating</c><00:00:43.829><c> a</c><00:00:43.890><c> chart</c>

00:00:44.150 --> 00:00:44.160 align:start position:0%
to find the answers by creating a chart
 

00:00:44.160 --> 00:00:47.060 align:start position:0%
to find the answers by creating a chart
or<00:00:44.489><c> sorting</c><00:00:45.090><c> but</c><00:00:45.690><c> pivot</c><00:00:46.050><c> table</c><00:00:46.379><c> reports</c><00:00:46.829><c> give</c>

00:00:47.060 --> 00:00:47.070 align:start position:0%
or sorting but pivot table reports give
 

00:00:47.070 --> 00:00:49.190 align:start position:0%
or sorting but pivot table reports give
you<00:00:47.190><c> power</c><00:00:47.460><c> because</c><00:00:48.270><c> you</c><00:00:48.360><c> can</c><00:00:48.510><c> quickly</c><00:00:48.809><c> find</c>

00:00:49.190 --> 00:00:49.200 align:start position:0%
you power because you can quickly find
 

00:00:49.200 --> 00:00:52.959 align:start position:0%
you power because you can quickly find
the<00:00:49.379><c> answer</c><00:00:49.770><c> to</c><00:00:49.800><c> many</c><00:00:50.100><c> different</c><00:00:50.340><c> questions</c>

00:00:52.959 --> 00:00:52.969 align:start position:0%
 
 

00:00:52.969 --> 00:00:56.270 align:start position:0%
 
pivot<00:00:53.969><c> table</c><00:00:54.270><c> reports</c><00:00:54.780><c> or</c><00:00:55.079><c> pivot</c><00:00:55.649><c> tables</c><00:00:56.070><c> as</c>

00:00:56.270 --> 00:00:56.280 align:start position:0%
pivot table reports or pivot tables as
 

00:00:56.280 --> 00:00:58.520 align:start position:0%
pivot table reports or pivot tables as
they<00:00:56.789><c> are</c><00:00:56.910><c> usually</c><00:00:57.120><c> called</c><00:00:57.329><c> can</c><00:00:58.140><c> help</c><00:00:58.379><c> you</c>

00:00:58.520 --> 00:00:58.530 align:start position:0%
they are usually called can help you
 

00:00:58.530 --> 00:01:00.319 align:start position:0%
they are usually called can help you
answer<00:00:58.770><c> questions</c><00:00:59.070><c> about</c><00:00:59.430><c> your</c><00:00:59.760><c> spreadsheets</c>

00:01:00.319 --> 00:01:00.329 align:start position:0%
answer questions about your spreadsheets
 

00:01:00.329 --> 00:01:02.090 align:start position:0%
answer questions about your spreadsheets
by<00:01:00.510><c> analyzing</c><00:01:01.170><c> the</c><00:01:01.260><c> numerical</c><00:01:01.859><c> information</c>

00:01:02.090 --> 00:01:02.100 align:start position:0%
by analyzing the numerical information
 

00:01:02.100 --> 00:01:07.399 align:start position:0%
by analyzing the numerical information
in<00:01:02.609><c> various</c><00:01:02.969><c> ways</c><00:01:05.030><c> to</c><00:01:06.030><c> create</c><00:01:06.420><c> a</c><00:01:06.659><c> pivot</c><00:01:06.900><c> table</c>

00:01:07.399 --> 00:01:07.409 align:start position:0%
in various ways to create a pivot table
 

00:01:07.409 --> 00:01:09.289 align:start position:0%
in various ways to create a pivot table
place<00:01:07.830><c> your</c><00:01:08.100><c> cursor</c><00:01:08.130><c> anywhere</c><00:01:08.549><c> in</c><00:01:09.150><c> the</c>

00:01:09.289 --> 00:01:09.299 align:start position:0%
place your cursor anywhere in the
 

00:01:09.299 --> 00:01:11.810 align:start position:0%
place your cursor anywhere in the
spreadsheet<00:01:09.840><c> data</c><00:01:10.110><c> or</c><00:01:10.439><c> select</c><00:01:11.310><c> the</c><00:01:11.520><c> data</c><00:01:11.729><c> you</c>

00:01:11.810 --> 00:01:11.820 align:start position:0%
spreadsheet data or select the data you
 

00:01:11.820 --> 00:01:17.690 align:start position:0%
spreadsheet data or select the data you
want<00:01:12.090><c> to</c><00:01:12.210><c> use</c><00:01:12.600><c> in</c><00:01:12.810><c> the</c><00:01:12.900><c> report</c><00:01:15.890><c> now</c><00:01:16.890><c> select</c><00:01:17.400><c> the</c>

00:01:17.690 --> 00:01:17.700 align:start position:0%
want to use in the report now select the
 

00:01:17.700 --> 00:01:21.170 align:start position:0%
want to use in the report now select the
insert<00:01:18.060><c> tab</c><00:01:18.119><c> and</c><00:01:18.780><c> the</c><00:01:19.619><c> tables</c><00:01:20.100><c> group</c><00:01:20.610><c> click</c>

00:01:21.170 --> 00:01:21.180 align:start position:0%
insert tab and the tables group click
 

00:01:21.180 --> 00:01:24.770 align:start position:0%
insert tab and the tables group click
pivot<00:01:21.869><c> table</c><00:01:22.530><c> and</c><00:01:22.770><c> then</c><00:01:23.369><c> click</c><00:01:23.729><c> pivot</c><00:01:24.119><c> table</c>

00:01:24.770 --> 00:01:24.780 align:start position:0%
pivot table and then click pivot table
 

00:01:24.780 --> 00:01:31.340 align:start position:0%
pivot table and then click pivot table
again<00:01:28.369><c> Excel</c><00:01:29.369><c> selects</c><00:01:29.970><c> cells</c><00:01:30.390><c> in</c><00:01:30.810><c> the</c><00:01:30.990><c> actual</c>

00:01:31.340 --> 00:01:31.350 align:start position:0%
again Excel selects cells in the actual
 

00:01:31.350 --> 00:01:34.130 align:start position:0%
again Excel selects cells in the actual
spreadsheet<00:01:31.979><c> and</c><00:01:32.220><c> the</c><00:01:32.850><c> create</c><00:01:33.210><c> pivot</c><00:01:33.810><c> table</c>

00:01:34.130 --> 00:01:34.140 align:start position:0%
spreadsheet and the create pivot table
 

00:01:34.140 --> 00:01:40.640 align:start position:0%
spreadsheet and the create pivot table
dialog<00:01:34.680><c> box</c><00:01:35.040><c> opens</c><00:01:38.000><c> select</c><00:01:39.000><c> a</c><00:01:39.420><c> table</c><00:01:39.750><c> or</c><00:01:40.200><c> range</c>

00:01:40.640 --> 00:01:40.650 align:start position:0%
dialog box opens select a table or range
 

00:01:40.650 --> 00:01:43.399 align:start position:0%
dialog box opens select a table or range
is<00:01:41.009><c> already</c><00:01:41.490><c> selected</c><00:01:41.729><c> and</c><00:01:42.329><c> the</c><00:01:42.780><c> table</c><00:01:43.200><c> range</c>

00:01:43.399 --> 00:01:43.409 align:start position:0%
is already selected and the table range
 

00:01:43.409 --> 00:01:45.800 align:start position:0%
is already selected and the table range
field<00:01:43.860><c> shows</c><00:01:44.280><c> the</c><00:01:44.310><c> range</c><00:01:44.850><c> of</c><00:01:45.180><c> the</c><00:01:45.270><c> selected</c>

00:01:45.800 --> 00:01:45.810 align:start position:0%
field shows the range of the selected
 

00:01:45.810 --> 00:01:49.460 align:start position:0%
field shows the range of the selected
data<00:01:46.759><c> new</c><00:01:47.759><c> worksheets</c><00:01:48.420><c> is</c><00:01:48.570><c> also</c><00:01:48.960><c> selected</c><00:01:49.140><c> by</c>

00:01:49.460 --> 00:01:49.470 align:start position:0%
data new worksheets is also selected by
 

00:01:49.470 --> 00:01:51.620 align:start position:0%
data new worksheets is also selected by
default<00:01:49.619><c> as</c><00:01:50.280><c> the</c><00:01:50.549><c> place</c><00:01:50.880><c> where</c><00:01:50.909><c> the</c><00:01:51.149><c> reports</c>

00:01:51.620 --> 00:01:51.630 align:start position:0%
default as the place where the reports
 

00:01:51.630 --> 00:01:54.380 align:start position:0%
default as the place where the reports
will<00:01:51.810><c> be</c><00:01:51.840><c> placed</c><00:01:52.290><c> if</c><00:01:52.619><c> you</c><00:01:53.549><c> do</c><00:01:53.700><c> not</c><00:01:53.820><c> want</c><00:01:54.240><c> the</c>

00:01:54.380 --> 00:01:54.390 align:start position:0%
will be placed if you do not want the
 

00:01:54.390 --> 00:01:56.420 align:start position:0%
will be placed if you do not want the
pivot<00:01:54.659><c> table</c><00:01:54.810><c> to</c><00:01:55.079><c> appear</c><00:01:55.500><c> in</c><00:01:55.619><c> a</c><00:01:55.710><c> new</c><00:01:55.920><c> worksheet</c>

00:01:56.420 --> 00:01:56.430 align:start position:0%
pivot table to appear in a new worksheet
 

00:01:56.430 --> 00:01:59.020 align:start position:0%
pivot table to appear in a new worksheet
just<00:01:57.149><c> click</c><00:01:57.450><c> existing</c><00:01:58.170><c> worksheets</c><00:01:58.770><c> and</c>

00:01:59.020 --> 00:01:59.030 align:start position:0%
just click existing worksheets and
 

00:01:59.030 --> 00:02:03.380 align:start position:0%
just click existing worksheets and
select<00:02:00.030><c> the</c><00:02:00.299><c> name</c><00:02:00.600><c> of</c><00:02:00.869><c> the</c><00:02:00.990><c> sheet</c><00:02:02.149><c> we'll</c><00:02:03.149><c> just</c>

00:02:03.380 --> 00:02:03.390 align:start position:0%
select the name of the sheet we'll just
 

00:02:03.390 --> 00:02:08.050 align:start position:0%
select the name of the sheet we'll just
leave<00:02:03.570><c> this</c><00:02:03.810><c> as</c><00:02:04.020><c> new</c><00:02:04.229><c> worksheet</c><00:02:05.990><c> click</c><00:02:06.990><c> OK</c><00:02:07.500><c> and</c>

00:02:08.050 --> 00:02:08.060 align:start position:0%
leave this as new worksheet click OK and
 

00:02:08.060 --> 00:02:12.910 align:start position:0%
leave this as new worksheet click OK and
the<00:02:09.060><c> pivot</c><00:02:09.420><c> table</c><00:02:09.599><c> appears</c><00:02:10.200><c> in</c><00:02:10.349><c> a</c><00:02:10.410><c> new</c><00:02:10.619><c> sheet</c>

00:02:12.910 --> 00:02:12.920 align:start position:0%
the pivot table appears in a new sheet
 

00:02:12.920 --> 00:02:15.340 align:start position:0%
the pivot table appears in a new sheet
let's<00:02:13.700><c> go</c><00:02:13.940><c> ahead</c><00:02:14.270><c> and</c><00:02:14.450><c> name</c><00:02:14.660><c> this</c><00:02:14.960><c> sheets</c>

00:02:15.340 --> 00:02:15.350 align:start position:0%
let's go ahead and name this sheets
 

00:02:15.350 --> 00:02:20.980 align:start position:0%
let's go ahead and name this sheets
pivot<00:02:15.890><c> table</c><00:02:17.560><c> if</c><00:02:18.850><c> this</c><00:02:19.850><c> is</c><00:02:20.000><c> your</c><00:02:20.150><c> first</c><00:02:20.480><c> look</c>

00:02:20.980 --> 00:02:20.990 align:start position:0%
pivot table if this is your first look
 

00:02:20.990 --> 00:02:22.809 align:start position:0%
pivot table if this is your first look
at<00:02:21.200><c> a</c><00:02:21.260><c> pivot</c><00:02:21.650><c> table</c><00:02:21.800><c> you're</c><00:02:22.490><c> probably</c>

00:02:22.809 --> 00:02:22.819 align:start position:0%
at a pivot table you're probably
 

00:02:22.819 --> 00:02:24.840 align:start position:0%
at a pivot table you're probably
wondering<00:02:23.510><c> why</c><00:02:23.630><c> they're</c><00:02:23.840><c> named</c><00:02:24.080><c> that</c>

00:02:24.840 --> 00:02:24.850 align:start position:0%
wondering why they're named that
 

00:02:24.850 --> 00:02:27.730 align:start position:0%
wondering why they're named that
basically<00:02:25.850><c> pivot</c><00:02:26.450><c> tables</c><00:02:26.840><c> allow</c><00:02:27.110><c> us</c><00:02:27.319><c> to</c><00:02:27.500><c> pivot</c>

00:02:27.730 --> 00:02:27.740 align:start position:0%
basically pivot tables allow us to pivot
 

00:02:27.740 --> 00:02:30.880 align:start position:0%
basically pivot tables allow us to pivot
or<00:02:28.069><c> move</c><00:02:28.459><c> data</c><00:02:29.090><c> so</c><00:02:29.810><c> you</c><00:02:29.870><c> can</c><00:02:29.959><c> produce</c><00:02:30.260><c> answers</c>

00:02:30.880 --> 00:02:30.890 align:start position:0%
or move data so you can produce answers
 

00:02:30.890 --> 00:02:35.140 align:start position:0%
or move data so you can produce answers
to<00:02:31.130><c> questions</c><00:02:31.640><c> you</c><00:02:32.920><c> can</c><00:02:33.920><c> very</c><00:02:34.280><c> easily</c><00:02:34.640><c> see</c>

00:02:35.140 --> 00:02:35.150 align:start position:0%
to questions you can very easily see
 

00:02:35.150 --> 00:02:38.530 align:start position:0%
to questions you can very easily see
what<00:02:35.600><c> effect</c><00:02:36.230><c> pivoting</c><00:02:36.950><c> the</c><00:02:37.100><c> data</c><00:02:37.370><c> has</c><00:02:38.090><c> on</c><00:02:38.420><c> the</c>

00:02:38.530 --> 00:02:38.540 align:start position:0%
what effect pivoting the data has on the
 

00:02:38.540 --> 00:02:42.729 align:start position:0%
what effect pivoting the data has on the
spreadsheets<00:02:39.170><c> information</c><00:02:39.950><c> if</c><00:02:41.200><c> we</c><00:02:42.200><c> look</c><00:02:42.620><c> at</c>

00:02:42.729 --> 00:02:42.739 align:start position:0%
spreadsheets information if we look at
 

00:02:42.739 --> 00:02:47.080 align:start position:0%
spreadsheets information if we look at
our<00:02:42.860><c> actual</c><00:02:43.520><c> spreadsheet</c><00:02:45.550><c> we</c><00:02:46.550><c> can</c><00:02:46.760><c> see</c><00:02:46.970><c> that</c>

00:02:47.080 --> 00:02:47.090 align:start position:0%
our actual spreadsheet we can see that
 

00:02:47.090 --> 00:02:49.590 align:start position:0%
our actual spreadsheet we can see that
our<00:02:47.239><c> column</c><00:02:47.840><c> headings</c><00:02:48.320><c> are</c><00:02:48.500><c> salesperson</c>

00:02:49.590 --> 00:02:49.600 align:start position:0%
our column headings are salesperson
 

00:02:49.600 --> 00:02:54.750 align:start position:0%
our column headings are salesperson
region<00:02:50.600><c> account</c><00:02:51.730><c> order</c><00:02:52.730><c> amount</c><00:02:53.209><c> and</c><00:02:53.540><c> month</c>

00:02:54.750 --> 00:02:54.760 align:start position:0%
region account order amount and month
 

00:02:54.760 --> 00:02:57.460 align:start position:0%
region account order amount and month
when<00:02:55.760><c> you</c><00:02:55.970><c> create</c><00:02:56.330><c> a</c><00:02:56.540><c> pivot</c><00:02:56.930><c> table</c><00:02:57.110><c> each</c>

00:02:57.460 --> 00:02:57.470 align:start position:0%
when you create a pivot table each
 

00:02:57.470 --> 00:03:00.130 align:start position:0%
when you create a pivot table each
column<00:02:58.160><c> label</c><00:02:58.580><c> in</c><00:02:58.760><c> your</c><00:02:58.940><c> data</c><00:02:59.239><c> becomes</c><00:03:00.019><c> a</c>

00:03:00.130 --> 00:03:00.140 align:start position:0%
column label in your data becomes a
 

00:03:00.140 --> 00:03:03.960 align:start position:0%
column label in your data becomes a
field<00:03:00.530><c> that</c><00:03:01.010><c> can</c><00:03:01.130><c> be</c><00:03:01.280><c> used</c><00:03:01.730><c> in</c><00:03:01.910><c> the</c><00:03:02.120><c> report</c>

00:03:03.960 --> 00:03:03.970 align:start position:0%
field that can be used in the report
 

00:03:03.970 --> 00:03:09.240 align:start position:0%
field that can be used in the report
let's<00:03:04.970><c> take</c><00:03:05.330><c> a</c><00:03:05.360><c> look</c><00:03:05.690><c> at</c><00:03:05.780><c> the</c><00:03:05.870><c> pivot</c><00:03:06.170><c> table</c><00:03:06.880><c> on</c>

00:03:09.240 --> 00:03:09.250 align:start position:0%
let's take a look at the pivot table on
 

00:03:09.250 --> 00:03:12.610 align:start position:0%
let's take a look at the pivot table on
one<00:03:10.250><c> side</c><00:03:10.670><c> is</c><00:03:11.030><c> the</c><00:03:11.209><c> layout</c><00:03:11.480><c> area</c><00:03:12.080><c> for</c><00:03:12.560><c> the</c>

00:03:12.610 --> 00:03:12.620 align:start position:0%
one side is the layout area for the
 

00:03:12.620 --> 00:03:15.370 align:start position:0%
one side is the layout area for the
report<00:03:13.040><c> and</c><00:03:13.370><c> on</c><00:03:14.000><c> the</c><00:03:14.150><c> other</c><00:03:14.300><c> side</c><00:03:14.510><c> is</c><00:03:15.200><c> the</c>

00:03:15.370 --> 00:03:15.380 align:start position:0%
report and on the other side is the
 

00:03:15.380 --> 00:03:20.140 align:start position:0%
report and on the other side is the
pivot<00:03:15.709><c> table</c><00:03:15.920><c> field</c><00:03:16.370><c> list</c><00:03:18.070><c> this</c><00:03:19.070><c> list</c><00:03:19.640><c> shows</c>

00:03:20.140 --> 00:03:20.150 align:start position:0%
pivot table field list this list shows
 

00:03:20.150 --> 00:03:25.530 align:start position:0%
pivot table field list this list shows
the<00:03:20.209><c> column</c><00:03:20.780><c> titles</c><00:03:21.320><c> from</c><00:03:21.620><c> the</c><00:03:21.709><c> source</c><00:03:22.010><c> data</c>

00:03:25.530 --> 00:03:25.540 align:start position:0%
 
 

00:03:25.540 --> 00:03:28.569 align:start position:0%
 
before<00:03:26.540><c> you</c><00:03:26.900><c> create</c><00:03:27.110><c> a</c><00:03:27.440><c> pivot</c><00:03:27.829><c> table</c><00:03:27.980><c> report</c>

00:03:28.569 --> 00:03:28.579 align:start position:0%
before you create a pivot table report
 

00:03:28.579 --> 00:03:31.770 align:start position:0%
before you create a pivot table report
decide<00:03:29.360><c> what</c><00:03:29.780><c> information</c><00:03:29.959><c> you</c><00:03:30.500><c> want</c><00:03:30.739><c> to</c><00:03:30.799><c> find</c>

00:03:31.770 --> 00:03:31.780 align:start position:0%
decide what information you want to find
 

00:03:31.780 --> 00:03:35.740 align:start position:0%
decide what information you want to find
for<00:03:32.780><c> example</c><00:03:32.810><c> in</c><00:03:33.590><c> this</c><00:03:34.430><c> spreadsheet</c><00:03:34.970><c> let's</c>

00:03:35.740 --> 00:03:35.750 align:start position:0%
for example in this spreadsheet let's
 

00:03:35.750 --> 00:03:38.380 align:start position:0%
for example in this spreadsheet let's
find<00:03:36.049><c> out</c><00:03:36.260><c> how</c><00:03:36.500><c> much</c><00:03:36.860><c> each</c><00:03:37.130><c> salesperson</c><00:03:37.760><c> sold</c>

00:03:38.380 --> 00:03:38.390 align:start position:0%
find out how much each salesperson sold
 

00:03:38.390 --> 00:03:41.020 align:start position:0%
find out how much each salesperson sold
to<00:03:39.230><c> answer</c><00:03:39.680><c> this</c><00:03:39.829><c> question</c><00:03:40.040><c> we're</c><00:03:40.730><c> going</c><00:03:40.910><c> to</c>

00:03:41.020 --> 00:03:41.030 align:start position:0%
to answer this question we're going to
 

00:03:41.030 --> 00:03:42.819 align:start position:0%
to answer this question we're going to
need<00:03:41.269><c> information</c><00:03:42.019><c> about</c><00:03:42.140><c> the</c><00:03:42.350><c> salespeople</c>

00:03:42.819 --> 00:03:42.829 align:start position:0%
need information about the salespeople
 

00:03:42.829 --> 00:03:48.370 align:start position:0%
need information about the salespeople
and<00:03:43.190><c> the</c><00:03:43.790><c> order</c><00:03:44.150><c> amounts</c><00:03:46.660><c> to</c><00:03:47.660><c> create</c><00:03:47.989><c> this</c>

00:03:48.370 --> 00:03:48.380 align:start position:0%
and the order amounts to create this
 

00:03:48.380 --> 00:03:50.740 align:start position:0%
and the order amounts to create this
report<00:03:48.860><c> we</c><00:03:49.220><c> need</c><00:03:49.459><c> to</c><00:03:49.579><c> select</c><00:03:49.940><c> the</c><00:03:50.209><c> checkbox</c>

00:03:50.740 --> 00:03:50.750 align:start position:0%
report we need to select the checkbox
 

00:03:50.750 --> 00:03:52.870 align:start position:0%
report we need to select the checkbox
next<00:03:50.930><c> to</c><00:03:51.380><c> the</c><00:03:51.530><c> salesperson</c><00:03:51.890><c> field</c><00:03:52.489><c> in</c><00:03:52.790><c> the</c>

00:03:52.870 --> 00:03:52.880 align:start position:0%
next to the salesperson field in the
 

00:03:52.880 --> 00:03:56.080 align:start position:0%
next to the salesperson field in the
pivot<00:03:53.209><c> table</c><00:03:53.390><c> fields</c><00:03:53.930><c> a</c><00:03:53.989><c> list</c><00:03:54.260><c> and</c><00:03:55.090><c> then</c>

00:03:56.080 --> 00:03:56.090 align:start position:0%
pivot table fields a list and then
 

00:03:56.090 --> 00:03:58.900 align:start position:0%
pivot table fields a list and then
select<00:03:56.630><c> the</c><00:03:56.900><c> check</c><00:03:56.930><c> box</c><00:03:57.560><c> next</c><00:03:57.860><c> to</c><00:03:58.370><c> the</c><00:03:58.549><c> order</c>

00:03:58.900 --> 00:03:58.910 align:start position:0%
select the check box next to the order
 

00:03:58.910 --> 00:04:04.300 align:start position:0%
select the check box next to the order
amount<00:03:59.060><c> field</c><00:03:59.780><c> and</c><00:04:02.110><c> just</c><00:04:03.110><c> like</c><00:04:03.290><c> that</c><00:04:03.560><c> we</c><00:04:04.130><c> can</c>

00:04:04.300 --> 00:04:04.310 align:start position:0%
amount field and just like that we can
 

00:04:04.310 --> 00:04:07.060 align:start position:0%
amount field and just like that we can
see<00:04:04.519><c> how</c><00:04:04.760><c> much</c><00:04:05.030><c> each</c><00:04:05.269><c> person</c><00:04:05.360><c> sold</c><00:04:06.140><c> and</c><00:04:06.440><c> how</c>

00:04:07.060 --> 00:04:07.070 align:start position:0%
see how much each person sold and how
 

00:04:07.070 --> 00:04:11.920 align:start position:0%
see how much each person sold and how
much<00:04:07.310><c> was</c><00:04:07.489><c> sold</c><00:04:07.730><c> total</c><00:04:08.390><c> I</c><00:04:10.780><c> didn't</c><00:04:11.780><c> select</c>

00:04:11.920 --> 00:04:11.930 align:start position:0%
much was sold total I didn't select
 

00:04:11.930 --> 00:04:13.960 align:start position:0%
much was sold total I didn't select
these<00:04:12.410><c> other</c><00:04:12.620><c> fields</c><00:04:13.160><c> because</c><00:04:13.370><c> I</c><00:04:13.430><c> didn't</c><00:04:13.700><c> need</c>

00:04:13.960 --> 00:04:13.970 align:start position:0%
these other fields because I didn't need
 

00:04:13.970 --> 00:04:16.000 align:start position:0%
these other fields because I didn't need
them<00:04:14.180><c> to</c><00:04:14.329><c> answer</c><00:04:14.660><c> this</c><00:04:14.870><c> question</c><00:04:15.079><c> and</c><00:04:15.650><c> build</c><00:04:15.920><c> a</c>

00:04:16.000 --> 00:04:16.010 align:start position:0%
them to answer this question and build a
 

00:04:16.010 --> 00:04:20.000 align:start position:0%
them to answer this question and build a
report

00:04:20.000 --> 00:04:20.010 align:start position:0%
 
 

00:04:20.010 --> 00:04:23.189 align:start position:0%
 
now<00:04:21.010><c> let's</c><00:04:21.850><c> look</c><00:04:22.120><c> a</c><00:04:22.240><c> little</c><00:04:22.449><c> closer</c><00:04:22.810><c> at</c><00:04:23.110><c> the</c>

00:04:23.189 --> 00:04:23.199 align:start position:0%
now let's look a little closer at the
 

00:04:23.199 --> 00:04:25.890 align:start position:0%
now let's look a little closer at the
PivotTable<00:04:24.060><c> you'll</c><00:04:25.060><c> notice</c><00:04:25.480><c> that</c><00:04:25.630><c> each</c><00:04:25.870><c> of</c>

00:04:25.890 --> 00:04:25.900 align:start position:0%
PivotTable you'll notice that each of
 

00:04:25.900 --> 00:04:28.469 align:start position:0%
PivotTable you'll notice that each of
the<00:04:26.230><c> selected</c><00:04:26.800><c> fields</c><00:04:27.280><c> appears</c><00:04:27.730><c> in</c><00:04:27.940><c> a</c><00:04:28.000><c> default</c>

00:04:28.469 --> 00:04:28.479 align:start position:0%
the selected fields appears in a default
 

00:04:28.479 --> 00:04:34.500 align:start position:0%
the selected fields appears in a default
area<00:04:28.840><c> below</c><00:04:29.410><c> and</c><00:04:30.690><c> in</c><00:04:31.690><c> the</c><00:04:31.810><c> layouts</c><00:04:32.199><c> area</c><00:04:33.510><c> all</c>

00:04:34.500 --> 00:04:34.510 align:start position:0%
area below and in the layouts area all
 

00:04:34.510 --> 00:04:36.960 align:start position:0%
area below and in the layouts area all
my<00:04:34.570><c> cells</c><00:04:35.229><c> people</c><00:04:35.470><c> data</c><00:04:35.860><c> appears</c><00:04:36.400><c> on</c><00:04:36.580><c> the</c><00:04:36.699><c> left</c>

00:04:36.960 --> 00:04:36.970 align:start position:0%
my cells people data appears on the left
 

00:04:36.970 --> 00:04:40.230 align:start position:0%
my cells people data appears on the left
side<00:04:37.419><c> as</c><00:04:37.810><c> rows</c><00:04:38.110><c> and</c><00:04:38.560><c> the</c><00:04:39.070><c> order</c><00:04:39.430><c> amounts</c><00:04:39.940><c> data</c>

00:04:40.230 --> 00:04:40.240 align:start position:0%
side as rows and the order amounts data
 

00:04:40.240 --> 00:04:43.469 align:start position:0%
side as rows and the order amounts data
appears<00:04:40.720><c> on</c><00:04:40.930><c> the</c><00:04:41.020><c> right</c><00:04:41.790><c> this</c><00:04:42.790><c> is</c><00:04:42.850><c> a</c><00:04:43.030><c> default</c>

00:04:43.469 --> 00:04:43.479 align:start position:0%
appears on the right this is a default
 

00:04:43.479 --> 00:04:46.230 align:start position:0%
appears on the right this is a default
setting<00:04:43.900><c> in</c><00:04:43.990><c> Excel</c><00:04:44.410><c> data</c><00:04:45.370><c> with</c><00:04:45.610><c> numbers</c><00:04:46.090><c> will</c>

00:04:46.230 --> 00:04:46.240 align:start position:0%
setting in Excel data with numbers will
 

00:04:46.240 --> 00:04:50.760 align:start position:0%
setting in Excel data with numbers will
always<00:04:46.780><c> appear</c><00:04:47.139><c> on</c><00:04:47.290><c> the</c><00:04:47.410><c> right</c><00:04:49.350><c> the</c><00:04:50.350><c> heading</c>

00:04:50.760 --> 00:04:50.770 align:start position:0%
always appear on the right the heading
 

00:04:50.770 --> 00:04:53.909 align:start position:0%
always appear on the right the heading
says<00:04:50.979><c> sum</c><00:04:51.729><c> of</c><00:04:52.060><c> order</c><00:04:52.450><c> amount</c><00:04:52.840><c> because</c><00:04:53.440><c> Excel</c>

00:04:53.909 --> 00:04:53.919 align:start position:0%
says sum of order amount because Excel
 

00:04:53.919 --> 00:04:57.030 align:start position:0%
says sum of order amount because Excel
uses<00:04:54.340><c> the</c><00:04:54.460><c> sum</c><00:04:54.729><c> function</c><00:04:55.150><c> to</c><00:04:55.930><c> add</c><00:04:56.110><c> up</c><00:04:56.440><c> fields</c>

00:04:57.030 --> 00:04:57.040 align:start position:0%
uses the sum function to add up fields
 

00:04:57.040 --> 00:05:01.170 align:start position:0%
uses the sum function to add up fields
with<00:04:57.340><c> numbers</c><00:04:59.160><c> awesome</c><00:05:00.160><c> if</c><00:05:00.370><c> you</c><00:05:00.520><c> decide</c><00:05:00.880><c> you</c>

00:05:01.170 --> 00:05:01.180 align:start position:0%
with numbers awesome if you decide you
 

00:05:01.180 --> 00:05:03.690 align:start position:0%
with numbers awesome if you decide you
don't<00:05:01.360><c> want</c><00:05:01.540><c> a</c><00:05:01.870><c> field</c><00:05:02.200><c> in</c><00:05:02.380><c> a</c><00:05:02.470><c> report</c><00:05:02.889><c> just</c>

00:05:03.690 --> 00:05:03.700 align:start position:0%
don't want a field in a report just
 

00:05:03.700 --> 00:05:06.090 align:start position:0%
don't want a field in a report just
clear<00:05:04.030><c> the</c><00:05:04.180><c> checkbox</c><00:05:04.810><c> next</c><00:05:05.320><c> to</c><00:05:05.500><c> the</c><00:05:05.650><c> field</c><00:05:05.919><c> a</c>

00:05:06.090 --> 00:05:06.100 align:start position:0%
clear the checkbox next to the field a
 

00:05:06.100 --> 00:05:10.770 align:start position:0%
clear the checkbox next to the field a
name<00:05:06.400><c> by</c><00:05:06.790><c> clicking</c><00:05:07.240><c> it</c><00:05:08.880><c> now</c><00:05:09.880><c> you</c><00:05:10.450><c> can</c><00:05:10.630><c> use</c>

00:05:10.770 --> 00:05:10.780 align:start position:0%
name by clicking it now you can use
 

00:05:10.780 --> 00:05:12.620 align:start position:0%
name by clicking it now you can use
pivot<00:05:11.050><c> tables</c><00:05:11.470><c> to</c><00:05:11.560><c> answer</c><00:05:11.889><c> just</c><00:05:12.250><c> one</c><00:05:12.370><c> question</c>

00:05:12.620 --> 00:05:12.630 align:start position:0%
pivot tables to answer just one question
 

00:05:12.630 --> 00:05:15.480 align:start position:0%
pivot tables to answer just one question
but<00:05:13.630><c> I</c><00:05:13.690><c> want</c><00:05:14.080><c> you</c><00:05:14.200><c> to</c><00:05:14.229><c> see</c><00:05:14.530><c> how</c><00:05:14.680><c> quickly</c><00:05:15.100><c> it</c><00:05:15.400><c> can</c>

00:05:15.480 --> 00:05:15.490 align:start position:0%
but I want you to see how quickly it can
 

00:05:15.490 --> 00:05:17.719 align:start position:0%
but I want you to see how quickly it can
be<00:05:15.550><c> used</c><00:05:15.880><c> to</c><00:05:16.000><c> answer</c><00:05:16.180><c> multiple</c><00:05:16.960><c> questions</c>

00:05:17.719 --> 00:05:17.729 align:start position:0%
be used to answer multiple questions
 

00:05:17.729 --> 00:05:20.430 align:start position:0%
be used to answer multiple questions
what<00:05:18.729><c> if</c><00:05:18.820><c> we</c><00:05:18.940><c> wanted</c><00:05:19.210><c> to</c><00:05:19.330><c> know</c><00:05:19.479><c> how</c><00:05:19.810><c> much</c><00:05:20.110><c> was</c>

00:05:20.430 --> 00:05:20.440 align:start position:0%
what if we wanted to know how much was
 

00:05:20.440 --> 00:05:25.290 align:start position:0%
what if we wanted to know how much was
sold<00:05:20.740><c> in</c><00:05:21.070><c> each</c><00:05:21.400><c> region</c><00:05:22.120><c> to</c><00:05:23.639><c> answer</c><00:05:24.639><c> this</c><00:05:24.940><c> ad</c>

00:05:25.290 --> 00:05:25.300 align:start position:0%
sold in each region to answer this ad
 

00:05:25.300 --> 00:05:29.909 align:start position:0%
sold in each region to answer this ad
the<00:05:25.840><c> region</c><00:05:26.229><c> field</c><00:05:26.530><c> as</c><00:05:26.830><c> a</c><00:05:26.860><c> report</c><00:05:27.340><c> filter</c><00:05:28.919><c> just</c>

00:05:29.909 --> 00:05:29.919 align:start position:0%
the region field as a report filter just
 

00:05:29.919 --> 00:05:33.810 align:start position:0%
the region field as a report filter just
click<00:05:30.250><c> the</c><00:05:30.430><c> region</c><00:05:30.850><c> field</c><00:05:31.210><c> in</c><00:05:31.510><c> the</c><00:05:31.690><c> list</c><00:05:32.820><c> by</c>

00:05:33.810 --> 00:05:33.820 align:start position:0%
click the region field in the list by
 

00:05:33.820 --> 00:05:36.450 align:start position:0%
click the region field in the list by
default<00:05:34.419><c> it</c><00:05:34.720><c> will</c><00:05:34.960><c> appear</c><00:05:35.349><c> in</c><00:05:35.470><c> the</c><00:05:35.590><c> row</c><00:05:35.800><c> labels</c>

00:05:36.450 --> 00:05:36.460 align:start position:0%
default it will appear in the row labels
 

00:05:36.460 --> 00:05:40.680 align:start position:0%
default it will appear in the row labels
group<00:05:38.070><c> left</c><00:05:39.070><c> click</c><00:05:39.430><c> and</c><00:05:39.639><c> drag</c><00:05:39.729><c> it</c><00:05:40.270><c> into</c><00:05:40.300><c> the</c>

00:05:40.680 --> 00:05:40.690 align:start position:0%
group left click and drag it into the
 

00:05:40.690 --> 00:05:44.940 align:start position:0%
group left click and drag it into the
reports<00:05:41.139><c> filter</c><00:05:41.560><c> section</c><00:05:43.349><c> release</c><00:05:44.349><c> the</c><00:05:44.710><c> mouse</c>

00:05:44.940 --> 00:05:44.950 align:start position:0%
reports filter section release the mouse
 

00:05:44.950 --> 00:05:46.550 align:start position:0%
reports filter section release the mouse
button

00:05:46.550 --> 00:05:46.560 align:start position:0%
button
 

00:05:46.560 --> 00:05:49.620 align:start position:0%
button
now<00:05:47.560><c> region</c><00:05:48.340><c> appears</c><00:05:48.789><c> at</c><00:05:48.970><c> the</c><00:05:49.060><c> top</c><00:05:49.090><c> of</c><00:05:49.539><c> the</c>

00:05:49.620 --> 00:05:49.630 align:start position:0%
now region appears at the top of the
 

00:05:49.630 --> 00:05:53.310 align:start position:0%
now region appears at the top of the
report<00:05:50.020><c> as</c><00:05:50.200><c> a</c><00:05:50.349><c> filter</c><00:05:51.510><c> the</c><00:05:52.510><c> arrow</c><00:05:52.750><c> by</c><00:05:53.260><c> the</c>

00:05:53.310 --> 00:05:53.320 align:start position:0%
report as a filter the arrow by the
 

00:05:53.320 --> 00:05:58.020 align:start position:0%
report as a filter the arrow by the
region<00:05:53.889><c> field</c><00:05:54.220><c> shows</c><00:05:55.710><c> to</c><00:05:56.710><c> show</c><00:05:56.740><c> just</c><00:05:57.490><c> the</c><00:05:57.669><c> data</c>

00:05:58.020 --> 00:05:58.030 align:start position:0%
region field shows to show just the data
 

00:05:58.030 --> 00:06:00.659 align:start position:0%
region field shows to show just the data
for<00:05:58.360><c> a</c><00:05:58.389><c> particular</c><00:05:58.570><c> region</c><00:05:59.229><c> click</c><00:06:00.190><c> the</c><00:06:00.400><c> drop</c>

00:06:00.659 --> 00:06:00.669 align:start position:0%
for a particular region click the drop
 

00:06:00.669 --> 00:06:04.409 align:start position:0%
for a particular region click the drop
down<00:06:00.700><c> arrow</c><00:06:01.330><c> and</c><00:06:01.750><c> select</c><00:06:02.110><c> the</c><00:06:02.590><c> region</c><00:06:03.210><c> to</c><00:06:04.210><c> see</c>

00:06:04.409 --> 00:06:04.419 align:start position:0%
down arrow and select the region to see
 

00:06:04.419 --> 00:06:06.450 align:start position:0%
down arrow and select the region to see
multiple<00:06:04.660><c> regions</c><00:06:05.380><c> click</c><00:06:05.830><c> the</c><00:06:06.010><c> multiple</c>

00:06:06.450 --> 00:06:06.460 align:start position:0%
multiple regions click the multiple
 

00:06:06.460 --> 00:06:09.120 align:start position:0%
multiple regions click the multiple
regions<00:06:06.820><c> box</c><00:06:07.440><c> select</c><00:06:08.440><c> the</c><00:06:08.560><c> regions</c><00:06:09.099><c> to</c>

00:06:09.120 --> 00:06:09.130 align:start position:0%
regions box select the regions to
 

00:06:09.130 --> 00:06:15.629 align:start position:0%
regions box select the regions to
display<00:06:09.639><c> and</c><00:06:10.020><c> then</c><00:06:11.020><c> click</c><00:06:11.830><c> OK</c><00:06:14.190><c> now</c><00:06:15.190><c> we</c><00:06:15.250><c> did</c>

00:06:15.629 --> 00:06:15.639 align:start position:0%
display and then click OK now we did
 

00:06:15.639 --> 00:06:17.610 align:start position:0%
display and then click OK now we did
talk<00:06:15.910><c> about</c><00:06:16.150><c> what</c><00:06:16.419><c> pivoting</c><00:06:16.840><c> means</c><00:06:17.110><c> and</c><00:06:17.440><c> how</c>

00:06:17.610 --> 00:06:17.620 align:start position:0%
talk about what pivoting means and how
 

00:06:17.620 --> 00:06:21.150 align:start position:0%
talk about what pivoting means and how
you<00:06:17.680><c> can</c><00:06:18.010><c> pivot</c><00:06:18.340><c> data</c><00:06:18.490><c> in</c><00:06:18.700><c> reports</c><00:06:19.210><c> in</c><00:06:20.160><c> this</c>

00:06:21.150 --> 00:06:21.160 align:start position:0%
you can pivot data in reports in this
 

00:06:21.160 --> 00:06:23.730 align:start position:0%
you can pivot data in reports in this
example<00:06:21.669><c> I</c><00:06:22.030><c> might</c><00:06:22.539><c> want</c><00:06:22.750><c> to</c><00:06:22.840><c> move</c><00:06:23.110><c> the</c><00:06:23.349><c> region</c>

00:06:23.730 --> 00:06:23.740 align:start position:0%
example I might want to move the region
 

00:06:23.740 --> 00:06:26.190 align:start position:0%
example I might want to move the region
filters<00:06:24.190><c> to</c><00:06:24.340><c> column</c><00:06:24.789><c> labels</c><00:06:25.270><c> so</c><00:06:26.080><c> the</c>

00:06:26.190 --> 00:06:26.200 align:start position:0%
filters to column labels so the
 

00:06:26.200 --> 00:06:27.600 align:start position:0%
filters to column labels so the
information<00:06:26.800><c> is</c><00:06:26.919><c> presented</c><00:06:27.099><c> in</c><00:06:27.490><c> a</c><00:06:27.580><c> different</c>

00:06:27.600 --> 00:06:27.610 align:start position:0%
information is presented in a different
 

00:06:27.610 --> 00:06:33.119 align:start position:0%
information is presented in a different
way<00:06:28.240><c> I</c><00:06:29.760><c> can</c><00:06:30.760><c> still</c><00:06:31.030><c> filter</c><00:06:31.780><c> and</c>

00:06:33.119 --> 00:06:33.129 align:start position:0%
way I can still filter and
 

00:06:33.129 --> 00:06:35.999 align:start position:0%
way I can still filter and
all<00:06:33.219><c> my</c><00:06:33.369><c> data</c><00:06:33.610><c> is</c><00:06:33.849><c> here</c><00:06:34.300><c> it's</c><00:06:35.139><c> just</c><00:06:35.439><c> organized</c>

00:06:35.999 --> 00:06:36.009 align:start position:0%
all my data is here it's just organized
 

00:06:36.009 --> 00:06:40.229 align:start position:0%
all my data is here it's just organized
in<00:06:36.219><c> a</c><00:06:36.279><c> different</c><00:06:36.669><c> way</c><00:06:36.909><c> I</c><00:06:38.339><c> can</c><00:06:39.339><c> do</c><00:06:39.550><c> this</c><00:06:39.729><c> by</c><00:06:39.879><c> left</c>

00:06:40.229 --> 00:06:40.239 align:start position:0%
in a different way I can do this by left
 

00:06:40.239 --> 00:06:42.299 align:start position:0%
in a different way I can do this by left
clicking<00:06:40.389><c> and</c><00:06:40.929><c> dragging</c><00:06:41.139><c> and</c><00:06:41.949><c> dropping</c>

00:06:42.299 --> 00:06:42.309 align:start position:0%
clicking and dragging and dropping
 

00:06:42.309 --> 00:06:48.600 align:start position:0%
clicking and dragging and dropping
region<00:06:43.149><c> in</c><00:06:43.360><c> the</c><00:06:43.989><c> column</c><00:06:44.379><c> labels</c><00:06:45.569><c> or</c><00:06:47.429><c> even</c><00:06:48.429><c> two</c>

00:06:48.600 --> 00:06:48.610 align:start position:0%
region in the column labels or even two
 

00:06:48.610 --> 00:06:52.769 align:start position:0%
region in the column labels or even two
values<00:06:50.009><c> each</c><00:06:51.009><c> just</c><00:06:51.699><c> changes</c><00:06:52.149><c> the</c><00:06:52.269><c> look</c><00:06:52.479><c> of</c><00:06:52.629><c> the</c>

00:06:52.769 --> 00:06:52.779 align:start position:0%
values each just changes the look of the
 

00:06:52.779 --> 00:06:57.479 align:start position:0%
values each just changes the look of the
report<00:06:55.229><c> another</c><00:06:56.229><c> way</c><00:06:56.469><c> to</c><00:06:56.529><c> pivot</c><00:06:56.860><c> this</c><00:06:57.069><c> report</c>

00:06:57.479 --> 00:06:57.489 align:start position:0%
report another way to pivot this report
 

00:06:57.489 --> 00:07:01.229 align:start position:0%
report another way to pivot this report
is<00:06:57.729><c> to</c><00:06:57.909><c> right-click</c><00:06:58.179><c> one</c><00:06:59.019><c> of</c><00:06:59.080><c> the</c><00:06:59.229><c> rows</c><00:07:00.239><c> select</c>

00:07:01.229 --> 00:07:01.239 align:start position:0%
is to right-click one of the rows select
 

00:07:01.239 --> 00:07:05.730 align:start position:0%
is to right-click one of the rows select
move<00:07:01.749><c> and</c><00:07:02.699><c> then</c><00:07:03.699><c> click</c><00:07:04.029><c> move</c><00:07:04.509><c> a</c><00:07:04.839><c> salesperson</c>

00:07:05.730 --> 00:07:05.740 align:start position:0%
move and then click move a salesperson
 

00:07:05.740 --> 00:07:08.939 align:start position:0%
move and then click move a salesperson
to<00:07:06.039><c> columns</c><00:07:06.990><c> this</c><00:07:07.990><c> will</c><00:07:08.229><c> move</c><00:07:08.439><c> the</c><00:07:08.499><c> entire</c>

00:07:08.939 --> 00:07:08.949 align:start position:0%
to columns this will move the entire
 

00:07:08.949 --> 00:07:11.459 align:start position:0%
to columns this will move the entire
salesperson<00:07:09.879><c> field</c><00:07:10.240><c> from</c><00:07:10.629><c> the</c><00:07:10.779><c> row</c><00:07:10.990><c> label</c>

00:07:11.459 --> 00:07:11.469 align:start position:0%
salesperson field from the row label
 

00:07:11.469 --> 00:07:14.219 align:start position:0%
salesperson field from the row label
area<00:07:11.769><c> to</c><00:07:12.490><c> the</c><00:07:12.669><c> column</c><00:07:13.089><c> label</c><00:07:13.479><c> area</c><00:07:13.749><c> of</c><00:07:14.080><c> the</c>

00:07:14.219 --> 00:07:14.229 align:start position:0%
area to the column label area of the
 

00:07:14.229 --> 00:07:17.999 align:start position:0%
area to the column label area of the
report<00:07:14.969><c> again</c><00:07:15.969><c> this</c><00:07:16.779><c> is</c><00:07:16.959><c> just</c><00:07:17.259><c> another</c><00:07:17.679><c> way</c>

00:07:17.999 --> 00:07:18.009 align:start position:0%
report again this is just another way
 

00:07:18.009 --> 00:07:22.949 align:start position:0%
report again this is just another way
you<00:07:18.069><c> can</c><00:07:18.550><c> work</c><00:07:18.729><c> with</c><00:07:18.939><c> your</c><00:07:19.029><c> data</c><00:07:21.539><c> to</c><00:07:22.539><c> return</c>

00:07:22.949 --> 00:07:22.959 align:start position:0%
you can work with your data to return
 

00:07:22.959 --> 00:07:25.230 align:start position:0%
you can work with your data to return
the<00:07:23.139><c> reports</c><00:07:23.619><c> back</c><00:07:23.949><c> to</c><00:07:24.009><c> the</c><00:07:24.249><c> original</c><00:07:24.909><c> view</c>

00:07:25.230 --> 00:07:25.240 align:start position:0%
the reports back to the original view
 

00:07:25.240 --> 00:07:27.269 align:start position:0%
the reports back to the original view
right-click<00:07:25.959><c> one</c><00:07:26.589><c> of</c><00:07:26.649><c> the</c><00:07:26.800><c> salesperson</c>

00:07:27.269 --> 00:07:27.279 align:start position:0%
right-click one of the salesperson
 

00:07:27.279 --> 00:07:30.679 align:start position:0%
right-click one of the salesperson
headings<00:07:28.319><c> will</c><00:07:29.319><c> just</c><00:07:29.529><c> click</c><00:07:29.769><c> Jane</c><00:07:30.039><c> Doe</c><00:07:30.249><c> and</c>

00:07:30.679 --> 00:07:30.689 align:start position:0%
headings will just click Jane Doe and
 

00:07:30.689 --> 00:07:35.659 align:start position:0%
headings will just click Jane Doe and
then<00:07:31.689><c> select</c><00:07:32.139><c> move</c><00:07:32.819><c> salesperson</c><00:07:33.819><c> to</c><00:07:34.360><c> rows</c>

00:07:35.659 --> 00:07:35.669 align:start position:0%
then select move salesperson to rows
 

00:07:35.669 --> 00:07:38.519 align:start position:0%
then select move salesperson to rows
that<00:07:36.669><c> will</c><00:07:36.879><c> move</c><00:07:37.059><c> the</c><00:07:37.240><c> field</c><00:07:37.479><c> back</c><00:07:37.929><c> to</c><00:07:38.169><c> the</c><00:07:38.289><c> row</c>

00:07:38.519 --> 00:07:38.529 align:start position:0%
that will move the field back to the row
 

00:07:38.529 --> 00:07:42.899 align:start position:0%
that will move the field back to the row
area<00:07:39.009><c> of</c><00:07:39.189><c> the</c><00:07:39.279><c> report</c><00:07:41.039><c> this</c><00:07:42.039><c> is</c><00:07:42.249><c> really</c><00:07:42.490><c> just</c><00:07:42.519><c> a</c>

00:07:42.899 --> 00:07:42.909 align:start position:0%
area of the report this is really just a
 

00:07:42.909 --> 00:07:45.239 align:start position:0%
area of the report this is really just a
basic<00:07:43.300><c> overview</c><00:07:43.449><c> of</c><00:07:43.899><c> pivot</c><00:07:44.199><c> tables</c><00:07:44.559><c> there</c><00:07:45.129><c> is</c>

00:07:45.239 --> 00:07:45.249 align:start position:0%
basic overview of pivot tables there is
 

00:07:45.249 --> 00:07:47.939 align:start position:0%
basic overview of pivot tables there is
so<00:07:45.459><c> much</c><00:07:45.699><c> more</c><00:07:45.969><c> you</c><00:07:46.029><c> can</c><00:07:46.419><c> do</c><00:07:46.749><c> but</c><00:07:47.319><c> the</c><00:07:47.469><c> best</c><00:07:47.499><c> way</c>

00:07:47.939 --> 00:07:47.949 align:start position:0%
so much more you can do but the best way
 

00:07:47.949 --> 00:07:49.829 align:start position:0%
so much more you can do but the best way
for<00:07:48.159><c> you</c><00:07:48.249><c> to</c><00:07:48.399><c> learn</c><00:07:48.550><c> some</c><00:07:48.939><c> of</c><00:07:49.059><c> these</c><00:07:49.179><c> concepts</c>

00:07:49.829 --> 00:07:49.839 align:start position:0%
for you to learn some of these concepts
 

00:07:49.839 --> 00:07:52.169 align:start position:0%
for you to learn some of these concepts
is<00:07:50.079><c> to</c><00:07:50.199><c> practice</c><00:07:50.649><c> the</c><00:07:50.679><c> basics</c><00:07:51.339><c> that</c><00:07:51.819><c> were</c><00:07:51.939><c> just</c>

00:07:52.169 --> 00:07:52.179 align:start position:0%
is to practice the basics that were just
 

00:07:52.179 --> 00:07:55.109 align:start position:0%
is to practice the basics that were just
discussed<00:07:52.389><c> you</c><00:07:53.079><c> may</c><00:07:53.979><c> also</c><00:07:54.189><c> want</c><00:07:54.550><c> to</c><00:07:54.669><c> explore</c>

00:07:55.109 --> 00:07:55.119 align:start position:0%
discussed you may also want to explore
 

00:07:55.119 --> 00:07:59.609 align:start position:0%
discussed you may also want to explore
the<00:07:55.300><c> options</c><00:07:55.779><c> tab</c><00:07:57.209><c> from</c><00:07:58.209><c> here</c><00:07:58.269><c> you</c><00:07:59.199><c> can</c><00:07:59.379><c> change</c>

00:07:59.609 --> 00:07:59.619 align:start position:0%
the options tab from here you can change
 

00:07:59.619 --> 00:08:02.489 align:start position:0%
the options tab from here you can change
the<00:07:59.769><c> name</c><00:08:00.189><c> of</c><00:08:00.459><c> the</c><00:08:00.550><c> pivot</c><00:08:00.879><c> table</c><00:08:01.240><c> you</c><00:08:01.499><c> can</c>

00:08:02.489 --> 00:08:02.499 align:start position:0%
the name of the pivot table you can
 

00:08:02.499 --> 00:08:05.449 align:start position:0%
the name of the pivot table you can
change<00:08:02.769><c> the</c><00:08:02.949><c> value</c><00:08:03.490><c> of</c><00:08:03.639><c> the</c><00:08:03.759><c> field</c><00:08:04.029><c> setting</c>

00:08:05.449 --> 00:08:05.459 align:start position:0%
change the value of the field setting
 

00:08:05.459 --> 00:08:08.189 align:start position:0%
change the value of the field setting
right<00:08:06.459><c> now</c><00:08:06.519><c> we're</c><00:08:07.149><c> calculating</c><00:08:07.779><c> the</c><00:08:07.869><c> sum</c><00:08:08.169><c> of</c>

00:08:08.189 --> 00:08:08.199 align:start position:0%
right now we're calculating the sum of
 

00:08:08.199 --> 00:08:10.769 align:start position:0%
right now we're calculating the sum of
each<00:08:08.589><c> sales</c><00:08:08.979><c> person's</c><00:08:09.519><c> order</c><00:08:09.879><c> top</c><00:08:10.209><c> but</c><00:08:10.689><c> we</c>

00:08:10.769 --> 00:08:10.779 align:start position:0%
each sales person's order top but we
 

00:08:10.779 --> 00:08:12.509 align:start position:0%
each sales person's order top but we
could<00:08:11.050><c> change</c><00:08:11.349><c> that</c><00:08:11.619><c> to</c><00:08:11.769><c> just</c><00:08:12.009><c> count</c><00:08:12.219><c> the</c>

00:08:12.509 --> 00:08:12.519 align:start position:0%
could change that to just count the
 

00:08:12.519 --> 00:08:15.779 align:start position:0%
could change that to just count the
number<00:08:12.879><c> of</c><00:08:12.909><c> cells</c><00:08:13.619><c> we</c><00:08:14.619><c> can</c><00:08:14.740><c> also</c><00:08:15.009><c> sort</c><00:08:15.519><c> to</c><00:08:15.699><c> the</c>

00:08:15.779 --> 00:08:15.789 align:start position:0%
number of cells we can also sort to the
 

00:08:15.789 --> 00:08:18.119 align:start position:0%
number of cells we can also sort to the
data<00:08:16.029><c> or</c><00:08:16.300><c> even</c><00:08:16.629><c> clear</c><00:08:17.229><c> the</c><00:08:17.379><c> entire</c><00:08:17.679><c> pivot</c>

00:08:18.119 --> 00:08:18.129 align:start position:0%
data or even clear the entire pivot
 

00:08:18.129 --> 00:08:24.149 align:start position:0%
data or even clear the entire pivot
table<00:08:18.579><c> and</c><00:08:18.789><c> start</c><00:08:19.360><c> from</c><00:08:19.479><c> scratch</c><00:08:23.129><c> you</c><00:08:24.129><c> can</c>

00:08:24.149 --> 00:08:24.159 align:start position:0%
table and start from scratch you can
 

00:08:24.159 --> 00:08:26.639 align:start position:0%
table and start from scratch you can
click<00:08:24.579><c> a</c><00:08:24.729><c> move</c><00:08:24.969><c> pivot</c><00:08:25.479><c> table</c><00:08:25.809><c> and</c><00:08:25.990><c> move</c><00:08:26.379><c> it</c><00:08:26.529><c> to</c>

00:08:26.639 --> 00:08:26.649 align:start position:0%
click a move pivot table and move it to
 

00:08:26.649 --> 00:08:29.489 align:start position:0%
click a move pivot table and move it to
an<00:08:26.769><c> existing</c><00:08:27.399><c> worksheet</c><00:08:27.729><c> or</c><00:08:28.269><c> a</c><00:08:28.360><c> new</c><00:08:28.749><c> worksheet</c>

00:08:29.489 --> 00:08:29.499 align:start position:0%
an existing worksheet or a new worksheet
 

00:08:29.499 --> 00:08:34.139 align:start position:0%
an existing worksheet or a new worksheet
I<00:08:31.289><c> do</c><00:08:32.289><c> want</c><00:08:32.889><c> to</c><00:08:32.949><c> spend</c><00:08:33.189><c> a</c><00:08:33.339><c> few</c><00:08:33.579><c> minutes</c><00:08:33.639><c> telling</c>

00:08:34.139 --> 00:08:34.149 align:start position:0%
I do want to spend a few minutes telling
 

00:08:34.149 --> 00:08:37.230 align:start position:0%
I do want to spend a few minutes telling
you<00:08:34.329><c> about</c><00:08:34.419><c> pivot</c><00:08:34.870><c> charts</c><00:08:35.759><c> you</c><00:08:36.759><c> can't</c><00:08:37.060><c> really</c>

00:08:37.230 --> 00:08:37.240 align:start position:0%
you about pivot charts you can't really
 

00:08:37.240 --> 00:08:39.120 align:start position:0%
you about pivot charts you can't really
cover<00:08:37.509><c> pivot</c><00:08:37.930><c> tables</c><00:08:38.349><c> without</c><00:08:38.409><c> talking</c><00:08:39.039><c> about</c>

00:08:39.120 --> 00:08:39.130 align:start position:0%
cover pivot tables without talking about
 

00:08:39.130 --> 00:08:42.269 align:start position:0%
cover pivot tables without talking about
pivot<00:08:39.490><c> charts</c><00:08:40.289><c> Microsoft</c><00:08:41.289><c> actually</c><00:08:41.529><c> refers</c>

00:08:42.269 --> 00:08:42.279 align:start position:0%
pivot charts Microsoft actually refers
 

00:08:42.279 --> 00:08:45.170 align:start position:0%
pivot charts Microsoft actually refers
to<00:08:42.309><c> these</c><00:08:42.789><c> as</c><00:08:42.870><c> pivottables</c><00:08:43.870><c> and</c><00:08:44.019><c> pivotcharts</c>

00:08:45.170 --> 00:08:45.180 align:start position:0%
to these as pivottables and pivotcharts
 

00:08:45.180 --> 00:08:47.070 align:start position:0%
to these as pivottables and pivotcharts
because<00:08:46.180><c> they</c><00:08:46.300><c> do</c><00:08:46.540><c> go</c>

00:08:47.070 --> 00:08:47.080 align:start position:0%
because they do go
 

00:08:47.080 --> 00:08:51.810 align:start position:0%
because they do go
in<00:08:47.170><c> hand</c><00:08:49.440><c> after</c><00:08:50.440><c> you</c><00:08:50.590><c> create</c><00:08:50.920><c> a</c><00:08:50.950><c> pivot</c><00:08:51.340><c> table</c>

00:08:51.810 --> 00:08:51.820 align:start position:0%
in hand after you create a pivot table
 

00:08:51.820 --> 00:08:54.270 align:start position:0%
in hand after you create a pivot table
you<00:08:52.000><c> can</c><00:08:52.270><c> create</c><00:08:52.450><c> a</c><00:08:52.750><c> pivot</c><00:08:52.990><c> chart</c><00:08:53.410><c> was</c><00:08:53.950><c> very</c>

00:08:54.270 --> 00:08:54.280 align:start position:0%
you can create a pivot chart was very
 

00:08:54.280 --> 00:08:58.530 align:start position:0%
you can create a pivot chart was very
little<00:08:54.580><c> extra</c><00:08:55.060><c> effort</c><00:08:56.700><c> this</c><00:08:57.700><c> allows</c><00:08:58.210><c> you</c><00:08:58.420><c> to</c>

00:08:58.530 --> 00:08:58.540 align:start position:0%
little extra effort this allows you to
 

00:08:58.540 --> 00:09:00.510 align:start position:0%
little extra effort this allows you to
display<00:08:58.870><c> the</c><00:08:59.170><c> information</c><00:08:59.830><c> in</c><00:09:00.010><c> your</c><00:09:00.040><c> pivot</c>

00:09:00.510 --> 00:09:00.520 align:start position:0%
display the information in your pivot
 

00:09:00.520 --> 00:09:04.830 align:start position:0%
display the information in your pivot
reports<00:09:01.060><c> in</c><00:09:01.210><c> a</c><00:09:01.360><c> graphical</c><00:09:01.900><c> way</c><00:09:03.210><c> to</c><00:09:04.210><c> create</c><00:09:04.570><c> a</c>

00:09:04.830 --> 00:09:04.840 align:start position:0%
reports in a graphical way to create a
 

00:09:04.840 --> 00:09:07.410 align:start position:0%
reports in a graphical way to create a
pivot<00:09:05.110><c> chart</c><00:09:05.580><c> select</c><00:09:06.580><c> the</c><00:09:06.820><c> pivot</c><00:09:07.150><c> chart</c>

00:09:07.410 --> 00:09:07.420 align:start position:0%
pivot chart select the pivot chart
 

00:09:07.420 --> 00:09:09.930 align:start position:0%
pivot chart select the pivot chart
command<00:09:07.780><c> from</c><00:09:08.140><c> the</c><00:09:08.230><c> options</c><00:09:08.620><c> tab</c><00:09:08.910><c> the</c><00:09:09.910><c> insert</c>

00:09:09.930 --> 00:09:09.940 align:start position:0%
command from the options tab the insert
 

00:09:09.940 --> 00:09:13.740 align:start position:0%
command from the options tab the insert
chart<00:09:10.360><c> dialog</c><00:09:11.320><c> box</c><00:09:11.710><c> appears</c><00:09:12.250><c> select</c><00:09:13.240><c> the</c>

00:09:13.740 --> 00:09:13.750 align:start position:0%
chart dialog box appears select the
 

00:09:13.750 --> 00:09:16.890 align:start position:0%
chart dialog box appears select the
chart<00:09:14.020><c> you</c><00:09:14.200><c> like</c><00:09:14.470><c> and</c><00:09:14.800><c> click</c><00:09:15.010><c> OK</c><00:09:15.600><c> the</c><00:09:16.600><c> chart</c>

00:09:16.890 --> 00:09:16.900 align:start position:0%
chart you like and click OK the chart
 

00:09:16.900 --> 00:09:19.080 align:start position:0%
chart you like and click OK the chart
will<00:09:17.080><c> now</c><00:09:17.320><c> appear</c><00:09:17.830><c> on</c><00:09:18.040><c> the</c><00:09:18.130><c> same</c><00:09:18.400><c> sheet</c><00:09:18.850><c> as</c><00:09:19.060><c> a</c>

00:09:19.080 --> 00:09:19.090 align:start position:0%
will now appear on the same sheet as a
 

00:09:19.090 --> 00:09:22.350 align:start position:0%
will now appear on the same sheet as a
pivot<00:09:19.480><c> table</c><00:09:20.700><c> you'll</c><00:09:21.700><c> notice</c><00:09:22.120><c> that</c><00:09:22.240><c> the</c>

00:09:22.350 --> 00:09:22.360 align:start position:0%
pivot table you'll notice that the
 

00:09:22.360 --> 00:09:24.210 align:start position:0%
pivot table you'll notice that the
information<00:09:22.480><c> in</c><00:09:23.140><c> the</c><00:09:23.230><c> chart</c><00:09:23.560><c> is</c><00:09:23.830><c> the</c><00:09:23.860><c> same</c>

00:09:24.210 --> 00:09:24.220 align:start position:0%
information in the chart is the same
 

00:09:24.220 --> 00:09:27.090 align:start position:0%
information in the chart is the same
information<00:09:25.000><c> in</c><00:09:25.090><c> the</c><00:09:25.180><c> pivot</c><00:09:25.480><c> table</c><00:09:26.100><c> although</c>

00:09:27.090 --> 00:09:27.100 align:start position:0%
information in the pivot table although
 

00:09:27.100 --> 00:09:29.610 align:start position:0%
information in the pivot table although
our<00:09:27.700><c> original</c><00:09:28.240><c> spreadsheet</c><00:09:28.510><c> has</c><00:09:28.930><c> information</c>

00:09:29.610 --> 00:09:29.620 align:start position:0%
our original spreadsheet has information
 

00:09:29.620 --> 00:09:31.710 align:start position:0%
our original spreadsheet has information
about<00:09:29.920><c> the</c><00:09:30.070><c> accounts</c><00:09:30.640><c> and</c><00:09:30.790><c> month</c><00:09:31.150><c> of</c><00:09:31.360><c> the</c><00:09:31.450><c> cell</c>

00:09:31.710 --> 00:09:31.720 align:start position:0%
about the accounts and month of the cell
 

00:09:31.720 --> 00:09:34.230 align:start position:0%
about the accounts and month of the cell
this<00:09:32.470><c> information</c><00:09:33.160><c> is</c><00:09:33.310><c> not</c><00:09:33.490><c> included</c><00:09:34.090><c> in</c><00:09:34.120><c> the</c>

00:09:34.230 --> 00:09:34.240 align:start position:0%
this information is not included in the
 

00:09:34.240 --> 00:09:36.630 align:start position:0%
this information is not included in the
pivot<00:09:34.600><c> chart</c><00:09:34.650><c> because</c><00:09:35.650><c> it</c><00:09:35.770><c> is</c><00:09:35.890><c> not</c><00:09:36.070><c> part</c><00:09:36.460><c> of</c>

00:09:36.630 --> 00:09:36.640 align:start position:0%
pivot chart because it is not part of
 

00:09:36.640 --> 00:09:40.620 align:start position:0%
pivot chart because it is not part of
the<00:09:36.760><c> pivot</c><00:09:37.090><c> table</c><00:09:37.300><c> you</c><00:09:38.820><c> have</c><00:09:39.820><c> a</c><00:09:39.850><c> filter</c><00:09:40.210><c> pane</c>

00:09:40.620 --> 00:09:40.630 align:start position:0%
the pivot table you have a filter pane
 

00:09:40.630 --> 00:09:42.900 align:start position:0%
the pivot table you have a filter pane
that<00:09:41.020><c> will</c><00:09:41.260><c> allow</c><00:09:41.530><c> you</c><00:09:41.590><c> to</c><00:09:41.770><c> filter</c><00:09:42.280><c> data</c><00:09:42.550><c> for</c>

00:09:42.900 --> 00:09:42.910 align:start position:0%
that will allow you to filter data for
 

00:09:42.910 --> 00:09:44.910 align:start position:0%
that will allow you to filter data for
the<00:09:43.000><c> charts</c><00:09:43.390><c> and</c><00:09:43.570><c> I</c><00:09:44.050><c> encourage</c><00:09:44.620><c> you</c><00:09:44.800><c> to</c>

00:09:44.910 --> 00:09:44.920 align:start position:0%
the charts and I encourage you to
 

00:09:44.920 --> 00:09:47.820 align:start position:0%
the charts and I encourage you to
explore<00:09:45.280><c> this</c><00:09:45.610><c> on</c><00:09:45.760><c> your</c><00:09:45.940><c> own</c><00:09:46.260><c> for</c><00:09:47.260><c> right</c><00:09:47.500><c> now</c>

00:09:47.820 --> 00:09:47.830 align:start position:0%
explore this on your own for right now
 

00:09:47.830 --> 00:09:50.610 align:start position:0%
explore this on your own for right now
we'll<00:09:48.370><c> just</c><00:09:48.400><c> close</c><00:09:48.910><c> this</c><00:09:49.330><c> and</c><00:09:49.660><c> we</c><00:09:50.230><c> can</c><00:09:50.380><c> always</c>

00:09:50.610 --> 00:09:50.620 align:start position:0%
we'll just close this and we can always
 

00:09:50.620 --> 00:09:53.190 align:start position:0%
we'll just close this and we can always
left-click<00:09:51.520><c> the</c><00:09:51.670><c> chart</c><00:09:51.940><c> and</c><00:09:52.240><c> drag</c><00:09:52.720><c> it</c><00:09:52.870><c> a</c><00:09:52.960><c> bit</c>

00:09:53.190 --> 00:09:53.200 align:start position:0%
left-click the chart and drag it a bit
 

00:09:53.200 --> 00:09:56.150 align:start position:0%
left-click the chart and drag it a bit
over<00:09:53.650><c> if</c><00:09:53.890><c> it</c><00:09:54.370><c> is</c><00:09:54.490><c> in</c><00:09:54.610><c> the</c><00:09:54.760><c> way</c><00:09:55.030><c> of</c><00:09:55.300><c> our</c><00:09:55.390><c> data</c>

00:09:56.150 --> 00:09:56.160 align:start position:0%
over if it is in the way of our data
 

00:09:56.160 --> 00:09:59.400 align:start position:0%
over if it is in the way of our data
when<00:09:57.160><c> you</c><00:09:57.280><c> first</c><00:09:57.580><c> use</c><00:09:57.790><c> a</c><00:09:58.090><c> pivot</c><00:09:58.570><c> table</c><00:09:58.780><c> the</c>

00:09:59.400 --> 00:09:59.410 align:start position:0%
when you first use a pivot table the
 

00:09:59.410 --> 00:10:03.180 align:start position:0%
when you first use a pivot table the
whole<00:09:59.650><c> thing</c><00:10:00.070><c> can</c><00:10:00.310><c> seem</c><00:10:00.520><c> overwhelming</c><00:10:02.190><c> once</c>

00:10:03.180 --> 00:10:03.190 align:start position:0%
whole thing can seem overwhelming once
 

00:10:03.190 --> 00:10:04.590 align:start position:0%
whole thing can seem overwhelming once
she<00:10:03.370><c> starts</c><00:10:03.730><c> working</c><00:10:04.000><c> with</c><00:10:04.150><c> pivot</c><00:10:04.570><c> tables</c>

00:10:04.590 --> 00:10:04.600 align:start position:0%
she starts working with pivot tables
 

00:10:04.600 --> 00:10:06.990 align:start position:0%
she starts working with pivot tables
you'll<00:10:05.380><c> realize</c><00:10:05.890><c> that</c><00:10:05.920><c> they</c><00:10:06.250><c> are</c><00:10:06.370><c> really</c><00:10:06.790><c> not</c>

00:10:06.990 --> 00:10:07.000 align:start position:0%
you'll realize that they are really not
 

00:10:07.000 --> 00:10:11.010 align:start position:0%
you'll realize that they are really not
that<00:10:07.240><c> difficult</c><00:10:09.150><c> the</c><00:10:10.150><c> key</c><00:10:10.390><c> thing</c><00:10:10.660><c> to</c><00:10:10.690><c> remember</c>

00:10:11.010 --> 00:10:11.020 align:start position:0%
that difficult the key thing to remember
 

00:10:11.020 --> 00:10:13.200 align:start position:0%
that difficult the key thing to remember
with<00:10:11.500><c> pivot</c><00:10:11.890><c> tables</c><00:10:12.280><c> is</c><00:10:12.430><c> that</c><00:10:12.670><c> you</c><00:10:12.910><c> are</c><00:10:13.000><c> not</c>

00:10:13.200 --> 00:10:13.210 align:start position:0%
with pivot tables is that you are not
 

00:10:13.210 --> 00:10:15.150 align:start position:0%
with pivot tables is that you are not
changing<00:10:13.540><c> your</c><00:10:13.870><c> original</c><00:10:14.410><c> spreadsheet</c><00:10:14.680><c> data</c>

00:10:15.150 --> 00:10:15.160 align:start position:0%
changing your original spreadsheet data
 

00:10:15.160 --> 00:10:17.340 align:start position:0%
changing your original spreadsheet data
so<00:10:15.760><c> it's</c><00:10:15.910><c> ok</c><00:10:16.240><c> to</c><00:10:16.270><c> try</c><00:10:16.510><c> different</c><00:10:16.750><c> things</c><00:10:16.960><c> and</c>

00:10:17.340 --> 00:10:17.350 align:start position:0%
so it's ok to try different things and
 

00:10:17.350 --> 00:10:20.970 align:start position:0%
so it's ok to try different things and
see<00:10:17.470><c> what</c><00:10:17.590><c> works</c><00:10:18.480><c> this</c><00:10:19.480><c> video</c><00:10:20.080><c> really</c><00:10:20.530><c> just</c>

00:10:20.970 --> 00:10:20.980 align:start position:0%
see what works this video really just
 

00:10:20.980 --> 00:10:23.210 align:start position:0%
see what works this video really just
covered<00:10:21.370><c> the</c><00:10:21.490><c> very</c><00:10:21.790><c> basics</c><00:10:22.450><c> of</c><00:10:22.570><c> pivot</c><00:10:22.900><c> tables</c>

00:10:23.210 --> 00:10:23.220 align:start position:0%
covered the very basics of pivot tables
 

00:10:23.220 --> 00:10:26.100 align:start position:0%
covered the very basics of pivot tables
we<00:10:24.220><c> worked</c><00:10:24.550><c> with</c><00:10:24.760><c> a</c><00:10:24.790><c> simple</c><00:10:25.300><c> spreadsheet</c><00:10:25.570><c> and</c>

00:10:26.100 --> 00:10:26.110 align:start position:0%
we worked with a simple spreadsheet and
 

00:10:26.110 --> 00:10:28.260 align:start position:0%
we worked with a simple spreadsheet and
simple<00:10:26.590><c> data</c><00:10:26.830><c> but</c><00:10:27.400><c> I</c><00:10:27.430><c> hope</c><00:10:27.730><c> you</c><00:10:27.910><c> can</c><00:10:28.060><c> see</c><00:10:28.240><c> how</c>

00:10:28.260 --> 00:10:28.270 align:start position:0%
simple data but I hope you can see how
 

00:10:28.270 --> 00:10:30.560 align:start position:0%
simple data but I hope you can see how
robust<00:10:29.110><c> and</c><00:10:29.350><c> useful</c><00:10:29.380><c> this</c><00:10:29.890><c> feature</c><00:10:30.130><c> is</c>

00:10:30.560 --> 00:10:30.570 align:start position:0%
robust and useful this feature is
 

00:10:30.570 --> 00:10:32.400 align:start position:0%
robust and useful this feature is
especially<00:10:31.570><c> if</c><00:10:31.690><c> you</c><00:10:31.810><c> are</c><00:10:31.930><c> working</c><00:10:32.140><c> with</c><00:10:32.320><c> a</c>

00:10:32.400 --> 00:10:32.410 align:start position:0%
especially if you are working with a
 

00:10:32.410 --> 00:10:34.320 align:start position:0%
especially if you are working with a
large<00:10:32.740><c> spreadsheet</c><00:10:33.550><c> with</c><00:10:33.760><c> hundreds</c><00:10:34.180><c> or</c><00:10:34.270><c> even</c>

00:10:34.320 --> 00:10:34.330 align:start position:0%
large spreadsheet with hundreds or even
 

00:10:34.330 --> 00:10:37.230 align:start position:0%
large spreadsheet with hundreds or even
thousands<00:10:34.990><c> of</c><00:10:35.110><c> rows</c><00:10:35.880><c> once</c><00:10:36.880><c> you</c><00:10:37.060><c> feel</c>

00:10:37.230 --> 00:10:37.240 align:start position:0%
thousands of rows once you feel
 

00:10:37.240 --> 00:10:39.390 align:start position:0%
thousands of rows once you feel
comfortable<00:10:37.480><c> with</c><00:10:37.990><c> this</c><00:10:38.230><c> you</c><00:10:38.830><c> can</c><00:10:38.950><c> explore</c>

00:10:39.390 --> 00:10:39.400 align:start position:0%
comfortable with this you can explore
 

00:10:39.400 --> 00:10:41.490 align:start position:0%
comfortable with this you can explore
and<00:10:39.670><c> learn</c><00:10:40.090><c> more</c><00:10:40.420><c> about</c><00:10:40.600><c> how</c><00:10:40.900><c> to</c><00:10:40.930><c> use</c><00:10:41.140><c> pivot</c>

00:10:41.490 --> 00:10:41.500 align:start position:0%
and learn more about how to use pivot
 

00:10:41.500 --> 00:10:45.360 align:start position:0%
and learn more about how to use pivot
tables<00:10:41.980><c> and</c><00:10:42.100><c> pivot</c><00:10:42.280><c> charts</c><00:10:42.730><c> with</c><00:10:42.880><c> your</c><00:10:43.060><c> data</c>