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.829 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.370><c> a</c><00:00:04.610><c> better</c><00:00:04.640><c> life</c><00:00:04.820><c> in</c><00:00:07.839><c> work</c>

00:00:08.829 --> 00:00:08.839 align:start position:0%
opportunities for a better life in work
 

00:00:08.839 --> 00:00:10.900 align:start position:0%
opportunities for a better life in work
books<00:00:09.139><c> with</c><00:00:09.379><c> lots</c><00:00:09.620><c> of</c><00:00:09.769><c> data</c><00:00:10.039><c> when</c><00:00:10.459><c> I'm</c><00:00:10.580><c> looking</c>

00:00:10.900 --> 00:00:10.910 align:start position:0%
books with lots of data when I'm looking
 

00:00:10.910 --> 00:00:12.579 align:start position:0%
books with lots of data when I'm looking
for<00:00:11.120><c> something</c><00:00:11.360><c> I</c><00:00:11.690><c> sometimes</c><00:00:12.049><c> have</c><00:00:12.469><c> trouble</c>

00:00:12.579 --> 00:00:12.589 align:start position:0%
for something I sometimes have trouble
 

00:00:12.589 --> 00:00:14.980 align:start position:0%
for something I sometimes have trouble
finding<00:00:13.219><c> a</c><00:00:13.309><c> specific</c><00:00:13.849><c> word</c><00:00:14.119><c> or</c><00:00:14.329><c> phrase</c><00:00:14.360><c> that</c><00:00:14.660><c> I</c>

00:00:14.980 --> 00:00:14.990 align:start position:0%
finding a specific word or phrase that I
 

00:00:14.990 --> 00:00:17.230 align:start position:0%
finding a specific word or phrase that I
know<00:00:15.110><c> is</c><00:00:15.409><c> in</c><00:00:15.440><c> there</c><00:00:15.709><c> somewhere</c><00:00:16.010><c> the</c><00:00:16.939><c> find</c>

00:00:17.230 --> 00:00:17.240 align:start position:0%
know is in there somewhere the find
 

00:00:17.240 --> 00:00:19.150 align:start position:0%
know is in there somewhere the find
feature<00:00:17.510><c> can</c><00:00:17.929><c> help</c><00:00:18.170><c> by</c><00:00:18.529><c> searching</c><00:00:18.830><c> the</c>

00:00:19.150 --> 00:00:19.160 align:start position:0%
feature can help by searching the
 

00:00:19.160 --> 00:00:22.150 align:start position:0%
feature can help by searching the
workbook<00:00:19.550><c> for</c><00:00:19.789><c> you</c><00:00:20.140><c> just</c><00:00:21.140><c> click</c><00:00:21.289><c> find</c><00:00:21.830><c> and</c>

00:00:22.150 --> 00:00:22.160 align:start position:0%
workbook for you just click find and
 

00:00:22.160 --> 00:00:25.120 align:start position:0%
workbook for you just click find and
select<00:00:22.340><c> on</c><00:00:22.789><c> the</c><00:00:22.970><c> ribbon</c><00:00:23.439><c> then</c><00:00:24.439><c> choose</c><00:00:24.769><c> find</c>

00:00:25.120 --> 00:00:25.130 align:start position:0%
select on the ribbon then choose find
 

00:00:25.130 --> 00:00:28.150 align:start position:0%
select on the ribbon then choose find
and<00:00:26.169><c> type</c><00:00:27.169><c> the</c><00:00:27.380><c> word</c><00:00:27.410><c> or</c><00:00:27.710><c> phrase</c><00:00:27.740><c> you're</c>

00:00:28.150 --> 00:00:28.160 align:start position:0%
and type the word or phrase you're
 

00:00:28.160 --> 00:00:32.019 align:start position:0%
and type the word or phrase you're
looking<00:00:28.189><c> for</c><00:00:29.769><c> when</c><00:00:30.769><c> you're</c><00:00:30.859><c> done</c><00:00:31.099><c> click</c><00:00:31.669><c> find</c>

00:00:32.019 --> 00:00:32.029 align:start position:0%
looking for when you're done click find
 

