WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.890><c> Foundation</c><00:00:02.520><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:10.560 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:10.560 --> 00:00:10.570 align:start position:0%
 
 

00:00:10.570 --> 00:00:13.090 align:start position:0%
 
every<00:00:11.570><c> worksheet</c><00:00:11.960><c> contains</c><00:00:12.170><c> thousands</c><00:00:12.980><c> of</c>

00:00:13.090 --> 00:00:13.100 align:start position:0%
every worksheet contains thousands of
 

00:00:13.100 --> 00:00:14.770 align:start position:0%
every worksheet contains thousands of
cells<00:00:13.370><c> where</c><00:00:13.730><c> different</c><00:00:14.090><c> columns</c><00:00:14.450><c> and</c><00:00:14.600><c> rows</c>

00:00:14.770 --> 00:00:14.780 align:start position:0%
cells where different columns and rows
 

00:00:14.780 --> 00:00:16.840 align:start position:0%
cells where different columns and rows
intersect<00:00:15.410><c> you'll</c><00:00:16.220><c> need</c><00:00:16.400><c> to</c><00:00:16.520><c> know</c><00:00:16.670><c> how</c><00:00:16.700><c> to</c>

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

00:00:16.850 --> 00:00:18.640 align:start position:0%
intersect you'll need to know how to
work<00:00:17.060><c> with</c><00:00:17.240><c> these</c><00:00:17.390><c> cells</c><00:00:17.690><c> in</c><00:00:17.960><c> order</c><00:00:18.140><c> to</c><00:00:18.260><c> enter</c>

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

00:00:18.650 --> 00:00:22.480 align:start position:0%
work with these cells in order to enter
in<00:00:18.770><c> edit</c><00:00:18.920><c> data</c><00:00:20.410><c> every</c><00:00:21.410><c> cell</c><00:00:21.650><c> has</c><00:00:21.680><c> its</c><00:00:21.920><c> own</c><00:00:22.250><c> name</c>

00:00:22.480 --> 00:00:22.490 align:start position:0%
in edit data every cell has its own name
 

00:00:22.490 --> 00:00:24.760 align:start position:0%
in edit data every cell has its own name
based<00:00:22.910><c> on</c><00:00:23.090><c> its</c><00:00:23.270><c> location</c><00:00:23.630><c> sometimes</c><00:00:24.260><c> called</c><00:00:24.680><c> a</c>

00:00:24.760 --> 00:00:24.770 align:start position:0%
based on its location sometimes called a
 

00:00:24.770 --> 00:00:27.310 align:start position:0%
based on its location sometimes called a
cell<00:00:24.950><c> address</c><00:00:25.250><c> in</c><00:00:25.520><c> this</c><00:00:26.330><c> example</c><00:00:26.720><c> the</c><00:00:27.110><c> cell</c>

00:00:27.310 --> 00:00:27.320 align:start position:0%
cell address in this example the cell
 

00:00:27.320 --> 00:00:29.530 align:start position:0%
cell address in this example the cell
I've<00:00:27.529><c> selected</c><00:00:27.740><c> is</c><00:00:28.130><c> where</c><00:00:28.340><c> column</c><00:00:28.730><c> D</c><00:00:28.939><c> and</c><00:00:29.210><c> row</c>

00:00:29.530 --> 00:00:29.540 align:start position:0%
I've selected is where column D and row
 

00:00:29.540 --> 00:00:32.290 align:start position:0%
I've selected is where column D and row
six<00:00:29.900><c> intersect</c><00:00:30.590><c> making</c><00:00:31.189><c> the</c><00:00:31.340><c> cell</c><00:00:31.520><c> address</c><00:00:31.669><c> D</c>

00:00:32.290 --> 00:00:32.300 align:start position:0%
six intersect making the cell address D
 

00:00:32.300 --> 00:00:35.020 align:start position:0%
six intersect making the cell address D
six<00:00:32.660><c> the</c><00:00:33.500><c> address</c><00:00:33.829><c> also</c><00:00:34.070><c> appears</c><00:00:34.610><c> in</c><00:00:34.790><c> the</c><00:00:34.880><c> name</c>

00:00:35.020 --> 00:00:35.030 align:start position:0%
six the address also appears in the name
 

00:00:35.030 --> 00:00:39.160 align:start position:0%
six the address also appears in the name
box<00:00:35.270><c> above</c><00:00:35.600><c> the</c><00:00:35.780><c> worksheet</c><00:00:37.510><c> to</c><00:00:38.510><c> select</c><00:00:38.840><c> a</c><00:00:38.960><c> cell</c>

00:00:39.160 --> 00:00:39.170 align:start position:0%
box above the worksheet to select a cell
 

00:00:39.170 --> 00:00:41.889 align:start position:0%
box above the worksheet to select a cell
just<00:00:39.620><c> click</c><00:00:39.950><c> you</c><00:00:40.940><c> can</c><00:00:40.970><c> even</c><00:00:41.360><c> use</c><00:00:41.540><c> the</c><00:00:41.720><c> arrow</c>

00:00:41.889 --> 00:00:41.899 align:start position:0%
just click you can even use the arrow
 

00:00:41.899 --> 00:00:43.540 align:start position:0%
just click you can even use the arrow
keys<00:00:42.230><c> on</c><00:00:42.440><c> your</c><00:00:42.530><c> keyboard</c><00:00:42.590><c> to</c><00:00:43.010><c> navigate</c>

00:00:43.540 --> 00:00:43.550 align:start position:0%
keys on your keyboard to navigate
 

00:00:43.550 --> 00:00:45.310 align:start position:0%
keys on your keyboard to navigate
between<00:00:43.699><c> cells</c><00:00:43.940><c> instead</c><00:00:44.629><c> of</c><00:00:44.840><c> clicking</c><00:00:45.079><c> with</c>

00:00:45.310 --> 00:00:45.320 align:start position:0%
between cells instead of clicking with
 

00:00:45.320 --> 00:00:48.340 align:start position:0%
between cells instead of clicking with
your<00:00:45.350><c> mouse</c><00:00:46.239><c> to</c><00:00:47.239><c> select</c><00:00:47.269><c> more</c><00:00:47.780><c> than</c><00:00:47.840><c> one</c><00:00:48.109><c> cell</c>

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

00:00:48.350 --> 00:00:50.529 align:start position:0%
your mouse to select more than one cell
at<00:00:48.469><c> a</c><00:00:48.530><c> time</c><00:00:48.559><c> known</c><00:00:49.250><c> as</c><00:00:49.399><c> a</c><00:00:49.429><c> cell</c><00:00:49.699><c> range</c><00:00:49.940><c> click</c>

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

00:00:50.539 --> 00:00:52.479 align:start position:0%
at a time known as a cell range click
and<00:00:50.780><c> drag</c><00:00:51.019><c> and</c><00:00:51.320><c> the</c><00:00:51.559><c> entire</c><00:00:51.590><c> range</c><00:00:52.250><c> will</c><00:00:52.460><c> be</c>

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

00:00:52.489 --> 00:00:55.599 align:start position:0%
and drag and the entire range will be
highlighted<00:00:53.590><c> you</c><00:00:54.590><c> can</c><00:00:54.739><c> enter</c><00:00:54.980><c> lots</c><00:00:55.190><c> of</c><00:00:55.370><c> things</c>

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

