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.680 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.680 --> 00:00:10.690 align:start position:0%
 
 

00:00:10.690 --> 00:00:13.600 align:start position:0%
 
tables<00:00:11.690><c> are</c><00:00:11.809><c> a</c><00:00:11.840><c> great</c><00:00:12.139><c> way</c><00:00:12.320><c> to</c><00:00:12.350><c> add</c><00:00:12.680><c> more</c>

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

00:00:13.610 --> 00:00:15.699 align:start position:0%
tables are a great way to add more
adding<00:00:14.000><c> to</c><00:00:14.179><c> your</c><00:00:14.299><c> worksheets</c><00:00:14.750><c> like</c><00:00:15.259><c> banded</c>

00:00:15.699 --> 00:00:15.709 align:start position:0%
adding to your worksheets like banded
 

00:00:15.709 --> 00:00:17.980 align:start position:0%
adding to your worksheets like banded
rows<00:00:15.740><c> preset</c><00:00:16.730><c> color</c><00:00:16.970><c> schemes</c><00:00:17.360><c> and</c><00:00:17.600><c> other</c>

00:00:17.980 --> 00:00:17.990 align:start position:0%
rows preset color schemes and other
 

00:00:17.990 --> 00:00:19.689 align:start position:0%
rows preset color schemes and other
design<00:00:18.380><c> elements</c><00:00:18.860><c> that</c><00:00:18.920><c> can</c><00:00:19.130><c> save</c><00:00:19.369><c> you</c><00:00:19.490><c> tons</c>

00:00:19.689 --> 00:00:19.699 align:start position:0%
design elements that can save you tons
 

00:00:19.699 --> 00:00:23.440 align:start position:0%
design elements that can save you tons
of<00:00:19.910><c> time</c><00:00:20.020><c> let's</c><00:00:21.020><c> take</c><00:00:21.259><c> a</c><00:00:21.289><c> look</c><00:00:22.090><c> to</c><00:00:23.090><c> create</c><00:00:23.300><c> a</c>

00:00:23.440 --> 00:00:23.450 align:start position:0%
of time let's take a look to create a
 

00:00:23.450 --> 00:00:25.659 align:start position:0%
of time let's take a look to create a
table<00:00:23.720><c> all</c><00:00:24.050><c> you</c><00:00:24.470><c> have</c><00:00:24.650><c> to</c><00:00:24.770><c> do</c><00:00:24.919><c> is</c><00:00:25.099><c> select</c><00:00:25.279><c> the</c>

00:00:25.659 --> 00:00:25.669 align:start position:0%
table all you have to do is select the
 

00:00:25.669 --> 00:00:28.749 align:start position:0%
table all you have to do is select the
cells<00:00:25.880><c> you</c><00:00:26.000><c> want</c><00:00:26.180><c> to</c><00:00:26.270><c> include</c><00:00:27.160><c> then</c><00:00:28.160><c> click</c><00:00:28.550><c> the</c>

00:00:28.749 --> 00:00:28.759 align:start position:0%
cells you want to include then click the
 

00:00:28.759 --> 00:00:31.709 align:start position:0%
cells you want to include then click the
format<00:00:29.000><c> as</c><00:00:29.390><c> table</c><00:00:29.630><c> command</c><00:00:30.140><c> on</c><00:00:30.380><c> the</c><00:00:30.500><c> Home</c><00:00:30.649><c> tab</c>

00:00:31.709 --> 00:00:31.719 align:start position:0%
format as table command on the Home tab
 

00:00:31.719 --> 00:00:33.850 align:start position:0%
format as table command on the Home tab
here<00:00:32.719><c> you'll</c><00:00:32.870><c> find</c><00:00:33.079><c> several</c><00:00:33.559><c> different</c>

00:00:33.850 --> 00:00:33.860 align:start position:0%
here you'll find several different
 

00:00:33.860 --> 00:00:35.860 align:start position:0%
here you'll find several different
styles<00:00:34.070><c> to</c><00:00:34.399><c> choose</c><00:00:34.430><c> from</c><00:00:34.910><c> just</c><00:00:35.120><c> pick</c>

00:00:35.860 --> 00:00:35.870 align:start position:0%
styles to choose from just pick
 

