WEBVTT
Kind: captions
Language: en

00:00:06.200 --> 00:00:09.259 align:start position:0%
 
now<00:00:07.200><c> that</c><00:00:07.440><c> I</c><00:00:07.529><c> have</c><00:00:07.740><c> my</c><00:00:07.890><c> basic</c><00:00:08.160><c> bills</c><00:00:08.610><c> listed</c><00:00:09.120><c> in</c>

00:00:09.259 --> 00:00:09.269 align:start position:0%
now that I have my basic bills listed in
 

00:00:09.269 --> 00:00:11.600 align:start position:0%
now that I have my basic bills listed in
my<00:00:09.389><c> worksheet</c><00:00:09.900><c> I</c><00:00:10.110><c> think</c><00:00:10.679><c> I</c><00:00:10.800><c> like</c><00:00:11.010><c> to</c><00:00:11.040><c> clean</c><00:00:11.400><c> it</c>

00:00:11.600 --> 00:00:11.610 align:start position:0%
my worksheet I think I like to clean it
 

00:00:11.610 --> 00:00:13.789 align:start position:0%
my worksheet I think I like to clean it
up<00:00:11.700><c> and</c><00:00:11.969><c> format</c><00:00:12.389><c> it</c><00:00:12.710><c> formatting</c><00:00:13.710><c> your</c>

00:00:13.789 --> 00:00:13.799 align:start position:0%
up and format it formatting your
 

00:00:13.799 --> 00:00:16.310 align:start position:0%
up and format it formatting your
worksheet<00:00:14.280><c> can</c><00:00:14.429><c> make</c><00:00:14.580><c> it</c><00:00:14.730><c> look</c><00:00:14.910><c> nice</c><00:00:15.269><c> and</c><00:00:15.660><c> make</c>

00:00:16.310 --> 00:00:16.320 align:start position:0%
worksheet can make it look nice and make
 

00:00:16.320 --> 00:00:19.040 align:start position:0%
worksheet can make it look nice and make
it<00:00:16.470><c> easier</c><00:00:16.830><c> to</c><00:00:17.039><c> read</c><00:00:17.250><c> you</c><00:00:18.240><c> will</c><00:00:18.359><c> find</c><00:00:18.660><c> some</c><00:00:19.020><c> of</c>

00:00:19.040 --> 00:00:19.050 align:start position:0%
it easier to read you will find some of
 

00:00:19.050 --> 00:00:20.990 align:start position:0%
it easier to read you will find some of
the<00:00:19.230><c> font</c><00:00:19.500><c> formatting</c><00:00:20.010><c> commands</c><00:00:20.460><c> on</c><00:00:20.730><c> the</c><00:00:20.820><c> Home</c>

00:00:20.990 --> 00:00:21.000 align:start position:0%
the font formatting commands on the Home
 

00:00:21.000 --> 00:00:24.410 align:start position:0%
the font formatting commands on the Home
tab<00:00:21.029><c> in</c><00:00:21.720><c> the</c><00:00:21.840><c> font</c><00:00:22.020><c> group</c><00:00:22.850><c> let's</c><00:00:23.850><c> start</c><00:00:24.210><c> by</c>

00:00:24.410 --> 00:00:24.420 align:start position:0%
tab in the font group let's start by
 

00:00:24.420 --> 00:00:28.519 align:start position:0%
tab in the font group let's start by
making<00:00:24.449><c> the</c><00:00:25.199><c> title</c><00:00:25.590><c> bold</c><00:00:26.599><c> to</c><00:00:27.599><c> do</c><00:00:27.779><c> this</c><00:00:28.019><c> you</c>

00:00:28.519 --> 00:00:28.529 align:start position:0%
making the title bold to do this you
 

00:00:28.529 --> 00:00:30.320 align:start position:0%
making the title bold to do this you
first<00:00:28.560><c> need</c><00:00:29.099><c> to</c><00:00:29.160><c> select</c><00:00:29.429><c> the</c><00:00:29.820><c> text</c><00:00:30.179><c> you</c><00:00:30.210><c> want</c>

00:00:30.320 --> 00:00:30.330 align:start position:0%
first need to select the text you want
 

00:00:30.330 --> 00:00:33.440 align:start position:0%
first need to select the text you want
to<00:00:30.599><c> make</c><00:00:30.840><c> bulb</c><00:00:31.109><c> now</c><00:00:31.949><c> just</c><00:00:32.790><c> click</c><00:00:33.059><c> the</c><00:00:33.270><c> bold</c>

00:00:33.440 --> 00:00:33.450 align:start position:0%
to make bulb now just click the bold
 

00:00:33.450 --> 00:00:37.549 align:start position:0%
to make bulb now just click the bold
command<00:00:34.170><c> I</c><00:00:35.690><c> think</c><00:00:36.690><c> I'll</c><00:00:36.809><c> do</c><00:00:36.930><c> the</c><00:00:37.050><c> same</c><00:00:37.320><c> with</c>

00:00:37.549 --> 00:00:37.559 align:start position:0%
command I think I'll do the same with
 

00:00:37.559 --> 00:00:41.180 align:start position:0%
command I think I'll do the same with
all<00:00:37.800><c> my</c><00:00:38.070><c> bills</c><00:00:38.370><c> here</c><00:00:39.030><c> on</c><00:00:39.149><c> the</c><00:00:39.300><c> left</c><00:00:39.510><c> if</c><00:00:40.079><c> I</c><00:00:40.920><c> want</c>

00:00:41.180 --> 00:00:41.190 align:start position:0%
all my bills here on the left if I want
 

00:00:41.190 --> 00:00:43.700 align:start position:0%
all my bills here on the left if I want
to<00:00:41.370><c> format</c><00:00:41.760><c> more</c><00:00:42.120><c> than</c><00:00:42.300><c> one</c><00:00:42.480><c> cell</c><00:00:42.809><c> at</c><00:00:42.989><c> a</c><00:00:43.020><c> time</c>

00:00:43.700 --> 00:00:43.710 align:start position:0%
to format more than one cell at a time
 

00:00:43.710 --> 00:00:46.940 align:start position:0%
to format more than one cell at a time
I<00:00:43.739><c> can</c><00:00:44.309><c> select</c><00:00:44.489><c> entire</c><00:00:45.180><c> columns</c><00:00:45.840><c> and</c><00:00:46.050><c> rows</c><00:00:46.500><c> or</c>

00:00:46.940 --> 00:00:46.950 align:start position:0%
I can select entire columns and rows or
 

00:00:46.950 --> 00:00:50.360 align:start position:0%
I can select entire columns and rows or
specific<00:00:47.700><c> cells</c><00:00:48.500><c> to</c><00:00:49.500><c> select</c><00:00:49.950><c> the</c><00:00:50.219><c> entire</c>

00:00:50.360 --> 00:00:50.370 align:start position:0%
specific cells to select the entire
 

00:00:50.370 --> 00:00:52.970 align:start position:0%
specific cells to select the entire
column<00:00:50.750><c> just</c><00:00:51.750><c> left-click</c><00:00:52.289><c> the</c><00:00:52.620><c> column</c>

00:00:52.970 --> 00:00:52.980 align:start position:0%
column just left-click the column
 

00:00:52.980 --> 00:00:55.970 align:start position:0%
column just left-click the column
heading<00:00:53.370><c> and</c><00:00:54.000><c> the</c><00:00:54.989><c> entire</c><00:00:55.350><c> column</c><00:00:55.829><c> will</c>

00:00:55.970 --> 00:00:55.980 align:start position:0%
heading and the entire column will
 

00:00:55.980 --> 00:00:59.810 align:start position:0%
heading and the entire column will
appear<00:00:56.010><c> as</c><00:00:56.550><c> selected</c><00:00:57.800><c> to</c><00:00:58.800><c> select</c><00:00:59.250><c> specific</c>

00:00:59.810 --> 00:00:59.820 align:start position:0%
appear as selected to select specific
 

00:00:59.820 --> 00:01:00.770 align:start position:0%
appear as selected to select specific
cells<00:01:00.090><c> in</c><00:01:00.300><c> the</c><00:01:00.390><c> column</c>

00:01:00.770 --> 00:01:00.780 align:start position:0%
cells in the column
 

00:01:00.780 --> 00:01:03.380 align:start position:0%
cells in the column
just<00:01:01.230><c> click</c><00:01:01.559><c> a</c><00:01:01.710><c> cell</c><00:01:02.039><c> and</c><00:01:02.370><c> drag</c><00:01:02.609><c> your</c><00:01:02.850><c> mouse</c><00:01:02.910><c> to</c>

00:01:03.380 --> 00:01:03.390 align:start position:0%
just click a cell and drag your mouse to
 

00:01:03.390 --> 00:01:05.660 align:start position:0%
just click a cell and drag your mouse to
select<00:01:03.570><c> the</c><00:01:03.930><c> entire</c><00:01:04.199><c> cells</c><00:01:04.650><c> you</c><00:01:05.339><c> wish</c><00:01:05.519><c> to</c>

00:01:05.660 --> 00:01:05.670 align:start position:0%
select the entire cells you wish to
 

00:01:05.670 --> 00:01:08.899 align:start position:0%
select the entire cells you wish to
format<00:01:06.680><c> then</c><00:01:07.680><c> release</c><00:01:08.070><c> the</c><00:01:08.250><c> mouse</c><00:01:08.430><c> button</c>