00:00:55.609 --> 00:00:57.759 align:start position:0%
highlighted you can enter lots of things
into<00:00:55.910><c> a</c><00:00:55.940><c> cell</c><00:00:56.239><c> for</c><00:00:56.750><c> example</c><00:00:57.170><c> all</c><00:00:57.410><c> of</c><00:00:57.440><c> mine</c>

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

00:00:57.769 --> 00:01:00.130 align:start position:0%
into a cell for example all of mine
contain<00:00:58.250><c> text</c><00:00:58.550><c> but</c><00:00:59.480><c> they</c><00:00:59.629><c> can</c><00:00:59.780><c> contain</c>

00:01:00.130 --> 00:01:00.140 align:start position:0%
contain text but they can contain
 

00:01:00.140 --> 00:01:02.319 align:start position:0%
contain text but they can contain
advanced<00:01:00.589><c> properties</c><00:01:01.039><c> too</c><00:01:01.309><c> like</c><00:01:01.760><c> formulas</c>

00:01:02.319 --> 00:01:02.329 align:start position:0%
advanced properties too like formulas
 

00:01:02.329 --> 00:01:04.780 align:start position:0%
advanced properties too like formulas
functions<00:01:02.600><c> and</c><00:01:03.079><c> formatting</c><00:01:03.379><c> elements</c><00:01:03.790><c> for</c>

00:01:04.780 --> 00:01:04.790 align:start position:0%
functions and formatting elements for
 

00:01:04.790 --> 00:01:06.760 align:start position:0%
functions and formatting elements for
now<00:01:04.940><c> I</c><00:01:05.150><c> just</c><00:01:05.210><c> like</c><00:01:05.630><c> to</c><00:01:05.750><c> show</c><00:01:05.900><c> you</c><00:01:05.960><c> the</c><00:01:06.170><c> basics</c>

00:01:06.760 --> 00:01:06.770 align:start position:0%
now I just like to show you the basics
 

00:01:06.770 --> 00:01:09.040 align:start position:0%
now I just like to show you the basics
we'll<00:01:07.310><c> start</c><00:01:07.610><c> with</c><00:01:07.730><c> inserting</c><00:01:08.180><c> content</c><00:01:08.510><c> into</c>

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

00:01:09.050 --> 00:01:12.160 align:start position:0%
we'll start with inserting content into
a<00:01:09.080><c> cell</c><00:01:10.000><c> this</c><00:01:11.000><c> person</c><00:01:11.450><c> is</c><00:01:11.540><c> just</c><00:01:11.570><c> confirmed</c>

00:01:12.160 --> 00:01:12.170 align:start position:0%
a cell this person is just confirmed
 

00:01:12.170 --> 00:01:13.810 align:start position:0%
a cell this person is just confirmed
that<00:01:12.470><c> she</c><00:01:12.590><c> completed</c><00:01:13.070><c> part</c><00:01:13.310><c> two</c><00:01:13.520><c> of</c><00:01:13.550><c> the</c>

00:01:13.810 --> 00:01:13.820 align:start position:0%
that she completed part two of the
 

00:01:13.820 --> 00:01:16.500 align:start position:0%
that she completed part two of the
training<00:01:14.240><c> so</c><00:01:14.840><c> I'm</c><00:01:14.990><c> going</c><00:01:15.140><c> to</c><00:01:15.170><c> select</c><00:01:15.410><c> cell</c><00:01:15.860><c> f9</c>

00:01:16.500 --> 00:01:16.510 align:start position:0%
training so I'm going to select cell f9
 

00:01:16.510 --> 00:01:20.350 align:start position:0%
training so I'm going to select cell f9
then<00:01:17.510><c> type</c><00:01:17.840><c> an</c><00:01:17.990><c> X</c><00:01:18.170><c> it</c><00:01:18.890><c> appears</c><00:01:19.880><c> in</c><00:01:20.030><c> the</c><00:01:20.120><c> cell</c>

00:01:20.350 --> 00:01:20.360 align:start position:0%
then type an X it appears in the cell
 

00:01:20.360 --> 00:01:22.150 align:start position:0%
then type an X it appears in the cell
and<00:01:20.570><c> in</c><00:01:20.870><c> the</c><00:01:20.900><c> formula</c><00:01:20.990><c> bar</c><00:01:21.560><c> where</c><00:01:22.040><c> you</c><00:01:22.070><c> can</c>

00:01:22.150 --> 00:01:22.160 align:start position:0%
and in the formula bar where you can
 

00:01:22.160 --> 00:01:24.220 align:start position:0%
and in the formula bar where you can
also<00:01:22.490><c> enter</c><00:01:22.820><c> or</c><00:01:23.150><c> edit</c><00:01:23.330><c> the</c><00:01:23.600><c> contents</c><00:01:24.080><c> of</c><00:01:24.170><c> your</c>

00:01:24.220 --> 00:01:24.230 align:start position:0%
also enter or edit the contents of your
 

00:01:24.230 --> 00:01:26.500 align:start position:0%
also enter or edit the contents of your
cell<00:01:24.560><c> in</c><00:01:24.800><c> fact</c><00:01:25.730><c> I'm</c><00:01:26.000><c> going</c><00:01:26.120><c> to</c><00:01:26.180><c> take</c><00:01:26.270><c> this</c>

00:01:26.500 --> 00:01:26.510 align:start position:0%
cell in fact I'm going to take this
 

00:01:26.510 --> 00:01:29.110 align:start position:0%
cell in fact I'm going to take this
opportunity<00:01:27.170><c> to</c><00:01:27.320><c> change</c><00:01:27.350><c> the</c><00:01:27.740><c> X</c><00:01:27.920><c> to</c><00:01:28.460><c> a</c><00:01:28.490><c> capital</c>

00:01:29.110 --> 00:01:29.120 align:start position:0%
opportunity to change the X to a capital
 

00:01:29.120 --> 00:01:30.970 align:start position:0%
opportunity to change the X to a capital
X<00:01:29.270><c> so</c><00:01:29.570><c> it's</c><00:01:29.870><c> consistent</c><00:01:30.410><c> with</c><00:01:30.440><c> the</c><00:01:30.560><c> rest</c><00:01:30.830><c> of</c>

00:01:30.970 --> 00:01:30.980 align:start position:0%
X so it's consistent with the rest of
 

00:01:30.980 --> 00:01:34.680 align:start position:0%
X so it's consistent with the rest of
the<00:01:31.070><c> list</c><00:01:32.050><c> now</c><00:01:33.050><c> for</c><00:01:33.290><c> the</c><00:01:33.380><c> next</c><00:01:33.500><c> person</c><00:01:33.950><c> Walter</c>

00:01:34.680 --> 00:01:34.690 align:start position:0%
the list now for the next person Walter
 

00:01:34.690 --> 00:01:36.550 align:start position:0%
the list now for the next person Walter
although<00:01:35.690><c> it</c><00:01:35.840><c> looks</c><00:01:35.870><c> like</c><00:01:36.110><c> I've</c><00:01:36.350><c> made</c><00:01:36.500><c> a</c>

00:01:36.550 --> 00:01:36.560 align:start position:0%
although it looks like I've made a
 