00:00:35.870 --> 00:00:37.180 align:start position:0%
styles to choose from just pick
whichever<00:00:36.200><c> one</c><00:00:36.350><c> appeals</c><00:00:36.800><c> to</c><00:00:36.980><c> you</c><00:00:37.040><c> the</c><00:00:37.160><c> most</c>

00:00:37.180 --> 00:00:37.190 align:start position:0%
whichever one appeals to you the most
 

00:00:37.190 --> 00:00:39.220 align:start position:0%
whichever one appeals to you the most
you<00:00:37.910><c> can</c><00:00:38.059><c> always</c><00:00:38.360><c> choose</c><00:00:38.540><c> a</c><00:00:38.600><c> different</c><00:00:38.930><c> table</c>

00:00:39.220 --> 00:00:39.230 align:start position:0%
you can always choose a different table
 

00:00:39.230 --> 00:00:42.880 align:start position:0%
you can always choose a different table
style<00:00:39.620><c> later</c><00:00:39.920><c> if</c><00:00:41.200><c> you</c><00:00:42.200><c> want</c><00:00:42.379><c> your</c><00:00:42.530><c> table</c><00:00:42.800><c> to</c>

00:00:42.880 --> 00:00:42.890 align:start position:0%
style later if you want your table to
 

00:00:42.890 --> 00:00:44.410 align:start position:0%
style later if you want your table to
have<00:00:43.010><c> special</c><00:00:43.430><c> formatting</c><00:00:43.850><c> in</c><00:00:44.090><c> the</c><00:00:44.210><c> header</c>

00:00:44.410 --> 00:00:44.420 align:start position:0%
have special formatting in the header
 

00:00:44.420 --> 00:00:46.440 align:start position:0%
have special formatting in the header
row<00:00:44.510><c> make</c><00:00:45.110><c> sure</c><00:00:45.289><c> you</c><00:00:45.410><c> leave</c><00:00:45.620><c> this</c><00:00:45.829><c> box</c><00:00:46.130><c> checked</c>

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

00:00:46.450 --> 00:00:49.150 align:start position:0%
row make sure you leave this box checked
you<00:00:47.450><c> can</c><00:00:47.630><c> also</c><00:00:47.780><c> change</c><00:00:48.170><c> the</c><00:00:48.470><c> selection</c><00:00:48.770><c> if</c><00:00:49.040><c> you</c>

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

00:00:49.160 --> 00:00:53.490 align:start position:0%
you can also change the selection if you
need<00:00:49.340><c> to</c><00:00:50.560><c> when</c><00:00:51.560><c> you're</c><00:00:51.710><c> ready</c><00:00:51.920><c> click</c><00:00:52.310><c> OK</c><00:00:52.460><c> and</c>

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

00:00:53.500 --> 00:00:57.910 align:start position:0%
need to when you're ready click OK and
now<00:00:54.500><c> we</c><00:00:54.560><c> have</c><00:00:54.800><c> a</c><00:00:54.829><c> table</c><00:00:56.380><c> notice</c><00:00:57.380><c> that</c><00:00:57.650><c> every</c>

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

00:00:57.920 --> 00:00:59.800 align:start position:0%
now we have a table notice that every
table<00:00:58.250><c> includes</c><00:00:58.700><c> filtering</c><00:00:59.270><c> by</c><00:00:59.420><c> default</c>

00:00:59.800 --> 00:00:59.810 align:start position:0%
table includes filtering by default
 

00:00:59.810 --> 00:01:01.720 align:start position:0%
table includes filtering by default
which<00:01:00.320><c> will</c><00:01:00.530><c> let</c><00:01:00.649><c> you</c><00:01:00.770><c> sort</c><00:01:01.070><c> your</c><00:01:01.250><c> data</c><00:01:01.280><c> or</c>

00:01:01.720 --> 00:01:01.730 align:start position:0%
which will let you sort your data or
 

00:01:01.730 --> 00:01:03.280 align:start position:0%
which will let you sort your data or
narrow<00:01:02.060><c> it</c><00:01:02.210><c> down</c><00:01:02.270><c> depending</c><00:01:02.780><c> on</c><00:01:02.989><c> what</c><00:01:03.200><c> you</c>

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