00:01:08.899 --> 00:01:08.909 align:start position:0%
format then release the mouse button
 

00:01:08.909 --> 00:01:11.390 align:start position:0%
format then release the mouse button
now<00:01:09.659><c> you</c><00:01:09.720><c> can</c><00:01:10.049><c> left-click</c><00:01:10.380><c> the</c><00:01:10.710><c> bold</c><00:01:10.950><c> command</c>

00:01:11.390 --> 00:01:11.400 align:start position:0%
now you can left-click the bold command
 

00:01:11.400 --> 00:01:13.520 align:start position:0%
now you can left-click the bold command
and<00:01:11.760><c> all</c><00:01:12.360><c> the</c><00:01:12.540><c> selected</c><00:01:12.869><c> cells</c><00:01:13.229><c> will</c><00:01:13.409><c> be</c>

00:01:13.520 --> 00:01:13.530 align:start position:0%
and all the selected cells will be
 

00:01:13.530 --> 00:01:16.490 align:start position:0%
and all the selected cells will be
formatted<00:01:14.810><c> now</c><00:01:15.810><c> I'll</c><00:01:16.049><c> just</c><00:01:16.080><c> do</c><00:01:16.350><c> the</c><00:01:16.470><c> same</c>

00:01:16.490 --> 00:01:16.500 align:start position:0%
formatted now I'll just do the same
 

00:01:16.500 --> 00:01:20.149 align:start position:0%
formatted now I'll just do the same
thing<00:01:16.740><c> to</c><00:01:17.159><c> this</c><00:01:17.280><c> room</c><00:01:17.580><c> in</c><00:01:18.770><c> addition</c><00:01:19.770><c> to</c><00:01:20.070><c> the</c>

00:01:20.149 --> 00:01:20.159 align:start position:0%
thing to this room in addition to the
 

00:01:20.159 --> 00:01:22.370 align:start position:0%
thing to this room in addition to the
bold<00:01:20.400><c> command</c><00:01:20.909><c> you</c><00:01:21.240><c> also</c><00:01:21.479><c> have</c><00:01:21.869><c> the</c><00:01:21.990><c> italic</c>

00:01:22.370 --> 00:01:22.380 align:start position:0%
bold command you also have the italic
 

00:01:22.380 --> 00:01:24.530 align:start position:0%
bold command you also have the italic
and<00:01:22.680><c> underline</c><00:01:23.159><c> commands</c><00:01:23.729><c> that</c><00:01:24.090><c> work</c><00:01:24.390><c> the</c>

00:01:24.530 --> 00:01:24.540 align:start position:0%
and underline commands that work the
 

00:01:24.540 --> 00:01:27.230 align:start position:0%
and underline commands that work the
same<00:01:24.780><c> way</c><00:01:25.020><c> I</c><00:01:25.340><c> think</c><00:01:26.340><c> the</c><00:01:26.520><c> title</c><00:01:26.790><c> will</c><00:01:27.090><c> look</c>

00:01:27.230 --> 00:01:27.240 align:start position:0%
same way I think the title will look
 

00:01:27.240 --> 00:01:29.420 align:start position:0%
same way I think the title will look
good<00:01:27.450><c> in</c><00:01:27.600><c> italics</c><00:01:28.170><c> so</c><00:01:28.320><c> I'll</c><00:01:28.619><c> just</c><00:01:28.860><c> select</c><00:01:29.040><c> it</c>

00:01:29.420 --> 00:01:29.430 align:start position:0%
good in italics so I'll just select it
 

00:01:29.430 --> 00:01:31.670 align:start position:0%
good in italics so I'll just select it
and<00:01:29.670><c> click</c><00:01:29.850><c> the</c><00:01:29.939><c> italics</c><00:01:30.509><c> command</c><00:01:30.930><c> the</c>

00:01:31.670 --> 00:01:31.680 align:start position:0%
and click the italics command the
 

00:01:31.680 --> 00:01:33.530 align:start position:0%
and click the italics command the
underlined<00:01:32.189><c> command</c><00:01:32.579><c> works</c><00:01:32.820><c> the</c><00:01:33.000><c> same</c><00:01:33.180><c> way</c>

00:01:33.530 --> 00:01:33.540 align:start position:0%
underlined command works the same way
 

00:01:33.540 --> 00:01:36.100 align:start position:0%
underlined command works the same way
but<00:01:34.110><c> it</c><00:01:34.259><c> does</c><00:01:34.439><c> have</c><00:01:34.710><c> extra</c><00:01:34.950><c> menu</c><00:01:35.490><c> options</c>

00:01:36.100 --> 00:01:36.110 align:start position:0%
but it does have extra menu options
 

00:01:36.110 --> 00:01:41.200 align:start position:0%
but it does have extra menu options
let's<00:01:37.110><c> add</c><00:01:37.350><c> the</c><00:01:37.560><c> word</c><00:01:37.590><c> total</c><00:01:38.159><c> and</c><00:01:38.579><c> cell</c><00:01:39.030><c> a</c><00:01:39.240><c> 29</c>

00:01:41.200 --> 00:01:41.210 align:start position:0%
let's add the word total and cell a 29
 

00:01:41.210 --> 00:01:43.639 align:start position:0%
let's add the word total and cell a 29
eventually<00:01:42.210><c> I'll</c><00:01:42.390><c> add</c><00:01:42.689><c> up</c><00:01:42.840><c> my</c><00:01:42.990><c> monthly</c><00:01:43.380><c> bills</c>

00:01:43.639 --> 00:01:43.649 align:start position:0%
eventually I'll add up my monthly bills
 

00:01:43.649 --> 00:01:46.679 align:start position:0%
eventually I'll add up my monthly bills
and<00:01:43.950><c> list</c><00:01:44.490><c> it</c><00:01:44.670><c> in</c><00:01:44.790><c> this</c><00:01:44.970><c> room</c>

00:01:46.679 --> 00:01:46.689 align:start position:0%
and list it in this room
 

00:01:46.689 --> 00:01:49.289 align:start position:0%
and list it in this room
I<00:01:46.950><c> think</c><00:01:47.950><c> it</c><00:01:48.070><c> would</c><00:01:48.159><c> be</c><00:01:48.280><c> a</c><00:01:48.310><c> good</c><00:01:48.609><c> idea</c><00:01:48.939><c> to</c><00:01:49.119><c> draw</c>

00:01:49.289 --> 00:01:49.299 align:start position:0%
I think it would be a good idea to draw
 

00:01:49.299 --> 00:01:51.569 align:start position:0%
I think it would be a good idea to draw
attention<00:01:49.420><c> to</c><00:01:49.840><c> this</c><00:01:50.259><c> so</c><00:01:50.710><c> I'll</c><00:01:50.890><c> make</c><00:01:51.130><c> it</c><00:01:51.280><c> bold</c>

00:01:51.569 --> 00:01:51.579 align:start position:0%
attention to this so I'll make it bold
 

00:01:51.579 --> 00:01:54.990 align:start position:0%
attention to this so I'll make it bold
and<00:01:52.049><c> underline</c><00:01:53.049><c> it</c><00:01:53.259><c> to</c><00:01:54.249><c> format</c><00:01:54.729><c> it</c><00:01:54.759><c> with</c><00:01:54.969><c> a</c>

00:01:54.990 --> 00:01:55.000 align:start position:0%
and underline it to format it with a
 

00:01:55.000 --> 00:01:57.270 align:start position:0%
and underline it to format it with a
simple<00:01:55.450><c> line</c><00:01:55.659><c> and</c><00:01:56.079><c> just</c><00:01:56.409><c> make</c><00:01:56.649><c> sure</c><00:01:56.679><c> the</c><00:01:57.009><c> cell</c>

00:01:57.270 --> 00:01:57.280 align:start position:0%
simple line and just make sure the cell
 

00:01:57.280 --> 00:01:59.699 align:start position:0%
simple line and just make sure the cell
is<00:01:57.399><c> selected</c><00:01:57.609><c> and</c><00:01:58.149><c> then</c><00:01:58.780><c> click</c><00:01:59.140><c> the</c><00:01:59.259><c> underline</c>

00:01:59.699 --> 00:01:59.709 align:start position:0%
is selected and then click the underline
 

00:01:59.709 --> 00:02:03.870 align:start position:0%
is selected and then click the underline
command<00:02:00.189><c> if</c><00:02:00.520><c> you</c><00:02:01.209><c> want</c><00:02:01.539><c> a</c><00:02:01.659><c> double</c><00:02:02.109><c> line</c><00:02:02.880><c> click</c>

00:02:03.870 --> 00:02:03.880 align:start position:0%
command if you want a double line click
 

00:02:03.880 --> 00:02:05.999 align:start position:0%
command if you want a double line click
the<00:02:04.149><c> down</c><00:02:04.359><c> arrow</c><00:02:04.780><c> and</c><00:02:04.929><c> select</c><00:02:05.350><c> the</c><00:02:05.619><c> double</c>

00:02:05.999 --> 00:02:06.009 align:start position:0%
the down arrow and select the double
 

00:02:06.009 --> 00:02:09.419 align:start position:0%
the down arrow and select the double
underline<00:02:06.369><c> option</c><00:02:07.440><c> you</c><00:02:08.440><c> can</c><00:02:08.619><c> also</c><00:02:08.860><c> change</c><00:02:09.220><c> the</c>

