WEBVTT
Kind: captions
Language: en

00:00:11.290 --> 00:00:13.629 align:start position:0%
 
cells<00:00:12.290><c> are</c><00:00:12.530><c> the</c><00:00:12.590><c> building</c><00:00:13.040><c> blocks</c><00:00:13.280><c> of</c><00:00:13.520><c> an</c>

00:00:13.629 --> 00:00:13.639 align:start position:0%
cells are the building blocks of an
 

00:00:13.639 --> 00:00:14.709 align:start position:0%
cells are the building blocks of an
Excel<00:00:13.969><c> spreadsheet</c>

00:00:14.709 --> 00:00:14.719 align:start position:0%
Excel spreadsheet
 

00:00:14.719 --> 00:00:16.480 align:start position:0%
Excel spreadsheet
the<00:00:14.960><c> little</c><00:00:15.350><c> rectangles</c><00:00:15.980><c> where</c><00:00:16.130><c> different</c>

00:00:16.480 --> 00:00:16.490 align:start position:0%
the little rectangles where different
 

00:00:16.490 --> 00:00:18.910 align:start position:0%
the little rectangles where different
columns<00:00:16.850><c> and</c><00:00:17.000><c> rows</c><00:00:17.180><c> intersect</c><00:00:17.779><c> you</c><00:00:18.590><c> will</c><00:00:18.740><c> need</c>

00:00:18.910 --> 00:00:18.920 align:start position:0%
columns and rows intersect you will need
 

00:00:18.920 --> 00:00:20.679 align:start position:0%
columns and rows intersect you will need
to<00:00:19.070><c> know</c><00:00:19.220><c> how</c><00:00:19.400><c> to</c><00:00:19.460><c> work</c><00:00:19.730><c> with</c><00:00:19.910><c> these</c><00:00:20.119><c> cells</c><00:00:20.390><c> in</c>

00:00:20.679 --> 00:00:20.689 align:start position:0%
to know how to work with these cells in
 

00:00:20.689 --> 00:00:22.630 align:start position:0%
to know how to work with these cells in
order<00:00:20.840><c> to</c><00:00:20.960><c> organize</c><00:00:21.340><c> calculate</c><00:00:22.340><c> and</c><00:00:22.520><c> analyze</c>

00:00:22.630 --> 00:00:22.640 align:start position:0%
order to organize calculate and analyze
 

00:00:22.640 --> 00:00:25.050 align:start position:0%
order to organize calculate and analyze
the<00:00:23.300><c> contents</c><00:00:23.869><c> of</c><00:00:23.990><c> your</c><00:00:24.200><c> spreadsheet</c><00:00:24.439><c> to</c>

00:00:25.050 --> 00:00:25.060 align:start position:0%
the contents of your spreadsheet to
 

00:00:25.060 --> 00:00:28.269 align:start position:0%
the contents of your spreadsheet to
select<00:00:26.060><c> the</c><00:00:26.180><c> cell</c><00:00:26.419><c> just</c><00:00:26.840><c> click</c><00:00:27.169><c> you</c><00:00:27.950><c> can</c><00:00:28.130><c> even</c>

00:00:28.269 --> 00:00:28.279 align:start position:0%
select the cell just click you can even
 

00:00:28.279 --> 00:00:30.159 align:start position:0%
select the cell just click you can even
use<00:00:28.579><c> the</c><00:00:28.759><c> arrow</c><00:00:28.939><c> keys</c><00:00:29.239><c> on</c><00:00:29.450><c> your</c><00:00:29.570><c> keyboard</c><00:00:29.630><c> to</c>

00:00:30.159 --> 00:00:30.169 align:start position:0%
use the arrow keys on your keyboard to
 

00:00:30.169 --> 00:00:32.109 align:start position:0%
use the arrow keys on your keyboard to
navigate<00:00:30.739><c> to</c><00:00:30.770><c> different</c><00:00:31.009><c> cells</c><00:00:31.430><c> instead</c><00:00:32.000><c> of</c>

00:00:32.109 --> 00:00:32.119 align:start position:0%
navigate to different cells instead of
 

00:00:32.119 --> 00:00:34.600 align:start position:0%
navigate to different cells instead of
clicking<00:00:32.390><c> with</c><00:00:32.630><c> your</c><00:00:32.660><c> mouse</c><00:00:33.010><c> to</c><00:00:34.010><c> select</c><00:00:34.160><c> more</c>

00:00:34.600 --> 00:00:34.610 align:start position:0%
clicking with your mouse to select more
 

00:00:34.610 --> 00:00:37.000 align:start position:0%
clicking with your mouse to select more
than<00:00:34.670><c> one</c><00:00:34.820><c> cell</c><00:00:35.270><c> at</c><00:00:35.450><c> a</c><00:00:35.510><c> time</c><00:00:35.540><c> click</c><00:00:36.350><c> and</c><00:00:36.590><c> drag</c>

00:00:37.000 --> 00:00:37.010 align:start position:0%
than one cell at a time click and drag
 

00:00:37.010 --> 00:00:39.750 align:start position:0%
than one cell at a time click and drag
and<00:00:37.370><c> the</c><00:00:37.940><c> entire</c><00:00:37.970><c> range</c><00:00:38.600><c> will</c><00:00:38.870><c> be</c><00:00:38.989><c> highlighted</c>

