WEBVTT
Kind: captions
Language: en

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

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

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

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

00:00:10.570 --> 00:00:13.650 align:start position:0%
 
in<00:00:10.770><c> Excel</c><00:00:11.770><c> 2013</c><00:00:12.130><c> the</c><00:00:12.910><c> look</c><00:00:13.120><c> and</c><00:00:13.300><c> feel</c><00:00:13.480><c> of</c><00:00:13.510><c> your</c>

00:00:13.650 --> 00:00:13.660 align:start position:0%
in Excel 2013 the look and feel of your
 

00:00:13.660 --> 00:00:15.150 align:start position:0%
in Excel 2013 the look and feel of your
worksheet<00:00:14.139><c> has</c><00:00:14.410><c> a</c><00:00:14.440><c> lot</c><00:00:14.650><c> to</c><00:00:14.799><c> do</c><00:00:14.920><c> with</c><00:00:15.040><c> the</c>

00:00:15.150 --> 00:00:15.160 align:start position:0%
worksheet has a lot to do with the
 

00:00:15.160 --> 00:00:17.460 align:start position:0%
worksheet has a lot to do with the
formatting<00:00:15.490><c> choices</c><00:00:16.000><c> you</c><00:00:16.119><c> make</c><00:00:16.299><c> if</c><00:00:16.540><c> we</c><00:00:17.290><c> added</c>

00:00:17.460 --> 00:00:17.470 align:start position:0%
formatting choices you make if we added
 

00:00:17.470 --> 00:00:19.170 align:start position:0%
formatting choices you make if we added
some<00:00:17.800><c> formatting</c><00:00:18.189><c> to</c><00:00:18.400><c> this</c><00:00:18.520><c> Fitness</c><00:00:18.880><c> chart</c>

00:00:19.170 --> 00:00:19.180 align:start position:0%
some formatting to this Fitness chart
 

00:00:19.180 --> 00:00:20.999 align:start position:0%
some formatting to this Fitness chart
for<00:00:19.360><c> example</c><00:00:19.779><c> we</c><00:00:20.110><c> can</c><00:00:20.259><c> make</c><00:00:20.290><c> it</c><00:00:20.529><c> easier</c><00:00:20.890><c> to</c>

00:00:20.999 --> 00:00:21.009 align:start position:0%
for example we can make it easier to
 

00:00:21.009 --> 00:00:23.760 align:start position:0%
for example we can make it easier to
read<00:00:21.220><c> and</c><00:00:21.460><c> more</c><00:00:21.849><c> visually</c><00:00:22.300><c> appealing</c><00:00:22.770><c> I'd</c>

00:00:23.760 --> 00:00:23.770 align:start position:0%
read and more visually appealing I'd
 

00:00:23.770 --> 00:00:25.410 align:start position:0%
read and more visually appealing I'd
like<00:00:23.980><c> to</c><00:00:24.130><c> start</c><00:00:24.340><c> by</c><00:00:24.430><c> selecting</c><00:00:24.700><c> the</c><00:00:25.000><c> cell</c><00:00:25.270><c> that</c>

00:00:25.410 --> 00:00:25.420 align:start position:0%
like to start by selecting the cell that
 

00:00:25.420 --> 00:00:27.330 align:start position:0%
like to start by selecting the cell that
contains<00:00:25.480><c> Fitness</c><00:00:26.410><c> progress</c><00:00:26.680><c> chart</c><00:00:27.189><c> and</c>

00:00:27.330 --> 00:00:27.340 align:start position:0%
contains Fitness progress chart and
 

00:00:27.340 --> 00:00:29.249 align:start position:0%
contains Fitness progress chart and
making<00:00:27.790><c> the</c><00:00:27.880><c> text</c><00:00:28.119><c> bigger</c><00:00:28.329><c> like</c><00:00:28.810><c> a</c><00:00:28.840><c> proper</c>

00:00:29.249 --> 00:00:29.259 align:start position:0%
making the text bigger like a proper
 

00:00:29.259 --> 00:00:31.620 align:start position:0%
making the text bigger like a proper
title<00:00:29.489><c> just</c><00:00:30.489><c> go</c><00:00:30.640><c> to</c><00:00:30.700><c> the</c><00:00:30.880><c> font</c><00:00:31.090><c> group</c><00:00:31.270><c> on</c><00:00:31.480><c> the</c>

00:00:31.620 --> 00:00:31.630 align:start position:0%
title just go to the font group on the
 

00:00:31.630 --> 00:00:33.389 align:start position:0%
title just go to the font group on the
Home<00:00:31.810><c> tab</c><00:00:31.840><c> and</c><00:00:32.320><c> click</c><00:00:32.680><c> the</c><00:00:32.800><c> drop</c><00:00:33.010><c> down</c><00:00:33.220><c> arrow</c>

00:00:33.389 --> 00:00:33.399 align:start position:0%
Home tab and click the drop down arrow
 

00:00:33.399 --> 00:00:36.180 align:start position:0%
Home tab and click the drop down arrow
next<00:00:33.489><c> to</c><00:00:33.820><c> size</c><00:00:34.230><c> you'll</c><00:00:35.230><c> see</c><00:00:35.440><c> a</c><00:00:35.470><c> preview</c><00:00:35.739><c> of</c><00:00:36.070><c> the</c>