00:01:36.560 --> 00:01:39.070 align:start position:0%
although it looks like I've made a
mistake<00:01:36.710><c> he's</c><00:01:37.310><c> on</c><00:01:37.490><c> the</c><00:01:37.610><c> list</c><00:01:37.760><c> twice</c><00:01:37.970><c> both</c><00:01:38.540><c> here</c>

00:01:39.070 --> 00:01:39.080 align:start position:0%
mistake he's on the list twice both here
 

00:01:39.080 --> 00:01:42.280 align:start position:0%
mistake he's on the list twice both here
and<00:01:39.370><c> here</c><00:01:40.370><c> I'm</c><00:01:40.580><c> just</c><00:01:41.540><c> going</c><00:01:41.870><c> to</c><00:01:41.930><c> clear</c><00:01:42.170><c> the</c>

00:01:42.280 --> 00:01:42.290 align:start position:0%
and here I'm just going to clear the
 

00:01:42.290 --> 00:01:44.410 align:start position:0%
and here I'm just going to clear the
contents<00:01:42.800><c> of</c><00:01:42.890><c> the</c><00:01:43.040><c> extra</c><00:01:43.490><c> row</c><00:01:43.640><c> by</c><00:01:43.850><c> selecting</c>

00:01:44.410 --> 00:01:44.420 align:start position:0%
contents of the extra row by selecting
 

00:01:44.420 --> 00:01:47.980 align:start position:0%
contents of the extra row by selecting
the<00:01:44.540><c> cells</c><00:01:46.180><c> then</c><00:01:47.180><c> clicking</c><00:01:47.540><c> the</c><00:01:47.660><c> clear</c>

00:01:47.980 --> 00:01:47.990 align:start position:0%
the cells then clicking the clear
 

00:01:47.990 --> 00:01:50.740 align:start position:0%
the cells then clicking the clear
command<00:01:48.170><c> on</c><00:01:48.470><c> the</c><00:01:48.560><c> ribbon</c><00:01:48.590><c> and</c><00:01:49.330><c> choosing</c><00:01:50.330><c> clear</c>

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

00:01:50.750 --> 00:01:53.950 align:start position:0%
command on the ribbon and choosing clear
contents<00:01:51.520><c> you</c><00:01:52.520><c> can</c><00:01:52.670><c> also</c><00:01:52.850><c> use</c><00:01:53.180><c> backspace</c><00:01:53.750><c> or</c>

00:01:53.950 --> 00:01:53.960 align:start position:0%
contents you can also use backspace or
 

00:01:53.960 --> 00:01:56.980 align:start position:0%
contents you can also use backspace or
delete<00:01:54.020><c> on</c><00:01:54.500><c> your</c><00:01:54.530><c> keyboard</c><00:01:55.450><c> so</c><00:01:56.450><c> let's</c><00:01:56.780><c> take</c><00:01:56.960><c> a</c>

00:01:56.980 --> 00:01:56.990 align:start position:0%
delete on your keyboard so let's take a
 

00:01:56.990 --> 00:01:58.900 align:start position:0%
delete on your keyboard so let's take a
look<00:01:57.170><c> at</c><00:01:57.290><c> what</c><00:01:57.440><c> that</c><00:01:57.470><c> did</c><00:01:57.860><c> it</c><00:01:58.100><c> cleared</c><00:01:58.790><c> the</c>

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

00:01:58.910 --> 00:02:00.670 align:start position:0%
look at what that did it cleared the
contents<00:01:59.420><c> of</c><00:01:59.510><c> the</c><00:01:59.630><c> cells</c><00:01:59.870><c> but</c><00:02:00.200><c> the</c><00:02:00.350><c> row</c><00:02:00.500><c> is</c>

00:02:00.670 --> 00:02:00.680 align:start position:0%
contents of the cells but the row is
 

00:02:00.680 --> 00:02:03.430 align:start position:0%
contents of the cells but the row is
still<00:02:00.920><c> there</c><00:02:01.160><c> that's</c><00:02:01.880><c> ok</c><00:02:02.330><c> if</c><00:02:02.540><c> you</c><00:02:03.170><c> want</c><00:02:03.380><c> to</c>

00:02:03.430 --> 00:02:03.440 align:start position:0%
still there that's ok if you want to
 

00:02:03.440 --> 00:02:05.440 align:start position:0%
still there that's ok if you want to
delete<00:02:03.710><c> the</c><00:02:03.860><c> cells</c><00:02:04.100><c> altogether</c><00:02:04.640><c> all</c><00:02:04.910><c> you</c><00:02:05.300><c> have</c>

00:02:05.440 --> 00:02:05.450 align:start position:0%
delete the cells altogether all you have
 

00:02:05.450 --> 00:02:06.700 align:start position:0%
delete the cells altogether all you have
to<00:02:05.570><c> do</c><00:02:05.720><c> is</c><00:02:05.840><c> click</c><00:02:06.080><c> the</c><00:02:06.230><c> delete</c><00:02:06.530><c> command</c>

00:02:06.700 --> 00:02:06.710 align:start position:0%
to do is click the delete command
 

00:02:06.710 --> 00:02:09.850 align:start position:0%
to do is click the delete command
instead<00:02:07.509><c> that</c><00:02:08.509><c> actually</c><00:02:09.050><c> removes</c><00:02:09.349><c> the</c><00:02:09.619><c> cells</c>

00:02:09.850 --> 00:02:09.860 align:start position:0%
instead that actually removes the cells
 

00:02:09.860 --> 00:02:11.530 align:start position:0%
instead that actually removes the cells
from<00:02:10.039><c> the</c><00:02:10.129><c> worksheet</c><00:02:10.580><c> causing</c><00:02:11.180><c> the</c><00:02:11.300><c> cells</c>

00:02:11.530 --> 00:02:11.540 align:start position:0%
from the worksheet causing the cells
 

00:02:11.540 --> 00:02:13.360 align:start position:0%
from the worksheet causing the cells
underneath<00:02:12.050><c> to</c><00:02:12.260><c> shift</c><00:02:12.500><c> up</c><00:02:12.709><c> and</c><00:02:12.920><c> fill</c><00:02:13.129><c> in</c><00:02:13.250><c> the</c>

00:02:13.360 --> 00:02:13.370 align:start position:0%
underneath to shift up and fill in the
 

00:02:13.370 --> 00:02:15.400 align:start position:0%
underneath to shift up and fill in the
gap<00:02:13.599><c> just</c><00:02:14.599><c> remember</c><00:02:15.050><c> that</c><00:02:15.170><c> there's</c><00:02:15.349><c> a</c>

00:02:15.400 --> 00:02:15.410 align:start position:0%
gap just remember that there's a
 

00:02:15.410 --> 00:02:17.199 align:start position:0%
gap just remember that there's a
difference<00:02:15.830><c> between</c><00:02:16.010><c> clearing</c><00:02:16.640><c> and</c><00:02:16.819><c> deleting</c>

00:02:17.199 --> 00:02:17.209 align:start position:0%
difference between clearing and deleting
 

00:02:17.209 --> 00:02:18.940 align:start position:0%
difference between clearing and deleting
cells<00:02:17.510><c> so</c><00:02:17.989><c> you</c><00:02:18.050><c> don't</c><00:02:18.290><c> accidentally</c><00:02:18.710><c> delete</c>