00:00:39.750 --> 00:00:39.760 align:start position:0%
and the entire range will be highlighted
 

00:00:39.760 --> 00:00:42.610 align:start position:0%
and the entire range will be highlighted
you<00:00:40.760><c> can</c><00:00:40.940><c> enter</c><00:00:41.300><c> lots</c><00:00:41.600><c> of</c><00:00:41.750><c> things</c><00:00:42.020><c> into</c><00:00:42.320><c> a</c><00:00:42.350><c> cell</c>

00:00:42.610 --> 00:00:42.620 align:start position:0%
you can enter lots of things into a cell
 

00:00:42.620 --> 00:00:45.640 align:start position:0%
you can enter lots of things into a cell
for<00:00:43.070><c> example</c><00:00:43.160><c> all</c><00:00:43.730><c> of</c><00:00:43.880><c> mine</c><00:00:44.090><c> contain</c><00:00:44.570><c> text</c><00:00:44.870><c> but</c>

00:00:45.640 --> 00:00:45.650 align:start position:0%
for example all of mine contain text but
 

00:00:45.650 --> 00:00:47.530 align:start position:0%
for example all of mine contain text but
cells<00:00:45.920><c> can</c><00:00:46.160><c> contain</c><00:00:46.550><c> advanced</c><00:00:47.060><c> properties</c>

00:00:47.530 --> 00:00:47.540 align:start position:0%
cells can contain advanced properties
 

00:00:47.540 --> 00:00:50.080 align:start position:0%
cells can contain advanced properties
too<00:00:47.810><c> like</c><00:00:48.230><c> formatting</c><00:00:48.740><c> comments</c><00:00:49.520><c> formulas</c>

00:00:50.080 --> 00:00:50.090 align:start position:0%
too like formatting comments formulas
 

00:00:50.090 --> 00:00:52.240 align:start position:0%
too like formatting comments formulas
and<00:00:50.300><c> functions</c><00:00:50.440><c> we'll</c><00:00:51.440><c> take</c><00:00:51.650><c> a</c><00:00:51.680><c> look</c><00:00:51.920><c> at</c><00:00:52.040><c> those</c>

00:00:52.240 --> 00:00:52.250 align:start position:0%
and functions we'll take a look at those
 

00:00:52.250 --> 00:00:54.970 align:start position:0%
and functions we'll take a look at those
in<00:00:52.610><c> another</c><00:00:52.760><c> series</c><00:00:53.420><c> of</c><00:00:53.450><c> lessons</c><00:00:53.990><c> right</c><00:00:54.740><c> now</c>

00:00:54.970 --> 00:00:54.980 align:start position:0%
in another series of lessons right now
 

00:00:54.980 --> 00:00:57.190 align:start position:0%
in another series of lessons right now
I'd<00:00:55.370><c> like</c><00:00:55.430><c> to</c><00:00:55.670><c> show</c><00:00:55.970><c> you</c><00:00:56.030><c> the</c><00:00:56.330><c> basics</c><00:00:56.780><c> while</c><00:00:57.080><c> we</c>

00:00:57.190 --> 00:00:57.200 align:start position:0%
I'd like to show you the basics while we
 

00:00:57.200 --> 00:00:59.020 align:start position:0%
I'd like to show you the basics while we
work<00:00:57.410><c> on</c><00:00:57.560><c> filling</c><00:00:57.920><c> out</c><00:00:58.070><c> this</c><00:00:58.340><c> list</c><00:00:58.640><c> for</c><00:00:58.910><c> an</c>

00:00:59.020 --> 00:00:59.030 align:start position:0%
work on filling out this list for an
 

00:00:59.030 --> 00:01:01.900 align:start position:0%
work on filling out this list for an
office<00:00:59.360><c> Christmas</c><00:00:59.570><c> party</c><00:01:00.400><c> let's</c><00:01:01.400><c> start</c><00:01:01.730><c> with</c>

00:01:01.900 --> 00:01:01.910 align:start position:0%
office Christmas party let's start with
 

00:01:01.910 --> 00:01:04.719 align:start position:0%
office Christmas party let's start with
inserting<00:01:02.270><c> content</c><00:01:02.930><c> into</c><00:01:03.260><c> a</c><00:01:03.290><c> cell</c><00:01:03.590><c> one</c><00:01:04.460><c> of</c><00:01:04.610><c> my</c>

00:01:04.719 --> 00:01:04.729 align:start position:0%
inserting content into a cell one of my
 

00:01:04.729 --> 00:01:06.399 align:start position:0%
inserting content into a cell one of my
co-workers<00:01:05.329><c> has</c><00:01:05.540><c> just</c><00:01:05.810><c> confirmed</c><00:01:06.229><c> that</c><00:01:06.320><c> she's</c>

00:01:06.399 --> 00:01:06.409 align:start position:0%
co-workers has just confirmed that she's
 

00:01:06.409 --> 00:01:08.380 align:start position:0%
co-workers has just confirmed that she's
attending<00:01:07.100><c> so</c><00:01:07.400><c> I'm</c><00:01:07.549><c> going</c><00:01:07.790><c> to</c><00:01:07.820><c> select</c><00:01:08.150><c> the</c>