00:01:03.290 --> 00:01:05.830 align:start position:0%
narrow it down depending on what you
need<00:01:03.530><c> you</c><00:01:04.399><c> can</c><00:01:04.579><c> apply</c><00:01:04.820><c> filtering</c><00:01:05.269><c> anytime</c>

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

00:01:05.840 --> 00:01:10.450 align:start position:0%
need you can apply filtering anytime
using<00:01:06.380><c> the</c><00:01:06.500><c> drop</c><00:01:06.710><c> down</c><00:01:06.920><c> arrows</c><00:01:07.220><c> here</c><00:01:08.770><c> if</c><00:01:09.770><c> you</c>

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

00:01:10.460 --> 00:01:12.310 align:start position:0%
using the drop down arrows here if you
need<00:01:10.640><c> to</c><00:01:10.759><c> fit</c><00:01:10.909><c> more</c><00:01:11.090><c> content</c><00:01:11.600><c> into</c><00:01:11.869><c> your</c><00:01:11.990><c> table</c>

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

00:01:12.320 --> 00:01:15.160 align:start position:0%
need to fit more content into your table
not<00:01:12.740><c> to</c><00:01:12.950><c> worry</c><00:01:13.280><c> Excel</c><00:01:14.180><c> gives</c><00:01:14.329><c> you</c><00:01:14.509><c> two</c><00:01:14.750><c> ways</c><00:01:14.960><c> to</c>

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

00:01:15.170 --> 00:01:17.139 align:start position:0%
not to worry Excel gives you two ways to
add<00:01:15.320><c> more</c><00:01:15.590><c> columns</c><00:01:15.829><c> or</c><00:01:16.189><c> rows</c><00:01:16.219><c> in</c><00:01:16.729><c> the</c><00:01:16.939><c> same</c>

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

00:01:17.149 --> 00:01:19.870 align:start position:0%
add more columns or rows in the same
style<00:01:17.479><c> as</c><00:01:17.690><c> the</c><00:01:17.750><c> rest</c><00:01:18.049><c> of</c><00:01:18.200><c> the</c><00:01:18.290><c> table</c><00:01:18.880><c> just</c>

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

00:01:19.880 --> 00:01:21.910 align:start position:0%
style as the rest of the table just
select<00:01:20.180><c> a</c><00:01:20.299><c> cell</c><00:01:20.330><c> in</c><00:01:20.570><c> the</c><00:01:20.870><c> last</c><00:01:21.080><c> column</c><00:01:21.560><c> or</c><00:01:21.680><c> row</c>

00:01:21.910 --> 00:01:21.920 align:start position:0%
select a cell in the last column or row
 

00:01:21.920 --> 00:01:27.670 align:start position:0%
select a cell in the last column or row
then<00:01:22.310><c> start</c><00:01:22.670><c> typing</c><00:01:22.880><c> in</c><00:01:23.210><c> a</c><00:01:23.299><c> new</c><00:01:23.479><c> cell</c><00:01:26.650><c> or</c><00:01:27.650><c> you</c>

00:01:27.670 --> 00:01:27.680 align:start position:0%
then start typing in a new cell or you
 

00:01:27.680 --> 00:01:30.399 align:start position:0%
then start typing in a new cell or you
can<00:01:28.549><c> click</c><00:01:28.820><c> hold</c><00:01:29.180><c> and</c><00:01:29.360><c> drag</c><00:01:29.540><c> the</c><00:01:29.690><c> bottom</c><00:01:30.229><c> right</c>

00:01:30.399 --> 00:01:30.409 align:start position:0%
can click hold and drag the bottom right
 

00:01:30.409 --> 00:01:32.380 align:start position:0%
can click hold and drag the bottom right
corner<00:01:30.770><c> of</c><00:01:30.799><c> the</c><00:01:30.979><c> table</c><00:01:31.340><c> to</c><00:01:31.549><c> create</c><00:01:31.850><c> any</c><00:01:32.060><c> size</c>

00:01:32.380 --> 00:01:32.390 align:start position:0%
corner of the table to create any size
 