00:00:36.180 --> 00:00:36.190 align:start position:0%
next to size you'll see a preview of the
 

00:00:36.190 --> 00:00:37.830 align:start position:0%
next to size you'll see a preview of the
results<00:00:36.309><c> as</c><00:00:36.730><c> you</c><00:00:36.820><c> go</c><00:00:37.000><c> down</c><00:00:37.210><c> the</c><00:00:37.360><c> list</c>

00:00:37.830 --> 00:00:37.840 align:start position:0%
results as you go down the list
 

00:00:37.840 --> 00:00:42.360 align:start position:0%
results as you go down the list
I<00:00:38.670><c> think</c><00:00:39.670><c> 24</c><00:00:40.149><c> looks</c><00:00:40.360><c> good</c><00:00:40.710><c> maybe</c><00:00:41.710><c> we</c><00:00:41.950><c> could</c><00:00:42.190><c> go</c>

00:00:42.360 --> 00:00:42.370 align:start position:0%
I think 24 looks good maybe we could go
 

00:00:42.370 --> 00:00:45.600 align:start position:0%
I think 24 looks good maybe we could go
a<00:00:42.399><c> little</c><00:00:42.700><c> bigger</c><00:00:42.880><c> though</c><00:00:44.310><c> increase</c><00:00:45.310><c> and</c>

00:00:45.600 --> 00:00:45.610 align:start position:0%
a little bigger though increase and
 

00:00:45.610 --> 00:00:47.490 align:start position:0%
a little bigger though increase and
decrease<00:00:45.760><c> our</c><00:00:46.270><c> two</c><00:00:46.600><c> other</c><00:00:46.780><c> options</c><00:00:47.260><c> for</c>

00:00:47.490 --> 00:00:47.500 align:start position:0%
decrease our two other options for
 

00:00:47.500 --> 00:00:48.930 align:start position:0%
decrease our two other options for
quickly<00:00:47.830><c> changing</c><00:00:47.860><c> the</c><00:00:48.340><c> size</c><00:00:48.550><c> of</c><00:00:48.760><c> your</c><00:00:48.910><c> text</c>

00:00:48.930 --> 00:00:48.940 align:start position:0%
quickly changing the size of your text
 

00:00:48.940 --> 00:00:51.330 align:start position:0%
quickly changing the size of your text
all<00:00:49.540><c> you</c><00:00:50.140><c> have</c><00:00:50.320><c> to</c><00:00:50.410><c> do</c><00:00:50.530><c> is</c><00:00:50.650><c> click</c><00:00:50.890><c> the</c><00:00:51.040><c> command</c>

00:00:51.330 --> 00:00:51.340 align:start position:0%
all you have to do is click the command
 

00:00:51.340 --> 00:00:55.410 align:start position:0%
all you have to do is click the command
and<00:00:51.870><c> perfect</c><00:00:53.490><c> to</c><00:00:54.490><c> change</c><00:00:54.760><c> the</c><00:00:54.940><c> actual</c><00:00:55.270><c> font</c>

00:00:55.410 --> 00:00:55.420 align:start position:0%
and perfect to change the actual font
 

00:00:55.420 --> 00:00:58.440 align:start position:0%
and perfect to change the actual font
click<00:00:56.200><c> the</c><00:00:56.350><c> drop</c><00:00:56.560><c> down</c><00:00:56.590><c> arrow</c><00:00:56.800><c> here</c><00:00:57.210><c> then</c><00:00:58.210><c> make</c>

00:00:58.440 --> 00:00:58.450 align:start position:0%
click the drop down arrow here then make
 

00:00:58.450 --> 00:01:00.000 align:start position:0%
click the drop down arrow here then make
your<00:00:58.600><c> way</c><00:00:58.720><c> down</c><00:00:58.930><c> the</c><00:00:59.079><c> list</c><00:00:59.230><c> you'll</c><00:00:59.680><c> get</c><00:00:59.860><c> that</c>

00:01:00.000 --> 00:01:00.010 align:start position:0%
your way down the list you'll get that
 

00:01:00.010 --> 00:01:04.109 align:start position:0%
your way down the list you'll get that
live<00:01:00.250><c> preview</c><00:01:00.760><c> again</c><00:01:00.970><c> I</c><00:01:02.850><c> think</c><00:01:03.850><c> I'll</c><00:01:03.970><c> go</c><00:01:04.089><c> with</c>

00:01:04.109 --> 00:01:04.119 align:start position:0%
live preview again I think I'll go with
 

00:01:04.119 --> 00:01:06.660 align:start position:0%
live preview again I think I'll go with
this<00:01:04.390><c> one</c><00:01:04.619><c> it's</c><00:01:05.619><c> different</c><00:01:06.100><c> but</c><00:01:06.369><c> still</c><00:01:06.610><c> very</c>

00:01:06.660 --> 00:01:06.670 align:start position:0%
this one it's different but still very
 