00:01:08.380 --> 00:01:08.390 align:start position:0%
attending so I'm going to select the
 

00:01:08.390 --> 00:01:11.770 align:start position:0%
attending so I'm going to select the
cell<00:01:08.600><c> next</c><00:01:08.930><c> to</c><00:01:09.049><c> her</c><00:01:09.229><c> name</c><00:01:09.259><c> then</c><00:01:10.040><c> type</c><00:01:10.490><c> an</c><00:01:10.729><c> X</c><00:01:10.970><c> it</c>

00:01:11.770 --> 00:01:11.780 align:start position:0%
cell next to her name then type an X it
 

00:01:11.780 --> 00:01:13.719 align:start position:0%
cell next to her name then type an X it
appears<00:01:12.259><c> in</c><00:01:12.500><c> the</c><00:01:12.650><c> cell</c><00:01:12.890><c> and</c><00:01:13.159><c> in</c><00:01:13.549><c> the</c><00:01:13.579><c> formula</c>

00:01:13.719 --> 00:01:13.729 align:start position:0%
appears in the cell and in the formula
 

00:01:13.729 --> 00:01:16.539 align:start position:0%
appears in the cell and in the formula
bar<00:01:14.179><c> where</c><00:01:14.929><c> you</c><00:01:15.049><c> can</c><00:01:15.200><c> also</c><00:01:15.380><c> enter</c><00:01:15.770><c> or</c><00:01:16.130><c> edit</c><00:01:16.429><c> the</c>

00:01:16.539 --> 00:01:16.549 align:start position:0%
bar where you can also enter or edit the
 

00:01:16.549 --> 00:01:18.669 align:start position:0%
bar where you can also enter or edit the
contents<00:01:17.030><c> of</c><00:01:17.119><c> your</c><00:01:17.179><c> cell</c><00:01:17.539><c> I'm</c><00:01:18.259><c> going</c><00:01:18.319><c> to</c><00:01:18.560><c> go</c>

00:01:18.669 --> 00:01:18.679 align:start position:0%
contents of your cell I'm going to go
 

00:01:18.679 --> 00:01:21.160 align:start position:0%
contents of your cell I'm going to go
ahead<00:01:18.829><c> and</c><00:01:19.249><c> change</c><00:01:19.670><c> this</c><00:01:19.969><c> to</c><00:01:20.030><c> a</c><00:01:20.240><c> capital</c><00:01:20.780><c> X</c><00:01:20.960><c> so</c>

00:01:21.160 --> 00:01:21.170 align:start position:0%
ahead and change this to a capital X so
 

00:01:21.170 --> 00:01:22.690 align:start position:0%
ahead and change this to a capital X so
it's<00:01:21.409><c> consistent</c><00:01:21.979><c> with</c><00:01:22.039><c> the</c><00:01:22.159><c> rest</c><00:01:22.399><c> of</c><00:01:22.579><c> the</c>

00:01:22.690 --> 00:01:22.700 align:start position:0%
it's consistent with the rest of the
 

00:01:22.700 --> 00:01:26.169 align:start position:0%
it's consistent with the rest of the
list<00:01:23.259><c> now</c><00:01:24.259><c> for</c><00:01:24.499><c> the</c><00:01:24.590><c> next</c><00:01:24.740><c> person</c><00:01:25.189><c> whoops</c>

00:01:26.169 --> 00:01:26.179 align:start position:0%
list now for the next person whoops
 

00:01:26.179 --> 00:01:28.660 align:start position:0%
list now for the next person whoops
looks<00:01:26.689><c> like</c><00:01:26.869><c> I</c><00:01:27.049><c> made</c><00:01:27.319><c> a</c><00:01:27.350><c> mistake</c><00:01:27.439><c> this</c><00:01:28.189><c> person</c>

00:01:28.660 --> 00:01:28.670 align:start position:0%
looks like I made a mistake this person
 

00:01:28.670 --> 00:01:32.499 align:start position:0%
looks like I made a mistake this person
is<00:01:28.789><c> on</c><00:01:28.819><c> the</c><00:01:29.060><c> list</c><00:01:29.270><c> twice</c><00:01:29.619><c> here</c><00:01:30.619><c> and</c><00:01:30.880><c> here</c><00:01:31.880><c> I'm</c>

00:01:32.499 --> 00:01:32.509 align:start position:0%
is on the list twice here and here I'm
 

00:01:32.509 --> 00:01:34.389 align:start position:0%
is on the list twice here and here I'm
just<00:01:32.569><c> going</c><00:01:33.020><c> to</c><00:01:33.079><c> delete</c><00:01:33.380><c> the</c><00:01:33.499><c> contents</c><00:01:33.889><c> of</c><00:01:34.159><c> the</c>

00:01:34.389 --> 00:01:34.399 align:start position:0%
just going to delete the contents of the
 

00:01:34.399 --> 00:01:36.459 align:start position:0%
just going to delete the contents of the
extra<00:01:34.969><c> row</c><00:01:35.149><c> by</c><00:01:35.450><c> finding</c><00:01:35.869><c> the</c><00:01:36.020><c> clear</c><00:01:36.289><c> command</c>

00:01:36.459 --> 00:01:36.469 align:start position:0%
extra row by finding the clear command
 