00:01:32.390 --> 00:01:38.320 align:start position:0%
corner of the table to create any size
you<00:01:32.600><c> need</c><00:01:36.130><c> this</c><00:01:37.130><c> is</c><00:01:37.340><c> looking</c><00:01:37.640><c> pretty</c><00:01:37.700><c> good</c><00:01:38.150><c> I</c>

00:01:38.320 --> 00:01:38.330 align:start position:0%
you need this is looking pretty good I
 

00:01:38.330 --> 00:01:39.969 align:start position:0%
you need this is looking pretty good I
think<00:01:38.960><c> I'm</c><00:01:39.080><c> ready</c><00:01:39.200><c> to</c><00:01:39.350><c> try</c><00:01:39.590><c> some</c><00:01:39.860><c> different</c>

00:01:39.969 --> 00:01:39.979 align:start position:0%
think I'm ready to try some different
 

00:01:39.979 --> 00:01:42.850 align:start position:0%
think I'm ready to try some different
formatting<00:01:40.580><c> options</c><00:01:40.760><c> now</c><00:01:41.240><c> for</c><00:01:41.560><c> that</c><00:01:42.560><c> you'll</c>

00:01:42.850 --> 00:01:42.860 align:start position:0%
formatting options now for that you'll
 

00:01:42.860 --> 00:01:44.649 align:start position:0%
formatting options now for that you'll
find<00:01:43.100><c> everything</c><00:01:43.610><c> you</c><00:01:43.729><c> need</c><00:01:43.939><c> on</c><00:01:44.119><c> the</c><00:01:44.330><c> design</c>

00:01:44.649 --> 00:01:44.659 align:start position:0%
find everything you need on the design
 

00:01:44.659 --> 00:01:46.630 align:start position:0%
find everything you need on the design
tab<00:01:44.900><c> which</c><00:01:45.380><c> appears</c><00:01:45.560><c> anytime</c><00:01:46.310><c> you</c><00:01:46.430><c> have</c><00:01:46.580><c> your</c>

00:01:46.630 --> 00:01:46.640 align:start position:0%
tab which appears anytime you have your
 

00:01:46.640 --> 00:01:50.050 align:start position:0%
tab which appears anytime you have your
table<00:01:46.880><c> selected</c><00:01:48.460><c> remember</c><00:01:49.460><c> how</c><00:01:49.610><c> I</c><00:01:49.640><c> said</c><00:01:49.790><c> you</c>

00:01:50.050 --> 00:01:50.060 align:start position:0%
table selected remember how I said you
 

00:01:50.060 --> 00:01:51.550 align:start position:0%
table selected remember how I said you
could<00:01:50.240><c> change</c><00:01:50.420><c> your</c><00:01:50.510><c> table</c><00:01:50.900><c> style</c><00:01:51.140><c> once</c><00:01:51.439><c> you</c>

00:01:51.550 --> 00:01:51.560 align:start position:0%
could change your table style once you
 

00:01:51.560 --> 00:01:53.800 align:start position:0%
could change your table style once you
added<00:01:51.770><c> one</c><00:01:52.010><c> to</c><00:01:52.159><c> your</c><00:01:52.280><c> worksheet</c><00:01:52.670><c> you</c><00:01:53.479><c> can</c><00:01:53.659><c> do</c>

00:01:53.800 --> 00:01:53.810 align:start position:0%
added one to your worksheet you can do
 

00:01:53.810 --> 00:01:56.020 align:start position:0%
added one to your worksheet you can do
that<00:01:53.990><c> here</c><00:01:54.439><c> using</c><00:01:54.860><c> the</c><00:01:54.979><c> options</c><00:01:55.400><c> in</c><00:01:55.549><c> the</c><00:01:55.700><c> table</c>

00:01:56.020 --> 00:01:56.030 align:start position:0%
that here using the options in the table
 

00:01:56.030 --> 00:01:58.570 align:start position:0%
that here using the options in the table
Styles<00:01:56.420><c> group</c><00:01:56.720><c> and</c><00:01:56.960><c> this</c><00:01:57.950><c> time</c><00:01:58.220><c> you</c><00:01:58.400><c> get</c><00:01:58.520><c> a</c>

00:01:58.570 --> 00:01:58.580 align:start position:0%
Styles group and this time you get a
 