00:02:18.940 --> 00:02:18.950 align:start position:0%
cells so you don't accidentally delete
 

00:02:18.950 --> 00:02:21.220 align:start position:0%
cells so you don't accidentally delete
any<00:02:19.280><c> cells</c><00:02:19.580><c> that</c><00:02:19.760><c> you</c><00:02:19.850><c> want</c><00:02:19.880><c> to</c><00:02:20.090><c> keep</c>

00:02:21.220 --> 00:02:21.230 align:start position:0%
any cells that you want to keep
 

00:02:21.230 --> 00:02:22.990 align:start position:0%
any cells that you want to keep
now<00:02:21.890><c> I'd</c><00:02:22.069><c> like</c><00:02:22.190><c> to</c><00:02:22.250><c> show</c><00:02:22.520><c> you</c><00:02:22.610><c> a</c><00:02:22.640><c> way</c><00:02:22.849><c> to</c><00:02:22.879><c> save</c>

00:02:22.990 --> 00:02:23.000 align:start position:0%
now I'd like to show you a way to save
 

00:02:23.000 --> 00:02:26.199 align:start position:0%
now I'd like to show you a way to save
time<00:02:23.209><c> by</c><00:02:23.810><c> copying</c><00:02:24.050><c> and</c><00:02:24.530><c> pasting</c><00:02:24.709><c> content</c><00:02:25.209><c> for</c>

00:02:26.199 --> 00:02:26.209 align:start position:0%
time by copying and pasting content for
 

00:02:26.209 --> 00:02:27.790 align:start position:0%
time by copying and pasting content for
example<00:02:26.629><c> I</c><00:02:26.780><c> need</c><00:02:26.840><c> to</c><00:02:27.080><c> mark</c><00:02:27.260><c> the</c><00:02:27.379><c> rest</c><00:02:27.560><c> of</c><00:02:27.709><c> the</c>

00:02:27.790 --> 00:02:27.800 align:start position:0%
example I need to mark the rest of the
 

00:02:27.800 --> 00:02:29.380 align:start position:0%
example I need to mark the rest of the
people<00:02:28.069><c> who</c><00:02:28.190><c> completed</c><00:02:28.550><c> part</c><00:02:28.879><c> two</c><00:02:29.090><c> of</c><00:02:29.269><c> the</c>

00:02:29.380 --> 00:02:29.390 align:start position:0%
people who completed part two of the
 

00:02:29.390 --> 00:02:31.900 align:start position:0%
people who completed part two of the
training<00:02:29.860><c> start</c><00:02:30.860><c> by</c><00:02:30.980><c> selecting</c><00:02:31.190><c> the</c><00:02:31.580><c> cell</c><00:02:31.760><c> you</c>

00:02:31.900 --> 00:02:31.910 align:start position:0%
training start by selecting the cell you
 

00:02:31.910 --> 00:02:35.070 align:start position:0%
training start by selecting the cell you
want<00:02:32.560><c> then</c><00:02:33.560><c> click</c><00:02:33.590><c> copy</c><00:02:34.129><c> on</c><00:02:34.519><c> the</c><00:02:34.610><c> ribbon</c>

00:02:35.070 --> 00:02:35.080 align:start position:0%
want then click copy on the ribbon
 

00:02:35.080 --> 00:02:37.660 align:start position:0%
want then click copy on the ribbon
note<00:02:36.080><c> the</c><00:02:36.230><c> -</c><00:02:36.410><c> box</c><00:02:36.739><c> that</c><00:02:37.010><c> appears</c><00:02:37.099><c> around</c><00:02:37.459><c> the</c>

00:02:37.660 --> 00:02:37.670 align:start position:0%
note the - box that appears around the
 

00:02:37.670 --> 00:02:40.750 align:start position:0%
note the - box that appears around the
copied<00:02:38.030><c> cell</c><00:02:38.530><c> next</c><00:02:39.530><c> select</c><00:02:40.160><c> the</c><00:02:40.220><c> cells</c><00:02:40.489><c> where</c>

00:02:40.750 --> 00:02:40.760 align:start position:0%
copied cell next select the cells where
 

00:02:40.760 --> 00:02:44.979 align:start position:0%
copied cell next select the cells where
you<00:02:40.819><c> want</c><00:02:41.000><c> the</c><00:02:41.120><c> content</c><00:02:41.510><c> to</c><00:02:41.660><c> go</c><00:02:43.660><c> then</c><00:02:44.660><c> click</c>

00:02:44.979 --> 00:02:44.989 align:start position:0%
you want the content to go then click
 

00:02:44.989 --> 00:02:48.640 align:start position:0%
you want the content to go then click
paste<00:02:46.120><c> to</c><00:02:47.120><c> access</c><00:02:47.480><c> more</c><00:02:47.720><c> paste</c><00:02:47.930><c> options</c><00:02:48.410><c> open</c>

00:02:48.640 --> 00:02:48.650 align:start position:0%
paste to access more paste options open
 

00:02:48.650 --> 00:02:51.670 align:start position:0%
paste to access more paste options open
the<00:02:49.010><c> drop</c><00:02:49.220><c> down</c><00:02:49.400><c> menu</c><00:02:49.670><c> here</c><00:02:50.290><c> these</c><00:02:51.290><c> commands</c>

00:02:51.670 --> 00:02:51.680 align:start position:0%
the drop down menu here these commands
 

00:02:51.680 --> 00:02:53.170 align:start position:0%
the drop down menu here these commands
will<00:02:51.830><c> come</c><00:02:51.980><c> in</c><00:02:52.099><c> handy</c><00:02:52.220><c> if</c><00:02:52.489><c> you're</c><00:02:52.670><c> copying</c><00:02:52.849><c> and</c>

00:02:53.170 --> 00:02:53.180 align:start position:0%
will come in handy if you're copying and
 

00:02:53.180 --> 00:02:55.210 align:start position:0%
will come in handy if you're copying and
pasting<00:02:53.299><c> cells</c><00:02:53.810><c> that</c><00:02:54.019><c> contain</c><00:02:54.349><c> formulas</c><00:02:54.950><c> or</c>

00:02:55.210 --> 00:02:55.220 align:start position:0%
pasting cells that contain formulas or
 

00:02:55.220 --> 00:02:58.720 align:start position:0%
pasting cells that contain formulas or
advanced<00:02:55.640><c> formatting</c><00:02:57.010><c> you</c><00:02:58.010><c> can</c><00:02:58.160><c> also</c><00:02:58.310><c> get</c><00:02:58.580><c> to</c>

00:02:58.720 --> 00:02:58.730 align:start position:0%
advanced formatting you can also get to
 

00:02:58.730 --> 00:03:00.460 align:start position:0%
advanced formatting you can also get to
these<00:02:58.849><c> commands</c><00:02:59.269><c> by</c><00:02:59.480><c> right-clicking</c><00:02:59.510><c> in</c><00:03:00.349><c> the</c>

00:03:00.460 --> 00:03:00.470 align:start position:0%
these commands by right-clicking in the
 

