WEBVTT
Kind: captions
Language: en

00:00:01.180 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.180><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

00:00:03.729 --> 00:00:03.739 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.739 --> 00:00:08.949 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.640><c> life</c><00:00:07.959><c> every</c>

00:00:08.949 --> 00:00:08.959 align:start position:0%
opportunities for a better life every
 

00:00:08.959 --> 00:00:10.930 align:start position:0%
opportunities for a better life every
worksheet<00:00:09.410><c> contains</c><00:00:09.679><c> thousands</c><00:00:10.549><c> of</c><00:00:10.669><c> cells</c>

00:00:10.930 --> 00:00:10.940 align:start position:0%
worksheet contains thousands of cells
 

00:00:10.940 --> 00:00:12.430 align:start position:0%
worksheet contains thousands of cells
where<00:00:11.299><c> different</c><00:00:11.690><c> columns</c><00:00:12.110><c> and</c><00:00:12.289><c> rows</c>

00:00:12.430 --> 00:00:12.440 align:start position:0%
where different columns and rows
 

00:00:12.440 --> 00:00:14.739 align:start position:0%
where different columns and rows
intersect<00:00:13.160><c> you'll</c><00:00:13.910><c> need</c><00:00:14.119><c> to</c><00:00:14.269><c> know</c><00:00:14.419><c> how</c><00:00:14.719><c> to</c>

00:00:14.739 --> 00:00:14.749 align:start position:0%
intersect you'll need to know how to
 

00:00:14.749 --> 00:00:16.839 align:start position:0%
intersect you'll need to know how to
work<00:00:14.990><c> with</c><00:00:15.200><c> these</c><00:00:15.379><c> cells</c><00:00:15.740><c> in</c><00:00:16.039><c> order</c><00:00:16.369><c> to</c><00:00:16.519><c> enter</c>

00:00:16.839 --> 00:00:16.849 align:start position:0%
work with these cells in order to enter
 

00:00:16.849 --> 00:00:20.050 align:start position:0%
work with these cells in order to enter
and<00:00:17.119><c> edit</c><00:00:17.480><c> data</c><00:00:18.160><c> every</c><00:00:19.160><c> cell</c><00:00:19.400><c> has</c><00:00:19.429><c> its</c><00:00:19.699><c> own</c>

00:00:20.050 --> 00:00:20.060 align:start position:0%
and edit data every cell has its own
 

00:00:20.060 --> 00:00:22.029 align:start position:0%
and edit data every cell has its own
name<00:00:20.330><c> based</c><00:00:20.689><c> on</c><00:00:20.869><c> its</c><00:00:21.019><c> location</c><00:00:21.349><c> sometimes</c>

00:00:22.029 --> 00:00:22.039 align:start position:0%
name based on its location sometimes
 

00:00:22.039 --> 00:00:24.550 align:start position:0%
name based on its location sometimes
called<00:00:22.490><c> a</c><00:00:22.609><c> cell</c><00:00:22.820><c> address</c><00:00:23.150><c> in</c><00:00:23.390><c> this</c><00:00:24.170><c> example</c>

00:00:24.550 --> 00:00:24.560 align:start position:0%
called a cell address in this example
 

00:00:24.560 --> 00:00:26.980 align:start position:0%
called a cell address in this example
the<00:00:24.949><c> cell</c><00:00:25.130><c> I've</c><00:00:25.310><c> selected</c><00:00:25.580><c> is</c><00:00:26.089><c> where</c><00:00:26.330><c> column</c><00:00:26.750><c> D</c>

00:00:26.980 --> 00:00:26.990 align:start position:0%
the cell I've selected is where column D
 

00:00:26.990 --> 00:00:29.620 align:start position:0%
the cell I've selected is where column D
and<00:00:27.259><c> row</c><00:00:27.589><c> six</c><00:00:27.980><c> intersect</c><00:00:28.640><c> making</c><00:00:29.330><c> the</c><00:00:29.419><c> cell</c>

00:00:29.620 --> 00:00:29.630 align:start position:0%
and row six intersect making the cell
 

00:00:29.630 --> 00:00:30.849 align:start position:0%
and row six intersect making the cell
address<00:00:29.749><c> d6</c>

00:00:30.849 --> 00:00:30.859 align:start position:0%
address d6
 

00:00:30.859 --> 00:00:33.549 align:start position:0%
address d6
the<00:00:31.730><c> address</c><00:00:32.060><c> also</c><00:00:32.329><c> appears</c><00:00:32.840><c> in</c><00:00:33.050><c> the</c><00:00:33.170><c> name</c><00:00:33.379><c> box</c>

00:00:33.549 --> 00:00:33.559 align:start position:0%
the address also appears in the name box
 

00:00:33.559 --> 00:00:37.119 align:start position:0%
the address also appears in the name box
above<00:00:34.070><c> the</c><00:00:34.129><c> worksheet</c><00:00:35.440><c> to</c><00:00:36.440><c> select</c><00:00:36.800><c> a</c><00:00:36.920><c> cell</c>

00:00:37.119 --> 00:00:37.129 align:start position:0%
above the worksheet to select a cell
 

00:00:37.129 --> 00:00:39.760 align:start position:0%
above the worksheet to select a cell
just<00:00:37.550><c> click</c><00:00:37.760><c> it</c><00:00:37.940><c> you</c><00:00:38.870><c> can</c><00:00:38.899><c> even</c><00:00:39.170><c> use</c><00:00:39.410><c> the</c><00:00:39.590><c> arrow</c>