00:01:36.469 --> 00:01:38.379 align:start position:0%
extra row by finding the clear command
on<00:01:36.829><c> the</c><00:01:37.039><c> ribbon</c><00:01:37.069><c> the</c><00:01:37.789><c> one</c><00:01:37.939><c> with</c><00:01:38.119><c> the</c><00:01:38.209><c> little</c>

00:01:38.379 --> 00:01:38.389 align:start position:0%
on the ribbon the one with the little
 

00:01:38.389 --> 00:01:42.669 align:start position:0%
on the ribbon the one with the little
eraser<00:01:39.039><c> then</c><00:01:40.039><c> choosing</c><00:01:40.729><c> clear</c><00:01:41.060><c> contents</c><00:01:41.749><c> you</c>

00:01:42.669 --> 00:01:42.679 align:start position:0%
eraser then choosing clear contents you
 

00:01:42.679 --> 00:01:44.410 align:start position:0%
eraser then choosing clear contents you
can<00:01:42.859><c> also</c><00:01:43.009><c> use</c><00:01:43.399><c> the</c><00:01:43.609><c> backspace</c><00:01:44.119><c> or</c><00:01:44.359><c> delete</c>

00:01:44.410 --> 00:01:44.420 align:start position:0%
can also use the backspace or delete
 

00:01:44.420 --> 00:01:47.349 align:start position:0%
can also use the backspace or delete
keys<00:01:44.990><c> on</c><00:01:45.200><c> your</c><00:01:45.319><c> keyboard</c><00:01:45.670><c> so</c><00:01:46.670><c> let's</c><00:01:47.090><c> take</c><00:01:47.329><c> a</c>

00:01:47.349 --> 00:01:47.359 align:start position:0%
keys on your keyboard so let's take a
 

00:01:47.359 --> 00:01:49.629 align:start position:0%
keys on your keyboard so let's take a
look<00:01:47.600><c> at</c><00:01:47.749><c> what</c><00:01:47.899><c> that</c><00:01:47.929><c> did</c><00:01:48.409><c> it</c><00:01:48.709><c> cleared</c><00:01:49.490><c> the</c>

00:01:49.629 --> 00:01:49.639 align:start position:0%
look at what that did it cleared the
 

00:01:49.639 --> 00:01:51.520 align:start position:0%
look at what that did it cleared the
contents<00:01:50.270><c> but</c><00:01:50.479><c> the</c><00:01:50.630><c> row</c><00:01:50.810><c> is</c><00:01:50.990><c> still</c><00:01:51.259><c> there</c>

00:01:51.520 --> 00:01:51.530 align:start position:0%
contents but the row is still there
 

00:01:51.530 --> 00:01:53.980 align:start position:0%
contents but the row is still there
that's<00:01:52.069><c> okay</c><00:01:52.520><c> if</c><00:01:52.759><c> you</c><00:01:53.270><c> want</c><00:01:53.450><c> to</c><00:01:53.539><c> delete</c><00:01:53.810><c> the</c>

00:01:53.980 --> 00:01:53.990 align:start position:0%
that's okay if you want to delete the
 

00:01:53.990 --> 00:01:55.120 align:start position:0%
that's okay if you want to delete the
cells<00:01:54.259><c> altogether</c>

00:01:55.120 --> 00:01:55.130 align:start position:0%
cells altogether
 

00:01:55.130 --> 00:01:57.099 align:start position:0%
cells altogether
all<00:01:55.219><c> you</c><00:01:55.520><c> have</c><00:01:55.729><c> to</c><00:01:55.880><c> do</c><00:01:56.060><c> is</c><00:01:56.270><c> click</c><00:01:56.539><c> the</c><00:01:56.779><c> delete</c>

00:01:57.099 --> 00:01:57.109 align:start position:0%
all you have to do is click the delete
 

00:01:57.109 --> 00:01:59.859 align:start position:0%
all you have to do is click the delete
command<00:01:57.319><c> instead</c><00:01:58.009><c> that</c><00:01:58.789><c> actually</c><00:01:59.389><c> removes</c>

00:01:59.859 --> 00:01:59.869 align:start position:0%
command instead that actually removes
 

00:01:59.869 --> 00:02:01.989 align:start position:0%
command instead that actually removes
the<00:02:00.079><c> cells</c><00:02:00.350><c> from</c><00:02:00.679><c> the</c><00:02:00.770><c> spreadsheet</c><00:02:01.159><c> causing</c>

00:02:01.989 --> 00:02:01.999 align:start position:0%
the cells from the spreadsheet causing
 

00:02:01.999 --> 00:02:03.819 align:start position:0%
the cells from the spreadsheet causing
the<00:02:02.119><c> cells</c><00:02:02.359><c> underneath</c><00:02:02.719><c> to</c><00:02:03.109><c> shift</c><00:02:03.380><c> up</c><00:02:03.590><c> and</c>

00:02:03.819 --> 00:02:03.829 align:start position:0%
the cells underneath to shift up and
 

00:02:03.829 --> 00:02:06.219 align:start position:0%
the cells underneath to shift up and
fill<00:02:04.039><c> in</c><00:02:04.219><c> the</c><00:02:04.310><c> gap</c><00:02:04.630><c> just</c><00:02:05.630><c> take</c><00:02:05.810><c> care</c><00:02:06.049><c> to</c>