00:01:06.670 --> 00:01:08.490 align:start position:0%
this one it's different but still very
easy<00:01:06.939><c> to</c><00:01:07.299><c> read</c><00:01:07.540><c> which</c><00:01:07.900><c> makes</c><00:01:08.170><c> it</c><00:01:08.290><c> a</c><00:01:08.350><c> good</c>

00:01:08.490 --> 00:01:08.500 align:start position:0%
easy to read which makes it a good
 

00:01:08.500 --> 00:01:11.880 align:start position:0%
easy to read which makes it a good
choice<00:01:08.560><c> for</c><00:01:09.040><c> the</c><00:01:09.130><c> title</c><00:01:10.049><c> so</c><00:01:11.049><c> how</c><00:01:11.380><c> about</c><00:01:11.530><c> some</c>

00:01:11.880 --> 00:01:11.890 align:start position:0%
choice for the title so how about some
 

00:01:11.890 --> 00:01:14.310 align:start position:0%
choice for the title so how about some
color<00:01:12.100><c> to</c><00:01:12.340><c> view</c><00:01:13.270><c> your</c><00:01:13.420><c> options</c><00:01:13.570><c> click</c><00:01:14.110><c> the</c>

00:01:14.310 --> 00:01:14.320 align:start position:0%
color to view your options click the
 

00:01:14.320 --> 00:01:16.980 align:start position:0%
color to view your options click the
arrow<00:01:14.500><c> next</c><00:01:14.830><c> to</c><00:01:14.950><c> the</c><00:01:15.040><c> font</c><00:01:15.280><c> color</c><00:01:15.400><c> command</c><00:01:15.990><c> you</c>

00:01:16.980 --> 00:01:16.990 align:start position:0%
arrow next to the font color command you
 

00:01:16.990 --> 00:01:18.780 align:start position:0%
arrow next to the font color command you
can<00:01:17.140><c> go</c><00:01:17.290><c> with</c><00:01:17.440><c> one</c><00:01:17.620><c> of</c><00:01:17.650><c> the</c><00:01:17.800><c> theme</c><00:01:18.010><c> colors</c><00:01:18.400><c> here</c>

00:01:18.780 --> 00:01:18.790 align:start position:0%
can go with one of the theme colors here
 

00:01:18.790 --> 00:01:21.060 align:start position:0%
can go with one of the theme colors here
or<00:01:18.940><c> if</c><00:01:19.630><c> you</c><00:01:19.750><c> don't</c><00:01:19.870><c> see</c><00:01:20.110><c> anything</c><00:01:20.470><c> you</c><00:01:20.590><c> like</c><00:01:20.740><c> go</c>

00:01:21.060 --> 00:01:21.070 align:start position:0%
or if you don't see anything you like go
 

00:01:21.070 --> 00:01:24.810 align:start position:0%
or if you don't see anything you like go
ahead<00:01:21.220><c> and</c><00:01:21.370><c> click</c><00:01:21.520><c> more</c><00:01:21.850><c> colors</c><00:01:23.460><c> this</c><00:01:24.460><c> bright</c>

00:01:24.810 --> 00:01:24.820 align:start position:0%
ahead and click more colors this bright
 

00:01:24.820 --> 00:01:26.130 align:start position:0%
ahead and click more colors this bright
pink<00:01:24.850><c> should</c><00:01:25.270><c> look</c><00:01:25.420><c> nice</c><00:01:25.630><c> with</c><00:01:25.870><c> the</c><00:01:25.930><c> color</c>

00:01:26.130 --> 00:01:26.140 align:start position:0%
pink should look nice with the color
 

00:01:26.140 --> 00:01:30.360 align:start position:0%
pink should look nice with the color
scheme<00:01:26.440><c> I</c><00:01:26.560><c> have</c><00:01:26.740><c> in</c><00:01:26.830><c> mind</c><00:01:29.100><c> another</c><00:01:30.100><c> way</c><00:01:30.310><c> to</c>

00:01:30.360 --> 00:01:30.370 align:start position:0%
scheme I have in mind another way to
 

00:01:30.370 --> 00:01:32.000 align:start position:0%
scheme I have in mind another way to
make<00:01:30.549><c> your</c><00:01:30.670><c> text</c><00:01:30.729><c> stand</c><00:01:31.060><c> out</c><00:01:31.330><c> is</c><00:01:31.630><c> to</c><00:01:31.659><c> use</c><00:01:31.840><c> bold</c>

00:01:32.000 --> 00:01:32.010 align:start position:0%
make your text stand out is to use bold
 

00:01:32.010 --> 00:01:35.190 align:start position:0%
make your text stand out is to use bold
italic<00:01:33.010><c> or</c><00:01:33.130><c> underline</c><00:01:33.750><c> bold</c><00:01:34.750><c> should</c><00:01:35.049><c> be</c><00:01:35.170><c> a</c>

00:01:35.190 --> 00:01:35.200 align:start position:0%
italic or underline bold should be a
 

00:01:35.200 --> 00:01:37.980 align:start position:0%
italic or underline bold should be a
good<00:01:35.380><c> choice</c><00:01:35.590><c> in</c><00:01:35.799><c> this</c><00:01:35.890><c> example</c><00:01:36.479><c> now</c><00:01:37.479><c> the</c><00:01:37.540><c> text</c>

