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.860><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.620 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.570><c> for</c><00:00:03.780><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:10.620 --> 00:00:10.630 align:start position:0%
 
 

00:00:10.630 --> 00:00:12.660 align:start position:0%
 
by<00:00:11.380><c> default</c><00:00:11.710><c> when</c><00:00:12.100><c> you</c><00:00:12.250><c> create</c><00:00:12.550><c> a</c><00:00:12.580><c> new</c>

00:00:12.660 --> 00:00:12.670 align:start position:0%
by default when you create a new
 

00:00:12.670 --> 00:00:14.730 align:start position:0%
by default when you create a new
workbook<00:00:13.000><c> in</c><00:00:13.330><c> Excel</c><00:00:13.420><c> it</c><00:00:13.900><c> contains</c><00:00:14.410><c> one</c>

00:00:14.730 --> 00:00:14.740 align:start position:0%
workbook in Excel it contains one
 

00:00:14.740 --> 00:00:17.730 align:start position:0%
workbook in Excel it contains one
worksheet<00:00:15.220><c> called</c><00:00:15.460><c> sheet</c><00:00:15.880><c> one</c><00:00:16.740><c> sometimes</c>

00:00:17.730 --> 00:00:17.740 align:start position:0%
worksheet called sheet one sometimes
 

00:00:17.740 --> 00:00:20.070 align:start position:0%
worksheet called sheet one sometimes
that's<00:00:18.010><c> all</c><00:00:18.160><c> you</c><00:00:18.310><c> need</c><00:00:18.520><c> but</c><00:00:19.360><c> if</c><00:00:19.480><c> you</c><00:00:19.600><c> want</c><00:00:19.840><c> you</c>

00:00:20.070 --> 00:00:20.080 align:start position:0%
that's all you need but if you want you
 

00:00:20.080 --> 00:00:21.630 align:start position:0%
that's all you need but if you want you
can<00:00:20.230><c> create</c><00:00:20.410><c> additional</c><00:00:20.740><c> worksheets</c><00:00:21.340><c> and</c>

00:00:21.630 --> 00:00:21.640 align:start position:0%
can create additional worksheets and
 

00:00:21.640 --> 00:00:23.370 align:start position:0%
can create additional worksheets and
even<00:00:21.910><c> customize</c><00:00:22.390><c> them</c><00:00:22.660><c> so</c><00:00:22.930><c> you</c><00:00:22.990><c> can</c><00:00:23.200><c> store</c>

00:00:23.370 --> 00:00:23.380 align:start position:0%
even customize them so you can store
 

00:00:23.380 --> 00:00:25.170 align:start position:0%
even customize them so you can store
large<00:00:23.680><c> amounts</c><00:00:23.740><c> of</c><00:00:24.100><c> data</c><00:00:24.310><c> all</c><00:00:24.550><c> in</c><00:00:24.850><c> the</c><00:00:24.970><c> same</c>

00:00:25.170 --> 00:00:25.180 align:start position:0%
large amounts of data all in the same
 

00:00:25.180 --> 00:00:28.020 align:start position:0%
large amounts of data all in the same
workbook<00:00:25.390><c> as</c><00:00:26.010><c> you</c><00:00:27.010><c> can</c><00:00:27.160><c> see</c><00:00:27.370><c> I've</c><00:00:27.610><c> already</c>

00:00:28.020 --> 00:00:28.030 align:start position:0%
workbook as you can see I've already
 

00:00:28.030 --> 00:00:29.580 align:start position:0%
workbook as you can see I've already
made<00:00:28.180><c> some</c><00:00:28.360><c> progress</c><00:00:28.570><c> creating</c><00:00:28.960><c> worksheets</c>

00:00:29.580 --> 00:00:29.590 align:start position:0%
made some progress creating worksheets
 

00:00:29.590 --> 00:00:30.900 align:start position:0%
made some progress creating worksheets
for<00:00:29.740><c> each</c><00:00:29.920><c> month</c><00:00:30.190><c> in</c><00:00:30.400><c> the</c><00:00:30.430><c> year</c>

00:00:30.900 --> 00:00:30.910 align:start position:0%
for each month in the year
 

00:00:30.910 --> 00:00:33.210 align:start position:0%
for each month in the year
I<00:00:30.960><c> still</c><00:00:31.960><c> need</c><00:00:32.110><c> one</c><00:00:32.320><c> final</c><00:00:32.590><c> sheet</c><00:00:32.920><c> for</c><00:00:33.129><c> the</c>

00:00:33.210 --> 00:00:33.220 align:start position:0%
I still need one final sheet for the
 

