WEBVTT
Kind: captions
Language: en

00:00:01.159 --> 00:00:03.740 align:start position:0%
 
Goodwill<00:00:02.159><c> Community</c><00:00:02.639><c> Foundation</c><00:00:03.300><c> creating</c>

00:00:03.740 --> 00:00:03.750 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.750 --> 00:00:08.879 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.350><c> for</c><00:00:04.560><c> a</c><00:00:04.620><c> better</c><00:00:04.650><c> life</c>

00:00:08.879 --> 00:00:08.889 align:start position:0%
 
 

00:00:08.889 --> 00:00:11.039 align:start position:0%
 
tables<00:00:09.820><c> are</c><00:00:09.940><c> a</c><00:00:09.969><c> great</c><00:00:10.269><c> way</c><00:00:10.450><c> to</c><00:00:10.480><c> add</c><00:00:10.780><c> more</c>

00:00:11.039 --> 00:00:11.049 align:start position:0%
tables are a great way to add more
 

00:00:11.049 --> 00:00:12.839 align:start position:0%
tables are a great way to add more
advanced<00:00:11.590><c> formatting</c><00:00:11.950><c> to</c><00:00:12.280><c> your</c><00:00:12.400><c> worksheets</c>

00:00:12.839 --> 00:00:12.849 align:start position:0%
advanced formatting to your worksheets
 

00:00:12.849 --> 00:00:15.449 align:start position:0%
advanced formatting to your worksheets
like<00:00:13.360><c> banded</c><00:00:13.809><c> rows</c><00:00:13.840><c> preset</c><00:00:14.830><c> color</c><00:00:15.070><c> schemes</c>

00:00:15.449 --> 00:00:15.459 align:start position:0%
like banded rows preset color schemes
 

00:00:15.459 --> 00:00:17.460 align:start position:0%
like banded rows preset color schemes
and<00:00:15.699><c> other</c><00:00:16.119><c> design</c><00:00:16.480><c> elements</c><00:00:16.960><c> that</c><00:00:17.020><c> can</c><00:00:17.259><c> save</c>

00:00:17.460 --> 00:00:17.470 align:start position:0%
and other design elements that can save
 

00:00:17.470 --> 00:00:21.029 align:start position:0%
and other design elements that can save
you<00:00:17.590><c> tons</c><00:00:17.800><c> of</c><00:00:18.009><c> time</c><00:00:18.119><c> let's</c><00:00:19.119><c> take</c><00:00:19.360><c> a</c><00:00:19.390><c> look</c><00:00:20.039><c> to</c>

00:00:21.029 --> 00:00:21.039 align:start position:0%
you tons of time let's take a look to
 

00:00:21.039 --> 00:00:23.069 align:start position:0%
you tons of time let's take a look to
create<00:00:21.400><c> a</c><00:00:21.430><c> table</c><00:00:21.700><c> all</c><00:00:22.029><c> you</c><00:00:22.450><c> have</c><00:00:22.630><c> to</c><00:00:22.750><c> do</c><00:00:22.869><c> is</c>

00:00:23.069 --> 00:00:23.079 align:start position:0%
create a table all you have to do is
 

00:00:23.079 --> 00:00:25.190 align:start position:0%
create a table all you have to do is
select<00:00:23.259><c> the</c><00:00:23.619><c> cells</c><00:00:23.860><c> you</c><00:00:24.039><c> want</c><00:00:24.160><c> to</c><00:00:24.250><c> include</c>

00:00:25.190 --> 00:00:25.200 align:start position:0%
select the cells you want to include
 

00:00:25.200 --> 00:00:28.170 align:start position:0%
select the cells you want to include
then<00:00:26.200><c> click</c><00:00:26.590><c> the</c><00:00:26.800><c> format</c><00:00:27.009><c> as</c><00:00:27.430><c> table</c><00:00:27.669><c> command</c>

00:00:28.170 --> 00:00:28.180 align:start position:0%
then click the format as table command
 