00:01:37.980 --> 00:01:37.990 align:start position:0%
good choice in this example now the text
 

00:01:37.990 --> 00:01:39.810 align:start position:0%
good choice in this example now the text
really<00:01:38.260><c> stands</c><00:01:38.680><c> out</c><00:01:38.860><c> and</c><00:01:39.100><c> is</c><00:01:39.220><c> much</c><00:01:39.400><c> easier</c><00:01:39.790><c> to</c>

00:01:39.810 --> 00:01:39.820 align:start position:0%
really stands out and is much easier to
 

00:01:39.820 --> 00:01:42.690 align:start position:0%
really stands out and is much easier to
read<00:01:40.090><c> I</c><00:01:41.070><c> think</c><00:01:42.070><c> I'm</c><00:01:42.220><c> ready</c><00:01:42.340><c> to</c><00:01:42.460><c> add</c><00:01:42.670><c> some</c>

00:01:42.690 --> 00:01:42.700 align:start position:0%
read I think I'm ready to add some
 

00:01:42.700 --> 00:01:44.430 align:start position:0%
read I think I'm ready to add some
formatting<00:01:42.970><c> to</c><00:01:43.540><c> the</c><00:01:43.570><c> rest</c><00:01:43.840><c> of</c><00:01:43.990><c> the</c><00:01:44.080><c> worksheet</c>

00:01:44.430 --> 00:01:44.440 align:start position:0%
formatting to the rest of the worksheet
 

00:01:44.440 --> 00:01:46.950 align:start position:0%
formatting to the rest of the worksheet
at<00:01:44.650><c> a</c><00:01:44.909><c> glance</c><00:01:45.909><c> it's</c><00:01:46.240><c> kind</c><00:01:46.479><c> of</c><00:01:46.540><c> hard</c><00:01:46.720><c> to</c><00:01:46.810><c> tell</c>

00:01:46.950 --> 00:01:46.960 align:start position:0%
at a glance it's kind of hard to tell
 

00:01:46.960 --> 00:01:48.270 align:start position:0%
at a glance it's kind of hard to tell
the<00:01:47.110><c> header</c><00:01:47.320><c> row</c><00:01:47.409><c> from</c><00:01:47.740><c> the</c><00:01:47.890><c> rest</c><00:01:48.070><c> of</c><00:01:48.190><c> the</c>

00:01:48.270 --> 00:01:48.280 align:start position:0%
the header row from the rest of the
 

00:01:48.280 --> 00:01:50.700 align:start position:0%
the header row from the rest of the
chart<00:01:48.520><c> because</c><00:01:48.880><c> it</c><00:01:49.000><c> just</c><00:01:49.180><c> isn't</c><00:01:49.450><c> distinct</c><00:01:50.020><c> we</c>

00:01:50.700 --> 00:01:50.710 align:start position:0%
chart because it just isn't distinct we
 

00:01:50.710 --> 00:01:52.530 align:start position:0%
chart because it just isn't distinct we
can<00:01:50.860><c> easily</c><00:01:51.010><c> fix</c><00:01:51.400><c> that</c><00:01:51.520><c> by</c><00:01:51.909><c> giving</c><00:01:52.060><c> the</c><00:01:52.299><c> cells</c>

00:01:52.530 --> 00:01:52.540 align:start position:0%
can easily fix that by giving the cells
 

00:01:52.540 --> 00:01:55.469 align:start position:0%
can easily fix that by giving the cells
a<00:01:52.720><c> unique</c><00:01:53.049><c> fill</c><00:01:53.260><c> color</c><00:01:53.820><c> all</c><00:01:54.820><c> you</c><00:01:55.060><c> have</c><00:01:55.210><c> to</c><00:01:55.360><c> do</c>

00:01:55.469 --> 00:01:55.479 align:start position:0%
a unique fill color all you have to do
 

00:01:55.479 --> 00:01:57.210 align:start position:0%
a unique fill color all you have to do
is<00:01:55.630><c> open</c><00:01:55.780><c> the</c><00:01:55.960><c> menu</c><00:01:56.290><c> next</c><00:01:56.470><c> to</c><00:01:56.619><c> the</c><00:01:56.710><c> fill</c><00:01:56.979><c> color</c>

00:01:57.210 --> 00:01:57.220 align:start position:0%
is open the menu next to the fill color
 

00:01:57.220 --> 00:01:59.730 align:start position:0%
is open the menu next to the fill color
command<00:01:57.310><c> and</c><00:01:57.850><c> make</c><00:01:57.970><c> your</c><00:01:58.180><c> choice</c><00:01:58.530><c> dark</c><00:01:59.530><c> grey</c>

00:01:59.730 --> 00:01:59.740 align:start position:0%
command and make your choice dark grey
 

00:01:59.740 --> 00:02:01.380 align:start position:0%
command and make your choice dark grey
should<00:01:59.950><c> be</c><00:02:00.040><c> a</c><00:02:00.070><c> nice</c><00:02:00.220><c> contrast</c><00:02:00.820><c> to</c><00:02:00.909><c> the</c><00:02:01.060><c> pink</c><00:02:01.270><c> we</c>