00:02:06.219 --> 00:02:06.229 align:start position:0%
fill in the gap just take care to
 

00:02:06.229 --> 00:02:08.230 align:start position:0%
fill in the gap just take care to
remember<00:02:06.679><c> the</c><00:02:06.799><c> difference</c><00:02:07.279><c> between</c><00:02:07.399><c> clearing</c>

00:02:08.230 --> 00:02:08.240 align:start position:0%
remember the difference between clearing
 

00:02:08.240 --> 00:02:10.690 align:start position:0%
remember the difference between clearing
the<00:02:08.330><c> contents</c><00:02:08.929><c> and</c><00:02:09.080><c> deleting</c><00:02:09.770><c> the</c><00:02:09.890><c> cell</c><00:02:10.160><c> so</c>

00:02:10.690 --> 00:02:10.700 align:start position:0%
the contents and deleting the cell so
 

00:02:10.700 --> 00:02:12.610 align:start position:0%
the contents and deleting the cell so
you<00:02:10.729><c> don't</c><00:02:11.060><c> accidentally</c><00:02:11.540><c> remove</c><00:02:12.020><c> any</c><00:02:12.230><c> cells</c>

00:02:12.610 --> 00:02:12.620 align:start position:0%
you don't accidentally remove any cells
 

00:02:12.620 --> 00:02:15.000 align:start position:0%
you don't accidentally remove any cells
columns<00:02:13.220><c> or</c><00:02:13.340><c> rows</c><00:02:13.370><c> that</c><00:02:13.849><c> you</c><00:02:13.940><c> want</c><00:02:14.150><c> it</c><00:02:14.240><c> to</c><00:02:14.330><c> keep</c>

00:02:15.000 --> 00:02:15.010 align:start position:0%
columns or rows that you want it to keep
 

00:02:15.010 --> 00:02:17.290 align:start position:0%
columns or rows that you want it to keep
now<00:02:16.010><c> I'd</c><00:02:16.190><c> like</c><00:02:16.340><c> to</c><00:02:16.490><c> show</c><00:02:16.670><c> you</c><00:02:16.730><c> how</c><00:02:16.970><c> to</c><00:02:17.030><c> save</c>

00:02:17.290 --> 00:02:17.300 align:start position:0%
now I'd like to show you how to save
 

00:02:17.300 --> 00:02:19.300 align:start position:0%
now I'd like to show you how to save
some<00:02:17.540><c> time</c><00:02:17.810><c> by</c><00:02:17.840><c> copying</c><00:02:18.290><c> and</c><00:02:18.710><c> pasting</c><00:02:18.860><c> content</c>

00:02:19.300 --> 00:02:19.310 align:start position:0%
some time by copying and pasting content
 

00:02:19.310 --> 00:02:21.850 align:start position:0%
some time by copying and pasting content
I<00:02:19.820><c> need</c><00:02:20.600><c> to</c><00:02:20.750><c> mark</c><00:02:20.930><c> the</c><00:02:21.050><c> rest</c><00:02:21.260><c> of</c><00:02:21.470><c> the</c><00:02:21.560><c> people</c>

00:02:21.850 --> 00:02:21.860 align:start position:0%
I need to mark the rest of the people
 

00:02:21.860 --> 00:02:23.230 align:start position:0%
I need to mark the rest of the people
who<00:02:22.010><c> are</c><00:02:22.130><c> bringing</c><00:02:22.250><c> a</c><00:02:22.670><c> guest</c>

00:02:23.230 --> 00:02:23.240 align:start position:0%
who are bringing a guest
 

00:02:23.240 --> 00:02:25.090 align:start position:0%
who are bringing a guest
so<00:02:23.510><c> I'm</c><00:02:23.660><c> going</c><00:02:23.930><c> to</c><00:02:24.020><c> select</c><00:02:24.200><c> any</c><00:02:24.620><c> one</c><00:02:24.710><c> of</c><00:02:24.950><c> these</c>

00:02:25.090 --> 00:02:25.100 align:start position:0%
so I'm going to select any one of these
 

00:02:25.100 --> 00:02:28.240 align:start position:0%
so I'm going to select any one of these
cells<00:02:25.400><c> that</c><00:02:25.610><c> contains</c><00:02:26.030><c> an</c><00:02:26.210><c> X</c><00:02:26.800><c> then</c><00:02:27.800><c> I'm</c><00:02:27.980><c> going</c>

00:02:28.240 --> 00:02:28.250 align:start position:0%
cells that contains an X then I'm going
 

00:02:28.250 --> 00:02:31.570 align:start position:0%
cells that contains an X then I'm going
to<00:02:28.280><c> click</c><00:02:28.520><c> copy</c><00:02:29.830><c> select</c><00:02:30.830><c> the</c><00:02:31.040><c> cells</c><00:02:31.280><c> where</c><00:02:31.400><c> I</c>

00:02:31.570 --> 00:02:31.580 align:start position:0%
to click copy select the cells where I
 

00:02:31.580 --> 00:02:36.730 align:start position:0%
to click copy select the cells where I
want<00:02:31.820><c> the</c><00:02:31.970><c> X</c><00:02:32.120><c> to</c><00:02:32.390><c> go</c><00:02:32.570><c> and</c><00:02:33.700><c> paste</c><00:02:35.320><c> to</c><00:02:36.320><c> access</c>