00:00:28.180 --> 00:00:31.560 align:start position:0%
then click the format as table command
on<00:00:28.419><c> the</c><00:00:28.540><c> Home</c><00:00:28.660><c> tab</c><00:00:29.759><c> here</c><00:00:30.759><c> you'll</c><00:00:30.910><c> find</c><00:00:31.090><c> several</c>

00:00:31.560 --> 00:00:31.570 align:start position:0%
on the Home tab here you'll find several
 

00:00:31.570 --> 00:00:33.119 align:start position:0%
on the Home tab here you'll find several
different<00:00:31.899><c> styles</c><00:00:32.110><c> to</c><00:00:32.439><c> choose</c><00:00:32.469><c> from</c><00:00:32.920><c> just</c>

00:00:33.119 --> 00:00:33.129 align:start position:0%
different styles to choose from just
 

00:00:33.129 --> 00:00:35.190 align:start position:0%
different styles to choose from just
pick<00:00:33.879><c> whichever</c><00:00:34.239><c> one</c><00:00:34.390><c> appeals</c><00:00:34.840><c> to</c><00:00:34.989><c> you</c><00:00:35.079><c> the</c>

00:00:35.190 --> 00:00:35.200 align:start position:0%
pick whichever one appeals to you the
 

00:00:35.200 --> 00:00:37.080 align:start position:0%
pick whichever one appeals to you the
most<00:00:35.230><c> you</c><00:00:35.920><c> can</c><00:00:36.070><c> always</c><00:00:36.280><c> choose</c><00:00:36.579><c> a</c><00:00:36.640><c> different</c>

00:00:37.080 --> 00:00:37.090 align:start position:0%
most you can always choose a different
 

00:00:37.090 --> 00:00:40.830 align:start position:0%
most you can always choose a different
table<00:00:37.239><c> style</c><00:00:37.660><c> later</c><00:00:38.250><c> if</c><00:00:39.250><c> you</c><00:00:40.210><c> want</c><00:00:40.420><c> your</c><00:00:40.539><c> table</c>

00:00:40.830 --> 00:00:40.840 align:start position:0%
table style later if you want your table
 

00:00:40.840 --> 00:00:42.420 align:start position:0%
table style later if you want your table
to<00:00:40.900><c> have</c><00:00:41.050><c> special</c><00:00:41.440><c> formatting</c><00:00:41.980><c> in</c><00:00:42.100><c> the</c><00:00:42.130><c> header</c>

00:00:42.420 --> 00:00:42.430 align:start position:0%
to have special formatting in the header
 

00:00:42.430 --> 00:00:44.480 align:start position:0%
to have special formatting in the header
row<00:00:42.520><c> make</c><00:00:43.120><c> sure</c><00:00:43.300><c> you</c><00:00:43.420><c> leave</c><00:00:43.630><c> this</c><00:00:43.840><c> box</c><00:00:44.140><c> checked</c>

00:00:44.480 --> 00:00:44.490 align:start position:0%
row make sure you leave this box checked
 

00:00:44.490 --> 00:00:47.160 align:start position:0%
row make sure you leave this box checked
you<00:00:45.490><c> can</c><00:00:45.640><c> also</c><00:00:45.790><c> change</c><00:00:46.180><c> the</c><00:00:46.480><c> selection</c><00:00:46.930><c> if</c><00:00:47.050><c> you</c>

00:00:47.160 --> 00:00:47.170 align:start position:0%
you can also change the selection if you
 

00:00:47.170 --> 00:00:51.500 align:start position:0%
you can also change the selection if you
need<00:00:47.350><c> to</c><00:00:48.570><c> when</c><00:00:49.570><c> you're</c><00:00:49.720><c> ready</c><00:00:49.930><c> click</c><00:00:50.320><c> OK</c><00:00:50.470><c> and</c>

00:00:51.500 --> 00:00:51.510 align:start position:0%
need to when you're ready click OK and
 