00:00:32.029 --> 00:00:35.740 align:start position:0%
looking for when you're done click find
next<00:00:32.419><c> in</c><00:00:32.780><c> the</c><00:00:32.930><c> dialog</c><00:00:33.379><c> box</c><00:00:33.649><c> if</c><00:00:34.489><c> the</c><00:00:35.360><c> word</c><00:00:35.539><c> or</c>

00:00:35.740 --> 00:00:35.750 align:start position:0%
next in the dialog box if the word or
 

00:00:35.750 --> 00:00:37.779 align:start position:0%
next in the dialog box if the word or
phrase<00:00:35.780><c> is</c><00:00:36.200><c> found</c><00:00:36.469><c> the</c><00:00:36.890><c> cell</c><00:00:37.129><c> containing</c><00:00:37.579><c> it</c>

00:00:37.779 --> 00:00:37.789 align:start position:0%
phrase is found the cell containing it
 

00:00:37.789 --> 00:00:40.810 align:start position:0%
phrase is found the cell containing it
will<00:00:37.940><c> be</c><00:00:38.059><c> selected</c><00:00:38.629><c> at</c><00:00:39.160><c> times</c><00:00:40.160><c> you</c><00:00:40.430><c> may</c><00:00:40.579><c> find</c>

00:00:40.810 --> 00:00:40.820 align:start position:0%
will be selected at times you may find
 

00:00:40.820 --> 00:00:42.250 align:start position:0%
will be selected at times you may find
that<00:00:40.969><c> you've</c><00:00:41.239><c> made</c><00:00:41.449><c> a</c><00:00:41.480><c> mistake</c><00:00:41.570><c> throughout</c>

00:00:42.250 --> 00:00:42.260 align:start position:0%
that you've made a mistake throughout
 

00:00:42.260 --> 00:00:44.290 align:start position:0%
that you've made a mistake throughout
your<00:00:42.440><c> workbook</c><00:00:42.890><c> or</c><00:00:43.100><c> you</c><00:00:43.699><c> need</c><00:00:43.850><c> to</c><00:00:43.969><c> swap</c><00:00:44.270><c> a</c>

00:00:44.290 --> 00:00:44.300 align:start position:0%
your workbook or you need to swap a
 

00:00:44.300 --> 00:00:47.020 align:start position:0%
your workbook or you need to swap a
certain<00:00:44.780><c> word</c><00:00:45.020><c> or</c><00:00:45.230><c> phrase</c><00:00:45.260><c> for</c><00:00:45.770><c> another</c><00:00:46.070><c> for</c>

00:00:47.020 --> 00:00:47.030 align:start position:0%
certain word or phrase for another for
 

00:00:47.030 --> 00:00:48.610 align:start position:0%
certain word or phrase for another for
that<00:00:47.180><c> you</c><00:00:47.480><c> can</c><00:00:47.660><c> use</c><00:00:47.840><c> the</c><00:00:48.020><c> replace</c><00:00:48.350><c> feature</c>

00:00:48.610 --> 00:00:48.620 align:start position:0%
that you can use the replace feature
 

00:00:48.620 --> 00:00:51.610 align:start position:0%
that you can use the replace feature
instead<00:00:49.219><c> I</c><00:00:49.960><c> actually</c><00:00:50.960><c> need</c><00:00:51.109><c> to</c><00:00:51.199><c> change</c><00:00:51.230><c> the</c>

00:00:51.610 --> 00:00:51.620 align:start position:0%
instead I actually need to change the
 

00:00:51.620 --> 00:00:53.290 align:start position:0%
instead I actually need to change the
name<00:00:51.769><c> of</c><00:00:51.800><c> this</c><00:00:52.070><c> department</c><00:00:52.430><c> from</c><00:00:52.820><c> accounting</c>

00:00:53.290 --> 00:00:53.300 align:start position:0%
name of this department from accounting
 

00:00:53.300 --> 00:00:56.860 align:start position:0%
name of this department from accounting
to<00:00:53.840><c> finance</c><00:00:54.640><c> to</c><00:00:55.640><c> continue</c><00:00:56.149><c> go</c><00:00:56.449><c> ahead</c><00:00:56.719><c> and</c>

00:00:56.860 --> 00:00:56.870 align:start position:0%
to finance to continue go ahead and
 