00:00:33.220 --> 00:00:36.090 align:start position:0%
I still need one final sheet for the
month<00:00:33.400><c> of</c><00:00:33.489><c> December</c><00:00:34.260><c> to</c><00:00:35.260><c> quickly</c><00:00:35.500><c> insert</c><00:00:35.950><c> a</c>

00:00:36.090 --> 00:00:36.100 align:start position:0%
month of December to quickly insert a
 

00:00:36.100 --> 00:00:37.830 align:start position:0%
month of December to quickly insert a
new<00:00:36.250><c> sheet</c><00:00:36.280><c> just</c><00:00:37.030><c> click</c><00:00:37.300><c> the</c><00:00:37.449><c> new</c><00:00:37.600><c> sheet</c>

00:00:37.830 --> 00:00:37.840 align:start position:0%
new sheet just click the new sheet
 

00:00:37.840 --> 00:00:39.720 align:start position:0%
new sheet just click the new sheet
button<00:00:38.020><c> always</c><00:00:38.739><c> found</c><00:00:38.980><c> to</c><00:00:39.160><c> the</c><00:00:39.250><c> far</c><00:00:39.460><c> right</c><00:00:39.670><c> of</c>

00:00:39.720 --> 00:00:39.730 align:start position:0%
button always found to the far right of
 

00:00:39.730 --> 00:00:43.439 align:start position:0%
button always found to the far right of
your<00:00:39.970><c> tabs</c><00:00:41.400><c> alternatively</c><00:00:42.400><c> you</c><00:00:42.820><c> can</c><00:00:42.970><c> copy</c><00:00:43.210><c> one</c>

00:00:43.439 --> 00:00:43.449 align:start position:0%
your tabs alternatively you can copy one
 

00:00:43.449 --> 00:00:45.450 align:start position:0%
your tabs alternatively you can copy one
of<00:00:43.480><c> your</c><00:00:43.720><c> existing</c><00:00:43.960><c> worksheets</c><00:00:44.589><c> this</c><00:00:45.250><c> will</c>

00:00:45.450 --> 00:00:45.460 align:start position:0%
of your existing worksheets this will
 

00:00:45.460 --> 00:00:47.549 align:start position:0%
of your existing worksheets this will
create<00:00:45.730><c> a</c><00:00:45.850><c> new</c><00:00:46.059><c> worksheet</c><00:00:46.269><c> and</c><00:00:46.720><c> duplicate</c><00:00:47.409><c> the</c>

00:00:47.549 --> 00:00:47.559 align:start position:0%
create a new worksheet and duplicate the
 

00:00:47.559 --> 00:00:49.710 align:start position:0%
create a new worksheet and duplicate the
contents<00:00:48.070><c> perfect</c><00:00:48.790><c> for</c><00:00:48.970><c> keeping</c><00:00:49.239><c> track</c><00:00:49.269><c> of</c><00:00:49.479><c> my</c>

00:00:49.710 --> 00:00:49.720 align:start position:0%
contents perfect for keeping track of my
 

00:00:49.720 --> 00:00:51.710 align:start position:0%
contents perfect for keeping track of my
budget<00:00:49.900><c> using</c><00:00:50.350><c> the</c><00:00:50.470><c> same</c><00:00:50.680><c> table</c><00:00:51.040><c> each</c><00:00:51.220><c> month</c>

00:00:51.710 --> 00:00:51.720 align:start position:0%
budget using the same table each month
 

00:00:51.720 --> 00:00:54.450 align:start position:0%
budget using the same table each month
all<00:00:52.720><c> you</c><00:00:52.989><c> have</c><00:00:53.170><c> to</c><00:00:53.320><c> do</c><00:00:53.470><c> is</c><00:00:53.710><c> right-click</c><00:00:54.040><c> the</c>

00:00:54.450 --> 00:00:54.460 align:start position:0%
all you have to do is right-click the
 

00:00:54.460 --> 00:00:57.119 align:start position:0%
all you have to do is right-click the
worksheet<00:00:54.879><c> you</c><00:00:55.000><c> want</c><00:00:55.239><c> then</c><00:00:56.229><c> choose</c><00:00:56.559><c> move</c><00:00:56.860><c> or</c>

00:00:57.119 --> 00:00:57.129 align:start position:0%
worksheet you want then choose move or
 

00:00:57.129 --> 00:01:00.660 align:start position:0%
worksheet you want then choose move or
copy<00:00:57.280><c> from</c><00:00:57.640><c> the</c><00:00:57.790><c> menu</c><00:00:58.800><c> next</c><00:00:59.800><c> check</c><00:01:00.489><c> the</c><00:01:00.519><c> box</c>

00:01:00.660 --> 00:01:00.670 align:start position:0%
copy from the menu next check the box
 