00:01:58.580 --> 00:02:01.510 align:start position:0%
Styles group and this time you get a
preview<00:01:59.350><c> this</c><00:02:00.350><c> is</c><00:02:00.530><c> one</c><00:02:00.710><c> of</c><00:02:00.740><c> the</c><00:02:00.920><c> benefits</c><00:02:01.369><c> of</c>

00:02:01.510 --> 00:02:01.520 align:start position:0%
preview this is one of the benefits of
 

00:02:01.520 --> 00:02:03.969 align:start position:0%
preview this is one of the benefits of
using<00:02:01.700><c> tables</c><00:02:02.210><c> in</c><00:02:02.330><c> Excel</c><00:02:02.420><c> they</c><00:02:03.409><c> make</c><00:02:03.619><c> it</c><00:02:03.740><c> easy</c>

00:02:03.969 --> 00:02:03.979 align:start position:0%
using tables in Excel they make it easy
 

00:02:03.979 --> 00:02:05.260 align:start position:0%
using tables in Excel they make it easy
to<00:02:04.070><c> change</c><00:02:04.430><c> the</c><00:02:04.640><c> look</c><00:02:04.759><c> and</c><00:02:04.880><c> feel</c><00:02:04.970><c> of</c><00:02:05.240><c> your</c>

00:02:05.260 --> 00:02:05.270 align:start position:0%
to change the look and feel of your
 

00:02:05.270 --> 00:02:07.149 align:start position:0%
to change the look and feel of your
worksheet<00:02:05.780><c> and</c><00:02:05.930><c> it's</c><00:02:06.259><c> a</c><00:02:06.380><c> lot</c><00:02:06.590><c> faster</c><00:02:07.040><c> than</c>

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

00:02:07.159 --> 00:02:09.729 align:start position:0%
worksheet and it's a lot faster than
formatting<00:02:07.670><c> the</c><00:02:07.759><c> cells</c><00:02:08.000><c> yourself</c><00:02:08.560><c> why</c><00:02:09.560><c> don't</c>

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

00:02:09.739 --> 00:02:13.270 align:start position:0%
formatting the cells yourself why don't
we<00:02:09.799><c> go</c><00:02:09.920><c> with</c><00:02:10.069><c> this</c><00:02:10.189><c> one</c><00:02:11.950><c> next</c><00:02:12.950><c> to</c><00:02:13.040><c> the</c><00:02:13.129><c> table</c>

00:02:13.270 --> 00:02:13.280 align:start position:0%
we go with this one next to the table
 

00:02:13.280 --> 00:02:15.130 align:start position:0%
we go with this one next to the table
Styles<00:02:13.819><c> Excel</c><00:02:14.390><c> gives</c><00:02:14.599><c> you</c><00:02:14.750><c> a</c><00:02:14.780><c> few</c><00:02:15.079><c> more</c>

00:02:15.130 --> 00:02:15.140 align:start position:0%
Styles Excel gives you a few more
 

00:02:15.140 --> 00:02:17.199 align:start position:0%
Styles Excel gives you a few more
options<00:02:15.290><c> for</c><00:02:15.769><c> customizing</c><00:02:16.370><c> your</c><00:02:16.610><c> table</c><00:02:17.060><c> for</c>

00:02:17.199 --> 00:02:17.209 align:start position:0%
options for customizing your table for
 

00:02:17.209 --> 00:02:19.720 align:start position:0%
options for customizing your table for
example<00:02:17.930><c> you</c><00:02:18.470><c> could</c><00:02:18.620><c> add</c><00:02:18.799><c> special</c><00:02:19.280><c> formatting</c>

00:02:19.720 --> 00:02:19.730 align:start position:0%
example you could add special formatting
 

00:02:19.730 --> 00:02:21.670 align:start position:0%
example you could add special formatting
to<00:02:20.000><c> the</c><00:02:20.030><c> last</c><00:02:20.299><c> column</c><00:02:20.629><c> to</c><00:02:20.959><c> make</c><00:02:21.079><c> it</c><00:02:21.230><c> stand</c><00:02:21.500><c> out</c>

00:02:21.670 --> 00:02:21.680 align:start position:0%
to the last column to make it stand out
 