00:00:56.870 --> 00:00:59.709 align:start position:0%
to finance to continue go ahead and
click<00:00:57.050><c> replace</c><00:00:57.230><c> and</c><00:00:58.210><c> it</c><00:00:59.210><c> will</c><00:00:59.329><c> jump</c><00:00:59.539><c> to</c><00:00:59.600><c> the</c>

00:00:59.709 --> 00:00:59.719 align:start position:0%
click replace and it will jump to the
 

00:00:59.719 --> 00:01:02.500 align:start position:0%
click replace and it will jump to the
next<00:00:59.929><c> instance</c><00:01:00.469><c> automatically</c><00:01:01.280><c> if</c><00:01:01.489><c> you</c><00:01:02.329><c> want</c>

00:01:02.500 --> 00:01:02.510 align:start position:0%
next instance automatically if you want
 

00:01:02.510 --> 00:01:04.210 align:start position:0%
next instance automatically if you want
to<00:01:02.690><c> skip</c><00:01:02.929><c> the</c><00:01:03.140><c> current</c><00:01:03.469><c> instance</c><00:01:03.859><c> without</c>

00:01:04.210 --> 00:01:04.220 align:start position:0%
to skip the current instance without
 

00:01:04.220 --> 00:01:08.190 align:start position:0%
to skip the current instance without
replacing<00:01:04.610><c> it</c><00:01:04.909><c> click</c><00:01:05.540><c> find</c><00:01:05.930><c> next</c><00:01:06.259><c> instead</c>

00:01:08.190 --> 00:01:08.200 align:start position:0%
replacing it click find next instead
 

00:01:08.200 --> 00:01:10.359 align:start position:0%
replacing it click find next instead
alternatively<00:01:09.200><c> to</c><00:01:09.619><c> replace</c><00:01:09.950><c> every</c><00:01:10.340><c> instance</c>

00:01:10.359 --> 00:01:10.369 align:start position:0%
alternatively to replace every instance
 

00:01:10.369 --> 00:01:13.030 align:start position:0%
alternatively to replace every instance
without<00:01:11.210><c> having</c><00:01:11.540><c> to</c><00:01:11.630><c> review</c><00:01:11.930><c> each</c><00:01:12.080><c> one</c><00:01:12.110><c> click</c>

00:01:13.030 --> 00:01:13.040 align:start position:0%
without having to review each one click
 

00:01:13.040 --> 00:01:16.539 align:start position:0%
without having to review each one click
replace<00:01:13.430><c> all</c><00:01:13.759><c> and</c><00:01:14.500><c> the</c><00:01:15.500><c> entire</c><00:01:15.860><c> workbook</c><00:01:16.189><c> will</c>

00:01:16.539 --> 00:01:16.549 align:start position:0%
replace all and the entire workbook will
 

00:01:16.549 --> 00:01:19.390 align:start position:0%
replace all and the entire workbook will
be<00:01:16.670><c> updated</c><00:01:17.680><c> when</c><00:01:18.680><c> it</c><00:01:18.799><c> comes</c><00:01:19.009><c> to</c><00:01:19.220><c> using</c>

00:01:19.390 --> 00:01:19.400 align:start position:0%
be updated when it comes to using
 

00:01:19.400 --> 00:01:21.490 align:start position:0%
be updated when it comes to using
replace<00:01:19.909><c> although</c><00:01:20.509><c> it's</c><00:01:20.840><c> important</c><00:01:21.380><c> to</c>

00:01:21.490 --> 00:01:21.500 align:start position:0%
replace although it's important to
 

00:01:21.500 --> 00:01:23.170 align:start position:0%
replace although it's important to
remember<00:01:21.770><c> that</c><00:01:22.040><c> it</c><00:01:22.159><c> could</c><00:01:22.340><c> find</c><00:01:22.610><c> matches</c><00:01:23.030><c> you</c>

00:01:23.170 --> 00:01:23.180 align:start position:0%
remember that it could find matches you
 

00:01:23.180 --> 00:01:25.179 align:start position:0%
remember that it could find matches you
didn't<00:01:23.420><c> anticipate</c><00:01:23.659><c> and</c><00:01:24.170><c> might</c><00:01:24.530><c> not</c><00:01:24.710><c> want</c><00:01:25.040><c> to</c>

00:01:25.179 --> 00:01:25.189 align:start position:0%
didn't anticipate and might not want to
 