00:02:09.419 --> 00:02:09.429 align:start position:0%
underline option you can also change the
 

00:02:09.429 --> 00:02:13.410 align:start position:0%
underline option you can also change the
font<00:02:09.459><c> style</c><00:02:09.789><c> size</c><00:02:10.450><c> and</c><00:02:11.290><c> color</c><00:02:12.000><c> to</c><00:02:13.000><c> change</c><00:02:13.269><c> the</c>

00:02:13.410 --> 00:02:13.420 align:start position:0%
font style size and color to change the
 

00:02:13.420 --> 00:02:15.660 align:start position:0%
font style size and color to change the
font<00:02:13.629><c> style</c><00:02:13.840><c> select</c><00:02:14.830><c> the</c><00:02:14.950><c> cells</c><00:02:15.220><c> you</c><00:02:15.340><c> want</c><00:02:15.549><c> to</c>

00:02:15.660 --> 00:02:15.670 align:start position:0%
font style select the cells you want to
 

00:02:15.670 --> 00:02:16.589 align:start position:0%
font style select the cells you want to
modify

00:02:16.589 --> 00:02:16.599 align:start position:0%
modify
 

00:02:16.599 --> 00:02:19.830 align:start position:0%
modify
I'll<00:02:16.840><c> just</c><00:02:17.620><c> left-click</c><00:02:18.400><c> the</c><00:02:18.640><c> rose</c><00:02:18.970><c> 7</c><00:02:19.450><c> heading</c>

00:02:19.830 --> 00:02:19.840 align:start position:0%
I'll just left-click the rose 7 heading
 

00:02:19.840 --> 00:02:22.770 align:start position:0%
I'll just left-click the rose 7 heading
to<00:02:20.140><c> select</c><00:02:20.590><c> the</c><00:02:20.709><c> entire</c><00:02:21.069><c> row</c><00:02:21.459><c> and</c><00:02:21.790><c> then</c><00:02:22.450><c> left</c>

00:02:22.770 --> 00:02:22.780 align:start position:0%
to select the entire row and then left
 

00:02:22.780 --> 00:02:25.080 align:start position:0%
to select the entire row and then left
click<00:02:22.900><c> the</c><00:02:23.260><c> font</c><00:02:23.530><c> drop-down</c><00:02:23.950><c> box</c><00:02:24.519><c> on</c><00:02:24.790><c> the</c><00:02:24.879><c> Home</c>

00:02:25.080 --> 00:02:25.090 align:start position:0%
click the font drop-down box on the Home
 

00:02:25.090 --> 00:02:27.119 align:start position:0%
click the font drop-down box on the Home
tab<00:02:25.120><c> to</c><00:02:25.629><c> select</c><00:02:25.930><c> the</c><00:02:26.140><c> font</c><00:02:26.349><c> style</c><00:02:26.560><c> from</c><00:02:27.099><c> the</c>

00:02:27.119 --> 00:02:27.129 align:start position:0%
tab to select the font style from the
 

00:02:27.129 --> 00:02:30.300 align:start position:0%
tab to select the font style from the
list<00:02:27.250><c> as</c><00:02:27.879><c> you</c><00:02:28.750><c> move</c><00:02:29.230><c> over</c><00:02:29.620><c> the</c><00:02:29.739><c> font</c><00:02:30.010><c> list</c>

00:02:30.300 --> 00:02:30.310 align:start position:0%
list as you move over the font list
 

00:02:30.310 --> 00:02:32.550 align:start position:0%
list as you move over the font list
you'll<00:02:30.910><c> see</c><00:02:31.120><c> the</c><00:02:31.239><c> fonts</c><00:02:31.690><c> previewed</c><00:02:32.290><c> in</c><00:02:32.470><c> the</c>

00:02:32.550 --> 00:02:32.560 align:start position:0%
you'll see the fonts previewed in the
 

00:02:32.560 --> 00:02:35.069 align:start position:0%
you'll see the fonts previewed in the
spreadsheet<00:02:33.060><c> this</c><00:02:34.060><c> is</c><00:02:34.269><c> the</c><00:02:34.390><c> live</c><00:02:34.569><c> preview</c>

00:02:35.069 --> 00:02:35.079 align:start position:0%
spreadsheet this is the live preview
 

00:02:35.079 --> 00:02:36.660 align:start position:0%
spreadsheet this is the live preview
feature<00:02:35.349><c> at</c><00:02:35.680><c> work</c><00:02:35.950><c> for</c><00:02:36.250><c> you</c>

00:02:36.660 --> 00:02:36.670 align:start position:0%
feature at work for you
 

00:02:36.670 --> 00:02:41.099 align:start position:0%
feature at work for you
I<00:02:36.700><c> think</c><00:02:37.660><c> to</c><00:02:37.870><c> Helmer</c><00:02:38.230><c> will</c><00:02:38.379><c> look</c><00:02:38.560><c> good</c><00:02:38.790><c> and</c><00:02:40.109><c> I</c>

00:02:41.099 --> 00:02:41.109 align:start position:0%
I think to Helmer will look good and I
 

00:02:41.109 --> 00:02:43.140 align:start position:0%
I think to Helmer will look good and I
think<00:02:41.170><c> I'll</c><00:02:41.560><c> choose</c><00:02:41.799><c> a</c><00:02:41.829><c> different</c><00:02:42.340><c> font</c><00:02:42.819><c> style</c>

00:02:43.140 --> 00:02:43.150 align:start position:0%
think I'll choose a different font style
 

00:02:43.150 --> 00:02:46.240 align:start position:0%
think I'll choose a different font style
for<00:02:43.420><c> the</c><00:02:43.510><c> title</c>

00:02:46.240 --> 00:02:46.250 align:start position:0%
 
 

00:02:46.250 --> 00:02:49.270 align:start position:0%
 
it<00:02:46.690><c> looks</c><00:02:47.690><c> good</c><00:02:47.990><c> but</c><00:02:48.320><c> I</c><00:02:48.350><c> think</c><00:02:48.440><c> the</c><00:02:48.710><c> font</c><00:02:48.980><c> size</c>

00:02:49.270 --> 00:02:49.280 align:start position:0%
it looks good but I think the font size
 

00:02:49.280 --> 00:02:51.150 align:start position:0%
it looks good but I think the font size
needs<00:02:49.700><c> to</c><00:02:49.790><c> be</c><00:02:49.880><c> bigger</c>

00:02:51.150 --> 00:02:51.160 align:start position:0%
needs to be bigger
 

00:02:51.160 --> 00:02:54.190 align:start position:0%
needs to be bigger
just<00:02:52.160><c> select</c><00:02:52.550><c> the</c><00:02:52.670><c> drop-down</c><00:02:52.970><c> arrow</c><00:02:53.480><c> next</c><00:02:54.020><c> to</c>

00:02:54.190 --> 00:02:54.200 align:start position:0%
just select the drop-down arrow next to
 

00:02:54.200 --> 00:02:56.440 align:start position:0%
just select the drop-down arrow next to
the<00:02:54.290><c> font</c><00:02:54.410><c> size</c><00:02:54.710><c> box</c><00:02:55.280><c> and</c><00:02:55.610><c> choose</c><00:02:56.120><c> a</c><00:02:56.150><c> size</c>

00:02:56.440 --> 00:02:56.450 align:start position:0%
the font size box and choose a size
 

00:02:56.450 --> 00:03:00.150 align:start position:0%
the font size box and choose a size
option<00:02:56.990><c> yeah</c><00:02:57.710><c> this</c><00:02:57.950><c> size</c><00:02:58.220><c> looks</c><00:02:58.550><c> good</c>

00:03:00.150 --> 00:03:00.160 align:start position:0%
option yeah this size looks good
 

00:03:00.160 --> 00:03:02.860 align:start position:0%
option yeah this size looks good
while<00:03:01.160><c> we're</c><00:03:01.370><c> changing</c><00:03:01.790><c> things</c><00:03:01.970><c> let</c><00:03:02.540><c> me</c><00:03:02.690><c> show</c>

00:03:02.860 --> 00:03:02.870 align:start position:0%
while we're changing things let me show
 

00:03:02.870 --> 00:03:05.410 align:start position:0%
while we're changing things let me show
you<00:03:02.930><c> how</c><00:03:03.110><c> to</c><00:03:03.170><c> change</c><00:03:03.440><c> the</c><00:03:03.590><c> text</c><00:03:03.920><c> color</c><00:03:04.420><c> just</c>

00:03:05.410 --> 00:03:05.420 align:start position:0%
you how to change the text color just
 

00:03:05.420 --> 00:03:07.900 align:start position:0%
you how to change the text color just
select<00:03:05.840><c> the</c><00:03:05.930><c> text</c><00:03:06.170><c> and</c><00:03:06.590><c> then</c><00:03:07.100><c> click</c><00:03:07.160><c> the</c><00:03:07.610><c> down</c>

00:03:07.900 --> 00:03:07.910 align:start position:0%
select the text and then click the down
 

00:03:07.910 --> 00:03:10.980 align:start position:0%
select the text and then click the down
arrow<00:03:08.300><c> next</c><00:03:08.690><c> to</c><00:03:09.260><c> the</c><00:03:09.350><c> text</c><00:03:09.680><c> color</c><00:03:09.980><c> command</c><00:03:10.460><c> a</c>

00:03:10.980 --> 00:03:10.990 align:start position:0%
arrow next to the text color command a
 