00:03:00.470 --> 00:03:02.920 align:start position:0%
these commands by right-clicking in the
worksheet<00:03:00.910><c> for</c><00:03:01.910><c> example</c><00:03:02.360><c> to</c><00:03:02.540><c> cut</c><00:03:02.690><c> and</c><00:03:02.870><c> paste</c>

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

00:03:02.930 --> 00:03:06.280 align:start position:0%
worksheet for example to cut and paste
select<00:03:03.590><c> your</c><00:03:03.950><c> cells</c><00:03:04.510><c> then</c><00:03:05.510><c> right-click</c><00:03:06.110><c> and</c>

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

00:03:06.290 --> 00:03:10.059 align:start position:0%
select your cells then right-click and
choose<00:03:06.610><c> cut</c><00:03:08.110><c> the</c><00:03:09.110><c> original</c><00:03:09.200><c> content</c><00:03:09.920><c> will</c>

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

00:03:10.069 --> 00:03:11.860 align:start position:0%
choose cut the original content will
disappear<00:03:10.579><c> as</c><00:03:10.790><c> soon</c><00:03:10.849><c> as</c><00:03:11.090><c> you</c><00:03:11.209><c> paste</c><00:03:11.450><c> it</c><00:03:11.630><c> in</c><00:03:11.780><c> a</c>

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

00:03:11.870 --> 00:03:15.940 align:start position:0%
disappear as soon as you paste it in a
new<00:03:11.989><c> location</c><00:03:13.989><c> there's</c><00:03:14.989><c> also</c><00:03:15.290><c> the</c><00:03:15.560><c> drag</c><00:03:15.799><c> and</c>

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

00:03:15.950 --> 00:03:17.680 align:start position:0%
new location there's also the drag and
drop<00:03:16.130><c> technique</c><00:03:16.519><c> for</c><00:03:16.760><c> moving</c><00:03:16.970><c> cells</c><00:03:17.299><c> from</c><00:03:17.540><c> one</c>

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

00:03:17.690 --> 00:03:20.559 align:start position:0%
drop technique for moving cells from one
place<00:03:17.959><c> to</c><00:03:17.989><c> another</c><00:03:18.200><c> to</c><00:03:18.819><c> drag-and-drop</c><00:03:19.819><c> start</c>

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

00:03:20.569 --> 00:03:23.140 align:start position:0%
place to another to drag-and-drop start
by<00:03:20.720><c> selecting</c><00:03:21.200><c> your</c><00:03:21.290><c> cells</c><00:03:21.670><c> then</c><00:03:22.670><c> place</c><00:03:22.970><c> your</c>

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

00:03:23.150 --> 00:03:26.110 align:start position:0%
by selecting your cells then place your
cursor<00:03:23.540><c> on</c><00:03:23.720><c> an</c><00:03:23.900><c> outside</c><00:03:24.290><c> edge</c><00:03:24.560><c> as</c><00:03:24.860><c> you</c><00:03:25.549><c> can</c><00:03:25.910><c> see</c>

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

00:03:26.120 --> 00:03:28.090 align:start position:0%
cursor on an outside edge as you can see
it<00:03:26.329><c> turns</c><00:03:26.569><c> into</c><00:03:26.750><c> a</c><00:03:26.870><c> symbol</c><00:03:27.170><c> with</c><00:03:27.470><c> four</c><00:03:27.739><c> arrows</c>

00:03:28.090 --> 00:03:28.100 align:start position:0%
it turns into a symbol with four arrows
 

00:03:28.100 --> 00:03:31.120 align:start position:0%
it turns into a symbol with four arrows
and<00:03:28.340><c> a</c><00:03:28.400><c> pointer</c><00:03:28.959><c> now</c><00:03:29.959><c> click</c><00:03:30.319><c> hold</c><00:03:30.829><c> and</c><00:03:31.040><c> drag</c>

00:03:31.120 --> 00:03:31.130 align:start position:0%
and a pointer now click hold and drag
 

00:03:31.130 --> 00:03:33.099 align:start position:0%
and a pointer now click hold and drag
the<00:03:31.370><c> cells</c><00:03:31.700><c> where</c><00:03:31.970><c> you</c><00:03:32.060><c> want</c><00:03:32.269><c> them</c><00:03:32.389><c> to</c><00:03:32.540><c> go</c><00:03:32.720><c> then</c>

00:03:33.099 --> 00:03:33.109 align:start position:0%
the cells where you want them to go then
 

00:03:33.109 --> 00:03:35.500 align:start position:0%
the cells where you want them to go then
release<00:03:33.470><c> your</c><00:03:33.500><c> mouse</c><00:03:33.940><c> there</c><00:03:34.940><c> that's</c><00:03:35.269><c> much</c>

00:03:35.500 --> 00:03:35.510 align:start position:0%
release your mouse there that's much
 

00:03:35.510 --> 00:03:36.240 align:start position:0%
release your mouse there that's much
better

00:03:36.240 --> 00:03:36.250 align:start position:0%
better
 

00:03:36.250 --> 00:03:38.410 align:start position:0%
better
to<00:03:37.250><c> mark</c><00:03:37.430><c> the</c><00:03:37.549><c> rest</c><00:03:37.730><c> of</c><00:03:37.910><c> the</c><00:03:38.000><c> people</c><00:03:38.269><c> who've</c>

00:03:38.410 --> 00:03:38.420 align:start position:0%
to mark the rest of the people who've
 

00:03:38.420 --> 00:03:40.059 align:start position:0%
to mark the rest of the people who've
completed<00:03:38.630><c> part</c><00:03:39.109><c> three</c><00:03:39.350><c> I'm</c><00:03:39.530><c> going</c><00:03:39.889><c> to</c><00:03:39.950><c> use</c>

00:03:40.059 --> 00:03:40.069 align:start position:0%
completed part three I'm going to use
 

00:03:40.069 --> 00:03:42.190 align:start position:0%
completed part three I'm going to use
one<00:03:40.250><c> of</c><00:03:40.280><c> my</c><00:03:40.400><c> favorite</c><00:03:40.910><c> techniques</c><00:03:41.109><c> filling</c><00:03:42.109><c> in</c>

00:03:42.190 --> 00:03:42.200 align:start position:0%
one of my favorite techniques filling in
 

00:03:42.200 --> 00:03:44.590 align:start position:0%
one of my favorite techniques filling in
cells<00:03:42.470><c> with</c><00:03:42.739><c> the</c><00:03:42.829><c> fill</c><00:03:43.040><c> handle</c><00:03:43.250><c> you</c><00:03:44.239><c> can</c><00:03:44.389><c> fill</c>

00:03:44.590 --> 00:03:44.600 align:start position:0%
cells with the fill handle you can fill
 

00:03:44.600 --> 00:03:46.840 align:start position:0%
cells with the fill handle you can fill
vertically<00:03:45.049><c> or</c><00:03:45.290><c> horizontally</c><00:03:45.340><c> by</c><00:03:46.340><c> selecting</c>

00:03:46.840 --> 00:03:46.850 align:start position:0%
vertically or horizontally by selecting
 

00:03:46.850 --> 00:03:49.180 align:start position:0%
vertically or horizontally by selecting
the<00:03:46.970><c> cell</c><00:03:47.180><c> you</c><00:03:47.329><c> want</c><00:03:47.510><c> to</c><00:03:47.569><c> use</c><00:03:47.859><c> then</c><00:03:48.859><c> clicking</c>

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

