WEBVTT
Kind: captions
Language: en

00:00:09.890 --> 00:00:13.570
I'm creating an invoice for a pasta company,
and

00:00:13.570 --> 00:00:15.100
I've entered all of the data,

00:00:15.100 --> 00:00:17.170
but it still feels
like something's missing.

00:00:17.170 --> 00:00:19.789
I think if it had some more color it would
look a

00:00:19.789 --> 00:00:23.289
lot better and feel more unified.

00:00:23.289 --> 00:00:25.300
Tables are a great way of doing this because
they

00:00:25.300 --> 00:00:26.179
allow you to quickly

00:00:26.179 --> 00:00:31.900
change the background colors,
borders, and font colors at the same time.

00:00:31.900 --> 00:00:35.070
To get started, select the cells that you
want to

00:00:35.070 --> 00:00:37.440
include in your table,

00:00:37.440 --> 00:00:40.820
and then go to Format as Table.

00:00:40.820 --> 00:00:46.090
And you'll see a list of all of the built-in
styles.

00:00:46.090 --> 00:00:49.710
And I think this one looks good.

00:00:49.710 --> 00:00:52.010
If you want your table to have headers, then
make

00:00:52.010 --> 00:00:55.510
sure this box is checked.

00:00:55.510 --> 00:00:57.429
And here you can also change the selection
if you

00:00:57.429 --> 00:00:58.969
need to.

00:00:58.969 --> 00:01:02.480
And then click OK.

00:01:02.480 --> 00:01:05.510
And there's our table! It already looks a
lot

00:01:05.510 --> 00:01:06.680
better, and we can

00:01:06.680 --> 00:01:10.360
make some more changes to by
clicking on it and then going to the Design

00:01:10.360 --> 00:01:10.729
tab.

00:01:10.729 --> 00:01:15.060
Let's say I needed to add a few more items
to this

00:01:15.060 --> 00:01:16.170
invoice,

00:01:16.170 --> 00:01:20.570
and I want to make sure they are also
included as part of this table.

00:01:20.570 --> 00:01:24.970
All I have to do is click Resize Table, and
then

00:01:24.970 --> 00:01:27.850
select a new range for the table.

00:01:27.850 --> 00:01:30.490
And make sure to include the original cells
in

00:01:30.490 --> 00:01:35.689
your selection.

00:01:35.689 --> 00:01:38.119
You can also resize the table by just clicking
and

00:01:38.119 --> 00:01:44.130
dragging the bottom-right corner.

00:01:44.130 --> 00:01:46.380
I think I'd like to try some different colors,

00:01:46.380 --> 00:01:53.380
so I'll just go up to the Table Styles group
and pick a different style.

00:01:57.430 --> 00:02:01.939
Next to the Styles, you have several different
options to fine-tune the look of your table.

00:02:01.939 --> 00:02:08.280
I'll just click the Last Column checkbox to
emphasize that column.

00:02:08.280 --> 00:02:11.720
And I'll also add a Total Row.

00:02:11.720 --> 00:02:13.370
You'll probably need to experiment with these
a

00:02:13.370 --> 00:02:14.200
little bit because

00:02:14.200 --> 00:02:20.160
they can look very different
depending on which table style you're using.

00:02:20.160 --> 00:02:22.530
There's one more feature I'd like you to notice.

00:02:22.530 --> 00:02:25.310
Whenever you create a table,
it will automatically add a

00:02:25.310 --> 00:02:29.170
Sort & Filter drop-down arrow on each
column.

00:02:29.170 --> 00:02:31.269
This makes it easier to organize the data
within

00:02:31.269 --> 00:02:33.459
the table.

00:02:33.459 --> 00:02:40.459
So in addition to making your data look better,
tables can also make it easier to manage.