00:03:10.990 --> 00:03:14.680 align:start position:0%
arrow next to the text color command a
color<00:03:11.990><c> palette</c><00:03:12.500><c> appears</c><00:03:12.980><c> I</c><00:03:13.280><c> can</c><00:03:14.270><c> select</c><00:03:14.540><c> the</c>

00:03:14.680 --> 00:03:14.690 align:start position:0%
color palette appears I can select the
 

00:03:14.690 --> 00:03:17.710 align:start position:0%
color palette appears I can select the
color<00:03:14.870><c> I</c><00:03:15.020><c> like</c><00:03:15.380><c> or</c><00:03:15.770><c> click</c><00:03:16.430><c> more</c><00:03:16.880><c> colors</c><00:03:17.420><c> to</c>

00:03:17.710 --> 00:03:17.720 align:start position:0%
color I like or click more colors to
 

00:03:17.720 --> 00:03:20.620 align:start position:0%
color I like or click more colors to
open<00:03:18.709><c> a</c><00:03:18.770><c> dialog</c><00:03:19.220><c> box</c><00:03:19.459><c> and</c><00:03:19.760><c> access</c><00:03:20.450><c> other</c>

00:03:20.620 --> 00:03:20.630 align:start position:0%
open a dialog box and access other
 

00:03:20.630 --> 00:03:24.040 align:start position:0%
open a dialog box and access other
colors<00:03:21.400><c> click</c><00:03:22.400><c> the</c><00:03:22.610><c> color</c><00:03:22.910><c> you</c><00:03:23.180><c> like</c><00:03:23.480><c> and</c><00:03:23.780><c> then</c>

00:03:24.040 --> 00:03:24.050 align:start position:0%
colors click the color you like and then
 

00:03:24.050 --> 00:03:25.170 align:start position:0%
colors click the color you like and then
click<00:03:24.290><c> OK</c>

00:03:25.170 --> 00:03:25.180 align:start position:0%
click OK
 

00:03:25.180 --> 00:03:28.570 align:start position:0%
click OK
there<00:03:26.180><c> that</c><00:03:26.570><c> looks</c><00:03:26.750><c> good</c><00:03:27.050><c> now</c><00:03:27.980><c> I'm</c><00:03:28.190><c> ready</c><00:03:28.400><c> to</c>

00:03:28.570 --> 00:03:28.580 align:start position:0%
there that looks good now I'm ready to
 

00:03:28.580 --> 00:03:30.640 align:start position:0%
there that looks good now I'm ready to
make<00:03:28.730><c> some</c><00:03:28.790><c> additional</c><00:03:29.330><c> formatting</c><00:03:30.170><c> changes</c>

00:03:30.640 --> 00:03:30.650 align:start position:0%
make some additional formatting changes
 

00:03:30.650 --> 00:03:32.800 align:start position:0%
make some additional formatting changes
that<00:03:31.160><c> will</c><00:03:31.280><c> make</c><00:03:31.459><c> the</c><00:03:31.610><c> worksheet</c><00:03:32.120><c> easier</c><00:03:32.540><c> to</c>

00:03:32.800 --> 00:03:32.810 align:start position:0%
that will make the worksheet easier to
 

00:03:32.810 --> 00:03:35.710 align:start position:0%
that will make the worksheet easier to
read<00:03:33.080><c> you</c><00:03:33.350><c> can</c><00:03:34.190><c> do</c><00:03:34.550><c> this</c><00:03:34.730><c> by</c><00:03:34.910><c> adding</c><00:03:35.120><c> borders</c>

00:03:35.710 --> 00:03:35.720 align:start position:0%
read you can do this by adding borders
 

00:03:35.720 --> 00:03:38.230 align:start position:0%
read you can do this by adding borders
and<00:03:36.020><c> fill</c><00:03:36.590><c> color</c><00:03:36.950><c> to</c><00:03:37.370><c> your</c><00:03:37.520><c> worksheet</c><00:03:38.030><c> in</c>

00:03:38.230 --> 00:03:38.240 align:start position:0%
and fill color to your worksheet in
 

00:03:38.240 --> 00:03:41.830 align:start position:0%
and fill color to your worksheet in
select<00:03:38.690><c> places</c><00:03:39.020><c> in</c><00:03:39.560><c> the</c><00:03:40.490><c> fonts</c><00:03:40.940><c> dialog</c><00:03:41.510><c> box</c>

00:03:41.830 --> 00:03:41.840 align:start position:0%
select places in the fonts dialog box
 

00:03:41.840 --> 00:03:44.410 align:start position:0%
select places in the fonts dialog box
you'll<00:03:42.350><c> find</c><00:03:42.410><c> the</c><00:03:42.800><c> fill</c><00:03:43.130><c> effects</c><00:03:43.640><c> command</c><00:03:44.150><c> and</c>

00:03:44.410 --> 00:03:44.420 align:start position:0%
you'll find the fill effects command and
 

00:03:44.420 --> 00:03:49.840 align:start position:0%
you'll find the fill effects command and
the<00:03:44.959><c> borders</c><00:03:45.380><c> command</c><00:03:45.880><c> side-by-side</c><00:03:48.850><c> let's</c>

00:03:49.840 --> 00:03:49.850 align:start position:0%
the borders command side-by-side let's
 

00:03:49.850 --> 00:03:51.640 align:start position:0%
the borders command side-by-side let's
go<00:03:50.060><c> ahead</c><00:03:50.209><c> and</c><00:03:50.480><c> select</c><00:03:50.600><c> the</c><00:03:50.870><c> cells</c><00:03:51.140><c> we</c><00:03:51.290><c> want</c><00:03:51.470><c> to</c>

00:03:51.640 --> 00:03:51.650 align:start position:0%
go ahead and select the cells we want to
 

00:03:51.650 --> 00:03:54.400 align:start position:0%
go ahead and select the cells we want to
add<00:03:51.800><c> a</c><00:03:51.830><c> border</c><00:03:52.190><c> to</c><00:03:52.519><c> so</c><00:03:53.480><c> I'll</c><00:03:53.630><c> just</c><00:03:53.900><c> select</c><00:03:54.290><c> the</c>

00:03:54.400 --> 00:03:54.410 align:start position:0%
add a border to so I'll just select the
 

00:03:54.410 --> 00:03:56.800 align:start position:0%
add a border to so I'll just select the
rose<00:03:54.650><c> and</c><00:03:55.070><c> then</c><00:03:55.430><c> click</c><00:03:55.790><c> the</c><00:03:55.940><c> arrow</c><00:03:56.120><c> next</c><00:03:56.630><c> to</c>

00:03:56.800 --> 00:03:56.810 align:start position:0%
rose and then click the arrow next to
 

00:03:56.810 --> 00:04:00.120 align:start position:0%
rose and then click the arrow next to
the<00:03:56.900><c> borders</c><00:03:57.170><c> command</c><00:03:57.530><c> on</c><00:03:58.010><c> the</c><00:03:58.250><c> Home</c><00:03:58.400><c> tab</c><00:03:58.459><c> and</c>

00:04:00.120 --> 00:04:00.130 align:start position:0%
the borders command on the Home tab and
 

00:04:00.130 --> 00:04:03.160 align:start position:0%
the borders command on the Home tab and
menu<00:04:01.130><c> appears</c><00:04:01.580><c> with</c><00:04:01.670><c> all</c><00:04:01.820><c> sorts</c><00:04:02.510><c> of</c><00:04:02.630><c> choices</c>

00:04:03.160 --> 00:04:03.170 align:start position:0%
menu appears with all sorts of choices
 

00:04:03.170 --> 00:04:05.710 align:start position:0%
menu appears with all sorts of choices
you<00:04:03.470><c> can</c><00:04:04.040><c> decide</c><00:04:04.370><c> whether</c><00:04:04.670><c> you</c><00:04:04.910><c> only</c><00:04:05.209><c> want</c><00:04:05.600><c> to</c>

00:04:05.710 --> 00:04:05.720 align:start position:0%
you can decide whether you only want to
 

00:04:05.720 --> 00:04:07.780 align:start position:0%
you can decide whether you only want to
border<00:04:06.019><c> on</c><00:04:06.140><c> the</c><00:04:06.260><c> top</c><00:04:06.290><c> or</c><00:04:06.860><c> border</c><00:04:07.550><c> on</c><00:04:07.670><c> the</c>

00:04:07.780 --> 00:04:07.790 align:start position:0%
border on the top or border on the
 

00:04:07.790 --> 00:04:11.350 align:start position:0%
border on the top or border on the
bottom<00:04:08.209><c> or</c><00:04:08.630><c> some</c><00:04:09.260><c> type</c><00:04:09.410><c> of</c><00:04:09.440><c> combination</c><00:04:10.360><c> just</c>

00:04:11.350 --> 00:04:11.360 align:start position:0%
bottom or some type of combination just
 

00:04:11.360 --> 00:04:13.509 align:start position:0%
bottom or some type of combination just
left-click<00:04:11.750><c> an</c><00:04:12.140><c> option</c><00:04:12.650><c> from</c><00:04:12.890><c> the</c><00:04:12.980><c> list</c><00:04:13.280><c> it</c>

00:04:13.509 --> 00:04:13.519 align:start position:0%
left-click an option from the list it
 