00:01:25.189 --> 00:01:27.969 align:start position:0%
didn't anticipate and might not want to
actually<00:01:25.369><c> change</c><00:01:26.200><c> generally</c><00:01:27.200><c> speaking</c><00:01:27.500><c> you</c>

00:01:27.969 --> 00:01:27.979 align:start position:0%
actually change generally speaking you
 

00:01:27.979 --> 00:01:30.219 align:start position:0%
actually change generally speaking you
don't<00:01:28.009><c> want</c><00:01:28.369><c> to</c><00:01:28.460><c> use</c><00:01:28.610><c> replace</c><00:01:29.030><c> all</c><00:01:29.360><c> because</c><00:01:30.110><c> it</c>

00:01:30.219 --> 00:01:30.229 align:start position:0%
don't want to use replace all because it
 

00:01:30.229 --> 00:01:31.600 align:start position:0%
don't want to use replace all because it
doesn't<00:01:30.530><c> give</c><00:01:30.649><c> you</c><00:01:30.740><c> the</c><00:01:30.920><c> option</c><00:01:31.310><c> of</c><00:01:31.460><c> skipping</c>

00:01:31.600 --> 00:01:31.610 align:start position:0%
doesn't give you the option of skipping
 

00:01:31.610 --> 00:01:34.090 align:start position:0%
doesn't give you the option of skipping
anything<00:01:32.210><c> you</c><00:01:32.360><c> don't</c><00:01:32.479><c> want</c><00:01:32.750><c> to</c><00:01:32.810><c> change</c><00:01:33.140><c> so</c><00:01:34.040><c> you</c>

00:01:34.090 --> 00:01:34.100 align:start position:0%
anything you don't want to change so you
 

00:01:34.100 --> 00:01:35.859 align:start position:0%
anything you don't want to change so you
should<00:01:34.340><c> only</c><00:01:34.549><c> use</c><00:01:34.700><c> this</c><00:01:35.030><c> option</c><00:01:35.240><c> if</c><00:01:35.630><c> you're</c>

00:01:35.859 --> 00:01:35.869 align:start position:0%
should only use this option if you're
 

00:01:35.869 --> 00:01:37.840 align:start position:0%
should only use this option if you're
absolutely<00:01:36.380><c> sure</c><00:01:36.680><c> that</c><00:01:36.950><c> it</c><00:01:37.280><c> won't</c><00:01:37.490><c> replace</c>

00:01:37.840 --> 00:01:37.850 align:start position:0%
absolutely sure that it won't replace
 

00:01:37.850 --> 00:01:41.139 align:start position:0%
absolutely sure that it won't replace
anything<00:01:38.180><c> you</c><00:01:38.479><c> didn't</c><00:01:38.750><c> intend</c><00:01:39.079><c> it</c><00:01:39.229><c> to</c><00:01:40.149><c> now</c>

00:01:41.139 --> 00:01:41.149 align:start position:0%
anything you didn't intend it to now
 

00:01:41.149 --> 00:01:42.399 align:start position:0%
anything you didn't intend it to now
that<00:01:41.210><c> you</c><00:01:41.479><c> know</c><00:01:41.630><c> how</c><00:01:41.780><c> to</c><00:01:41.810><c> use</c><00:01:42.020><c> Find</c><00:01:42.320><c> and</c>

00:01:42.399 --> 00:01:42.409 align:start position:0%
that you know how to use Find and
 

00:01:42.409 --> 00:01:44.319 align:start position:0%
that you know how to use Find and
Replace<00:01:42.500><c> you</c><00:01:43.159><c> can</c><00:01:43.340><c> put</c><00:01:43.520><c> this</c><00:01:43.670><c> time-saving</c>

00:01:44.319 --> 00:01:44.329 align:start position:0%
Replace you can put this time-saving
 

00:01:44.329 --> 00:01:45.670 align:start position:0%
Replace you can put this time-saving
technique<00:01:44.689><c> to</c><00:01:44.869><c> work</c><00:01:45.020><c> in</c><00:01:45.200><c> your</c><00:01:45.320><c> Excel</c>

00:01:45.670 --> 00:01:45.680 align:start position:0%
technique to work in your Excel
 

00:01:45.680 --> 00:01:48.250 align:start position:0%
technique to work in your Excel
spreadsheets