00:02:36.730 --> 00:02:36.740 align:start position:0%
want the X to go and paste to access
 

00:02:36.740 --> 00:02:38.800 align:start position:0%
want the X to go and paste to access
more<00:02:37.010><c> paste</c><00:02:37.280><c> options</c><00:02:37.790><c> open</c><00:02:38.060><c> the</c><00:02:38.390><c> drop</c><00:02:38.600><c> down</c>

00:02:38.800 --> 00:02:38.810 align:start position:0%
more paste options open the drop down
 

00:02:38.810 --> 00:02:41.260 align:start position:0%
more paste options open the drop down
menu<00:02:39.110><c> here</c><00:02:39.190><c> these</c><00:02:40.190><c> commands</c><00:02:40.760><c> will</c><00:02:40.940><c> be</c><00:02:41.060><c> more</c>

00:02:41.260 --> 00:02:41.270 align:start position:0%
menu here these commands will be more
 

00:02:41.270 --> 00:02:43.300 align:start position:0%
menu here these commands will be more
useful<00:02:41.480><c> to</c><00:02:41.870><c> advanced</c><00:02:42.380><c> users</c><00:02:42.740><c> who</c><00:02:42.950><c> are</c><00:02:43.100><c> working</c>

00:02:43.300 --> 00:02:43.310 align:start position:0%
useful to advanced users who are working
 

00:02:43.310 --> 00:02:45.160 align:start position:0%
useful to advanced users who are working
with<00:02:43.550><c> cells</c><00:02:43.820><c> that</c><00:02:44.030><c> contain</c><00:02:44.360><c> formulas</c><00:02:44.960><c> or</c>

00:02:45.160 --> 00:02:45.170 align:start position:0%
with cells that contain formulas or
 

00:02:45.170 --> 00:02:47.530 align:start position:0%
with cells that contain formulas or
formatting<00:02:45.770><c> you</c><00:02:46.640><c> can</c><00:02:46.670><c> also</c><00:02:46.970><c> get</c><00:02:47.270><c> to</c><00:02:47.300><c> these</c>

00:02:47.530 --> 00:02:47.540 align:start position:0%
formatting you can also get to these
 

00:02:47.540 --> 00:02:49.480 align:start position:0%
formatting you can also get to these
commands<00:02:47.990><c> by</c><00:02:48.230><c> right-clicking</c><00:02:48.260><c> a</c><00:02:49.010><c> cell</c><00:02:49.220><c> in</c><00:02:49.460><c> the</c>

00:02:49.480 --> 00:02:49.490 align:start position:0%
commands by right-clicking a cell in the
 

00:02:49.490 --> 00:02:51.730 align:start position:0%
commands by right-clicking a cell in the
worksheet<00:02:49.940><c> for</c><00:02:50.660><c> example</c><00:02:51.140><c> to</c><00:02:51.290><c> cut</c><00:02:51.470><c> and</c><00:02:51.680><c> paste</c>

00:02:51.730 --> 00:02:51.740 align:start position:0%
worksheet for example to cut and paste
 

00:02:51.740 --> 00:02:55.600 align:start position:0%
worksheet for example to cut and paste
select<00:02:52.430><c> your</c><00:02:52.820><c> cells</c><00:02:53.230><c> now</c><00:02:54.230><c> right-click</c><00:02:54.680><c> then</c>

00:02:55.600 --> 00:02:55.610 align:start position:0%
select your cells now right-click then
 

00:02:55.610 --> 00:02:58.420 align:start position:0%
select your cells now right-click then
choose<00:02:55.670><c> cut</c><00:02:56.360><c> the</c><00:02:57.350><c> original</c><00:02:57.830><c> content</c><00:02:58.250><c> will</c>

00:02:58.420 --> 00:02:58.430 align:start position:0%
choose cut the original content will
 

00:02:58.430 --> 00:03:00.400 align:start position:0%
choose cut the original content will
disappear<00:02:58.970><c> as</c><00:02:59.180><c> soon</c><00:02:59.450><c> as</c><00:02:59.600><c> you</c><00:02:59.720><c> paste</c><00:02:59.960><c> it</c><00:03:00.170><c> in</c><00:03:00.290><c> the</c>

00:03:00.400 --> 00:03:00.410 align:start position:0%
disappear as soon as you paste it in the
 

00:03:00.410 --> 00:03:03.880 align:start position:0%
disappear as soon as you paste it in the
new<00:03:00.560><c> location</c><00:03:01.900><c> there's</c><00:03:02.900><c> also</c><00:03:03.200><c> the</c><00:03:03.470><c> drag</c><00:03:03.710><c> and</c>

00:03:03.880 --> 00:03:03.890 align:start position:0%
new location there's also the drag and
 

00:03:03.890 --> 00:03:05.740 align:start position:0%
new location there's also the drag and
drop<00:03:03.920><c> technique</c><00:03:04.490><c> for</c><00:03:04.760><c> moving</c><00:03:04.910><c> cells</c><00:03:05.360><c> from</c><00:03:05.600><c> one</c>

00:03:05.740 --> 00:03:05.750 align:start position:0%
drop technique for moving cells from one
 