00:00:51.510 --> 00:00:55.920 align:start position:0%
need to when you're ready click OK and
now<00:00:52.510><c> we</c><00:00:52.570><c> have</c><00:00:52.810><c> a</c><00:00:52.840><c> table</c><00:00:54.480><c> notice</c><00:00:55.480><c> that</c><00:00:55.630><c> every</c>

00:00:55.920 --> 00:00:55.930 align:start position:0%
now we have a table notice that every
 

00:00:55.930 --> 00:00:57.810 align:start position:0%
now we have a table notice that every
table<00:00:56.140><c> includes</c><00:00:56.710><c> filtering</c><00:00:57.280><c> by</c><00:00:57.430><c> default</c>

00:00:57.810 --> 00:00:57.820 align:start position:0%
table includes filtering by default
 

00:00:57.820 --> 00:00:59.729 align:start position:0%
table includes filtering by default
which<00:00:58.329><c> will</c><00:00:58.360><c> let</c><00:00:58.660><c> you</c><00:00:58.780><c> sort</c><00:00:59.110><c> your</c><00:00:59.230><c> data</c><00:00:59.290><c> or</c>

00:00:59.729 --> 00:00:59.739 align:start position:0%
which will let you sort your data or
 

00:00:59.739 --> 00:01:01.290 align:start position:0%
which will let you sort your data or
narrow<00:01:00.070><c> it</c><00:01:00.220><c> down</c><00:01:00.250><c> depending</c><00:01:00.790><c> on</c><00:01:01.030><c> what</c><00:01:01.180><c> you</c>

00:01:01.290 --> 00:01:01.300 align:start position:0%
narrow it down depending on what you
 

00:01:01.300 --> 00:01:03.840 align:start position:0%
narrow it down depending on what you
need<00:01:01.410><c> you</c><00:01:02.410><c> can</c><00:01:02.559><c> apply</c><00:01:02.800><c> filtering</c><00:01:03.250><c> anytime</c>

00:01:03.840 --> 00:01:03.850 align:start position:0%
need you can apply filtering anytime
 

00:01:03.850 --> 00:01:08.399 align:start position:0%
need you can apply filtering anytime
using<00:01:04.390><c> the</c><00:01:04.479><c> drop</c><00:01:04.689><c> down</c><00:01:04.720><c> arrows</c><00:01:05.229><c> here</c><00:01:06.899><c> if</c><00:01:07.899><c> you</c>

00:01:08.399 --> 00:01:08.409 align:start position:0%
using the drop down arrows here if you
 

00:01:08.409 --> 00:01:10.260 align:start position:0%
using the drop down arrows here if you
need<00:01:08.560><c> to</c><00:01:08.680><c> fit</c><00:01:08.860><c> more</c><00:01:09.009><c> content</c><00:01:09.549><c> into</c><00:01:09.820><c> your</c><00:01:09.850><c> table</c>

00:01:10.260 --> 00:01:10.270 align:start position:0%
need to fit more content into your table
 

00:01:10.270 --> 00:01:12.899 align:start position:0%
need to fit more content into your table
not<00:01:10.659><c> to</c><00:01:10.689><c> worry</c><00:01:11.229><c> Excel</c><00:01:12.130><c> gives</c><00:01:12.340><c> you</c><00:01:12.460><c> two</c><00:01:12.670><c> ways</c><00:01:12.880><c> to</c>

00:01:12.899 --> 00:01:12.909 align:start position:0%
not to worry Excel gives you two ways to
 

00:01:12.909 --> 00:01:15.060 align:start position:0%
not to worry Excel gives you two ways to
add<00:01:13.240><c> more</c><00:01:13.479><c> columns</c><00:01:13.780><c> or</c><00:01:14.140><c> rows</c><00:01:14.170><c> in</c><00:01:14.680><c> the</c><00:01:14.860><c> same</c>

00:01:15.060 --> 00:01:15.070 align:start position:0%
add more columns or rows in the same
 

00:01:15.070 --> 00:01:18.090 align:start position:0%
add more columns or rows in the same
style<00:01:15.370><c> as</c><00:01:15.640><c> the</c><00:01:15.670><c> rest</c><00:01:16.000><c> of</c><00:01:16.150><c> the</c><00:01:16.210><c> table</c><00:01:17.100><c> just</c>