00:03:49.190 --> 00:03:50.890 align:start position:0%
the cell you want to use then clicking
and<00:03:49.430><c> dragging</c><00:03:49.459><c> the</c><00:03:49.850><c> square</c><00:03:50.180><c> in</c><00:03:50.420><c> the</c><00:03:50.600><c> bottom</c>

00:03:50.890 --> 00:03:50.900 align:start position:0%
and dragging the square in the bottom
 

00:03:50.900 --> 00:03:54.699 align:start position:0%
and dragging the square in the bottom
right<00:03:51.079><c> corner</c><00:03:52.540><c> the</c><00:03:53.540><c> fill</c><00:03:53.780><c> handle</c><00:03:53.959><c> can</c><00:03:54.230><c> also</c><00:03:54.440><c> be</c>

00:03:54.699 --> 00:03:54.709 align:start position:0%
right corner the fill handle can also be
 

00:03:54.709 --> 00:03:56.920 align:start position:0%
right corner the fill handle can also be
used<00:03:54.920><c> to</c><00:03:55.040><c> continue</c><00:03:55.400><c> a</c><00:03:55.579><c> series</c><00:03:55.819><c> for</c><00:03:56.510><c> example</c>

00:03:56.920 --> 00:03:56.930 align:start position:0%
used to continue a series for example
 

00:03:56.930 --> 00:03:58.569 align:start position:0%
used to continue a series for example
numbers<00:03:57.350><c> dates</c><00:03:57.859><c> and</c><00:03:58.130><c> other</c><00:03:58.459><c> information</c>

00:03:58.569 --> 00:03:58.579 align:start position:0%
numbers dates and other information
 

00:03:58.579 --> 00:04:01.750 align:start position:0%
numbers dates and other information
that's<00:03:59.329><c> listed</c><00:03:59.569><c> in</c><00:03:59.810><c> sequential</c><00:04:00.350><c> order</c><00:04:00.760><c> see</c>

00:04:01.750 --> 00:04:01.760 align:start position:0%
that's listed in sequential order see
 

00:04:01.760 --> 00:04:03.340 align:start position:0%
that's listed in sequential order see
what<00:04:01.910><c> happens</c><00:04:02.239><c> when</c><00:04:02.420><c> I</c><00:04:02.450><c> use</c><00:04:02.540><c> the</c><00:04:02.840><c> technique</c><00:04:03.019><c> on</c>

00:04:03.340 --> 00:04:03.350 align:start position:0%
what happens when I use the technique on
 

00:04:03.350 --> 00:04:05.920 align:start position:0%
what happens when I use the technique on
my<00:04:03.500><c> header</c><00:04:03.709><c> row</c><00:04:03.920><c> it</c><00:04:04.269><c> continues</c><00:04:05.269><c> the</c><00:04:05.450><c> series</c><00:04:05.750><c> up</c>

00:04:05.920 --> 00:04:05.930 align:start position:0%
my header row it continues the series up
 

00:04:05.930 --> 00:04:09.190 align:start position:0%
my header row it continues the series up
to<00:04:06.079><c> part</c><00:04:06.290><c> six</c><00:04:07.420><c> Excel</c><00:04:08.420><c> is</c><00:04:08.569><c> actually</c><00:04:08.989><c> pretty</c>

00:04:09.190 --> 00:04:09.200 align:start position:0%
to part six Excel is actually pretty
 

00:04:09.200 --> 00:04:10.809 align:start position:0%
to part six Excel is actually pretty
good<00:04:09.290><c> at</c><00:04:09.560><c> filling</c><00:04:09.889><c> in</c><00:04:10.010><c> certain</c><00:04:10.340><c> types</c><00:04:10.549><c> of</c><00:04:10.670><c> data</c>

00:04:10.809 --> 00:04:10.819 align:start position:0%
good at filling in certain types of data
 

00:04:10.819 --> 00:04:13.390 align:start position:0%
good at filling in certain types of data
automatically<00:04:11.510><c> take</c><00:04:12.470><c> the</c><00:04:12.650><c> new</c><00:04:12.799><c> flash</c><00:04:13.130><c> fill</c>

00:04:13.390 --> 00:04:13.400 align:start position:0%
automatically take the new flash fill
 

00:04:13.400 --> 00:04:16.150 align:start position:0%
automatically take the new flash fill
feature<00:04:13.930><c> flash</c><00:04:14.930><c> fill</c><00:04:15.200><c> can</c><00:04:15.380><c> enter</c><00:04:15.680><c> data</c><00:04:15.709><c> for</c>

00:04:16.150 --> 00:04:16.160 align:start position:0%
feature flash fill can enter data for
 

00:04:16.160 --> 00:04:18.219 align:start position:0%
feature flash fill can enter data for
you<00:04:16.370><c> by</c><00:04:16.639><c> picking</c><00:04:17.000><c> up</c><00:04:17.090><c> on</c><00:04:17.269><c> simple</c><00:04:17.660><c> patterns</c><00:04:18.019><c> and</c>

00:04:18.219 --> 00:04:18.229 align:start position:0%
you by picking up on simple patterns and
 

00:04:18.229 --> 00:04:20.680 align:start position:0%
you by picking up on simple patterns and
guessing<00:04:18.709><c> what</c><00:04:18.859><c> you</c><00:04:18.950><c> plan</c><00:04:19.160><c> to</c><00:04:19.190><c> type</c><00:04:19.519><c> in</c><00:04:19.760><c> this</c>

00:04:20.680 --> 00:04:20.690 align:start position:0%
guessing what you plan to type in this
 

00:04:20.690 --> 00:04:22.600 align:start position:0%
guessing what you plan to type in this
example<00:04:21.079><c> we'll</c><00:04:21.530><c> use</c><00:04:21.560><c> the</c><00:04:21.889><c> feature</c><00:04:22.099><c> to</c><00:04:22.310><c> enter</c>

00:04:22.600 --> 00:04:22.610 align:start position:0%
example we'll use the feature to enter
 

00:04:22.610 --> 00:04:24.159 align:start position:0%
example we'll use the feature to enter
each<00:04:22.789><c> person's</c><00:04:23.240><c> first</c><00:04:23.539><c> initial</c><00:04:23.990><c> and</c><00:04:24.139><c> last</c>

00:04:24.159 --> 00:04:24.169 align:start position:0%
each person's first initial and last
 

00:04:24.169 --> 00:04:28.850 align:start position:0%
each person's first initial and last
name<00:04:24.500><c> which</c><00:04:25.039><c> will</c><00:04:25.220><c> serve</c><00:04:25.430><c> as</c><00:04:25.550><c> their</c><00:04:25.700><c> username</c>

00:04:28.850 --> 00:04:28.860 align:start position:0%
 
 

00:04:28.860 --> 00:04:30.589 align:start position:0%
 
vil<00:04:29.159><c> eventually</c><00:04:29.639><c> figures</c><00:04:29.939><c> out</c><00:04:30.090><c> what</c><00:04:30.270><c> I</c><00:04:30.300><c> want</c>

00:04:30.589 --> 00:04:30.599 align:start position:0%
vil eventually figures out what I want
 