00:02:01.380 --> 00:02:01.390 align:start position:0%
should be a nice contrast to the pink we
 

00:02:01.390 --> 00:02:03.960 align:start position:0%
should be a nice contrast to the pink we
already<00:02:01.689><c> have</c><00:02:01.840><c> in</c><00:02:01.990><c> the</c><00:02:02.080><c> title</c><00:02:02.640><c> now</c><00:02:03.640><c> we</c><00:02:03.700><c> just</c>

00:02:03.960 --> 00:02:03.970 align:start position:0%
already have in the title now we just
 

00:02:03.970 --> 00:02:05.670 align:start position:0%
already have in the title now we just
need<00:02:04.060><c> to</c><00:02:04.270><c> change</c><00:02:04.510><c> the</c><00:02:04.689><c> color</c><00:02:04.869><c> of</c><00:02:04.960><c> my</c><00:02:05.200><c> text</c><00:02:05.590><c> to</c>

00:02:05.670 --> 00:02:05.680 align:start position:0%
need to change the color of my text to
 

00:02:05.680 --> 00:02:09.960 align:start position:0%
need to change the color of my text to
something<00:02:06.070><c> lighter</c><00:02:08.009><c> you</c><00:02:09.009><c> can</c><00:02:09.189><c> also</c><00:02:09.369><c> use</c><00:02:09.700><c> cell</c>

00:02:09.960 --> 00:02:09.970 align:start position:0%
something lighter you can also use cell
 

00:02:09.970 --> 00:02:11.640 align:start position:0%
something lighter you can also use cell
styles<00:02:10.420><c> to</c><00:02:10.629><c> quickly</c><00:02:10.869><c> apply</c><00:02:11.260><c> different</c>

00:02:11.640 --> 00:02:11.650 align:start position:0%
styles to quickly apply different
 

00:02:11.650 --> 00:02:13.830 align:start position:0%
styles to quickly apply different
formatting<00:02:12.010><c> to</c><00:02:12.220><c> your</c><00:02:12.250><c> workbook</c><00:02:12.670><c> let's</c><00:02:13.629><c> give</c>

00:02:13.830 --> 00:02:13.840 align:start position:0%
formatting to your workbook let's give
 

00:02:13.840 --> 00:02:17.070 align:start position:0%
formatting to your workbook let's give
it<00:02:13.870><c> a</c><00:02:13.989><c> try</c><00:02:14.140><c> on</c><00:02:14.260><c> the</c><00:02:14.620><c> rest</c><00:02:14.799><c> of</c><00:02:14.980><c> the</c><00:02:15.069><c> chart</c><00:02:16.080><c> when</c>

00:02:17.070 --> 00:02:17.080 align:start position:0%
it a try on the rest of the chart when
 

00:02:17.080 --> 00:02:18.420 align:start position:0%
it a try on the rest of the chart when
you're<00:02:17.230><c> ready</c><00:02:17.439><c> click</c><00:02:17.769><c> the</c><00:02:17.830><c> cell</c><00:02:18.159><c> Styles</c>

00:02:18.420 --> 00:02:18.430 align:start position:0%
you're ready click the cell Styles
 

00:02:18.430 --> 00:02:21.300 align:start position:0%
you're ready click the cell Styles
command<00:02:18.989><c> then</c><00:02:19.989><c> mouse</c><00:02:20.260><c> over</c><00:02:20.469><c> the</c><00:02:20.680><c> styles</c><00:02:21.069><c> for</c><00:02:21.249><c> a</c>

00:02:21.300 --> 00:02:21.310 align:start position:0%
command then mouse over the styles for a
 

00:02:21.310 --> 00:02:22.990 align:start position:0%
command then mouse over the styles for a
preview

00:02:22.990 --> 00:02:23.000 align:start position:0%
preview
 

00:02:23.000 --> 00:02:27.040 align:start position:0%
preview
and<00:02:23.090><c> click</c><00:02:23.750><c> the</c><00:02:23.780><c> one</c><00:02:24.020><c> you</c><00:02:24.080><c> want</c><00:02:24.200><c> as</c><00:02:25.900><c> you</c><00:02:26.900><c> can</c>

00:02:27.040 --> 00:02:27.050 align:start position:0%
and click the one you want as you can
 

00:02:27.050 --> 00:02:29.140 align:start position:0%
and click the one you want as you can
see<00:02:27.230><c> at</c><00:02:27.350><c> this</c><00:02:27.500><c> point</c><00:02:27.620><c> adding</c><00:02:28.370><c> a</c><00:02:28.460><c> fill</c><00:02:28.670><c> color</c><00:02:28.940><c> to</c>

00:02:29.140 --> 00:02:29.150 align:start position:0%
see at this point adding a fill color to
 

00:02:29.150 --> 00:02:31.060 align:start position:0%
see at this point adding a fill color to
a<00:02:29.180><c> range</c><00:02:29.450><c> of</c><00:02:29.600><c> cells</c><00:02:29.870><c> causes</c><00:02:30.410><c> the</c><00:02:30.560><c> lines</c><00:02:30.800><c> in</c>

00:02:31.060 --> 00:02:31.070 align:start position:0%
a range of cells causes the lines in
 