00:01:18.090 --> 00:01:18.100 align:start position:0%
style as the rest of the table just
 

00:01:18.100 --> 00:01:20.160 align:start position:0%
style as the rest of the table just
enter<00:01:18.400><c> your</c><00:01:18.580><c> data</c><00:01:18.700><c> in</c><00:01:19.000><c> any</c><00:01:19.240><c> adjacent</c><00:01:19.630><c> column</c>

00:01:20.160 --> 00:01:20.170 align:start position:0%
enter your data in any adjacent column
 

00:01:20.170 --> 00:01:23.370 align:start position:0%
enter your data in any adjacent column
or<00:01:20.350><c> row</c><00:01:20.530><c> and</c><00:01:21.330><c> it'll</c><00:01:22.330><c> be</c><00:01:22.450><c> roped</c><00:01:22.690><c> into</c><00:01:22.870><c> the</c><00:01:23.080><c> table</c>

00:01:23.370 --> 00:01:23.380 align:start position:0%
or row and it'll be roped into the table
 

00:01:23.380 --> 00:01:26.700 align:start position:0%
or row and it'll be roped into the table
automatically<00:01:24.570><c> you</c><00:01:25.570><c> can</c><00:01:25.720><c> also</c><00:01:25.900><c> click</c><00:01:26.350><c> hold</c>

00:01:26.700 --> 00:01:26.710 align:start position:0%
automatically you can also click hold
 

00:01:26.710 --> 00:01:28.469 align:start position:0%
automatically you can also click hold
and<00:01:26.890><c> drag</c><00:01:27.100><c> the</c><00:01:27.220><c> bottom</c><00:01:27.610><c> right</c><00:01:27.909><c> corner</c><00:01:27.940><c> to</c>

00:01:28.469 --> 00:01:28.479 align:start position:0%
and drag the bottom right corner to
 

00:01:28.479 --> 00:01:34.680 align:start position:0%
and drag the bottom right corner to
create<00:01:28.780><c> any</c><00:01:29.020><c> sized</c><00:01:29.380><c> table</c><00:01:29.770><c> you</c><00:01:29.890><c> need</c><00:01:33.479><c> this</c><00:01:34.479><c> is</c>

00:01:34.680 --> 00:01:34.690 align:start position:0%
create any sized table you need this is
 

00:01:34.690 --> 00:01:36.660 align:start position:0%
create any sized table you need this is
looking<00:01:34.990><c> pretty</c><00:01:35.170><c> good</c><00:01:35.290><c> I</c><00:01:35.650><c> think</c><00:01:36.280><c> I'm</c><00:01:36.400><c> ready</c><00:01:36.520><c> to</c>

00:01:36.660 --> 00:01:36.670 align:start position:0%
looking pretty good I think I'm ready to
 

00:01:36.670 --> 00:01:38.310 align:start position:0%
looking pretty good I think I'm ready to
try<00:01:36.909><c> some</c><00:01:37.180><c> different</c><00:01:37.299><c> formatting</c><00:01:37.900><c> options</c>

00:01:38.310 --> 00:01:38.320 align:start position:0%
try some different formatting options
 

00:01:38.320 --> 00:01:41.039 align:start position:0%
try some different formatting options
now<00:01:38.729><c> for</c><00:01:39.729><c> that</c><00:01:39.850><c> you'll</c><00:01:40.180><c> find</c><00:01:40.420><c> everything</c><00:01:40.930><c> you</c>

00:01:41.039 --> 00:01:41.049 align:start position:0%
now for that you'll find everything you
 

00:01:41.049 --> 00:01:42.840 align:start position:0%
now for that you'll find everything you
need<00:01:41.260><c> on</c><00:01:41.409><c> the</c><00:01:41.650><c> design</c><00:01:41.979><c> tab</c><00:01:42.220><c> which</c><00:01:42.700><c> appears</c>

00:01:42.840 --> 00:01:42.850 align:start position:0%
need on the design tab which appears
 