00:01:00.670 --> 00:01:03.840 align:start position:0%
copy from the menu next check the box
that<00:01:01.000><c> says</c><00:01:01.150><c> create</c><00:01:01.659><c> a</c><00:01:01.839><c> copy</c><00:01:02.110><c> and</c><00:01:02.850><c> identify</c>

00:01:03.840 --> 00:01:03.850 align:start position:0%
that says create a copy and identify
 

00:01:03.850 --> 00:01:05.340 align:start position:0%
that says create a copy and identify
where<00:01:04.030><c> you</c><00:01:04.150><c> want</c><00:01:04.330><c> the</c><00:01:04.420><c> worksheet</c><00:01:04.809><c> to</c><00:01:04.960><c> go</c><00:01:05.110><c> I</c>

00:01:05.340 --> 00:01:05.350 align:start position:0%
where you want the worksheet to go I
 

00:01:05.350 --> 00:01:07.800 align:start position:0%
where you want the worksheet to go I
want<00:01:06.159><c> mine</c><00:01:06.340><c> to</c><00:01:06.490><c> go</c><00:01:06.640><c> to</c><00:01:06.700><c> the</c><00:01:06.940><c> very</c><00:01:07.210><c> end</c><00:01:07.330><c> of</c><00:01:07.659><c> the</c>

00:01:07.800 --> 00:01:07.810 align:start position:0%
want mine to go to the very end of the
 

00:01:07.810 --> 00:01:12.149 align:start position:0%
want mine to go to the very end of the
list<00:01:08.970><c> click</c><00:01:09.970><c> OK</c><00:01:10.360><c> and</c><00:01:10.600><c> a</c><00:01:11.380><c> copy</c><00:01:11.590><c> will</c><00:01:11.710><c> appear</c>

00:01:12.149 --> 00:01:12.159 align:start position:0%
list click OK and a copy will appear
 

00:01:12.159 --> 00:01:13.590 align:start position:0%
list click OK and a copy will appear
with<00:01:12.310><c> the</c><00:01:12.340><c> same</c><00:01:12.640><c> name</c><00:01:12.880><c> as</c><00:01:13.030><c> the</c><00:01:13.150><c> original</c><00:01:13.180><c> plus</c>

00:01:13.590 --> 00:01:13.600 align:start position:0%
with the same name as the original plus
 

00:01:13.600 --> 00:01:16.679 align:start position:0%
with the same name as the original plus
a<00:01:13.930><c> version</c><00:01:14.260><c> number</c><00:01:14.880><c> remember</c><00:01:15.880><c> this</c><00:01:16.390><c> is</c><00:01:16.570><c> the</c>

00:01:16.679 --> 00:01:16.689 align:start position:0%
a version number remember this is the
 

00:01:16.689 --> 00:01:17.999 align:start position:0%
a version number remember this is the
worksheet<00:01:17.079><c> I</c><00:01:17.110><c> needed</c><00:01:17.469><c> for</c><00:01:17.649><c> the</c><00:01:17.710><c> month</c><00:01:17.890><c> of</c>

00:01:17.999 --> 00:01:18.009 align:start position:0%
worksheet I needed for the month of
 

00:01:18.009 --> 00:01:20.039 align:start position:0%
worksheet I needed for the month of
December<00:01:18.070><c> so</c><00:01:19.030><c> I'm</c><00:01:19.210><c> going</c><00:01:19.390><c> to</c><00:01:19.450><c> rename</c><00:01:19.840><c> it</c><00:01:20.020><c> by</c>

00:01:20.039 --> 00:01:20.049 align:start position:0%
December so I'm going to rename it by
 

00:01:20.049 --> 00:01:22.649 align:start position:0%
December so I'm going to rename it by
right-clicking<00:01:20.439><c> the</c><00:01:20.829><c> tab</c><00:01:21.210><c> then</c><00:01:22.210><c> choosing</c>

00:01:22.649 --> 00:01:22.659 align:start position:0%
right-clicking the tab then choosing
 

00:01:22.659 --> 00:01:26.639 align:start position:0%
right-clicking the tab then choosing
rename<00:01:24.420><c> when</c><00:01:25.420><c> you're</c><00:01:25.570><c> done</c><00:01:25.750><c> click</c><00:01:26.289><c> anywhere</c>

00:01:26.639 --> 00:01:26.649 align:start position:0%
rename when you're done click anywhere
 

00:01:26.649 --> 00:01:29.069 align:start position:0%
rename when you're done click anywhere
outside<00:01:26.859><c> the</c><00:01:27.280><c> tab</c><00:01:27.490><c> to</c><00:01:27.729><c> deselect</c><00:01:28.090><c> it</c><00:01:28.390><c> or</c><00:01:28.719><c> press</c>