00:00:39.760 --> 00:00:39.770 align:start position:0%
just click it you can even use the arrow
 

00:00:39.770 --> 00:00:41.049 align:start position:0%
just click it you can even use the arrow
keys<00:00:40.129><c> on</c><00:00:40.280><c> your</c><00:00:40.399><c> keyboard</c><00:00:40.460><c> to</c><00:00:40.969><c> navigate</c>

00:00:41.049 --> 00:00:41.059 align:start position:0%
keys on your keyboard to navigate
 

00:00:41.059 --> 00:00:43.180 align:start position:0%
keys on your keyboard to navigate
between<00:00:41.539><c> cells</c><00:00:41.780><c> instead</c><00:00:42.649><c> of</c><00:00:42.739><c> clicking</c><00:00:42.980><c> with</c>

00:00:43.180 --> 00:00:43.190 align:start position:0%
between cells instead of clicking with
 

00:00:43.190 --> 00:00:46.180 align:start position:0%
between cells instead of clicking with
your<00:00:43.219><c> mouse</c><00:00:44.050><c> to</c><00:00:45.050><c> select</c><00:00:45.079><c> more</c><00:00:45.590><c> than</c><00:00:45.649><c> one</c><00:00:45.949><c> cell</c>

00:00:46.180 --> 00:00:46.190 align:start position:0%
your mouse to select more than one cell
 

00:00:46.190 --> 00:00:48.279 align:start position:0%
your mouse to select more than one cell
at<00:00:46.309><c> a</c><00:00:46.370><c> time</c><00:00:46.399><c> known</c><00:00:47.030><c> as</c><00:00:47.180><c> a</c><00:00:47.210><c> cell</c><00:00:47.480><c> range</c><00:00:47.719><c> click</c>

00:00:48.279 --> 00:00:48.289 align:start position:0%
at a time known as a cell range click
 

00:00:48.289 --> 00:00:50.500 align:start position:0%
at a time known as a cell range click
and<00:00:48.530><c> drag</c><00:00:48.890><c> and</c><00:00:49.160><c> the</c><00:00:49.550><c> entire</c><00:00:49.579><c> range</c><00:00:50.270><c> will</c><00:00:50.480><c> be</c>

00:00:50.500 --> 00:00:50.510 align:start position:0%
and drag and the entire range will be
 

00:00:50.510 --> 00:00:53.650 align:start position:0%
and drag and the entire range will be
highlighted<00:00:51.609><c> you</c><00:00:52.609><c> can</c><00:00:52.640><c> enter</c><00:00:53.030><c> lots</c><00:00:53.239><c> of</c><00:00:53.420><c> things</c>

00:00:53.650 --> 00:00:53.660 align:start position:0%
highlighted you can enter lots of things
 

00:00:53.660 --> 00:00:55.959 align:start position:0%
highlighted you can enter lots of things
into<00:00:53.930><c> a</c><00:00:53.960><c> cell</c><00:00:54.260><c> for</c><00:00:54.739><c> example</c><00:00:55.219><c> all</c><00:00:55.399><c> of</c><00:00:55.460><c> mine</c>

00:00:55.959 --> 00:00:55.969 align:start position:0%
into a cell for example all of mine
 

00:00:55.969 --> 00:00:58.060 align:start position:0%
into a cell for example all of mine
contain<00:00:56.480><c> text</c><00:00:56.780><c> but</c><00:00:57.379><c> they</c><00:00:57.530><c> can</c><00:00:57.739><c> contain</c>

00:00:58.060 --> 00:00:58.070 align:start position:0%
contain text but they can contain
 

00:00:58.070 --> 00:01:00.279 align:start position:0%
contain text but they can contain
advanced<00:00:58.550><c> properties</c><00:00:59.000><c> -</c><00:00:59.239><c> like</c><00:00:59.660><c> formulas</c>

00:01:00.279 --> 00:01:00.289 align:start position:0%
advanced properties - like formulas
 

00:01:00.289 --> 00:01:03.310 align:start position:0%
advanced properties - like formulas
functions<00:01:00.769><c> and</c><00:01:01.370><c> formatting</c><00:01:01.850><c> elements</c><00:01:02.420><c> for</c>

00:01:03.310 --> 00:01:03.320 align:start position:0%
functions and formatting elements for
 

00:01:03.320 --> 00:01:05.109 align:start position:0%
functions and formatting elements for
now<00:01:03.440><c> I'd</c><00:01:03.769><c> just</c><00:01:03.800><c> like</c><00:01:04.160><c> to</c><00:01:04.190><c> show</c><00:01:04.400><c> you</c><00:01:04.460><c> the</c><00:01:04.640><c> basics</c>

00:01:05.109 --> 00:01:05.119 align:start position:0%
now I'd just like to show you the basics
 

00:01:05.119 --> 00:01:07.660 align:start position:0%
now I'd just like to show you the basics
we'll<00:01:05.930><c> start</c><00:01:06.200><c> with</c><00:01:06.350><c> inserting</c><00:01:06.770><c> content</c><00:01:07.130><c> into</c>

00:01:07.660 --> 00:01:07.670 align:start position:0%
we'll start with inserting content into
 

00:01:07.670 --> 00:01:08.280 align:start position:0%
we'll start with inserting content into
a<00:01:07.700><c> cell</c>

00:01:08.280 --> 00:01:08.290 align:start position:0%
a cell
 