00:01:42.850 --> 00:01:45.770 align:start position:0%
need on the design tab which appears
anytime<00:01:43.600><c> you</c><00:01:43.750><c> have</c><00:01:43.869><c> your</c><00:01:43.930><c> table</c><00:01:44.200><c> selected</c>

00:01:45.770 --> 00:01:45.780 align:start position:0%
anytime you have your table selected
 

00:01:45.780 --> 00:01:47.730 align:start position:0%
anytime you have your table selected
remember<00:01:46.780><c> how</c><00:01:46.930><c> I</c><00:01:46.960><c> said</c><00:01:47.110><c> you</c><00:01:47.380><c> could</c><00:01:47.530><c> change</c>

00:01:47.730 --> 00:01:47.740 align:start position:0%
remember how I said you could change
 

00:01:47.740 --> 00:01:49.440 align:start position:0%
remember how I said you could change
your<00:01:47.920><c> table</c><00:01:48.220><c> style</c><00:01:48.460><c> once</c><00:01:48.729><c> you</c><00:01:48.880><c> added</c><00:01:49.060><c> one</c><00:01:49.330><c> to</c>

00:01:49.440 --> 00:01:49.450 align:start position:0%
your table style once you added one to
 

00:01:49.450 --> 00:01:51.840 align:start position:0%
your table style once you added one to
your<00:01:49.570><c> worksheet</c><00:01:49.930><c> you</c><00:01:50.799><c> can</c><00:01:50.830><c> do</c><00:01:51.100><c> that</c><00:01:51.280><c> here</c>

00:01:51.840 --> 00:01:51.850 align:start position:0%
your worksheet you can do that here
 

00:01:51.850 --> 00:01:53.700 align:start position:0%
your worksheet you can do that here
using<00:01:52.150><c> the</c><00:01:52.270><c> options</c><00:01:52.720><c> in</c><00:01:52.900><c> the</c><00:01:52.990><c> table</c><00:01:53.320><c> Styles</c>

00:01:53.700 --> 00:01:53.710 align:start position:0%
using the options in the table Styles
 

00:01:53.710 --> 00:01:56.600 align:start position:0%
using the options in the table Styles
group<00:01:53.920><c> and</c><00:01:54.250><c> this</c><00:01:55.240><c> time</c><00:01:55.540><c> you</c><00:01:55.689><c> get</c><00:01:55.810><c> a</c><00:01:55.869><c> preview</c>

00:01:56.600 --> 00:01:56.610 align:start position:0%
group and this time you get a preview
 

00:01:56.610 --> 00:01:58.980 align:start position:0%
group and this time you get a preview
this<00:01:57.610><c> is</c><00:01:57.820><c> one</c><00:01:58.000><c> of</c><00:01:58.119><c> the</c><00:01:58.240><c> benefits</c><00:01:58.659><c> of</c><00:01:58.810><c> using</c>

00:01:58.980 --> 00:01:58.990 align:start position:0%
this is one of the benefits of using
 

00:01:58.990 --> 00:02:01.350 align:start position:0%
this is one of the benefits of using
tables<00:01:59.500><c> in</c><00:01:59.650><c> Excel</c><00:01:59.710><c> they</c><00:02:00.700><c> make</c><00:02:00.909><c> it</c><00:02:01.030><c> easy</c><00:02:01.270><c> to</c>

00:02:01.350 --> 00:02:01.360 align:start position:0%
tables in Excel they make it easy to
 

00:02:01.360 --> 00:02:02.550 align:start position:0%
tables in Excel they make it easy to
change<00:02:01.720><c> the</c><00:02:01.930><c> look</c><00:02:02.080><c> and</c><00:02:02.200><c> feel</c><00:02:02.290><c> of</c><00:02:02.530><c> your</c>

00:02:02.550 --> 00:02:02.560 align:start position:0%
change the look and feel of your
 