00:01:29.069 --> 00:01:29.079 align:start position:0%
outside the tab to deselect it or press
 

00:01:29.079 --> 00:01:32.010 align:start position:0%
outside the tab to deselect it or press
ENTER<00:01:29.439><c> on</c><00:01:29.469><c> your</c><00:01:29.619><c> keyboard</c><00:01:30.299><c> I'm</c><00:01:31.299><c> also</c><00:01:31.689><c> going</c><00:01:31.960><c> to</c>

00:01:32.010 --> 00:01:32.020 align:start position:0%
ENTER on your keyboard I'm also going to
 

00:01:32.020 --> 00:01:37.289 align:start position:0%
ENTER on your keyboard I'm also going to
update<00:01:32.200><c> the</c><00:01:32.469><c> worksheet</c><00:01:32.859><c> itself</c><00:01:36.180><c> next</c><00:01:37.180><c> I'd</c>

00:01:37.289 --> 00:01:37.299 align:start position:0%
update the worksheet itself next I'd
 

00:01:37.299 --> 00:01:38.880 align:start position:0%
update the worksheet itself next I'd
like<00:01:37.450><c> to</c><00:01:37.600><c> review</c><00:01:37.719><c> the</c><00:01:37.899><c> rest</c><00:01:38.170><c> of</c><00:01:38.320><c> my</c><00:01:38.439><c> worksheets</c>

00:01:38.880 --> 00:01:38.890 align:start position:0%
like to review the rest of my worksheets
 

00:01:38.890 --> 00:01:40.980 align:start position:0%
like to review the rest of my worksheets
and<00:01:39.159><c> make</c><00:01:39.310><c> sure</c><00:01:39.460><c> everything</c><00:01:39.939><c> is</c><00:01:40.060><c> in</c><00:01:40.179><c> order</c><00:01:40.329><c> it</c>

00:01:40.980 --> 00:01:40.990 align:start position:0%
and make sure everything is in order it
 

00:01:40.990 --> 00:01:42.740 align:start position:0%
and make sure everything is in order it
looks<00:01:41.229><c> like</c><00:01:41.409><c> some</c><00:01:41.649><c> of</c><00:01:41.679><c> them</c><00:01:41.890><c> need</c><00:01:42.070><c> to</c><00:01:42.189><c> be</c><00:01:42.310><c> moved</c>

00:01:42.740 --> 00:01:42.750 align:start position:0%
looks like some of them need to be moved
 

00:01:42.750 --> 00:01:45.359 align:start position:0%
looks like some of them need to be moved
to<00:01:43.750><c> do</c><00:01:43.899><c> this</c><00:01:44.109><c> just</c><00:01:44.649><c> drag</c><00:01:44.890><c> and</c><00:01:45.070><c> drop</c><00:01:45.100><c> the</c>

00:01:45.359 --> 00:01:45.369 align:start position:0%
to do this just drag and drop the
 

00:01:45.369 --> 00:01:50.969 align:start position:0%
to do this just drag and drop the
worksheet<00:01:45.729><c> tabs</c><00:01:45.969><c> into</c><00:01:46.299><c> place</c><00:01:49.590><c> you</c><00:01:50.590><c> can</c><00:01:50.770><c> even</c>

00:01:50.969 --> 00:01:50.979 align:start position:0%
worksheet tabs into place you can even
 

00:01:50.979 --> 00:01:51.429 align:start position:0%
worksheet tabs into place you can even
color

00:01:51.429 --> 00:01:51.439 align:start position:0%
color
 

00:01:51.439 --> 00:01:53.050 align:start position:0%
color
your<00:01:51.679><c> worksheets</c><00:01:52.100><c> to</c><00:01:52.369><c> make</c><00:01:52.490><c> them</c><00:01:52.670><c> easier</c><00:01:53.030><c> to</c>

00:01:53.050 --> 00:01:53.060 align:start position:0%
your worksheets to make them easier to
 

00:01:53.060 --> 00:01:56.679 align:start position:0%
your worksheets to make them easier to
reference<00:01:53.619><c> just</c><00:01:54.619><c> right-click</c><00:01:55.130><c> the</c><00:01:55.280><c> tab</c><00:01:55.689><c> then</c>

00:01:56.679 --> 00:01:56.689 align:start position:0%
reference just right-click the tab then
 

00:01:56.689 --> 00:02:01.450 align:start position:0%
reference just right-click the tab then
go<00:01:56.719><c> to</c><00:01:56.990><c> tab</c><00:01:57.259><c> color</c><00:01:59.829><c> the</c><00:02:00.829><c> color</c><00:02:01.039><c> is</c><00:02:01.250><c> less</c>