00:01:08.290 --> 00:01:10.719 align:start position:0%
a cell
this<00:01:09.290><c> person</c><00:01:09.710><c> has</c><00:01:09.830><c> confirmed</c><00:01:10.280><c> that</c><00:01:10.490><c> she</c>

00:01:10.719 --> 00:01:10.729 align:start position:0%
this person has confirmed that she
 

00:01:10.729 --> 00:01:12.999 align:start position:0%
this person has confirmed that she
completed<00:01:11.119><c> part</c><00:01:11.509><c> two</c><00:01:11.689><c> of</c><00:01:11.720><c> the</c><00:01:11.990><c> training</c><00:01:12.409><c> so</c>

00:01:12.999 --> 00:01:13.009 align:start position:0%
completed part two of the training so
 

00:01:13.009 --> 00:01:16.420 align:start position:0%
completed part two of the training so
I'm<00:01:13.100><c> going</c><00:01:13.340><c> to</c><00:01:13.400><c> select</c><00:01:13.700><c> cell</c><00:01:14.150><c> f9</c><00:01:14.920><c> then</c><00:01:15.920><c> type</c><00:01:16.250><c> in</c>

00:01:16.420 --> 00:01:16.430 align:start position:0%
I'm going to select cell f9 then type in
 

00:01:16.430 --> 00:01:19.810 align:start position:0%
I'm going to select cell f9 then type in
X<00:01:17.409><c> it</c><00:01:18.409><c> appears</c><00:01:18.799><c> in</c><00:01:18.950><c> the</c><00:01:19.070><c> cell</c><00:01:19.280><c> and</c><00:01:19.610><c> in</c><00:01:19.790><c> the</c>

00:01:19.810 --> 00:01:19.820 align:start position:0%
X it appears in the cell and in the
 

00:01:19.820 --> 00:01:22.120 align:start position:0%
X it appears in the cell and in the
formula<00:01:19.909><c> bar</c><00:01:20.479><c> where</c><00:01:20.900><c> you</c><00:01:20.930><c> can</c><00:01:21.200><c> also</c><00:01:21.350><c> enter</c><00:01:21.710><c> or</c>

00:01:22.120 --> 00:01:22.130 align:start position:0%
formula bar where you can also enter or
 

00:01:22.130 --> 00:01:24.520 align:start position:0%
formula bar where you can also enter or
edit<00:01:22.310><c> the</c><00:01:22.549><c> contents</c><00:01:23.000><c> of</c><00:01:23.090><c> your</c><00:01:23.150><c> cell</c><00:01:23.479><c> in</c><00:01:23.689><c> fact</c>

00:01:24.520 --> 00:01:24.530 align:start position:0%
edit the contents of your cell in fact
 

00:01:24.530 --> 00:01:26.109 align:start position:0%
edit the contents of your cell in fact
I'm<00:01:24.799><c> going</c><00:01:25.040><c> to</c><00:01:25.130><c> take</c><00:01:25.340><c> this</c><00:01:25.460><c> opportunity</c><00:01:25.640><c> to</c>

00:01:26.109 --> 00:01:26.119 align:start position:0%
I'm going to take this opportunity to
 

00:01:26.119 --> 00:01:28.749 align:start position:0%
I'm going to take this opportunity to
change<00:01:26.570><c> the</c><00:01:26.780><c> X</c><00:01:26.960><c> to</c><00:01:27.350><c> a</c><00:01:27.380><c> capital</c><00:01:27.860><c> X</c><00:01:28.070><c> so</c><00:01:28.369><c> it's</c>

00:01:28.749 --> 00:01:28.759 align:start position:0%
change the X to a capital X so it's
 

00:01:28.759 --> 00:01:32.050 align:start position:0%
change the X to a capital X so it's
consistent<00:01:29.180><c> with</c><00:01:29.420><c> the</c><00:01:29.509><c> rest</c><00:01:29.720><c> of</c><00:01:29.899><c> the</c><00:01:30.020><c> list</c><00:01:31.060><c> now</c>

00:01:32.050 --> 00:01:32.060 align:start position:0%
consistent with the rest of the list now
 

00:01:32.060 --> 00:01:33.069 align:start position:0%
consistent with the rest of the list now
for<00:01:32.299><c> the</c><00:01:32.360><c> next</c><00:01:32.540><c> person</c>

00:01:33.069 --> 00:01:33.079 align:start position:0%
for the next person
 

00:01:33.079 --> 00:01:35.350 align:start position:0%
for the next person
Walter<00:01:33.649><c> although</c><00:01:34.579><c> it</c><00:01:34.700><c> looks</c><00:01:34.909><c> like</c><00:01:35.060><c> I've</c><00:01:35.210><c> made</c>

00:01:35.350 --> 00:01:35.360 align:start position:0%
Walter although it looks like I've made
 

00:01:35.360 --> 00:01:37.810 align:start position:0%
Walter although it looks like I've made
a<00:01:35.420><c> mistake</c><00:01:35.570><c> he's</c><00:01:36.439><c> on</c><00:01:36.590><c> the</c><00:01:36.710><c> list</c><00:01:36.860><c> twice</c><00:01:37.250><c> both</c>

00:01:37.810 --> 00:01:37.820 align:start position:0%
a mistake he's on the list twice both
 

00:01:37.820 --> 00:01:41.109 align:start position:0%
a mistake he's on the list twice both
here<00:01:38.299><c> and</c><00:01:38.420><c> here</c><00:01:39.380><c> I'm</c><00:01:39.590><c> just</c><00:01:40.520><c> going</c><00:01:40.700><c> to</c><00:01:40.820><c> clear</c>