00:02:31.070 --> 00:02:33.460 align:start position:0%
a range of cells causes the lines in
between<00:02:31.190><c> to</c><00:02:31.610><c> disappear</c><00:02:32.150><c> I'd</c><00:02:32.900><c> like</c><00:02:33.110><c> to</c><00:02:33.260><c> change</c>

00:02:33.460 --> 00:02:33.470 align:start position:0%
between to disappear I'd like to change
 

00:02:33.470 --> 00:02:35.500 align:start position:0%
between to disappear I'd like to change
that<00:02:33.590><c> by</c><00:02:34.010><c> adding</c><00:02:34.220><c> borders</c><00:02:34.790><c> to</c><00:02:35.030><c> the</c><00:02:35.060><c> entire</c>

00:02:35.500 --> 00:02:35.510 align:start position:0%
that by adding borders to the entire
 

00:02:35.510 --> 00:02:39.040 align:start position:0%
that by adding borders to the entire
chart<00:02:36.910><c> click</c><00:02:37.910><c> the</c><00:02:38.060><c> drop</c><00:02:38.270><c> down</c><00:02:38.450><c> arrow</c><00:02:38.690><c> next</c><00:02:38.780><c> to</c>

00:02:39.040 --> 00:02:39.050 align:start position:0%
chart click the drop down arrow next to
 

00:02:39.050 --> 00:02:40.690 align:start position:0%
chart click the drop down arrow next to
the<00:02:39.140><c> borders</c><00:02:39.350><c> command</c><00:02:39.680><c> and</c><00:02:40.100><c> you'll</c><00:02:40.340><c> find</c><00:02:40.550><c> lots</c>

00:02:40.690 --> 00:02:40.700 align:start position:0%
the borders command and you'll find lots
 

00:02:40.700 --> 00:02:43.420 align:start position:0%
the borders command and you'll find lots
of<00:02:40.880><c> different</c><00:02:40.940><c> options</c><00:02:41.470><c> for</c><00:02:42.470><c> example</c><00:02:42.709><c> you</c><00:02:43.250><c> can</c>

00:02:43.420 --> 00:02:43.430 align:start position:0%
of different options for example you can
 

00:02:43.430 --> 00:02:46.300 align:start position:0%
of different options for example you can
add<00:02:43.580><c> a</c><00:02:43.610><c> top</c><00:02:43.880><c> and</c><00:02:44.060><c> bottom</c><00:02:44.120><c> border</c><00:02:44.660><c> a</c><00:02:45.310><c> thick</c>

00:02:46.300 --> 00:02:46.310 align:start position:0%
add a top and bottom border a thick
 

00:02:46.310 --> 00:02:49.480 align:start position:0%
add a top and bottom border a thick
outside<00:02:46.820><c> border</c><00:02:47.740><c> even</c><00:02:48.740><c> different</c><00:02:49.280><c> line</c>

00:02:49.480 --> 00:02:49.490 align:start position:0%
outside border even different line
 

00:02:49.490 --> 00:02:52.540 align:start position:0%
outside border even different line
colors<00:02:49.850><c> and</c><00:02:50.060><c> styles</c><00:02:50.860><c> for</c><00:02:51.860><c> a</c><00:02:51.920><c> border</c><00:02:52.280><c> that</c><00:02:52.400><c> goes</c>

00:02:52.540 --> 00:02:52.550 align:start position:0%
colors and styles for a border that goes
 

00:02:52.550 --> 00:02:54.699 align:start position:0%
colors and styles for a border that goes
around<00:02:52.730><c> the</c><00:02:52.970><c> outside</c><00:02:53.000><c> and</c><00:02:53.720><c> in</c><00:02:54.200><c> between</c><00:02:54.380><c> the</c>

00:02:54.699 --> 00:02:54.709 align:start position:0%
around the outside and in between the
 

00:02:54.709 --> 00:02:55.180 align:start position:0%
around the outside and in between the
cells

00:02:55.180 --> 00:02:55.190 align:start position:0%
cells
 

00:02:55.190 --> 00:02:59.320 align:start position:0%
cells
choose<00:02:55.550><c> all</c><00:02:55.850><c> borders</c><00:02:56.300><c> I</c><00:02:57.790><c> also</c><00:02:58.790><c> want</c><00:02:59.120><c> to</c><00:02:59.150><c> show</c>

00:02:59.320 --> 00:02:59.330 align:start position:0%
choose all borders I also want to show
 

00:02:59.330 --> 00:03:00.790 align:start position:0%
choose all borders I also want to show
you<00:02:59.390><c> how</c><00:02:59.600><c> to</c><00:02:59.630><c> change</c><00:02:59.959><c> the</c><00:03:00.140><c> placement</c><00:03:00.410><c> or</c>

00:03:00.790 --> 00:03:00.800 align:start position:0%
you how to change the placement or
 

00:03:00.800 --> 00:03:02.920 align:start position:0%
you how to change the placement or
alignment<00:03:00.830><c> of</c><00:03:01.370><c> your</c><00:03:01.430><c> text</c><00:03:01.550><c> using</c><00:03:02.180><c> the</c><00:03:02.390><c> options</c>