00:02:01.450 --> 00:02:01.460 align:start position:0%
go to tab color the color is less
 

00:02:01.460 --> 00:02:02.740 align:start position:0%
go to tab color the color is less
noticeable<00:02:01.700><c> when</c><00:02:02.149><c> the</c><00:02:02.240><c> worksheet</c><00:02:02.630><c> is</c>

00:02:02.740 --> 00:02:02.750 align:start position:0%
noticeable when the worksheet is
 

00:02:02.750 --> 00:02:05.169 align:start position:0%
noticeable when the worksheet is
selected<00:02:03.289><c> if</c><00:02:03.469><c> you</c><00:02:04.039><c> select</c><00:02:04.429><c> another</c><00:02:04.759><c> worksheet</c>

00:02:05.169 --> 00:02:05.179 align:start position:0%
selected if you select another worksheet
 

00:02:05.179 --> 00:02:07.270 align:start position:0%
selected if you select another worksheet
you'll<00:02:06.170><c> see</c><00:02:06.350><c> the</c><00:02:06.469><c> color</c><00:02:06.679><c> the</c><00:02:06.770><c> way</c><00:02:06.920><c> it</c><00:02:07.130><c> was</c>

00:02:07.270 --> 00:02:07.280 align:start position:0%
you'll see the color the way it was
 

00:02:07.280 --> 00:02:10.359 align:start position:0%
you'll see the color the way it was
intended<00:02:08.289><c> finally</c><00:02:09.289><c> if</c><00:02:09.500><c> you</c><00:02:09.739><c> have</c><00:02:09.920><c> a</c><00:02:09.950><c> worksheet</c>

00:02:10.359 --> 00:02:10.369 align:start position:0%
intended finally if you have a worksheet
 

00:02:10.369 --> 00:02:11.289 align:start position:0%
intended finally if you have a worksheet
you<00:02:10.519><c> don't</c><00:02:10.700><c> need</c><00:02:10.849><c> anymore</c>

00:02:11.289 --> 00:02:11.299 align:start position:0%
you don't need anymore
 

00:02:11.299 --> 00:02:12.850 align:start position:0%
you don't need anymore
you<00:02:11.629><c> can</c><00:02:11.810><c> easily</c><00:02:12.049><c> remove</c><00:02:12.500><c> it</c><00:02:12.620><c> from</c><00:02:12.769><c> your</c>

00:02:12.850 --> 00:02:12.860 align:start position:0%
you can easily remove it from your
 

00:02:12.860 --> 00:02:15.100 align:start position:0%
you can easily remove it from your
workbook<00:02:13.370><c> all</c><00:02:14.209><c> you</c><00:02:14.450><c> have</c><00:02:14.629><c> to</c><00:02:14.750><c> do</c><00:02:14.900><c> is</c>

00:02:15.100 --> 00:02:15.110 align:start position:0%
workbook all you have to do is
 

00:02:15.110 --> 00:02:18.839 align:start position:0%
workbook all you have to do is
right-click<00:02:15.379><c> the</c><00:02:15.739><c> tab</c><00:02:16.629><c> then</c><00:02:17.629><c> choose</c><00:02:17.660><c> delete</c>

00:02:18.839 --> 00:02:18.849 align:start position:0%
right-click the tab then choose delete
 

00:02:18.849 --> 00:02:23.140 align:start position:0%
right-click the tab then choose delete
now<00:02:19.849><c> it</c><00:02:20.000><c> looks</c><00:02:20.180><c> like</c><00:02:20.390><c> we're</c><00:02:20.540><c> all</c><00:02:20.629><c> set</c><00:02:22.030><c> when</c><00:02:23.030><c> you</c>

00:02:23.140 --> 00:02:23.150 align:start position:0%
now it looks like we're all set when you
 

00:02:23.150 --> 00:02:24.940 align:start position:0%
now it looks like we're all set when you
have<00:02:23.360><c> multiple</c><00:02:23.599><c> worksheets</c><00:02:24.170><c> you</c><00:02:24.470><c> can</c><00:02:24.769><c> work</c>

00:02:24.940 --> 00:02:24.950 align:start position:0%
have multiple worksheets you can work
 

00:02:24.950 --> 00:02:26.890 align:start position:0%
have multiple worksheets you can work
with<00:02:25.099><c> each</c><00:02:25.310><c> one</c><00:02:25.549><c> individually</c><00:02:25.879><c> or</c><00:02:26.480><c> you</c><00:02:26.720><c> can</c>

00:02:26.890 --> 00:02:26.900 align:start position:0%
with each one individually or you can
 