00:04:13.519 --> 00:04:15.550 align:start position:0%
left-click an option from the list it
selects<00:04:13.940><c> it</c><00:04:14.060><c> and</c><00:04:14.269><c> it</c><00:04:14.780><c> will</c><00:04:14.930><c> appear</c><00:04:15.290><c> in</c><00:04:15.470><c> the</c>

00:04:15.550 --> 00:04:15.560 align:start position:0%
selects it and it will appear in the
 

00:04:15.560 --> 00:04:22.320 align:start position:0%
selects it and it will appear in the
worksheet

00:04:22.320 --> 00:04:22.330 align:start position:0%
 
 

00:04:22.330 --> 00:04:24.940 align:start position:0%
 
adding<00:04:23.330><c> fill</c><00:04:23.570><c> color</c><00:04:23.900><c> to</c><00:04:24.140><c> cells</c><00:04:24.440><c> can</c><00:04:24.800><c> be</c><00:04:24.920><c> a</c>

00:04:24.940 --> 00:04:24.950 align:start position:0%
adding fill color to cells can be a
 

00:04:24.950 --> 00:04:27.520 align:start position:0%
adding fill color to cells can be a
great<00:04:25.370><c> way</c><00:04:25.610><c> to</c><00:04:25.640><c> format</c><00:04:26.180><c> a</c><00:04:26.210><c> worksheet</c><00:04:26.780><c> so</c><00:04:27.500><c> that</c>

00:04:27.520 --> 00:04:27.530 align:start position:0%
great way to format a worksheet so that
 

00:04:27.530 --> 00:04:30.550 align:start position:0%
great way to format a worksheet so that
it's<00:04:27.830><c> easy</c><00:04:28.100><c> to</c><00:04:28.220><c> read</c><00:04:28.600><c> you</c><00:04:29.600><c> may</c><00:04:29.810><c> have</c><00:04:29.990><c> seen</c><00:04:30.230><c> some</c>

00:04:30.550 --> 00:04:30.560 align:start position:0%
it's easy to read you may have seen some
 

00:04:30.560 --> 00:04:32.620 align:start position:0%
it's easy to read you may have seen some
long<00:04:30.830><c> business</c><00:04:31.220><c> reports</c><00:04:31.940><c> that</c><00:04:32.360><c> have</c>

00:04:32.620 --> 00:04:32.630 align:start position:0%
long business reports that have
 

00:04:32.630 --> 00:04:35.170 align:start position:0%
long business reports that have
alternating<00:04:33.290><c> colored</c><00:04:33.680><c> rows</c><00:04:34.010><c> or</c><00:04:34.400><c> columns</c><00:04:34.430><c> to</c>

00:04:35.170 --> 00:04:35.180 align:start position:0%
alternating colored rows or columns to
 

00:04:35.180 --> 00:04:37.990 align:start position:0%
alternating colored rows or columns to
make<00:04:35.210><c> it</c><00:04:35.510><c> easier</c><00:04:35.870><c> to</c><00:04:36.080><c> read</c><00:04:36.520><c> you</c><00:04:37.520><c> can</c><00:04:37.550><c> also</c>

00:04:37.990 --> 00:04:38.000 align:start position:0%
make it easier to read you can also
 

00:04:38.000 --> 00:04:39.760 align:start position:0%
make it easier to read you can also
change<00:04:38.420><c> the</c><00:04:38.630><c> fill</c><00:04:38.870><c> color</c><00:04:39.200><c> to</c><00:04:39.470><c> draw</c><00:04:39.650><c> attention</c>

00:04:39.760 --> 00:04:39.770 align:start position:0%
change the fill color to draw attention
 

00:04:39.770 --> 00:04:42.580 align:start position:0%
change the fill color to draw attention
to<00:04:40.250><c> a</c><00:04:40.370><c> specific</c><00:04:40.970><c> part</c><00:04:41.210><c> or</c><00:04:41.690><c> just</c><00:04:42.140><c> make</c><00:04:42.260><c> a</c><00:04:42.290><c> little</c>

00:04:42.580 --> 00:04:42.590 align:start position:0%
to a specific part or just make a little
 

00:04:42.590 --> 00:04:45.340 align:start position:0%
to a specific part or just make a little
nicer<00:04:42.890><c> overall</c><00:04:43.480><c> let's</c><00:04:44.480><c> change</c><00:04:44.870><c> the</c><00:04:45.110><c> fill</c>

00:04:45.340 --> 00:04:45.350 align:start position:0%
nicer overall let's change the fill
 

00:04:45.350 --> 00:04:49.060 align:start position:0%
nicer overall let's change the fill
color<00:04:45.380><c> of</c><00:04:46.010><c> the</c><00:04:46.100><c> title</c><00:04:46.370><c> cells</c><00:04:47.560><c> just</c><00:04:48.560><c> select</c><00:04:48.950><c> the</c>

00:04:49.060 --> 00:04:49.070 align:start position:0%
color of the title cells just select the
 

00:04:49.070 --> 00:04:54.000 align:start position:0%
color of the title cells just select the
cells<00:04:51.010><c> then</c><00:04:52.010><c> click</c><00:04:52.400><c> the</c><00:04:52.550><c> fill</c><00:04:52.790><c> command</c><00:04:53.240><c> a</c>

00:04:54.000 --> 00:04:54.010 align:start position:0%
cells then click the fill command a
 

00:04:54.010 --> 00:04:57.910 align:start position:0%
cells then click the fill command a
color<00:04:55.010><c> palette</c><00:04:55.550><c> appears</c><00:04:56.320><c> you</c><00:04:57.320><c> can</c><00:04:57.500><c> select</c><00:04:57.650><c> the</c>

00:04:57.910 --> 00:04:57.920 align:start position:0%
color palette appears you can select the
 

00:04:57.920 --> 00:05:00.130 align:start position:0%
color palette appears you can select the
color<00:04:58.190><c> you</c><00:04:58.250><c> like</c><00:04:58.400><c> or</c><00:04:58.940><c> choose</c><00:04:59.360><c> more</c><00:04:59.660><c> colors</c><00:05:00.110><c> to</c>

00:05:00.130 --> 00:05:00.140 align:start position:0%
color you like or choose more colors to
 

00:05:00.140 --> 00:05:03.730 align:start position:0%
color you like or choose more colors to
open<00:05:00.560><c> a</c><00:05:00.620><c> dialog</c><00:05:01.070><c> box</c><00:05:01.310><c> of</c><00:05:01.550><c> colors</c><00:05:02.590><c> here</c>

00:05:03.730 --> 00:05:03.740 align:start position:0%
open a dialog box of colors here
 

00:05:03.740 --> 00:05:07.660 align:start position:0%
open a dialog box of colors here
I<00:05:03.770><c> like</c><00:05:04.400><c> this</c><00:05:04.730><c> color</c><00:05:05.030><c> right</c><00:05:05.300><c> here</c><00:05:06.280><c> it</c><00:05:07.280><c> looks</c>

00:05:07.660 --> 00:05:07.670 align:start position:0%
I like this color right here it looks
 

00:05:07.670 --> 00:05:09.250 align:start position:0%
I like this color right here it looks
pretty<00:05:07.910><c> good</c><00:05:08.120><c> but</c><00:05:08.180><c> I</c><00:05:08.420><c> think</c><00:05:08.480><c> I</c><00:05:08.780><c> need</c><00:05:08.870><c> to</c><00:05:09.080><c> change</c>

00:05:09.250 --> 00:05:09.260 align:start position:0%
pretty good but I think I need to change
 

00:05:09.260 --> 00:05:12.100 align:start position:0%
pretty good but I think I need to change
my<00:05:09.500><c> text</c><00:05:09.830><c> color</c><00:05:10.280><c> to</c><00:05:10.580><c> white</c><00:05:10.820><c> if</c><00:05:11.120><c> the</c><00:05:11.570><c> fill</c><00:05:11.840><c> color</c>

00:05:12.100 --> 00:05:12.110 align:start position:0%
my text color to white if the fill color
 

00:05:12.110 --> 00:05:15.210 align:start position:0%
my text color to white if the fill color
is<00:05:12.230><c> dark</c><00:05:12.620><c> like</c><00:05:12.860><c> this</c>

00:05:15.210 --> 00:05:15.220 align:start position:0%
 
 

00:05:15.220 --> 00:05:19.680 align:start position:0%
 
I<00:05:16.980><c> can</c><00:05:17.980><c> use</c><00:05:18.190><c> a</c><00:05:18.220><c> fill</c><00:05:18.580><c> color</c><00:05:18.820><c> in</c><00:05:19.090><c> the</c><00:05:19.180><c> same</c><00:05:19.450><c> way</c>

00:05:19.680 --> 00:05:19.690 align:start position:0%
I can use a fill color in the same way
 

00:05:19.690 --> 00:05:21.960 align:start position:0%
I can use a fill color in the same way
to<00:05:19.750><c> format</c><00:05:20.320><c> my</c><00:05:20.350><c> columns</c><00:05:20.950><c> to</c><00:05:21.250><c> make</c><00:05:21.460><c> them</c><00:05:21.610><c> easier</c>

00:05:21.960 --> 00:05:21.970 align:start position:0%
to format my columns to make them easier
 

00:05:21.970 --> 00:05:25.860 align:start position:0%
to format my columns to make them easier
to<00:05:22.030><c> read</c><00:05:23.430><c> you</c><00:05:24.430><c> may</c><00:05:24.640><c> have</c><00:05:24.790><c> noticed</c><00:05:25.330><c> that</c><00:05:25.450><c> I</c><00:05:25.540><c> have</c>