00:03:02.920 --> 00:03:02.930 align:start position:0%
alignment of your text using the options
 

00:03:02.930 --> 00:03:05.500 align:start position:0%
alignment of your text using the options
in<00:03:03.080><c> the</c><00:03:03.200><c> alignment</c><00:03:03.230><c> group</c><00:03:03.680><c> in</c><00:03:04.090><c> addition</c><00:03:05.090><c> to</c>

00:03:05.500 --> 00:03:05.510 align:start position:0%
in the alignment group in addition to
 

00:03:05.510 --> 00:03:09.220 align:start position:0%
in the alignment group in addition to
left<00:03:05.780><c> center</c><00:03:06.739><c> and</c><00:03:06.950><c> right</c><00:03:07.600><c> text</c><00:03:08.600><c> can</c><00:03:08.750><c> also</c><00:03:08.989><c> be</c>

00:03:09.220 --> 00:03:09.230 align:start position:0%
left center and right text can also be
 

00:03:09.230 --> 00:03:11.979 align:start position:0%
left center and right text can also be
aligned<00:03:09.530><c> to</c><00:03:09.709><c> the</c><00:03:09.800><c> bottom</c><00:03:10.130><c> middle</c><00:03:10.970><c> or</c><00:03:11.120><c> top</c><00:03:11.780><c> of</c>

00:03:11.979 --> 00:03:11.989 align:start position:0%
aligned to the bottom middle or top of
 

00:03:11.989 --> 00:03:14.500 align:start position:0%
aligned to the bottom middle or top of
the<00:03:12.080><c> cell</c><00:03:12.790><c> aligning</c><00:03:13.790><c> the</c><00:03:13.910><c> text</c><00:03:14.060><c> in</c><00:03:14.330><c> the</c><00:03:14.420><c> middle</c>

00:03:14.500 --> 00:03:14.510 align:start position:0%
the cell aligning the text in the middle
 

00:03:14.510 --> 00:03:16.270 align:start position:0%
the cell aligning the text in the middle
Center<00:03:14.989><c> should</c><00:03:15.200><c> make</c><00:03:15.350><c> the</c><00:03:15.500><c> chart</c><00:03:15.739><c> nice</c><00:03:15.980><c> and</c>

00:03:16.270 --> 00:03:16.280 align:start position:0%
Center should make the chart nice and
 

00:03:16.280 --> 00:03:19.780 align:start position:0%
Center should make the chart nice and
easy<00:03:16.430><c> to</c><00:03:16.610><c> read</c><00:03:17.860><c> finally</c><00:03:18.860><c> one</c><00:03:19.220><c> of</c><00:03:19.250><c> excels</c><00:03:19.670><c> most</c>

00:03:19.780 --> 00:03:19.790 align:start position:0%
easy to read finally one of excels most
 

00:03:19.790 --> 00:03:22.180 align:start position:0%
easy to read finally one of excels most
useful<00:03:20.390><c> features</c><00:03:20.720><c> is</c><00:03:20.989><c> its</c><00:03:21.260><c> ability</c><00:03:21.680><c> to</c><00:03:21.709><c> format</c>

00:03:22.180 --> 00:03:22.190 align:start position:0%
useful features is its ability to format
 

00:03:22.190 --> 00:03:24.060 align:start position:0%
useful features is its ability to format
dates<00:03:22.370><c> and</c><00:03:22.640><c> numbers</c><00:03:22.790><c> for</c><00:03:23.150><c> you</c><00:03:23.239><c> automatically</c>

00:03:24.060 --> 00:03:24.070 align:start position:0%
dates and numbers for you automatically
 

00:03:24.070 --> 00:03:26.470 align:start position:0%
dates and numbers for you automatically
for<00:03:25.070><c> example</c><00:03:25.459><c> it</c><00:03:25.730><c> would</c><00:03:25.820><c> help</c><00:03:26.000><c> me</c><00:03:26.090><c> to</c><00:03:26.180><c> know</c><00:03:26.330><c> not</c>

00:03:26.470 --> 00:03:26.480 align:start position:0%
for example it would help me to know not
 

00:03:26.480 --> 00:03:27.820 align:start position:0%
for example it would help me to know not
only<00:03:26.540><c> the</c><00:03:26.930><c> dates</c><00:03:27.170><c> that</c><00:03:27.290><c> I</c><00:03:27.440><c> took</c><00:03:27.680><c> these</c>

00:03:27.820 --> 00:03:27.830 align:start position:0%
only the dates that I took these
 

00:03:27.830 --> 00:03:29.560 align:start position:0%
only the dates that I took these
measurements<00:03:28.400><c> but</c><00:03:28.640><c> also</c><00:03:28.880><c> the</c><00:03:29.120><c> days</c><00:03:29.299><c> of</c><00:03:29.450><c> the</c>

00:03:29.560 --> 00:03:29.570 align:start position:0%
measurements but also the days of the
 

00:03:29.570 --> 00:03:32.229 align:start position:0%
measurements but also the days of the
week<00:03:29.950><c> all</c><00:03:30.950><c> you</c><00:03:31.310><c> have</c><00:03:31.459><c> to</c><00:03:31.610><c> do</c><00:03:31.730><c> is</c><00:03:31.910><c> click</c><00:03:32.090><c> the</c>