00:02:26.900 --> 00:02:29.500 align:start position:0%
with each one individually or you can
edit<00:02:27.079><c> several</c><00:02:27.590><c> at</c><00:02:27.739><c> the</c><00:02:27.860><c> same</c><00:02:28.099><c> time</c><00:02:28.430><c> this</c><00:02:29.269><c> can</c>

00:02:29.500 --> 00:02:29.510 align:start position:0%
edit several at the same time this can
 

00:02:29.510 --> 00:02:31.030 align:start position:0%
edit several at the same time this can
be<00:02:29.629><c> useful</c><00:02:29.989><c> if</c><00:02:30.110><c> you're</c><00:02:30.260><c> working</c><00:02:30.560><c> with</c><00:02:30.680><c> lots</c><00:02:30.860><c> of</c>

00:02:31.030 --> 00:02:31.040 align:start position:0%
be useful if you're working with lots of
 

00:02:31.040 --> 00:02:33.400 align:start position:0%
be useful if you're working with lots of
data<00:02:31.220><c> that's</c><00:02:31.549><c> closely</c><00:02:31.819><c> related</c><00:02:32.170><c> let's</c><00:02:33.170><c> take</c><00:02:33.379><c> a</c>

00:02:33.400 --> 00:02:33.410 align:start position:0%
data that's closely related let's take a
 

00:02:33.410 --> 00:02:36.400 align:start position:0%
data that's closely related let's take a
look<00:02:33.879><c> for</c><00:02:34.879><c> example</c><00:02:34.970><c> I'm</c><00:02:35.569><c> planning</c><00:02:35.989><c> to</c><00:02:36.140><c> move</c><00:02:36.290><c> in</c>

00:02:36.400 --> 00:02:36.410 align:start position:0%
look for example I'm planning to move in
 

00:02:36.410 --> 00:02:38.589 align:start position:0%
look for example I'm planning to move in
the<00:02:36.530><c> month</c><00:02:36.709><c> of</c><00:02:36.799><c> September</c><00:02:37.150><c> my</c><00:02:38.150><c> rent</c><00:02:38.390><c> is</c><00:02:38.540><c> going</c>

00:02:38.589 --> 00:02:38.599 align:start position:0%
the month of September my rent is going
 

00:02:38.599 --> 00:02:40.330 align:start position:0%
the month of September my rent is going
to<00:02:38.840><c> go</c><00:02:38.959><c> up</c><00:02:39.110><c> and</c><00:02:39.349><c> I'm</c><00:02:39.530><c> canceling</c><00:02:39.739><c> my</c><00:02:40.129><c> gym</c>

00:02:40.330 --> 00:02:40.340 align:start position:0%
to go up and I'm canceling my gym
 

00:02:40.340 --> 00:02:42.520 align:start position:0%
to go up and I'm canceling my gym
membership<00:02:40.489><c> too</c><00:02:41.030><c> that</c><00:02:41.930><c> means</c><00:02:42.140><c> I</c><00:02:42.349><c> need</c><00:02:42.410><c> to</c>

00:02:42.520 --> 00:02:42.530 align:start position:0%
membership too that means I need to
 

00:02:42.530 --> 00:02:44.619 align:start position:0%
membership too that means I need to
update<00:02:42.769><c> not</c><00:02:43.099><c> only</c><00:02:43.400><c> this</c><00:02:43.549><c> worksheet</c><00:02:44.120><c> but</c><00:02:44.450><c> also</c>

00:02:44.619 --> 00:02:44.629 align:start position:0%
update not only this worksheet but also
 

00:02:44.629 --> 00:02:47.170 align:start position:0%
update not only this worksheet but also
the<00:02:44.900><c> sheets</c><00:02:45.109><c> for</c><00:02:45.319><c> the</c><00:02:45.440><c> rest</c><00:02:45.620><c> of</c><00:02:45.739><c> the</c><00:02:45.859><c> year</c><00:02:46.180><c> we</c>

00:02:47.170 --> 00:02:47.180 align:start position:0%
the sheets for the rest of the year we
 

00:02:47.180 --> 00:02:48.789 align:start position:0%
the sheets for the rest of the year we
can<00:02:47.209><c> edit</c><00:02:47.510><c> them</c><00:02:47.750><c> all</c><00:02:47.900><c> at</c><00:02:48.049><c> once</c><00:02:48.260><c> just</c><00:02:48.650><c> by</c>

00:02:48.789 --> 00:02:48.799 align:start position:0%
can edit them all at once just by
 

00:02:48.799 --> 00:02:51.099 align:start position:0%
can edit them all at once just by
grouping<00:02:49.129><c> them</c><00:02:49.359><c> start</c><00:02:50.359><c> by</c><00:02:50.510><c> selecting</c><00:02:50.989><c> the</c>