00:04:30.599 --> 00:04:32.600 align:start position:0%
vil eventually figures out what I want
and<00:04:30.810><c> uses</c><00:04:31.319><c> the</c><00:04:31.439><c> data</c><00:04:31.650><c> in</c><00:04:31.860><c> the</c><00:04:31.949><c> first</c><00:04:32.189><c> name</c><00:04:32.400><c> and</c>

00:04:32.600 --> 00:04:32.610 align:start position:0%
and uses the data in the first name and
 

00:04:32.610 --> 00:04:34.279 align:start position:0%
and uses the data in the first name and
last<00:04:32.669><c> name</c><00:04:32.969><c> columns</c><00:04:33.479><c> to</c><00:04:33.659><c> complete</c><00:04:33.960><c> the</c><00:04:34.110><c> series</c>

00:04:34.279 --> 00:04:34.289 align:start position:0%
last name columns to complete the series
 

00:04:34.289 --> 00:04:36.679 align:start position:0%
last name columns to complete the series
all<00:04:34.650><c> you</c><00:04:35.370><c> have</c><00:04:35.520><c> to</c><00:04:35.639><c> do</c><00:04:35.759><c> is</c><00:04:35.909><c> press</c><00:04:36.120><c> ENTER</c><00:04:36.539><c> to</c>

00:04:36.679 --> 00:04:36.689 align:start position:0%
all you have to do is press ENTER to
 

00:04:36.689 --> 00:04:39.080 align:start position:0%
all you have to do is press ENTER to
confirm<00:04:36.870><c> and</c><00:04:37.319><c> the</c><00:04:38.280><c> data</c><00:04:38.460><c> will</c><00:04:38.669><c> be</c><00:04:38.789><c> added</c><00:04:38.909><c> to</c>

00:04:39.080 --> 00:04:39.090 align:start position:0%
confirm and the data will be added to
 

00:04:39.090 --> 00:04:42.339 align:start position:0%
confirm and the data will be added to
the<00:04:39.270><c> worksheet</c>

00:04:42.339 --> 00:04:42.349 align:start position:0%
 
 

00:04:42.349 --> 00:04:45.110 align:start position:0%
 
finally<00:04:43.349><c> in</c><00:04:43.560><c> workbooks</c><00:04:44.039><c> with</c><00:04:44.250><c> lots</c><00:04:44.460><c> of</c><00:04:44.610><c> data</c><00:04:44.789><c> I</c>

00:04:45.110 --> 00:04:45.120 align:start position:0%
finally in workbooks with lots of data I
 

00:04:45.120 --> 00:04:46.640 align:start position:0%
finally in workbooks with lots of data I
sometimes<00:04:45.569><c> have</c><00:04:45.960><c> trouble</c><00:04:46.289><c> finding</c><00:04:46.409><c> a</c>

00:04:46.640 --> 00:04:46.650 align:start position:0%
sometimes have trouble finding a
 

00:04:46.650 --> 00:04:48.589 align:start position:0%
sometimes have trouble finding a
specific<00:04:46.860><c> word</c><00:04:47.370><c> or</c><00:04:47.550><c> phrase</c><00:04:47.610><c> that</c><00:04:48.150><c> I</c><00:04:48.180><c> know</c><00:04:48.300><c> is</c>

00:04:48.589 --> 00:04:48.599 align:start position:0%
specific word or phrase that I know is
 

00:04:48.599 --> 00:04:50.990 align:start position:0%
specific word or phrase that I know is
in<00:04:48.629><c> there</c><00:04:48.870><c> somewhere</c><00:04:49.139><c> the</c><00:04:50.129><c> find</c><00:04:50.460><c> feature</c><00:04:50.669><c> can</c>

00:04:50.990 --> 00:04:51.000 align:start position:0%
in there somewhere the find feature can
 

00:04:51.000 --> 00:04:53.020 align:start position:0%
in there somewhere the find feature can
help<00:04:51.030><c> by</c><00:04:51.449><c> searching</c><00:04:51.659><c> the</c><00:04:51.960><c> workbook</c><00:04:52.319><c> for</c><00:04:52.560><c> you</c>

00:04:53.020 --> 00:04:53.030 align:start position:0%
help by searching the workbook for you
 

00:04:53.030 --> 00:04:55.550 align:start position:0%
help by searching the workbook for you
just<00:04:54.030><c> click</c><00:04:54.180><c> find</c><00:04:54.539><c> and</c><00:04:54.719><c> select</c><00:04:54.870><c> on</c><00:04:55.169><c> the</c><00:04:55.259><c> ribbon</c>

00:04:55.550 --> 00:04:55.560 align:start position:0%
just click find and select on the ribbon
 

00:04:55.560 --> 00:04:58.909 align:start position:0%
just click find and select on the ribbon
then<00:04:56.490><c> choose</c><00:04:56.819><c> find</c><00:04:57.210><c> and</c><00:04:57.479><c> type</c><00:04:58.379><c> the</c><00:04:58.530><c> word</c><00:04:58.740><c> or</c>

00:04:58.909 --> 00:04:58.919 align:start position:0%
then choose find and type the word or
 

00:04:58.919 --> 00:05:02.179 align:start position:0%
then choose find and type the word or
phrase<00:04:58.979><c> you're</c><00:04:59.430><c> looking</c><00:04:59.729><c> for</c><00:05:01.069><c> when</c><00:05:02.069><c> you're</c>

00:05:02.179 --> 00:05:02.189 align:start position:0%
phrase you're looking for when you're
 

00:05:02.189 --> 00:05:04.399 align:start position:0%
phrase you're looking for when you're
done<00:05:02.400><c> click</c><00:05:02.789><c> find</c><00:05:03.150><c> next</c><00:05:03.360><c> in</c><00:05:03.659><c> the</c><00:05:03.750><c> dialog</c><00:05:04.139><c> box</c>

00:05:04.399 --> 00:05:04.409 align:start position:0%
done click find next in the dialog box
 

00:05:04.409 --> 00:05:07.159 align:start position:0%
done click find next in the dialog box
if<00:05:04.680><c> the</c><00:05:05.460><c> word</c><00:05:05.789><c> or</c><00:05:05.939><c> phrase</c><00:05:05.969><c> is</c><00:05:06.330><c> found</c><00:05:06.569><c> the</c><00:05:06.930><c> cell</c>

00:05:07.159 --> 00:05:07.169 align:start position:0%
if the word or phrase is found the cell
 

00:05:07.169 --> 00:05:10.700 align:start position:0%
if the word or phrase is found the cell
containing<00:05:07.590><c> it</c><00:05:07.770><c> will</c><00:05:07.949><c> be</c><00:05:08.099><c> selected</c><00:05:08.580><c> at</c><00:05:09.710><c> times</c>

00:05:10.700 --> 00:05:10.710 align:start position:0%
containing it will be selected at times
 

00:05:10.710 --> 00:05:11.929 align:start position:0%
containing it will be selected at times
you<00:05:10.949><c> may</c><00:05:11.069><c> find</c><00:05:11.279><c> that</c><00:05:11.430><c> you've</c><00:05:11.550><c> made</c><00:05:11.759><c> a</c><00:05:11.789><c> mistake</c>

00:05:11.929 --> 00:05:11.939 align:start position:0%
you may find that you've made a mistake
 