00:01:41.109 --> 00:01:41.119 align:start position:0%
here and here I'm just going to clear
 

00:01:41.119 --> 00:01:42.670 align:start position:0%
here and here I'm just going to clear
the<00:01:41.270><c> contents</c><00:01:41.479><c> of</c><00:01:41.810><c> the</c><00:01:41.930><c> extra</c><00:01:42.290><c> row</c><00:01:42.470><c> by</c>

00:01:42.670 --> 00:01:42.680 align:start position:0%
the contents of the extra row by
 

00:01:42.680 --> 00:01:46.240 align:start position:0%
the contents of the extra row by
selecting<00:01:43.219><c> the</c><00:01:43.340><c> cells</c><00:01:44.770><c> then</c><00:01:45.770><c> clicking</c><00:01:46.130><c> the</c>

00:01:46.240 --> 00:01:46.250 align:start position:0%
selecting the cells then clicking the
 

00:01:46.250 --> 00:01:48.700 align:start position:0%
selecting the cells then clicking the
clear<00:01:46.579><c> command</c><00:01:46.759><c> on</c><00:01:47.060><c> the</c><00:01:47.180><c> ribbon</c><00:01:47.210><c> and</c><00:01:47.710><c> choosing</c>

00:01:48.700 --> 00:01:48.710 align:start position:0%
clear command on the ribbon and choosing
 

00:01:48.710 --> 00:01:52.330 align:start position:0%
clear command on the ribbon and choosing
clear<00:01:49.280><c> contents</c><00:01:50.680><c> you</c><00:01:51.680><c> can</c><00:01:51.710><c> also</c><00:01:52.040><c> use</c>

00:01:52.330 --> 00:01:52.340 align:start position:0%
clear contents you can also use
 

00:01:52.340 --> 00:01:55.749 align:start position:0%
clear contents you can also use
backspace<00:01:52.939><c> or</c><00:01:53.149><c> delete</c><00:01:53.240><c> on</c><00:01:53.750><c> your</c><00:01:53.780><c> keyboard</c><00:01:54.759><c> so</c>

00:01:55.749 --> 00:01:55.759 align:start position:0%
backspace or delete on your keyboard so
 

00:01:55.759 --> 00:01:57.490 align:start position:0%
backspace or delete on your keyboard so
let's<00:01:55.969><c> take</c><00:01:56.149><c> a</c><00:01:56.180><c> look</c><00:01:56.360><c> at</c><00:01:56.509><c> what</c><00:01:56.630><c> that</c><00:01:56.750><c> did</c><00:01:57.020><c> it</c>

00:01:57.490 --> 00:01:57.500 align:start position:0%
let's take a look at what that did it
 

00:01:57.500 --> 00:01:59.859 align:start position:0%
let's take a look at what that did it
cleared<00:01:58.009><c> the</c><00:01:58.280><c> contents</c><00:01:58.880><c> of</c><00:01:58.969><c> the</c><00:01:59.119><c> cell</c><00:01:59.360><c> but</c><00:01:59.750><c> the</c>

00:01:59.859 --> 00:01:59.869 align:start position:0%
cleared the contents of the cell but the
 

00:01:59.869 --> 00:02:02.319 align:start position:0%
cleared the contents of the cell but the
row<00:02:00.049><c> is</c><00:02:00.229><c> still</c><00:02:00.469><c> there</c><00:02:00.649><c> that's</c><00:02:01.130><c> okay</c><00:02:01.520><c> if</c><00:02:01.729><c> you</c>

00:02:02.319 --> 00:02:02.329 align:start position:0%
row is still there that's okay if you
 

00:02:02.329 --> 00:02:04.240 align:start position:0%
row is still there that's okay if you
want<00:02:02.539><c> to</c><00:02:02.630><c> delete</c><00:02:02.899><c> the</c><00:02:03.079><c> cells</c><00:02:03.320><c> altogether</c><00:02:03.950><c> all</c>

00:02:04.240 --> 00:02:04.250 align:start position:0%
want to delete the cells altogether all
 

00:02:04.250 --> 00:02:05.859 align:start position:0%
want to delete the cells altogether all
you<00:02:04.460><c> have</c><00:02:04.640><c> to</c><00:02:04.759><c> do</c><00:02:04.909><c> is</c><00:02:05.119><c> click</c><00:02:05.390><c> the</c><00:02:05.539><c> delete</c>

00:02:05.859 --> 00:02:05.869 align:start position:0%
you have to do is click the delete
 

00:02:05.869 --> 00:02:08.980 align:start position:0%
you have to do is click the delete
command<00:02:06.020><c> instead</c><00:02:07.119><c> that</c><00:02:08.119><c> actually</c><00:02:08.660><c> removes</c>

00:02:08.980 --> 00:02:08.990 align:start position:0%
command instead that actually removes
 

00:02:08.990 --> 00:02:11.020 align:start position:0%
command instead that actually removes
the<00:02:09.290><c> cells</c><00:02:09.530><c> from</c><00:02:09.740><c> the</c><00:02:09.920><c> worksheet</c><00:02:10.310><c> causing</c><00:02:10.940><c> the</c>

00:02:11.020 --> 00:02:11.030 align:start position:0%
the cells from the worksheet causing the
 

00:02:11.030 --> 00:02:13.120 align:start position:0%
the cells from the worksheet causing the
cells<00:02:11.300><c> underneath</c><00:02:11.660><c> to</c><00:02:12.080><c> shift</c><00:02:12.320><c> up</c><00:02:12.530><c> and</c><00:02:12.710><c> fill</c><00:02:13.010><c> in</c>