00:02:51.099 --> 00:02:51.109 align:start position:0%
grouping them start by selecting the
 

00:02:51.109 --> 00:02:52.869 align:start position:0%
grouping them start by selecting the
first<00:02:51.290><c> sheet</c><00:02:51.560><c> you</c><00:02:51.680><c> want</c><00:02:51.859><c> a</c><00:02:51.920><c> group</c><00:02:52.129><c> then</c><00:02:52.579><c> press</c>

00:02:52.869 --> 00:02:52.879 align:start position:0%
first sheet you want a group then press
 

00:02:52.879 --> 00:02:54.910 align:start position:0%
first sheet you want a group then press
and<00:02:53.090><c> hold</c><00:02:53.269><c> ctrl</c><00:02:53.810><c> on</c><00:02:54.049><c> your</c><00:02:54.079><c> keyboard</c><00:02:54.230><c> while</c><00:02:54.859><c> you</c>

00:02:54.910 --> 00:02:54.920 align:start position:0%
and hold ctrl on your keyboard while you
 

00:02:54.920 --> 00:02:58.030 align:start position:0%
and hold ctrl on your keyboard while you
select<00:02:55.190><c> the</c><00:02:55.489><c> rest</c><00:02:56.109><c> release</c><00:02:57.109><c> the</c><00:02:57.290><c> ctrl</c><00:02:57.650><c> key</c><00:02:57.680><c> and</c>

00:02:58.030 --> 00:02:58.040 align:start position:0%
select the rest release the ctrl key and
 

00:02:58.040 --> 00:02:59.589 align:start position:0%
select the rest release the ctrl key and
you'll<00:02:58.400><c> be</c><00:02:58.549><c> able</c><00:02:58.760><c> to</c><00:02:58.849><c> navigate</c><00:02:59.030><c> and</c><00:02:59.329><c> make</c>

00:02:59.589 --> 00:02:59.599 align:start position:0%
you'll be able to navigate and make
 

00:02:59.599 --> 00:03:01.809 align:start position:0%
you'll be able to navigate and make
changes<00:03:00.049><c> to</c><00:03:00.109><c> the</c><00:03:00.319><c> data</c><00:03:00.470><c> changes</c><00:03:01.370><c> that</c><00:03:01.700><c> will</c>

00:03:01.809 --> 00:03:01.819 align:start position:0%
changes to the data changes that will
 

00:03:01.819 --> 00:03:03.900 align:start position:0%
changes to the data changes that will
apply<00:03:02.090><c> to</c><00:03:02.150><c> all</c><00:03:02.329><c> the</c><00:03:02.480><c> worksheets</c><00:03:02.660><c> in</c><00:03:03.230><c> the</c><00:03:03.319><c> group</c>

00:03:03.900 --> 00:03:03.910 align:start position:0%
apply to all the worksheets in the group
 

00:03:03.910 --> 00:03:06.520 align:start position:0%
apply to all the worksheets in the group
for<00:03:04.910><c> example</c><00:03:05.329><c> if</c><00:03:05.510><c> I</c><00:03:05.630><c> change</c><00:03:05.900><c> the</c><00:03:06.139><c> rent</c><00:03:06.349><c> to</c>

00:03:06.520 --> 00:03:06.530 align:start position:0%
for example if I change the rent to
 

00:03:06.530 --> 00:03:10.059 align:start position:0%
for example if I change the rent to
seven<00:03:06.859><c> seventy</c><00:03:07.220><c> five</c><00:03:07.400><c> in</c><00:03:07.430><c> one</c><00:03:07.910><c> worksheet</c><00:03:09.069><c> the</c>

00:03:10.059 --> 00:03:10.069 align:start position:0%
seven seventy five in one worksheet the
 

00:03:10.069 --> 00:03:12.870 align:start position:0%
seven seventy five in one worksheet the
rest<00:03:10.310><c> of</c><00:03:10.459><c> the</c><00:03:10.519><c> group</c><00:03:10.669><c> gets</c><00:03:10.940><c> updated</c><00:03:11.329><c> to</c><00:03:11.450><c> the</c>

00:03:12.870 --> 00:03:12.880 align:start position:0%
rest of the group gets updated to the
 

00:03:12.880 --> 00:03:15.309 align:start position:0%
rest of the group gets updated to the
same<00:03:13.880><c> rule</c><00:03:14.120><c> applies</c><00:03:14.419><c> if</c><00:03:14.660><c> I</c><00:03:14.780><c> clear</c><00:03:15.049><c> the</c><00:03:15.169><c> row</c>

00:03:15.309 --> 00:03:15.319 align:start position:0%
same rule applies if I clear the row
 