00:05:25.860 --> 00:05:25.870 align:start position:0%
to read you may have noticed that I have
 

00:05:25.870 --> 00:05:28.470 align:start position:0%
to read you may have noticed that I have
my<00:05:26.050><c> bill</c><00:05:26.380><c> amounts</c><00:05:26.950><c> listed</c><00:05:27.220><c> each</c><00:05:27.610><c> month</c><00:05:27.970><c> but</c>

00:05:28.470 --> 00:05:28.480 align:start position:0%
my bill amounts listed each month but
 

00:05:28.480 --> 00:05:30.330 align:start position:0%
my bill amounts listed each month but
there<00:05:28.660><c> isn't</c><00:05:28.810><c> a</c><00:05:29.020><c> dollar</c><00:05:29.260><c> sign</c><00:05:29.620><c> in</c><00:05:29.680><c> front</c><00:05:30.220><c> of</c>

00:05:30.330 --> 00:05:30.340 align:start position:0%
there isn't a dollar sign in front of
 

00:05:30.340 --> 00:05:32.850 align:start position:0%
there isn't a dollar sign in front of
each<00:05:30.490><c> amount</c><00:05:30.990><c> Excel</c><00:05:31.990><c> gives</c><00:05:32.290><c> you</c><00:05:32.410><c> the</c><00:05:32.560><c> ability</c>

00:05:32.850 --> 00:05:32.860 align:start position:0%
each amount Excel gives you the ability
 

00:05:32.860 --> 00:05:36.480 align:start position:0%
each amount Excel gives you the ability
to<00:05:33.160><c> change</c><00:05:33.580><c> the</c><00:05:33.820><c> number</c><00:05:34.180><c> formats</c><00:05:34.860><c> by</c><00:05:35.860><c> default</c>

00:05:36.480 --> 00:05:36.490 align:start position:0%
to change the number formats by default
 

00:05:36.490 --> 00:05:38.430 align:start position:0%
to change the number formats by default
the<00:05:36.790><c> numbers</c><00:05:37.240><c> appear</c><00:05:37.720><c> in</c><00:05:37.750><c> the</c><00:05:38.020><c> general</c>

00:05:38.430 --> 00:05:38.440 align:start position:0%
the numbers appear in the general
 

00:05:38.440 --> 00:05:40.980 align:start position:0%
the numbers appear in the general
category<00:05:38.730><c> which</c><00:05:39.730><c> means</c><00:05:40.060><c> there</c><00:05:40.270><c> is</c><00:05:40.360><c> no</c><00:05:40.570><c> special</c>

00:05:40.980 --> 00:05:40.990 align:start position:0%
category which means there is no special
 

00:05:40.990 --> 00:05:43.620 align:start position:0%
category which means there is no special
formatting<00:05:41.710><c> if</c><00:05:42.070><c> I</c><00:05:42.880><c> want</c><00:05:43.150><c> to</c><00:05:43.270><c> change</c><00:05:43.510><c> the</c>

00:05:43.620 --> 00:05:43.630 align:start position:0%
formatting if I want to change the
 

00:05:43.630 --> 00:05:45.630 align:start position:0%
formatting if I want to change the
number<00:05:43.810><c> formatting</c><00:05:44.470><c> I</c><00:05:44.740><c> just</c><00:05:45.100><c> need</c><00:05:45.340><c> to</c><00:05:45.490><c> select</c>

00:05:45.630 --> 00:05:45.640 align:start position:0%
number formatting I just need to select
 

00:05:45.640 --> 00:05:48.660 align:start position:0%
number formatting I just need to select
the<00:05:46.030><c> cells</c><00:05:46.300><c> and</c><00:05:46.890><c> then</c><00:05:47.890><c> click</c><00:05:48.280><c> the</c><00:05:48.430><c> drop</c><00:05:48.640><c> down</c>

00:05:48.660 --> 00:05:48.670 align:start position:0%
the cells and then click the drop down
 

00:05:48.670 --> 00:05:52.380 align:start position:0%
the cells and then click the drop down
arrow<00:05:49.210><c> in</c><00:05:49.570><c> the</c><00:05:49.690><c> number</c><00:05:50.050><c> format</c><00:05:50.560><c> box</c><00:05:51.030><c> from</c><00:05:52.030><c> here</c>

00:05:52.380 --> 00:05:52.390 align:start position:0%
arrow in the number format box from here
 

00:05:52.390 --> 00:05:53.790 align:start position:0%
arrow in the number format box from here
you<00:05:52.570><c> can</c><00:05:52.720><c> see</c><00:05:52.900><c> that</c><00:05:53.020><c> there</c><00:05:53.170><c> are</c><00:05:53.200><c> many</c><00:05:53.470><c> ways</c><00:05:53.740><c> you</c>

00:05:53.790 --> 00:05:53.800 align:start position:0%
you can see that there are many ways you
 

00:05:53.800 --> 00:05:55.760 align:start position:0%
you can see that there are many ways you
can<00:05:54.070><c> format</c><00:05:54.550><c> numbers</c><00:05:55.000><c> in</c><00:05:55.180><c> your</c><00:05:55.330><c> worksheet</c>

00:05:55.760 --> 00:05:55.770 align:start position:0%
can format numbers in your worksheet
 

00:05:55.770 --> 00:05:58.710 align:start position:0%
can format numbers in your worksheet
since<00:05:56.770><c> I'm</c><00:05:56.950><c> dealing</c><00:05:57.160><c> with</c><00:05:57.400><c> monetary</c><00:05:58.090><c> amounts</c>

00:05:58.710 --> 00:05:58.720 align:start position:0%
since I'm dealing with monetary amounts
 

00:05:58.720 --> 00:06:00.900 align:start position:0%
since I'm dealing with monetary amounts
I<00:05:58.780><c> think</c><00:05:59.050><c> currency</c><00:05:59.710><c> or</c><00:05:59.890><c> accounting</c><00:06:00.520><c> will</c><00:06:00.760><c> work</c>

00:06:00.900 --> 00:06:00.910 align:start position:0%
I think currency or accounting will work
 

00:06:00.910 --> 00:06:04.200 align:start position:0%
I think currency or accounting will work
best<00:06:01.210><c> to</c><00:06:02.200><c> select</c><00:06:02.410><c> one</c><00:06:02.920><c> just</c><00:06:03.460><c> left-click</c><00:06:03.790><c> it</c>

00:06:04.200 --> 00:06:04.210 align:start position:0%
best to select one just left-click it
 

00:06:04.210 --> 00:06:07.410 align:start position:0%
best to select one just left-click it
and<00:06:04.500><c> there</c><00:06:05.500><c> you</c><00:06:05.650><c> go</c><00:06:05.860><c> now</c><00:06:06.520><c> the</c><00:06:06.580><c> amounts</c><00:06:07.060><c> appear</c>

00:06:07.410 --> 00:06:07.420 align:start position:0%
and there you go now the amounts appear
 

00:06:07.420 --> 00:06:09.900 align:start position:0%
and there you go now the amounts appear
in<00:06:07.570><c> the</c><00:06:07.660><c> currency</c><00:06:07.990><c> formats</c><00:06:08.650><c> in</c><00:06:08.920><c> the</c><00:06:09.430><c> number</c>

00:06:09.900 --> 00:06:09.910 align:start position:0%
in the currency formats in the number
 

00:06:09.910 --> 00:06:12.360 align:start position:0%
in the currency formats in the number
group<00:06:10.240><c> you</c><00:06:10.540><c> have</c><00:06:10.780><c> some</c><00:06:10.990><c> other</c><00:06:11.170><c> options</c><00:06:11.680><c> for</c>

00:06:12.360 --> 00:06:12.370 align:start position:0%
group you have some other options for
 

00:06:12.370 --> 00:06:14.580 align:start position:0%
group you have some other options for
example<00:06:12.700><c> you</c><00:06:13.330><c> can</c><00:06:13.510><c> change</c><00:06:13.750><c> the</c><00:06:13.900><c> US</c><00:06:14.290><c> dollar</c>

00:06:14.580 --> 00:06:14.590 align:start position:0%
example you can change the US dollar
 

00:06:14.590 --> 00:06:18.120 align:start position:0%
example you can change the US dollar
sign<00:06:14.920><c> to</c><00:06:15.160><c> another</c><00:06:15.430><c> currency</c><00:06:15.730><c> format</c><00:06:16.980><c> you</c><00:06:17.980><c> can</c>

00:06:18.120 --> 00:06:18.130 align:start position:0%
sign to another currency format you can
 

00:06:18.130 --> 00:06:21.750 align:start position:0%
sign to another currency format you can
change<00:06:18.370><c> the</c><00:06:18.490><c> numbers</c><00:06:18.910><c> to</c><00:06:18.940><c> percents</c><00:06:19.810><c> and</c><00:06:20.760><c> add</c>

00:06:21.750 --> 00:06:21.760 align:start position:0%
change the numbers to percents and add
 

00:06:21.760 --> 00:06:24.960 align:start position:0%
change the numbers to percents and add
commas<00:06:22.510><c> you</c><00:06:22.840><c> can</c><00:06:23.680><c> even</c><00:06:24.040><c> change</c><00:06:24.460><c> how</c><00:06:24.790><c> many</c>