00:02:13.120 --> 00:02:13.130 align:start position:0%
cells underneath to shift up and fill in
 

00:02:13.130 --> 00:02:13.870 align:start position:0%
cells underneath to shift up and fill in
the<00:02:13.250><c> gap</c>

00:02:13.870 --> 00:02:13.880 align:start position:0%
the gap
 

00:02:13.880 --> 00:02:15.640 align:start position:0%
the gap
just<00:02:14.480><c> remember</c><00:02:14.840><c> that</c><00:02:14.870><c> there's</c><00:02:15.170><c> a</c><00:02:15.230><c> difference</c>

00:02:15.640 --> 00:02:15.650 align:start position:0%
just remember that there's a difference
 

00:02:15.650 --> 00:02:17.830 align:start position:0%
just remember that there's a difference
between<00:02:15.710><c> clearing</c><00:02:16.460><c> and</c><00:02:16.670><c> deleting</c><00:02:17.120><c> cells</c><00:02:17.390><c> so</c>

00:02:17.830 --> 00:02:17.840 align:start position:0%
between clearing and deleting cells so
 

00:02:17.840 --> 00:02:19.720 align:start position:0%
between clearing and deleting cells so
you<00:02:17.870><c> don't</c><00:02:18.140><c> accidentally</c><00:02:18.740><c> delete</c><00:02:19.040><c> cells</c><00:02:19.490><c> that</c>

00:02:19.720 --> 00:02:19.730 align:start position:0%
you don't accidentally delete cells that
 

00:02:19.730 --> 00:02:22.960 align:start position:0%
you don't accidentally delete cells that
you<00:02:19.880><c> want</c><00:02:20.060><c> to</c><00:02:20.150><c> keep</c><00:02:21.310><c> now</c><00:02:22.310><c> I'd</c><00:02:22.520><c> like</c><00:02:22.670><c> to</c><00:02:22.820><c> show</c>

00:02:22.960 --> 00:02:22.970 align:start position:0%
you want to keep now I'd like to show
 

00:02:22.970 --> 00:02:24.850 align:start position:0%
you want to keep now I'd like to show
you<00:02:23.000><c> a</c><00:02:23.150><c> way</c><00:02:23.360><c> to</c><00:02:23.390><c> save</c><00:02:23.510><c> time</c><00:02:23.750><c> by</c><00:02:24.170><c> copying</c><00:02:24.410><c> and</c>

00:02:24.850 --> 00:02:24.860 align:start position:0%
you a way to save time by copying and
 

00:02:24.860 --> 00:02:27.550 align:start position:0%
you a way to save time by copying and
pasting<00:02:25.040><c> content</c><00:02:25.540><c> for</c><00:02:26.540><c> example</c><00:02:26.660><c> I</c><00:02:27.200><c> need</c><00:02:27.320><c> to</c>

00:02:27.550 --> 00:02:27.560 align:start position:0%
pasting content for example I need to
 

00:02:27.560 --> 00:02:28.780 align:start position:0%
pasting content for example I need to
mark<00:02:27.770><c> the</c><00:02:27.920><c> rest</c><00:02:28.130><c> of</c><00:02:28.280><c> the</c><00:02:28.370><c> people</c><00:02:28.670><c> who</c>

00:02:28.780 --> 00:02:28.790 align:start position:0%
mark the rest of the people who
 

00:02:28.790 --> 00:02:31.390 align:start position:0%
mark the rest of the people who
completed<00:02:29.270><c> part</c><00:02:29.510><c> 2</c><00:02:29.690><c> of</c><00:02:29.720><c> the</c><00:02:29.930><c> training</c><00:02:30.400><c> start</c>

00:02:31.390 --> 00:02:31.400 align:start position:0%
completed part 2 of the training start
 

00:02:31.400 --> 00:02:33.820 align:start position:0%
completed part 2 of the training start
by<00:02:31.520><c> clicking</c><00:02:31.760><c> the</c><00:02:31.940><c> cell</c><00:02:32.240><c> you</c><00:02:32.390><c> want</c><00:02:32.570><c> then</c><00:02:33.440><c> click</c>

00:02:33.820 --> 00:02:33.830 align:start position:0%
by clicking the cell you want then click
 

00:02:33.830 --> 00:02:37.240 align:start position:0%
by clicking the cell you want then click
copy<00:02:34.070><c> on</c><00:02:34.490><c> the</c><00:02:34.640><c> ribbon</c><00:02:35.710><c> you'll</c><00:02:36.710><c> see</c><00:02:36.920><c> a</c><00:02:36.950><c> dashed</c>

00:02:37.240 --> 00:02:37.250 align:start position:0%
copy on the ribbon you'll see a dashed
 

00:02:37.250 --> 00:02:39.450 align:start position:0%
copy on the ribbon you'll see a dashed
box<00:02:37.640><c> that</c><00:02:37.880><c> appears</c><00:02:38.000><c> around</c><00:02:38.360><c> the</c><00:02:38.600><c> copied</c><00:02:38.990><c> cell</c>

00:02:39.450 --> 00:02:39.460 align:start position:0%
box that appears around the copied cell
 

00:02:39.460 --> 00:02:42.100 align:start position:0%
box that appears around the copied cell
next<00:02:40.460><c> select</c><00:02:41.120><c> the</c><00:02:41.210><c> cells</c><00:02:41.480><c> where</c><00:02:41.720><c> you</c><00:02:41.810><c> want</c><00:02:41.990><c> the</c>