00:03:05.750 --> 00:03:08.290 align:start position:0%
drop technique for moving cells from one
place<00:03:06.020><c> to</c><00:03:06.050><c> another</c><00:03:06.290><c> to</c><00:03:06.770><c> drag</c><00:03:07.490><c> and</c><00:03:07.700><c> drop</c><00:03:07.730><c> first</c>

00:03:08.290 --> 00:03:08.300 align:start position:0%
place to another to drag and drop first
 

00:03:08.300 --> 00:03:10.510 align:start position:0%
place to another to drag and drop first
select<00:03:08.900><c> your</c><00:03:08.960><c> cells</c><00:03:09.290><c> for</c><00:03:09.920><c> example</c><00:03:09.950><c> this</c>

00:03:10.510 --> 00:03:10.520 align:start position:0%
select your cells for example this
 

00:03:10.520 --> 00:03:12.450 align:start position:0%
select your cells for example this
column<00:03:10.970><c> that's</c><00:03:11.120><c> too</c><00:03:11.390><c> far</c><00:03:11.660><c> off</c><00:03:11.810><c> to</c><00:03:11.990><c> the</c><00:03:12.020><c> right</c>

00:03:12.450 --> 00:03:12.460 align:start position:0%
column that's too far off to the right
 

00:03:12.460 --> 00:03:15.070 align:start position:0%
column that's too far off to the right
then<00:03:13.460><c> place</c><00:03:13.820><c> your</c><00:03:13.850><c> cursor</c><00:03:14.360><c> on</c><00:03:14.390><c> an</c><00:03:14.690><c> outside</c>

00:03:15.070 --> 00:03:15.080 align:start position:0%
then place your cursor on an outside
 

00:03:15.080 --> 00:03:16.980 align:start position:0%
then place your cursor on an outside
edge<00:03:15.320><c> where</c><00:03:15.710><c> it</c><00:03:15.800><c> will</c><00:03:15.890><c> change</c><00:03:16.160><c> to</c><00:03:16.310><c> a</c><00:03:16.490><c> pointer</c>

00:03:16.980 --> 00:03:16.990 align:start position:0%
edge where it will change to a pointer
 

00:03:16.990 --> 00:03:20.080 align:start position:0%
edge where it will change to a pointer
now<00:03:17.990><c> click</c><00:03:18.380><c> hold</c><00:03:18.800><c> and</c><00:03:19.070><c> drag</c><00:03:19.160><c> the</c><00:03:19.430><c> cells</c><00:03:19.850><c> where</c>

00:03:20.080 --> 00:03:20.090 align:start position:0%
now click hold and drag the cells where
 

00:03:20.090 --> 00:03:23.380 align:start position:0%
now click hold and drag the cells where
you<00:03:20.210><c> want</c><00:03:20.420><c> them</c><00:03:20.570><c> to</c><00:03:20.750><c> go</c><00:03:21.670><c> there</c><00:03:22.670><c> that's</c><00:03:23.060><c> much</c>

00:03:23.380 --> 00:03:23.390 align:start position:0%
you want them to go there that's much
 

00:03:23.390 --> 00:03:24.450 align:start position:0%
you want them to go there that's much
better

00:03:24.450 --> 00:03:24.460 align:start position:0%
better
 

00:03:24.460 --> 00:03:26.860 align:start position:0%
better
to<00:03:25.460><c> mark</c><00:03:25.670><c> the</c><00:03:25.790><c> rest</c><00:03:26.030><c> of</c><00:03:26.210><c> the</c><00:03:26.300><c> people</c><00:03:26.480><c> who</c><00:03:26.780><c> are</c>

00:03:26.860 --> 00:03:26.870 align:start position:0%
to mark the rest of the people who are
 

00:03:26.870 --> 00:03:28.720 align:start position:0%
to mark the rest of the people who are
going<00:03:27.050><c> to</c><00:03:27.170><c> attend</c><00:03:27.590><c> I'm</c><00:03:27.830><c> going</c><00:03:28.190><c> to</c><00:03:28.280><c> use</c><00:03:28.460><c> one</c><00:03:28.700><c> of</c>

00:03:28.720 --> 00:03:28.730 align:start position:0%
going to attend I'm going to use one of
 

00:03:28.730 --> 00:03:31.090 align:start position:0%
going to attend I'm going to use one of
my<00:03:28.820><c> favorite</c><00:03:29.450><c> techniques</c><00:03:29.680><c> filling</c><00:03:30.680><c> in</c><00:03:30.800><c> cells</c>

00:03:31.090 --> 00:03:31.100 align:start position:0%
my favorite techniques filling in cells
 

00:03:31.100 --> 00:03:33.040 align:start position:0%
my favorite techniques filling in cells
with<00:03:31.340><c> the</c><00:03:31.430><c> fill</c><00:03:31.640><c> handle</c><00:03:31.850><c> you</c><00:03:32.660><c> can</c><00:03:32.690><c> fill</c>

00:03:33.040 --> 00:03:33.050 align:start position:0%
with the fill handle you can fill
 

00:03:33.050 --> 00:03:35.230 align:start position:0%
with the fill handle you can fill
vertically<00:03:33.530><c> or</c><00:03:33.740><c> horizontally</c><00:03:33.770><c> by</c><00:03:34.700><c> selecting</c>

00:03:35.230 --> 00:03:35.240 align:start position:0%
vertically or horizontally by selecting
 