00:02:21.680 --> 00:02:25.660 align:start position:0%
to the last column to make it stand out
or<00:02:22.010><c> you</c><00:02:22.880><c> could</c><00:02:23.060><c> add</c><00:02:23.209><c> a</c><00:02:23.239><c> total</c><00:02:23.540><c> row</c><00:02:24.430><c> these</c><00:02:25.430><c> will</c>

00:02:25.660 --> 00:02:25.670 align:start position:0%
or you could add a total row these will
 

00:02:25.670 --> 00:02:27.410 align:start position:0%
or you could add a total row these will
all<00:02:25.880><c> look</c><00:02:26.090><c> slightly</c><00:02:26.390><c> different</c><00:02:26.569><c> depending</c>

00:02:27.410 --> 00:02:27.420 align:start position:0%
all look slightly different depending
 

00:02:27.420 --> 00:02:29.150 align:start position:0%
all look slightly different depending
the<00:02:27.540><c> table</c><00:02:27.870><c> style</c><00:02:28.050><c> you've</c><00:02:28.290><c> chosen</c><00:02:28.590><c> so</c><00:02:29.099><c> you</c>

00:02:29.150 --> 00:02:29.160 align:start position:0%
the table style you've chosen so you
 

00:02:29.160 --> 00:02:30.710 align:start position:0%
the table style you've chosen so you
might<00:02:29.370><c> need</c><00:02:29.520><c> to</c><00:02:29.580><c> experiment</c><00:02:30.060><c> to</c><00:02:30.360><c> get</c><00:02:30.510><c> the</c><00:02:30.599><c> look</c>

00:02:30.710 --> 00:02:30.720 align:start position:0%
might need to experiment to get the look
 

00:02:30.720 --> 00:02:34.250 align:start position:0%
might need to experiment to get the look
you<00:02:30.780><c> want</c><00:02:31.280><c> if</c><00:02:32.280><c> you</c><00:02:33.180><c> change</c><00:02:33.480><c> your</c><00:02:33.630><c> mind</c><00:02:33.870><c> you</c><00:02:34.230><c> can</c>

00:02:34.250 --> 00:02:34.260 align:start position:0%
you want if you change your mind you can
 

00:02:34.260 --> 00:02:35.839 align:start position:0%
you want if you change your mind you can
always<00:02:34.590><c> remove</c><00:02:34.739><c> the</c><00:02:35.250><c> table</c><00:02:35.550><c> from</c><00:02:35.700><c> your</c>

00:02:35.839 --> 00:02:35.849 align:start position:0%
always remove the table from your
 

00:02:35.849 --> 00:02:37.490 align:start position:0%
always remove the table from your
workbook<00:02:36.239><c> without</c><00:02:36.810><c> losing</c><00:02:37.170><c> any</c><00:02:37.319><c> of</c><00:02:37.410><c> the</c>

00:02:37.490 --> 00:02:37.500 align:start position:0%
workbook without losing any of the
 

00:02:37.500 --> 00:02:40.280 align:start position:0%
workbook without losing any of the
formatting<00:02:37.950><c> or</c><00:02:38.310><c> the</c><00:02:38.489><c> data</c><00:02:38.780><c> you</c><00:02:39.780><c> will</c><00:02:40.020><c> lose</c>

00:02:40.280 --> 00:02:40.290 align:start position:0%
formatting or the data you will lose
 

00:02:40.290 --> 00:02:42.320 align:start position:0%
formatting or the data you will lose
some<00:02:40.560><c> functionality</c><00:02:41.280><c> though</c><00:02:41.430><c> like</c><00:02:41.970><c> table</c>

00:02:42.320 --> 00:02:42.330 align:start position:0%
some functionality though like table
 

00:02:42.330 --> 00:02:44.510 align:start position:0%
some functionality though like table
Styles<00:02:42.720><c> and</c><00:02:42.900><c> filtering</c><00:02:43.349><c> so</c><00:02:43.950><c> keep</c><00:02:44.160><c> this</c><00:02:44.340><c> in</c>

00:02:44.510 --> 00:02:44.520 align:start position:0%
Styles and filtering so keep this in
 

00:02:44.520 --> 00:02:45.830 align:start position:0%
Styles and filtering so keep this in
mind<00:02:44.700><c> before</c><00:02:44.970><c> you</c><00:02:45.180><c> go</c><00:02:45.390><c> through</c><00:02:45.600><c> with</c><00:02:45.720><c> the</c>