00:02:42.100 --> 00:02:42.110 align:start position:0%
next select the cells where you want the
 

00:02:42.110 --> 00:02:47.440 align:start position:0%
next select the cells where you want the
content<00:02:42.470><c> to</c><00:02:42.590><c> go</c><00:02:43.600><c> then</c><00:02:44.600><c> click</c><00:02:44.930><c> paste</c><00:02:46.060><c> to</c><00:02:47.060><c> access</c>

00:02:47.440 --> 00:02:47.450 align:start position:0%
content to go then click paste to access
 

00:02:47.450 --> 00:02:49.720 align:start position:0%
content to go then click paste to access
more<00:02:47.690><c> paste</c><00:02:47.990><c> options</c><00:02:48.470><c> open</c><00:02:48.950><c> the</c><00:02:49.310><c> drop</c><00:02:49.520><c> down</c>

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

00:02:49.730 --> 00:02:52.000 align:start position:0%
more paste options open the drop down
menu<00:02:50.090><c> here</c><00:02:50.120><c> these</c><00:02:51.110><c> commands</c><00:02:51.500><c> will</c><00:02:51.710><c> come</c><00:02:51.890><c> in</c>

00:02:52.000 --> 00:02:52.010 align:start position:0%
menu here these commands will come in
 

00:02:52.010 --> 00:02:53.350 align:start position:0%
menu here these commands will come in
handy<00:02:52.190><c> if</c><00:02:52.490><c> you're</c><00:02:52.640><c> copying</c><00:02:52.850><c> and</c><00:02:53.210><c> pasting</c>

00:02:53.350 --> 00:02:53.360 align:start position:0%
handy if you're copying and pasting
 

00:02:53.360 --> 00:02:55.780 align:start position:0%
handy if you're copying and pasting
cells<00:02:53.870><c> that</c><00:02:54.110><c> contain</c><00:02:54.410><c> formulas</c><00:02:55.040><c> or</c><00:02:55.310><c> advanced</c>

00:02:55.780 --> 00:02:55.790 align:start position:0%
cells that contain formulas or advanced
 

00:02:55.790 --> 00:02:58.330 align:start position:0%
cells that contain formulas or advanced
formatting<00:02:56.410><c> you</c><00:02:57.410><c> can</c><00:02:57.590><c> also</c><00:02:57.800><c> get</c><00:02:58.100><c> to</c><00:02:58.220><c> these</c>

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

00:02:58.340 --> 00:02:59.920 align:start position:0%
formatting you can also get to these
commands<00:02:58.790><c> by</c><00:02:59.000><c> right-clicking</c><00:02:59.030><c> in</c><00:02:59.810><c> the</c>

00:02:59.920 --> 00:02:59.930 align:start position:0%
commands by right-clicking in the
 

00:02:59.930 --> 00:03:02.350 align:start position:0%
commands by right-clicking in the
worksheet<00:03:00.290><c> for</c><00:03:01.160><c> example</c><00:03:01.610><c> to</c><00:03:01.910><c> cut</c><00:03:02.060><c> and</c><00:03:02.300><c> paste</c>

00:03:02.350 --> 00:03:02.360 align:start position:0%
worksheet for example to cut and paste
 

00:03:02.360 --> 00:03:05.550 align:start position:0%
worksheet for example to cut and paste
select<00:03:03.170><c> your</c><00:03:03.530><c> cells</c><00:03:03.770><c> then</c><00:03:04.700><c> right-click</c><00:03:05.330><c> and</c>

00:03:05.550 --> 00:03:05.560 align:start position:0%
select your cells then right-click and
 

00:03:05.560 --> 00:03:09.250 align:start position:0%
select your cells then right-click and
choose<00:03:06.560><c> cut</c><00:03:07.210><c> the</c><00:03:08.210><c> original</c><00:03:08.690><c> content</c><00:03:09.110><c> will</c>

00:03:09.250 --> 00:03:09.260 align:start position:0%
choose cut the original content will
 

00:03:09.260 --> 00:03:10.990 align:start position:0%
choose cut the original content will
disappear<00:03:09.770><c> as</c><00:03:09.950><c> soon</c><00:03:10.010><c> as</c><00:03:10.280><c> you</c><00:03:10.370><c> paste</c><00:03:10.610><c> it</c><00:03:10.790><c> in</c><00:03:10.910><c> a</c>

00:03:10.990 --> 00:03:11.000 align:start position:0%
disappear as soon as you paste it in a
 

00:03:11.000 --> 00:03:14.560 align:start position:0%
disappear as soon as you paste it in a
new<00:03:11.030><c> location</c><00:03:12.880><c> there's</c><00:03:13.880><c> also</c><00:03:14.090><c> a</c><00:03:14.210><c> drag</c><00:03:14.510><c> and</c>

00:03:14.560 --> 00:03:14.570 align:start position:0%
new location there's also a drag and
 

00:03:14.570 --> 00:03:16.540 align:start position:0%
new location there's also a drag and
drop<00:03:14.750><c> technique</c><00:03:15.320><c> for</c><00:03:15.530><c> moving</c><00:03:15.710><c> cells</c><00:03:16.130><c> from</c><00:03:16.370><c> one</c>

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

00:03:16.550 --> 00:03:19.360 align:start position:0%
drop technique for moving cells from one
place<00:03:16.820><c> to</c><00:03:17.030><c> another</c><00:03:17.240><c> to</c><00:03:17.540><c> drag-and-drop</c><00:03:18.440><c> start</c>