00:06:24.960 --> 00:06:24.970 align:start position:0%
commas you can even change how many
 

00:06:24.970 --> 00:06:27.420 align:start position:0%
commas you can even change how many
places<00:06:25.360><c> appear</c><00:06:25.930><c> after</c><00:06:26.380><c> the</c><00:06:26.500><c> decimal</c><00:06:26.710><c> by</c>

00:06:27.420 --> 00:06:27.430 align:start position:0%
places appear after the decimal by
 

00:06:27.430 --> 00:06:28.980 align:start position:0%
places appear after the decimal by
clicking<00:06:27.880><c> the</c><00:06:28.000><c> increase</c><00:06:28.510><c> or</c><00:06:28.720><c> decrease</c>

00:06:28.980 --> 00:06:28.990 align:start position:0%
clicking the increase or decrease
 

00:06:28.990 --> 00:06:32.400 align:start position:0%
clicking the increase or decrease
decimal<00:06:29.919><c> commands</c><00:06:30.490><c> now</c><00:06:31.150><c> before</c><00:06:31.600><c> we</c><00:06:31.720><c> wrap</c><00:06:31.930><c> up</c><00:06:31.960><c> I</c>

00:06:32.400 --> 00:06:32.410 align:start position:0%
decimal commands now before we wrap up I
 

00:06:32.410 --> 00:06:34.530 align:start position:0%
decimal commands now before we wrap up I
want<00:06:32.710><c> to</c><00:06:32.860><c> add</c><00:06:33.010><c> my</c><00:06:33.220><c> due</c><00:06:33.280><c> dates</c><00:06:33.700><c> in</c><00:06:33.910><c> this</c><00:06:34.090><c> second</c>

00:06:34.530 --> 00:06:34.540 align:start position:0%
want to add my due dates in this second
 

00:06:34.540 --> 00:06:39.860 align:start position:0%
want to add my due dates in this second
column

00:06:39.860 --> 00:06:39.870 align:start position:0%
 
 

00:06:39.870 --> 00:06:42.390 align:start position:0%
 
hmm<00:06:40.870><c> I</c><00:06:41.050><c> really</c><00:06:41.680><c> don't</c><00:06:41.830><c> like</c><00:06:41.949><c> the</c><00:06:42.100><c> way</c><00:06:42.190><c> this</c><00:06:42.340><c> is</c>

00:06:42.390 --> 00:06:42.400 align:start position:0%
hmm I really don't like the way this is
 

00:06:42.400 --> 00:06:45.059 align:start position:0%
hmm I really don't like the way this is
formatted<00:06:43.120><c> to</c><00:06:43.630><c> change</c><00:06:43.900><c> the</c><00:06:44.050><c> formatting</c><00:06:44.530><c> all</c>

00:06:45.059 --> 00:06:45.069 align:start position:0%
formatted to change the formatting all
 

00:06:45.069 --> 00:06:47.129 align:start position:0%
formatted to change the formatting all
you<00:06:45.340><c> have</c><00:06:45.490><c> to</c><00:06:45.610><c> do</c><00:06:45.789><c> is</c><00:06:46.030><c> go</c><00:06:46.270><c> back</c><00:06:46.300><c> to</c><00:06:46.660><c> the</c><00:06:46.780><c> number</c>

00:06:47.129 --> 00:06:47.139 align:start position:0%
you have to do is go back to the number
 

00:06:47.139 --> 00:06:50.390 align:start position:0%
you have to do is go back to the number
group<00:06:47.410><c> and</c><00:06:47.710><c> click</c><00:06:48.220><c> on</c><00:06:48.460><c> the</c><00:06:48.729><c> drop</c><00:06:48.849><c> down</c><00:06:48.940><c> arrow</c>

00:06:50.390 --> 00:06:50.400 align:start position:0%
group and click on the drop down arrow
 

00:06:50.400 --> 00:06:53.339 align:start position:0%
group and click on the drop down arrow
from<00:06:51.400><c> here</c><00:06:51.849><c> I</c><00:06:51.970><c> can</c><00:06:52.240><c> choose</c><00:06:52.479><c> how</c><00:06:52.780><c> I</c><00:06:52.810><c> want</c><00:06:53.020><c> my</c>

00:06:53.339 --> 00:06:53.349 align:start position:0%
from here I can choose how I want my
 

00:06:53.349 --> 00:06:55.589 align:start position:0%
from here I can choose how I want my
date<00:06:53.590><c> to</c><00:06:53.740><c> be</c><00:06:53.860><c> displayed</c><00:06:54.310><c> so</c><00:06:54.669><c> I</c><00:06:55.120><c> want</c><00:06:55.300><c> it</c><00:06:55.389><c> to</c><00:06:55.479><c> be</c>

00:06:55.589 --> 00:06:55.599 align:start position:0%
date to be displayed so I want it to be
 

00:06:55.599 --> 00:06:58.499 align:start position:0%
date to be displayed so I want it to be
displayed<00:06:55.720><c> in</c><00:06:56.500><c> the</c><00:06:57.280><c> short</c><00:06:57.580><c> date</c><00:06:57.789><c> format</c><00:06:58.240><c> or</c>

00:06:58.499 --> 00:06:58.509 align:start position:0%
displayed in the short date format or
 

00:06:58.509 --> 00:07:00.480 align:start position:0%
displayed in the short date format or
the<00:06:58.599><c> long</c><00:06:58.780><c> date</c><00:06:58.990><c> format</c><00:06:59.440><c> I</c><00:06:59.740><c> think</c><00:07:00.310><c> I'm</c><00:07:00.400><c> going</c>

00:07:00.480 --> 00:07:00.490 align:start position:0%
the long date format I think I'm going
 

00:07:00.490 --> 00:07:03.330 align:start position:0%
the long date format I think I'm going
to<00:07:00.550><c> choose</c><00:07:00.789><c> a</c><00:07:00.819><c> short</c><00:07:01.180><c> date</c><00:07:01.419><c> format</c><00:07:01.919><c> to</c><00:07:02.919><c> avoid</c>

00:07:03.330 --> 00:07:03.340 align:start position:0%
to choose a short date format to avoid
 

00:07:03.340 --> 00:07:05.490 align:start position:0%
to choose a short date format to avoid
having<00:07:03.639><c> to</c><00:07:03.910><c> do</c><00:07:04.060><c> this</c><00:07:04.210><c> for</c><00:07:04.509><c> each</c><00:07:04.750><c> and</c><00:07:05.080><c> every</c>

00:07:05.490 --> 00:07:05.500 align:start position:0%
having to do this for each and every
 

00:07:05.500 --> 00:07:08.010 align:start position:0%
having to do this for each and every
cell<00:07:05.830><c> in</c><00:07:06.069><c> this</c><00:07:06.160><c> column</c><00:07:06.460><c> all</c><00:07:07.150><c> I</c><00:07:07.210><c> have</c><00:07:07.569><c> to</c><00:07:07.690><c> do</c><00:07:07.840><c> is</c>

00:07:08.010 --> 00:07:08.020 align:start position:0%
cell in this column all I have to do is
 

00:07:08.020 --> 00:07:09.809 align:start position:0%
cell in this column all I have to do is
select<00:07:08.199><c> the</c><00:07:08.470><c> remaining</c><00:07:08.770><c> cells</c><00:07:09.220><c> where</c><00:07:09.550><c> I</c><00:07:09.580><c> would</c>

00:07:09.809 --> 00:07:09.819 align:start position:0%
select the remaining cells where I would
 

00:07:09.819 --> 00:07:12.990 align:start position:0%
select the remaining cells where I would
like<00:07:09.970><c> to</c><00:07:10.120><c> enter</c><00:07:10.389><c> my</c><00:07:10.539><c> dates</c><00:07:10.919><c> now</c><00:07:11.919><c> I</c><00:07:12.310><c> have</c><00:07:12.729><c> to</c><00:07:12.880><c> go</c>

00:07:12.990 --> 00:07:13.000 align:start position:0%
like to enter my dates now I have to go
 

00:07:13.000 --> 00:07:14.850 align:start position:0%
like to enter my dates now I have to go
back<00:07:13.270><c> to</c><00:07:13.479><c> the</c><00:07:13.599><c> number</c><00:07:13.750><c> group</c><00:07:14.169><c> click</c><00:07:14.680><c> on</c><00:07:14.740><c> the</c>

00:07:14.850 --> 00:07:14.860 align:start position:0%
back to the number group click on the
 

00:07:14.860 --> 00:07:18.029 align:start position:0%
back to the number group click on the
drop<00:07:15.190><c> down</c><00:07:15.220><c> arrow</c><00:07:15.849><c> and</c><00:07:16.180><c> click</c><00:07:16.270><c> on</c><00:07:17.169><c> short</c><00:07:17.740><c> date</c>

00:07:18.029 --> 00:07:18.039 align:start position:0%
drop down arrow and click on short date
 

00:07:18.039 --> 00:07:20.550 align:start position:0%
drop down arrow and click on short date
again<00:07:18.460><c> this</c><00:07:19.360><c> means</c><00:07:19.720><c> that</c><00:07:19.870><c> no</c><00:07:20.080><c> matter</c><00:07:20.229><c> what</c>

00:07:20.550 --> 00:07:20.560 align:start position:0%
again this means that no matter what
 