00:02:02.560 --> 00:02:04.440 align:start position:0%
change the look and feel of your
worksheet<00:02:03.070><c> and</c><00:02:03.220><c> it's</c><00:02:03.580><c> a</c><00:02:03.670><c> lot</c><00:02:03.880><c> faster</c><00:02:04.090><c> than</c>

00:02:04.440 --> 00:02:04.450 align:start position:0%
worksheet and it's a lot faster than
 

00:02:04.450 --> 00:02:07.020 align:start position:0%
worksheet and it's a lot faster than
formatting<00:02:04.960><c> the</c><00:02:05.049><c> cells</c><00:02:05.290><c> yourself</c><00:02:05.850><c> why</c><00:02:06.850><c> don't</c>

00:02:07.020 --> 00:02:07.030 align:start position:0%
formatting the cells yourself why don't
 

00:02:07.030 --> 00:02:09.199 align:start position:0%
formatting the cells yourself why don't
we<00:02:07.090><c> go</c><00:02:07.210><c> with</c><00:02:07.360><c> this</c><00:02:07.479><c> one</c>

00:02:09.199 --> 00:02:09.209 align:start position:0%
we go with this one
 

00:02:09.209 --> 00:02:12.000 align:start position:0%
we go with this one
next<00:02:10.209><c> to</c><00:02:10.299><c> the</c><00:02:10.420><c> table</c><00:02:10.569><c> Styles</c><00:02:11.110><c> Excel</c><00:02:11.680><c> gives</c><00:02:11.829><c> you</c>

00:02:12.000 --> 00:02:12.010 align:start position:0%
next to the table Styles Excel gives you
 

00:02:12.010 --> 00:02:13.860 align:start position:0%
next to the table Styles Excel gives you
a<00:02:12.040><c> few</c><00:02:12.340><c> more</c><00:02:12.400><c> options</c><00:02:12.970><c> for</c><00:02:13.060><c> customizing</c><00:02:13.629><c> your</c>

00:02:13.860 --> 00:02:13.870 align:start position:0%
a few more options for customizing your
 

00:02:13.870 --> 00:02:16.559 align:start position:0%
a few more options for customizing your
table<00:02:14.319><c> for</c><00:02:15.129><c> example</c><00:02:15.220><c> you</c><00:02:15.760><c> could</c><00:02:15.879><c> add</c><00:02:15.939><c> special</c>

00:02:16.559 --> 00:02:16.569 align:start position:0%
table for example you could add special
 

00:02:16.569 --> 00:02:18.510 align:start position:0%
table for example you could add special
formatting<00:02:17.020><c> to</c><00:02:17.260><c> the</c><00:02:17.290><c> last</c><00:02:17.590><c> column</c><00:02:18.069><c> to</c><00:02:18.250><c> make</c><00:02:18.370><c> it</c>

00:02:18.510 --> 00:02:18.520 align:start position:0%
formatting to the last column to make it
 

00:02:18.520 --> 00:02:22.559 align:start position:0%
formatting to the last column to make it
stand<00:02:18.730><c> out</c><00:02:18.970><c> or</c><00:02:19.239><c> you</c><00:02:20.170><c> could</c><00:02:20.319><c> add</c><00:02:20.500><c> a</c><00:02:20.530><c> total</c><00:02:20.830><c> row</c>

00:02:22.559 --> 00:02:22.569 align:start position:0%
stand out or you could add a total row
 

00:02:22.569 --> 00:02:23.819 align:start position:0%
stand out or you could add a total row
these<00:02:22.749><c> will</c><00:02:22.959><c> all</c><00:02:23.140><c> look</c><00:02:23.379><c> slightly</c><00:02:23.650><c> different</c>

00:02:23.819 --> 00:02:23.829 align:start position:0%
these will all look slightly different
 

00:02:23.829 --> 00:02:25.559 align:start position:0%
these will all look slightly different
depending<00:02:24.609><c> on</c><00:02:24.670><c> the</c><00:02:24.730><c> table</c><00:02:24.969><c> style</c><00:02:25.180><c> you've</c>

00:02:25.559 --> 00:02:25.569 align:start position:0%
depending on the table style you've
 