00:02:45.830 --> 00:02:45.840 align:start position:0%
mind before you go through with the
 

00:02:45.840 --> 00:02:48.800 align:start position:0%
mind before you go through with the
steps<00:02:46.110><c> all</c><00:02:46.880><c> you</c><00:02:47.880><c> have</c><00:02:48.060><c> to</c><00:02:48.180><c> do</c><00:02:48.360><c> is</c><00:02:48.569><c> make</c><00:02:48.780><c> sure</c>

00:02:48.800 --> 00:02:48.810 align:start position:0%
steps all you have to do is make sure
 

00:02:48.810 --> 00:02:50.510 align:start position:0%
steps all you have to do is make sure
your<00:02:49.110><c> table</c><00:02:49.440><c> is</c><00:02:49.560><c> selected</c><00:02:49.709><c> then</c><00:02:50.489><c> click</c>

00:02:50.510 --> 00:02:50.520 align:start position:0%
your table is selected then click
 

00:02:50.520 --> 00:02:55.309 align:start position:0%
your table is selected then click
convert<00:02:51.420><c> to</c><00:02:51.600><c> range</c><00:02:51.870><c> on</c><00:02:52.140><c> the</c><00:02:52.350><c> design</c><00:02:52.680><c> tab</c><00:02:54.319><c> next</c>

00:02:55.309 --> 00:02:55.319 align:start position:0%
convert to range on the design tab next
 

00:02:55.319 --> 00:02:58.970 align:start position:0%
convert to range on the design tab next
click<00:02:55.830><c> Yes</c><00:02:56.069><c> to</c><00:02:56.100><c> confirm</c><00:02:56.340><c> and</c><00:02:57.560><c> the</c><00:02:58.560><c> range</c><00:02:58.769><c> will</c>

00:02:58.970 --> 00:02:58.980 align:start position:0%
click Yes to confirm and the range will
 

00:02:58.980 --> 00:03:02.479 align:start position:0%
click Yes to confirm and the range will
no<00:02:59.130><c> longer</c><00:02:59.340><c> be</c><00:02:59.550><c> a</c><00:02:59.580><c> table</c><00:03:00.620><c> the</c><00:03:01.620><c> design</c><00:03:02.010><c> tab</c><00:03:02.280><c> has</c>

00:03:02.479 --> 00:03:02.489 align:start position:0%
no longer be a table the design tab has
 

00:03:02.489 --> 00:03:04.430 align:start position:0%
no longer be a table the design tab has
disappeared<00:03:03.150><c> but</c><00:03:03.450><c> you</c><00:03:03.569><c> can</c><00:03:03.720><c> still</c><00:03:03.959><c> adjust</c><00:03:04.080><c> the</c>

00:03:04.430 --> 00:03:04.440 align:start position:0%
disappeared but you can still adjust the
 

00:03:04.440 --> 00:03:06.680 align:start position:0%
disappeared but you can still adjust the
formatting<00:03:04.680><c> manually</c><00:03:05.459><c> using</c><00:03:05.970><c> the</c><00:03:06.060><c> options</c><00:03:06.510><c> on</c>

00:03:06.680 --> 00:03:06.690 align:start position:0%
formatting manually using the options on
 

00:03:06.690 --> 00:03:10.130 align:start position:0%
formatting manually using the options on
the<00:03:06.840><c> Home</c><00:03:07.019><c> tab</c><00:03:08.090><c> now</c><00:03:09.090><c> you</c><00:03:09.150><c> know</c><00:03:09.420><c> how</c><00:03:09.660><c> to</c><00:03:09.690><c> add</c><00:03:09.900><c> and</c>

00:03:10.130 --> 00:03:10.140 align:start position:0%
the Home tab now you know how to add and
 

00:03:10.140 --> 00:03:16.150 align:start position:0%
the Home tab now you know how to add and
remove<00:03:10.170><c> tables</c><00:03:10.830><c> in</c><00:03:10.950><c> Excel</c>

00:03:16.150 --> 00:03:16.160 align:start position:0%
 
 

00:03:16.160 --> 00:03:18.220 align:start position:0%
 
you