00:07:20.560 --> 00:07:23.249 align:start position:0%
again this means that no matter what
format<00:07:21.130><c> I</c><00:07:21.370><c> try</c><00:07:21.759><c> to</c><00:07:21.820><c> enter</c><00:07:22.150><c> my</c><00:07:22.419><c> date</c><00:07:22.690><c> the</c><00:07:23.229><c> only</c>

00:07:23.249 --> 00:07:23.259 align:start position:0%
format I try to enter my date the only
 

00:07:23.259 --> 00:07:25.529 align:start position:0%
format I try to enter my date the only
format<00:07:23.979><c> that</c><00:07:24.160><c> will</c><00:07:24.250><c> be</c><00:07:24.400><c> applied</c><00:07:24.729><c> is</c><00:07:25.120><c> a</c><00:07:25.150><c> short</c>

00:07:25.529 --> 00:07:25.539 align:start position:0%
format that will be applied is a short
 

00:07:25.539 --> 00:07:31.189 align:start position:0%
format that will be applied is a short
date<00:07:25.810><c> format</c><00:07:26.320><c> here</c><00:07:27.250><c> I'll</c><00:07:27.460><c> show</c><00:07:27.789><c> you</c>

00:07:31.189 --> 00:07:31.199 align:start position:0%
 
 

00:07:31.199 --> 00:07:33.499 align:start position:0%
 
now<00:07:31.740><c> I'll</c><00:07:31.979><c> click</c><00:07:32.189><c> outside</c><00:07:32.669><c> of</c><00:07:32.789><c> the</c><00:07:32.879><c> cell</c><00:07:33.150><c> for</c>

00:07:33.499 --> 00:07:33.509 align:start position:0%
now I'll click outside of the cell for
 

00:07:33.509 --> 00:07:36.619 align:start position:0%
now I'll click outside of the cell for
the<00:07:33.569><c> changes</c><00:07:33.930><c> to</c><00:07:34.050><c> apply</c><00:07:34.349><c> see</c><00:07:35.219><c> this</c><00:07:36.060><c> helps</c><00:07:36.479><c> with</c>

00:07:36.619 --> 00:07:36.629 align:start position:0%
the changes to apply see this helps with
 

00:07:36.629 --> 00:07:38.869 align:start position:0%
the changes to apply see this helps with
consistency<00:07:37.310><c> now</c><00:07:38.310><c> things</c><00:07:38.639><c> are</c><00:07:38.849><c> looking</c>

00:07:38.869 --> 00:07:38.879 align:start position:0%
consistency now things are looking
 

00:07:38.879 --> 00:07:42.050 align:start position:0%
consistency now things are looking
pretty<00:07:39.449><c> good</c><00:07:39.779><c> but</c><00:07:40.169><c> I'd</c><00:07:41.039><c> like</c><00:07:41.310><c> to</c><00:07:41.550><c> Center</c><00:07:41.909><c> my</c>

00:07:42.050 --> 00:07:42.060 align:start position:0%
pretty good but I'd like to Center my
 

00:07:42.060 --> 00:07:46.070 align:start position:0%
pretty good but I'd like to Center my
title<00:07:42.569><c> over</c><00:07:43.050><c> my</c><00:07:43.199><c> entire</c><00:07:43.379><c> budget</c><00:07:44.270><c> to</c><00:07:45.270><c> do</c><00:07:45.479><c> this</c><00:07:45.779><c> I</c>

00:07:46.070 --> 00:07:46.080 align:start position:0%
title over my entire budget to do this I
 

00:07:46.080 --> 00:07:50.179 align:start position:0%
title over my entire budget to do this I
need<00:07:46.199><c> to</c><00:07:46.590><c> left</c><00:07:47.039><c> click</c><00:07:47.189><c> cell</c><00:07:48.090><c> a1</c><00:07:48.749><c> and</c><00:07:49.080><c> drag</c><00:07:50.009><c> it</c>

00:07:50.179 --> 00:07:50.189 align:start position:0%
need to left click cell a1 and drag it
 

00:07:50.189 --> 00:07:53.089 align:start position:0%
need to left click cell a1 and drag it
to<00:07:50.219><c> my</c><00:07:50.490><c> right</c><00:07:50.879><c> to</c><00:07:51.419><c> select</c><00:07:51.779><c> all</c><00:07:51.990><c> the</c><00:07:52.289><c> cells</c><00:07:52.529><c> over</c>

00:07:53.089 --> 00:07:53.099 align:start position:0%
to my right to select all the cells over
 

00:07:53.099 --> 00:07:59.089 align:start position:0%
to my right to select all the cells over
to<00:07:53.460><c> and</c><00:07:54.139><c> including</c><00:07:55.139><c> oh</c><00:07:55.439><c> one</c><00:07:56.689><c> now</c><00:07:57.689><c> on</c><00:07:58.080><c> the</c><00:07:58.860><c> Home</c>

00:07:59.089 --> 00:07:59.099 align:start position:0%
to and including oh one now on the Home
 

00:07:59.099 --> 00:08:02.749 align:start position:0%
to and including oh one now on the Home
tab<00:07:59.129><c> in</c><00:07:59.939><c> the</c><00:08:00.509><c> alignment</c><00:08:00.870><c> group</c><00:08:01.139><c> I</c><00:08:01.710><c> just</c><00:08:02.279><c> need</c>

00:08:02.749 --> 00:08:02.759 align:start position:0%
tab in the alignment group I just need
 

00:08:02.759 --> 00:08:06.399 align:start position:0%
tab in the alignment group I just need
to<00:08:02.939><c> click</c><00:08:03.150><c> the</c><00:08:03.330><c> merge</c><00:08:03.629><c> &amp;</c><00:08:03.990><c> Center</c><00:08:04.439><c> command</c><00:08:04.469><c> and</c>

00:08:06.399 --> 00:08:06.409 align:start position:0%
to click the merge &amp; Center command and
 

00:08:06.409 --> 00:08:09.290 align:start position:0%
to click the merge &amp; Center command and
the<00:08:07.409><c> title</c><00:08:07.860><c> is</c><00:08:07.949><c> now</c><00:08:08.009><c> centered</c><00:08:08.819><c> over</c><00:08:09.029><c> the</c>

00:08:09.290 --> 00:08:09.300 align:start position:0%
the title is now centered over the
 

00:08:09.300 --> 00:08:12.110 align:start position:0%
the title is now centered over the
selected<00:08:09.870><c> cells</c><00:08:10.189><c> you'll</c><00:08:11.189><c> also</c><00:08:11.430><c> notice</c><00:08:11.969><c> that</c>

00:08:12.110 --> 00:08:12.120 align:start position:0%
selected cells you'll also notice that
 

00:08:12.120 --> 00:08:14.629 align:start position:0%
selected cells you'll also notice that
the<00:08:12.360><c> separate</c><00:08:12.779><c> column</c><00:08:13.169><c> lines</c><00:08:13.439><c> no</c><00:08:14.129><c> longer</c>

00:08:14.629 --> 00:08:14.639 align:start position:0%
the separate column lines no longer
 

00:08:14.639 --> 00:08:17.149 align:start position:0%
the separate column lines no longer
appear<00:08:15.180><c> well</c><00:08:15.870><c> that's</c><00:08:16.050><c> because</c><00:08:16.319><c> the</c><00:08:16.650><c> selected</c>

00:08:17.149 --> 00:08:17.159 align:start position:0%
appear well that's because the selected
 

00:08:17.159 --> 00:08:20.559 align:start position:0%
appear well that's because the selected
cells<00:08:17.460><c> were</c><00:08:18.089><c> merged</c><00:08:18.449><c> into</c><00:08:18.719><c> one</c><00:08:18.870><c> cell</c>

00:08:20.559 --> 00:08:20.569 align:start position:0%
cells were merged into one cell
 

00:08:20.569 --> 00:08:23.600 align:start position:0%
cells were merged into one cell
formatting<00:08:21.569><c> rows</c><00:08:21.930><c> columns</c><00:08:22.710><c> and</c><00:08:22.830><c> text</c><00:08:23.490><c> and</c>

00:08:23.600 --> 00:08:23.610 align:start position:0%
formatting rows columns and text and
 

00:08:23.610 --> 00:08:25.939 align:start position:0%
formatting rows columns and text and
Excel<00:08:23.999><c> makes</c><00:08:24.719><c> data</c><00:08:25.050><c> look</c><00:08:25.349><c> a</c><00:08:25.499><c> little</c><00:08:25.710><c> more</c>

00:08:25.939 --> 00:08:25.949 align:start position:0%
Excel makes data look a little more
 

00:08:25.949 --> 00:08:28.010 align:start position:0%
Excel makes data look a little more
interesting<00:08:26.669><c> go</c><00:08:27.360><c> ahead</c><00:08:27.659><c> and</c><00:08:27.810><c> start</c>

00:08:28.010 --> 00:08:28.020 align:start position:0%
interesting go ahead and start
 

00:08:28.020 --> 00:08:29.749 align:start position:0%
interesting go ahead and start
formatting<00:08:28.620><c> your</c><00:08:28.889><c> worksheet</c><00:08:29.460><c> for</c><00:08:29.699><c> a</c>

00:08:29.749 --> 00:08:29.759 align:start position:0%
formatting your worksheet for a
 

00:08:29.759 --> 00:08:33.560 align:start position:0%
formatting your worksheet for a
customized<00:08:30.389><c> and</c><00:08:30.749><c> appealing</c><00:08:31.259><c> look</c>