00:02:25.569 --> 00:02:27.300 align:start position:0%
depending on the table style you've
chosen<00:02:25.840><c> so</c><00:02:26.349><c> you</c><00:02:26.409><c> might</c><00:02:26.650><c> need</c><00:02:26.769><c> to</c><00:02:26.920><c> experiment</c>

00:02:27.300 --> 00:02:27.310 align:start position:0%
chosen so you might need to experiment
 

00:02:27.310 --> 00:02:30.720 align:start position:0%
chosen so you might need to experiment
to<00:02:27.639><c> get</c><00:02:27.730><c> the</c><00:02:27.790><c> look</c><00:02:28.030><c> you</c><00:02:28.060><c> want</c><00:02:29.219><c> if</c><00:02:30.219><c> you</c><00:02:30.459><c> change</c>

00:02:30.720 --> 00:02:30.730 align:start position:0%
to get the look you want if you change
 

00:02:30.730 --> 00:02:32.489 align:start position:0%
to get the look you want if you change
your<00:02:30.879><c> mind</c><00:02:31.150><c> you</c><00:02:31.510><c> can</c><00:02:31.540><c> always</c><00:02:31.810><c> remove</c><00:02:32.290><c> the</c>

00:02:32.489 --> 00:02:32.499 align:start position:0%
your mind you can always remove the
 

00:02:32.499 --> 00:02:34.410 align:start position:0%
your mind you can always remove the
table<00:02:32.680><c> from</c><00:02:32.950><c> your</c><00:02:33.129><c> workbook</c><00:02:33.489><c> without</c><00:02:34.060><c> losing</c>

00:02:34.410 --> 00:02:34.420 align:start position:0%
table from your workbook without losing
 

00:02:34.420 --> 00:02:36.989 align:start position:0%
table from your workbook without losing
any<00:02:34.599><c> of</c><00:02:34.780><c> your</c><00:02:34.900><c> data</c><00:02:35.109><c> just</c><00:02:35.409><c> be</c><00:02:36.310><c> aware</c><00:02:36.579><c> that</c><00:02:36.639><c> this</c>

00:02:36.989 --> 00:02:36.999 align:start position:0%
any of your data just be aware that this
 

00:02:36.999 --> 00:02:39.300 align:start position:0%
any of your data just be aware that this
can<00:02:37.269><c> cause</c><00:02:37.540><c> issues</c><00:02:37.810><c> with</c><00:02:38.019><c> cell</c><00:02:38.439><c> formatting</c><00:02:38.950><c> so</c>

00:02:39.300 --> 00:02:39.310 align:start position:0%
can cause issues with cell formatting so
 

00:02:39.310 --> 00:02:40.740 align:start position:0%
can cause issues with cell formatting so
it<00:02:39.430><c> should</c><00:02:39.579><c> only</c><00:02:39.760><c> be</c><00:02:39.909><c> done</c><00:02:40.180><c> if</c><00:02:40.389><c> you</c><00:02:40.420><c> truly</c>

00:02:40.740 --> 00:02:40.750 align:start position:0%
it should only be done if you truly
 

00:02:40.750 --> 00:02:43.679 align:start position:0%
it should only be done if you truly
intend<00:02:41.170><c> to</c><00:02:41.260><c> start</c><00:02:41.500><c> over</c><00:02:41.939><c> all</c><00:02:42.939><c> you</c><00:02:43.209><c> have</c><00:02:43.389><c> to</c><00:02:43.540><c> do</c>

00:02:43.679 --> 00:02:43.689 align:start position:0%
intend to start over all you have to do
 

00:02:43.689 --> 00:02:45.809 align:start position:0%
intend to start over all you have to do
is<00:02:43.900><c> make</c><00:02:44.139><c> sure</c><00:02:44.170><c> your</c><00:02:44.439><c> table</c><00:02:44.769><c> is</c><00:02:44.889><c> selected</c><00:02:45.040><c> then</c>

00:02:45.809 --> 00:02:45.819 align:start position:0%
is make sure your table is selected then
 