00:03:19.360 --> 00:03:19.370 align:start position:0%
place to another to drag-and-drop start
 

00:03:19.370 --> 00:03:21.850 align:start position:0%
place to another to drag-and-drop start
by<00:03:19.520><c> selecting</c><00:03:20.030><c> your</c><00:03:20.120><c> cells</c><00:03:20.420><c> then</c><00:03:21.350><c> place</c><00:03:21.650><c> your</c>

00:03:21.850 --> 00:03:21.860 align:start position:0%
by selecting your cells then place your
 

00:03:21.860 --> 00:03:24.940 align:start position:0%
by selecting your cells then place your
cursor<00:03:22.220><c> on</c><00:03:22.250><c> an</c><00:03:22.640><c> outside</c><00:03:23.060><c> edge</c><00:03:23.330><c> as</c><00:03:23.630><c> you</c><00:03:24.530><c> can</c><00:03:24.710><c> see</c>

00:03:24.940 --> 00:03:24.950 align:start position:0%
cursor on an outside edge as you can see
 

00:03:24.950 --> 00:03:27.130 align:start position:0%
cursor on an outside edge as you can see
it<00:03:25.160><c> turns</c><00:03:25.430><c> into</c><00:03:25.640><c> a</c><00:03:25.760><c> symbol</c><00:03:26.180><c> with</c><00:03:26.330><c> 4</c><00:03:26.570><c> arrows</c><00:03:26.810><c> and</c>

00:03:27.130 --> 00:03:27.140 align:start position:0%
it turns into a symbol with 4 arrows and
 

00:03:27.140 --> 00:03:30.250 align:start position:0%
it turns into a symbol with 4 arrows and
a<00:03:27.290><c> pointer</c><00:03:27.680><c> now</c><00:03:28.550><c> click</c><00:03:28.940><c> hold</c><00:03:29.480><c> and</c><00:03:29.720><c> drag</c><00:03:29.840><c> the</c>

00:03:30.250 --> 00:03:30.260 align:start position:0%
a pointer now click hold and drag the
 

00:03:30.260 --> 00:03:31.980 align:start position:0%
a pointer now click hold and drag the
cells<00:03:30.440><c> wherever</c><00:03:30.830><c> you</c><00:03:30.980><c> want</c><00:03:31.190><c> them</c><00:03:31.310><c> to</c><00:03:31.460><c> go</c><00:03:31.610><c> and</c>

00:03:31.980 --> 00:03:31.990 align:start position:0%
cells wherever you want them to go and
 

00:03:31.990 --> 00:03:34.840 align:start position:0%
cells wherever you want them to go and
release<00:03:32.990><c> your</c><00:03:33.170><c> mouse</c><00:03:33.320><c> and</c><00:03:33.740><c> the</c><00:03:34.430><c> cells</c><00:03:34.670><c> have</c>

00:03:34.840 --> 00:03:34.850 align:start position:0%
release your mouse and the cells have
 

00:03:34.850 --> 00:03:37.870 align:start position:0%
release your mouse and the cells have
moved<00:03:35.060><c> to</c><00:03:35.180><c> their</c><00:03:35.300><c> new</c><00:03:35.360><c> location</c><00:03:36.020><c> to</c><00:03:36.730><c> mark</c><00:03:37.730><c> the</c>

00:03:37.870 --> 00:03:37.880 align:start position:0%
moved to their new location to mark the
 

00:03:37.880 --> 00:03:39.460 align:start position:0%
moved to their new location to mark the
rest<00:03:38.090><c> of</c><00:03:38.210><c> the</c><00:03:38.300><c> people</c><00:03:38.480><c> who've</c><00:03:38.750><c> completed</c><00:03:38.990><c> part</c>

00:03:39.460 --> 00:03:39.470 align:start position:0%
rest of the people who've completed part
 

00:03:39.470 --> 00:03:41.680 align:start position:0%
rest of the people who've completed part
3<00:03:39.800><c> I'm</c><00:03:40.010><c> going</c><00:03:40.580><c> to</c><00:03:40.760><c> use</c><00:03:40.910><c> one</c><00:03:41.090><c> of</c><00:03:41.120><c> my</c><00:03:41.210><c> favorite</c>

00:03:41.680 --> 00:03:41.690 align:start position:0%
3 I'm going to use one of my favorite
 

00:03:41.690 --> 00:03:43.870 align:start position:0%
3 I'm going to use one of my favorite
techniques<00:03:42.070><c> filling</c><00:03:43.070><c> in</c><00:03:43.190><c> cells</c><00:03:43.460><c> with</c><00:03:43.760><c> the</c>

00:03:43.870 --> 00:03:43.880 align:start position:0%
techniques filling in cells with the
 

00:03:43.880 --> 00:03:46.450 align:start position:0%
techniques filling in cells with the
fill<00:03:44.030><c> handle</c><00:03:44.270><c> you</c><00:03:45.200><c> can</c><00:03:45.410><c> fill</c><00:03:45.620><c> vertically</c><00:03:46.190><c> or</c>

00:03:46.450 --> 00:03:46.460 align:start position:0%
fill handle you can fill vertically or
 

00:03:46.460 --> 00:03:48.370 align:start position:0%
fill handle you can fill vertically or
horizontally<00:03:46.490><c> by</c><00:03:47.420><c> selecting</c><00:03:47.930><c> the</c><00:03:48.020><c> cell</c><00:03:48.200><c> you</c>