00:03:15.319 --> 00:03:20.559 align:start position:0%
same rule applies if I clear the row
that<00:03:15.500><c> contains</c><00:03:15.919><c> my</c><00:03:16.099><c> gym</c><00:03:16.340><c> membership</c><00:03:19.569><c> to</c>

00:03:20.559 --> 00:03:20.569 align:start position:0%
that contains my gym membership to
 

00:03:20.569 --> 00:03:22.420 align:start position:0%
that contains my gym membership to
ungroup<00:03:20.930><c> just</c><00:03:21.590><c> right-click</c><00:03:22.069><c> one</c><00:03:22.250><c> of</c><00:03:22.310><c> the</c>

00:03:22.420 --> 00:03:22.430 align:start position:0%
ungroup just right-click one of the
 

00:03:22.430 --> 00:03:25.860 align:start position:0%
ungroup just right-click one of the
worksheets<00:03:22.900><c> then</c><00:03:23.900><c> click</c><00:03:24.200><c> ungroup</c><00:03:24.470><c> sheets</c>

00:03:25.860 --> 00:03:25.870 align:start position:0%
worksheets then click ungroup sheets
 

00:03:25.870 --> 00:03:27.940 align:start position:0%
worksheets then click ungroup sheets
alternatively<00:03:26.870><c> you</c><00:03:27.319><c> can</c><00:03:27.500><c> click</c><00:03:27.650><c> any</c>

00:03:27.940 --> 00:03:27.950 align:start position:0%
alternatively you can click any
 

00:03:27.950 --> 00:03:29.979 align:start position:0%
alternatively you can click any
worksheet<00:03:28.370><c> outside</c><00:03:28.849><c> the</c><00:03:29.000><c> group</c><00:03:29.239><c> just</c><00:03:29.870><c> be</c>

00:03:29.979 --> 00:03:29.989 align:start position:0%
worksheet outside the group just be
 

00:03:29.989 --> 00:03:32.490 align:start position:0%
worksheet outside the group just be
careful<00:03:30.290><c> not</c><00:03:30.410><c> to</c><00:03:30.470><c> do</c><00:03:30.680><c> that</c><00:03:30.829><c> by</c><00:03:31.040><c> accident</c>

00:03:32.490 --> 00:03:32.500 align:start position:0%
careful not to do that by accident
 

00:03:32.500 --> 00:03:34.420 align:start position:0%
careful not to do that by accident
worksheets<00:03:33.500><c> are</c><00:03:33.680><c> a</c><00:03:33.709><c> great</c><00:03:33.980><c> option</c><00:03:34.220><c> for</c>

00:03:34.420 --> 00:03:34.430 align:start position:0%
worksheets are a great option for
 

00:03:34.430 --> 00:03:36.069 align:start position:0%
worksheets are a great option for
storing<00:03:34.910><c> lots</c><00:03:35.120><c> of</c><00:03:35.269><c> data</c><00:03:35.510><c> in</c><00:03:35.599><c> the</c><00:03:35.870><c> same</c>

00:03:36.069 --> 00:03:36.079 align:start position:0%
storing lots of data in the same
 

00:03:36.079 --> 00:03:38.379 align:start position:0%
storing lots of data in the same
workbook<00:03:36.380><c> and</c><00:03:36.739><c> with</c><00:03:37.459><c> the</c><00:03:37.609><c> ability</c><00:03:38.030><c> to</c><00:03:38.060><c> group</c>

00:03:38.379 --> 00:03:38.389 align:start position:0%
workbook and with the ability to group
 

00:03:38.389 --> 00:03:40.629 align:start position:0%
workbook and with the ability to group
them<00:03:38.630><c> you</c><00:03:39.019><c> can</c><00:03:39.200><c> easily</c><00:03:39.440><c> add</c><00:03:39.769><c> or</c><00:03:39.799><c> edit</c><00:03:40.160><c> data</c>

00:03:40.629 --> 00:03:40.639 align:start position:0%
them you can easily add or edit data
 

00:03:40.639 --> 00:03:42.699 align:start position:0%
them you can easily add or edit data
anytime<00:03:41.030><c> whether</c><00:03:41.930><c> you</c><00:03:42.109><c> have</c><00:03:42.260><c> hundreds</c><00:03:42.650><c> of</c>

00:03:42.699 --> 00:03:42.709 align:start position:0%
anytime whether you have hundreds of
 

00:03:42.709 --> 00:03:46.090 align:start position:0%
anytime whether you have hundreds of
worksheets<00:03:43.130><c> or</c><00:03:43.340><c> just</c><00:03:43.819><c> a</c><00:03:43.940><c> few</c>