00:03:35.240 --> 00:03:37.690 align:start position:0%
vertically or horizontally by selecting
the<00:03:35.360><c> cell</c><00:03:35.570><c> you</c><00:03:35.750><c> want</c><00:03:35.900><c> to</c><00:03:36.080><c> use</c><00:03:36.320><c> then</c><00:03:37.280><c> clicking</c>

00:03:37.690 --> 00:03:37.700 align:start position:0%
the cell you want to use then clicking
 

00:03:37.700 --> 00:03:39.070 align:start position:0%
the cell you want to use then clicking
and<00:03:37.970><c> dragging</c><00:03:38.030><c> the</c><00:03:38.510><c> square</c><00:03:38.840><c> in</c><00:03:38.960><c> the</c>

00:03:39.070 --> 00:03:39.080 align:start position:0%
and dragging the square in the
 

00:03:39.080 --> 00:03:40.030 align:start position:0%
and dragging the square in the
bottom-right<00:03:39.410><c> corner</c>

00:03:40.030 --> 00:03:40.040 align:start position:0%
bottom-right corner
 

00:03:40.040 --> 00:03:42.310 align:start position:0%
bottom-right corner
that's<00:03:40.460><c> the</c><00:03:40.700><c> fill</c><00:03:40.910><c> handle</c><00:03:41.120><c> over</c><00:03:41.450><c> the</c><00:03:42.110><c> cells</c>

00:03:42.310 --> 00:03:42.320 align:start position:0%
that's the fill handle over the cells
 

00:03:42.320 --> 00:03:45.490 align:start position:0%
that's the fill handle over the cells
you<00:03:42.500><c> want</c><00:03:42.710><c> to</c><00:03:42.830><c> fill</c><00:03:43.570><c> now</c><00:03:44.570><c> you</c><00:03:44.630><c> know</c><00:03:44.930><c> the</c><00:03:45.080><c> basics</c>

00:03:45.490 --> 00:03:45.500 align:start position:0%
you want to fill now you know the basics
 

00:03:45.500 --> 00:03:48.250 align:start position:0%
you want to fill now you know the basics
including<00:03:45.740><c> insert</c><00:03:46.610><c> and</c><00:03:46.850><c> delete</c><00:03:46.940><c> cut</c><00:03:47.810><c> copy</c><00:03:48.080><c> and</c>

00:03:48.250 --> 00:03:48.260 align:start position:0%
including insert and delete cut copy and
 

00:03:48.260 --> 00:03:51.130 align:start position:0%
including insert and delete cut copy and
paste<00:03:48.470><c> drag</c><00:03:49.460><c> and</c><00:03:49.640><c> drop</c><00:03:49.850><c> and</c><00:03:50.120><c> using</c><00:03:50.870><c> the</c><00:03:50.960><c> fill</c>

00:03:51.130 --> 00:03:51.140 align:start position:0%
paste drag and drop and using the fill
 

00:03:51.140 --> 00:03:53.230 align:start position:0%
paste drag and drop and using the fill
handle<00:03:51.550><c> everything</c><00:03:52.550><c> you</c><00:03:52.640><c> need</c><00:03:52.850><c> to</c><00:03:53.000><c> work</c><00:03:53.210><c> with</c>

00:03:53.230 --> 00:03:53.240 align:start position:0%
handle everything you need to work with
 

00:03:53.240 --> 00:03:57.120 align:start position:0%
handle everything you need to work with
cells<00:03:53.660><c> in</c><00:03:53.930><c> Excel</c><00:03:54.050><c> 2010</c>

00:03:57.120 --> 00:03:57.130 align:start position:0%
 
 

00:03:57.130 --> 00:04:01.090 align:start position:0%
 
like<00:03:58.130><c> what</c><00:03:58.310><c> you</c><00:03:58.460><c> just</c><00:03:58.640><c> saw</c><00:03:59.350><c> rate</c><00:04:00.350><c> it</c><00:04:00.530><c> at</c><00:04:01.040><c> a</c>

00:04:01.090 --> 00:04:01.100 align:start position:0%
like what you just saw rate it at a
 

00:04:01.100 --> 00:04:04.180 align:start position:0%
like what you just saw rate it at a
comment<00:04:01.610><c> subscribe</c><00:04:02.150><c> to</c><00:04:02.450><c> our</c><00:04:02.720><c> chill</c><00:04:03.190><c> the</c>

00:04:04.180 --> 00:04:04.190 align:start position:0%
comment subscribe to our chill the
 

00:04:04.190 --> 00:04:08.440 align:start position:0%
comment subscribe to our chill the
freedom<00:04:04.640><c> to</c><00:04:04.760><c> learn</c><00:04:05.560><c> what</c><00:04:06.560><c> you</c><00:04:06.770><c> want</c><00:04:07.240><c> when</c><00:04:08.240><c> you</c>

00:04:08.440 --> 00:04:08.450 align:start position:0%
freedom to learn what you want when you
 

00:04:08.450 --> 00:04:18.459 align:start position:0%
freedom to learn what you want when you
want<00:04:09.670><c> absolutely</c><00:04:10.670><c> free</c><00:04:14.830><c> GCF</c><00:04:15.830><c> learn</c><00:04:16.430><c> free.org</c>