00:03:48.370 --> 00:03:48.380 align:start position:0%
horizontally by selecting the cell you
 

00:03:48.380 --> 00:03:50.740 align:start position:0%
horizontally by selecting the cell you
want<00:03:48.410><c> to</c><00:03:48.620><c> use</c><00:03:48.970><c> then</c><00:03:49.970><c> clicking</c><00:03:50.510><c> and</c><00:03:50.720><c> dragging</c>

00:03:50.740 --> 00:03:50.750 align:start position:0%
want to use then clicking and dragging
 

00:03:50.750 --> 00:03:54.060 align:start position:0%
want to use then clicking and dragging
the<00:03:51.200><c> square</c><00:03:51.590><c> in</c><00:03:51.830><c> the</c><00:03:51.980><c> bottom</c><00:03:52.100><c> right</c><00:03:52.430><c> corner</c>

00:03:54.060 --> 00:03:54.070 align:start position:0%
the square in the bottom right corner
 

00:03:54.070 --> 00:03:56.710 align:start position:0%
the square in the bottom right corner
the<00:03:55.070><c> fill</c><00:03:55.310><c> handle</c><00:03:55.520><c> can</c><00:03:55.880><c> also</c><00:03:56.060><c> be</c><00:03:56.330><c> used</c><00:03:56.540><c> to</c>

00:03:56.710 --> 00:03:56.720 align:start position:0%
the fill handle can also be used to
 

00:03:56.720 --> 00:03:59.320 align:start position:0%
the fill handle can also be used to
continue<00:03:57.140><c> a</c><00:03:57.170><c> series</c><00:03:57.440><c> for</c><00:03:58.340><c> example</c><00:03:58.880><c> numbers</c>

00:03:59.320 --> 00:03:59.330 align:start position:0%
continue a series for example numbers
 

00:03:59.330 --> 00:04:01.390 align:start position:0%
continue a series for example numbers
dates<00:03:59.930><c> and</c><00:04:00.290><c> other</c><00:04:00.530><c> information</c><00:04:00.650><c> that's</c>

00:04:01.390 --> 00:04:01.400 align:start position:0%
dates and other information that's
 

00:04:01.400 --> 00:04:03.700 align:start position:0%
dates and other information that's
listed<00:04:01.640><c> in</c><00:04:01.850><c> sequential</c><00:04:02.390><c> order</c><00:04:02.600><c> see</c><00:04:03.560><c> what</c>

00:04:03.700 --> 00:04:03.710 align:start position:0%
listed in sequential order see what
 

00:04:03.710 --> 00:04:05.290 align:start position:0%
listed in sequential order see what
happens<00:04:04.010><c> when</c><00:04:04.220><c> I</c><00:04:04.250><c> use</c><00:04:04.310><c> the</c><00:04:04.670><c> technique</c><00:04:04.850><c> on</c><00:04:05.180><c> my</c>

00:04:05.290 --> 00:04:05.300 align:start position:0%
happens when I use the technique on my
 

00:04:05.300 --> 00:04:07.780 align:start position:0%
happens when I use the technique on my
header<00:04:05.510><c> row</c><00:04:05.720><c> it</c><00:04:06.040><c> continues</c><00:04:07.040><c> the</c><00:04:07.220><c> series</c><00:04:07.550><c> up</c><00:04:07.760><c> to</c>

00:04:07.780 --> 00:04:07.790 align:start position:0%
header row it continues the series up to
 

00:04:07.790 --> 00:04:10.960 align:start position:0%
header row it continues the series up to
part<00:04:08.180><c> six</c><00:04:09.100><c> now</c><00:04:10.100><c> you</c><00:04:10.160><c> know</c><00:04:10.430><c> the</c><00:04:10.580><c> basics</c>

00:04:10.960 --> 00:04:10.970 align:start position:0%
part six now you know the basics
 

00:04:10.970 --> 00:04:13.990 align:start position:0%
part six now you know the basics
including<00:04:11.270><c> insert</c><00:04:12.140><c> and</c><00:04:12.380><c> delete</c><00:04:12.560><c> cut</c><00:04:13.400><c> copy</c><00:04:13.790><c> and</c>

00:04:13.990 --> 00:04:14.000 align:start position:0%
including insert and delete cut copy and
 

00:04:14.000 --> 00:04:16.260 align:start position:0%
including insert and delete cut copy and
paste<00:04:14.210><c> and</c><00:04:14.840><c> other</c><00:04:15.200><c> time-saving</c><00:04:15.860><c> techniques</c>

00:04:16.260 --> 00:04:16.270 align:start position:0%
paste and other time-saving techniques
 

00:04:16.270 --> 00:04:18.340 align:start position:0%
paste and other time-saving techniques
everything<00:04:17.270><c> you</c><00:04:17.390><c> need</c><00:04:17.540><c> to</c><00:04:17.660><c> know</c><00:04:17.690><c> to</c><00:04:17.840><c> work</c><00:04:18.170><c> with</c>

00:04:18.340 --> 00:04:18.350 align:start position:0%
everything you need to know to work with
 

00:04:18.350 --> 00:04:20.390 align:start position:0%
everything you need to know to work with
cells<00:04:18.590><c> in</c><00:04:18.830><c> Excel</c>

00:04:20.390 --> 00:04:20.400 align:start position:0%
cells in Excel
 

00:04:20.400 --> 00:04:22.459 align:start position:0%
cells in Excel
you