00:02:45.819 --> 00:02:49.640 align:start position:0%
is make sure your table is selected then
click<00:02:45.849><c> convert</c><00:02:46.750><c> to</c><00:02:46.930><c> range</c><00:02:47.200><c> on</c><00:02:47.500><c> the</c><00:02:47.709><c> design</c><00:02:48.010><c> tab</c>

00:02:49.640 --> 00:02:49.650 align:start position:0%
click convert to range on the design tab
 

00:02:49.650 --> 00:02:54.059 align:start position:0%
click convert to range on the design tab
next<00:02:50.650><c> click</c><00:02:51.129><c> Yes</c><00:02:51.370><c> to</c><00:02:51.400><c> confirm</c><00:02:51.639><c> and</c><00:02:52.859><c> the</c><00:02:53.859><c> range</c>

00:02:54.059 --> 00:02:54.069 align:start position:0%
next click Yes to confirm and the range
 

00:02:54.069 --> 00:02:57.569 align:start position:0%
next click Yes to confirm and the range
will<00:02:54.249><c> no</c><00:02:54.430><c> longer</c><00:02:54.639><c> be</c><00:02:54.849><c> a</c><00:02:54.879><c> table</c><00:02:55.919><c> the</c><00:02:56.919><c> design</c><00:02:57.310><c> tab</c>

00:02:57.569 --> 00:02:57.579 align:start position:0%
will no longer be a table the design tab
 

00:02:57.579 --> 00:02:59.369 align:start position:0%
will no longer be a table the design tab
has<00:02:57.790><c> disappeared</c><00:02:58.450><c> but</c><00:02:58.719><c> you</c><00:02:58.870><c> can</c><00:02:59.019><c> still</c><00:02:59.260><c> adjust</c>

00:02:59.369 --> 00:02:59.379 align:start position:0%
has disappeared but you can still adjust
 

00:02:59.379 --> 00:03:01.319 align:start position:0%
has disappeared but you can still adjust
the<00:02:59.739><c> formatting</c><00:02:59.980><c> manually</c><00:03:00.760><c> using</c><00:03:01.239><c> the</c>

00:03:01.319 --> 00:03:01.329 align:start position:0%
the formatting manually using the
 

00:03:01.329 --> 00:03:03.929 align:start position:0%
the formatting manually using the
options<00:03:01.750><c> on</c><00:03:01.900><c> the</c><00:03:02.049><c> Home</c><00:03:02.199><c> tab</c><00:03:02.340><c> you</c><00:03:03.340><c> can</c><00:03:03.519><c> even</c><00:03:03.699><c> use</c>

00:03:03.929 --> 00:03:03.939 align:start position:0%
options on the Home tab you can even use
 

00:03:03.939 --> 00:03:05.580 align:start position:0%
options on the Home tab you can even use
the<00:03:04.120><c> clear</c><00:03:04.359><c> command</c><00:03:04.540><c> to</c><00:03:05.019><c> restart</c><00:03:05.469><c> your</c>

00:03:05.580 --> 00:03:05.590 align:start position:0%
the clear command to restart your
 

00:03:05.590 --> 00:03:08.879 align:start position:0%
the clear command to restart your
formatting<00:03:06.040><c> from</c><00:03:06.219><c> scratch</c><00:03:07.319><c> now</c><00:03:08.319><c> you</c><00:03:08.379><c> know</c><00:03:08.650><c> how</c>

00:03:08.879 --> 00:03:08.889 align:start position:0%
formatting from scratch now you know how
 

00:03:08.889 --> 00:03:15.320 align:start position:0%
formatting from scratch now you know how
to<00:03:08.949><c> add</c><00:03:09.129><c> and</c><00:03:09.370><c> remove</c><00:03:09.400><c> tables</c><00:03:10.060><c> in</c><00:03:10.180><c> Excel</c>

00:03:15.320 --> 00:03:15.330 align:start position:0%
 
 

00:03:15.330 --> 00:03:17.390 align:start position:0%
 
you