00:03:32.229 --> 00:03:32.239 align:start position:0%
week all you have to do is click the
 

00:03:32.239 --> 00:03:33.789 align:start position:0%
week all you have to do is click the
drop<00:03:32.480><c> down</c><00:03:32.510><c> arrow</c><00:03:32.720><c> next</c><00:03:33.260><c> to</c><00:03:33.410><c> the</c><00:03:33.530><c> number</c>

00:03:33.789 --> 00:03:33.799 align:start position:0%
drop down arrow next to the number
 

00:03:33.799 --> 00:03:36.670 align:start position:0%
drop down arrow next to the number
format<00:03:34.220><c> command</c><00:03:34.540><c> then</c><00:03:35.540><c> choose</c><00:03:35.900><c> a</c><00:03:35.930><c> format</c><00:03:36.440><c> in</c>

00:03:36.670 --> 00:03:36.680 align:start position:0%
format command then choose a format in
 

00:03:36.680 --> 00:03:40.780 align:start position:0%
format command then choose a format in
this<00:03:37.250><c> case</c><00:03:37.310><c> we'll</c><00:03:37.910><c> choose</c><00:03:38.090><c> the</c><00:03:38.330><c> long</c><00:03:38.510><c> date</c><00:03:39.790><c> you</c>

00:03:40.780 --> 00:03:40.790 align:start position:0%
this case we'll choose the long date you
 

00:03:40.790 --> 00:03:42.340 align:start position:0%
this case we'll choose the long date you
can<00:03:40.970><c> accomplish</c><00:03:41.239><c> lots</c><00:03:41.630><c> of</c><00:03:41.750><c> things</c><00:03:41.989><c> with</c><00:03:42.170><c> data</c>

00:03:42.340 --> 00:03:42.350 align:start position:0%
can accomplish lots of things with data
 

00:03:42.350 --> 00:03:44.710 align:start position:0%
can accomplish lots of things with data
number<00:03:42.739><c> formatting</c><00:03:43.130><c> take</c><00:03:44.060><c> this</c><00:03:44.209><c> column</c><00:03:44.510><c> of</c>

00:03:44.710 --> 00:03:44.720 align:start position:0%
number formatting take this column of
 

00:03:44.720 --> 00:03:46.390 align:start position:0%
number formatting take this column of
percentages<00:03:45.290><c> just</c><00:03:45.530><c> numbers</c><00:03:45.980><c> with</c><00:03:46.130><c> a</c><00:03:46.160><c> decimal</c>

00:03:46.390 --> 00:03:46.400 align:start position:0%
percentages just numbers with a decimal
 

00:03:46.400 --> 00:03:49.150 align:start position:0%
percentages just numbers with a decimal
place<00:03:47.019><c> switching</c><00:03:48.019><c> to</c><00:03:48.140><c> the</c><00:03:48.260><c> percentage</c><00:03:48.769><c> format</c>

00:03:49.150 --> 00:03:49.160 align:start position:0%
place switching to the percentage format
 

00:03:49.160 --> 00:03:52.080 align:start position:0%
place switching to the percentage format
will<00:03:49.430><c> instantly</c><00:03:49.910><c> display</c><00:03:50.299><c> them</c><00:03:50.450><c> properly</c>

00:03:52.080 --> 00:03:52.090 align:start position:0%
will instantly display them properly
 

00:03:52.090 --> 00:03:53.590 align:start position:0%
will instantly display them properly
there<00:03:53.090><c> we</c><00:03:53.239><c> go</c>

00:03:53.590 --> 00:03:53.600 align:start position:0%
there we go
 

00:03:53.600 --> 00:03:55.509 align:start position:0%
there we go
what<00:03:54.200><c> a</c><00:03:54.230><c> big</c><00:03:54.470><c> difference</c><00:03:54.680><c> formatting</c><00:03:55.370><c> can</c>

00:03:55.509 --> 00:03:55.519 align:start position:0%
what a big difference formatting can
 

00:03:55.519 --> 00:03:57.970 align:start position:0%
what a big difference formatting can
make<00:03:55.780><c> not</c><00:03:56.780><c> only</c><00:03:57.019><c> does</c><00:03:57.200><c> my</c><00:03:57.230><c> worksheet</c><00:03:57.769><c> look</c>

00:03:57.970 --> 00:03:57.980 align:start position:0%
make not only does my worksheet look
 

00:03:57.980 --> 00:03:59.710 align:start position:0%
make not only does my worksheet look
better<00:03:58.220><c> than</c><00:03:58.400><c> it</c><00:03:58.519><c> did</c><00:03:58.640><c> before</c><00:03:58.820><c> it's</c><00:03:59.510><c> also</c>

00:03:59.710 --> 00:03:59.720 align:start position:0%
better than it did before it's also
 

00:03:59.720 --> 00:04:03.070 align:start position:0%
better than it did before it's also
easier<00:04:00.290><c> to</c><00:04:00.350><c> review</c><00:04:00.739><c> the</c><00:04:00.860><c> data</c>