00:05:11.939 --> 00:05:13.670 align:start position:0%
you may find that you've made a mistake
throughout<00:05:12.509><c> your</c><00:05:12.629><c> workbook</c><00:05:13.020><c> or</c><00:05:13.199><c> you</c><00:05:13.349><c> need</c><00:05:13.529><c> to</c>

00:05:13.670 --> 00:05:13.680 align:start position:0%
throughout your workbook or you need to
 

00:05:13.680 --> 00:05:15.019 align:start position:0%
throughout your workbook or you need to
swap<00:05:13.889><c> a</c><00:05:13.949><c> certain</c><00:05:14.430><c> word</c><00:05:14.610><c> or</c><00:05:14.759><c> phrase</c><00:05:14.819><c> for</c>

00:05:15.019 --> 00:05:15.029 align:start position:0%
swap a certain word or phrase for
 

00:05:15.029 --> 00:05:17.809 align:start position:0%
swap a certain word or phrase for
another<00:05:15.590><c> for</c><00:05:16.590><c> that</c><00:05:16.620><c> you</c><00:05:16.979><c> can</c><00:05:17.159><c> use</c><00:05:17.310><c> the</c><00:05:17.490><c> replace</c>

00:05:17.809 --> 00:05:17.819 align:start position:0%
another for that you can use the replace
 

00:05:17.819 --> 00:05:20.809 align:start position:0%
another for that you can use the replace
feature<00:05:18.060><c> instead</c><00:05:18.599><c> I</c><00:05:19.580><c> actually</c><00:05:20.580><c> need</c><00:05:20.729><c> to</c>

00:05:20.809 --> 00:05:20.819 align:start position:0%
feature instead I actually need to
 

00:05:20.819 --> 00:05:22.339 align:start position:0%
feature instead I actually need to
change<00:05:21.060><c> the</c><00:05:21.270><c> name</c><00:05:21.419><c> of</c><00:05:21.449><c> this</c><00:05:21.719><c> department</c><00:05:22.020><c> from</c>

00:05:22.339 --> 00:05:22.349 align:start position:0%
change the name of this department from
 

00:05:22.349 --> 00:05:26.899 align:start position:0%
change the name of this department from
accounting<00:05:22.860><c> to</c><00:05:22.939><c> finance</c><00:05:25.099><c> to</c><00:05:26.099><c> continue</c><00:05:26.580><c> go</c>

00:05:26.899 --> 00:05:26.909 align:start position:0%
accounting to finance to continue go
 

00:05:26.909 --> 00:05:29.330 align:start position:0%
accounting to finance to continue go
ahead<00:05:27.180><c> and</c><00:05:27.330><c> click</c><00:05:27.479><c> replace</c><00:05:27.659><c> and</c><00:05:28.169><c> it</c><00:05:29.009><c> will</c><00:05:29.129><c> jump</c>

00:05:29.330 --> 00:05:29.340 align:start position:0%
ahead and click replace and it will jump
 

00:05:29.340 --> 00:05:31.209 align:start position:0%
ahead and click replace and it will jump
to<00:05:29.430><c> the</c><00:05:29.520><c> next</c><00:05:29.729><c> instance</c><00:05:30.300><c> automatically</c><00:05:30.990><c> if</c>

00:05:31.209 --> 00:05:31.219 align:start position:0%
to the next instance automatically if
 

00:05:31.219 --> 00:05:33.529 align:start position:0%
to the next instance automatically if
you<00:05:32.219><c> want</c><00:05:32.400><c> to</c><00:05:32.490><c> skip</c><00:05:32.729><c> the</c><00:05:32.879><c> current</c><00:05:33.180><c> instance</c>

00:05:33.529 --> 00:05:33.539 align:start position:0%
you want to skip the current instance
 

00:05:33.539 --> 00:05:35.570 align:start position:0%
you want to skip the current instance
without<00:05:33.750><c> replacing</c><00:05:34.469><c> it</c><00:05:34.589><c> click</c><00:05:35.039><c> find</c><00:05:35.370><c> next</c>

00:05:35.570 --> 00:05:35.580 align:start position:0%
without replacing it click find next
 

00:05:35.580 --> 00:05:39.619 align:start position:0%
without replacing it click find next
instead<00:05:37.460><c> alternatively</c><00:05:38.460><c> to</c><00:05:38.879><c> replace</c><00:05:39.240><c> every</c>

00:05:39.619 --> 00:05:39.629 align:start position:0%
instead alternatively to replace every
 

00:05:39.629 --> 00:05:41.390 align:start position:0%
instead alternatively to replace every
instance<00:05:39.659><c> without</c><00:05:40.409><c> having</c><00:05:40.710><c> to</c><00:05:40.830><c> review</c><00:05:41.159><c> each</c>

00:05:41.390 --> 00:05:41.400 align:start position:0%
instance without having to review each
 

00:05:41.400 --> 00:05:44.390 align:start position:0%
instance without having to review each
one<00:05:41.430><c> click</c><00:05:42.300><c> replace</c><00:05:42.659><c> all</c><00:05:42.990><c> and</c><00:05:43.289><c> the</c><00:05:44.099><c> entire</c>

00:05:44.390 --> 00:05:44.400 align:start position:0%
one click replace all and the entire
 

00:05:44.400 --> 00:05:48.740 align:start position:0%
one click replace all and the entire
workbook<00:05:44.729><c> will</c><00:05:45.089><c> be</c><00:05:45.180><c> updated</c><00:05:47.449><c> now</c><00:05:48.449><c> you</c><00:05:48.509><c> know</c>

00:05:48.740 --> 00:05:48.750 align:start position:0%
workbook will be updated now you know
 

00:05:48.750 --> 00:05:50.719 align:start position:0%
workbook will be updated now you know
the<00:05:48.870><c> basics</c><00:05:49.259><c> including</c><00:05:49.500><c> insert</c><00:05:50.460><c> and</c><00:05:50.669><c> delete</c>

00:05:50.719 --> 00:05:50.729 align:start position:0%
the basics including insert and delete
 

00:05:50.729 --> 00:05:53.659 align:start position:0%
the basics including insert and delete
cut<00:05:51.539><c> copy</c><00:05:51.810><c> and</c><00:05:51.990><c> paste</c><00:05:52.139><c> and</c><00:05:52.650><c> other</c><00:05:53.039><c> time-saving</c>

00:05:53.659 --> 00:05:53.669 align:start position:0%
cut copy and paste and other time-saving
 

00:05:53.669 --> 00:05:55.820 align:start position:0%
cut copy and paste and other time-saving
techniques<00:05:54.289><c> everything</c><00:05:55.289><c> you</c><00:05:55.379><c> need</c><00:05:55.529><c> to</c><00:05:55.680><c> work</c>

00:05:55.820 --> 00:05:55.830 align:start position:0%
techniques everything you need to work
 

00:05:55.830 --> 00:06:00.559 align:start position:0%
techniques everything you need to work
with<00:05:55.889><c> cells</c><00:05:56.279><c> in</c><00:05:56.580><c> Excel</c><00:05:56.699><c> 2013</c>

00:06:00.559 --> 00:06:00.569 align:start position:0%
 
 

00:06:00.569 --> 00:06:02.629 align:start position:0%
 
you