WEBVTT
X-TIMESTAMP-MAP=LOCAL:00:00:00.000,MPEGTS:0

00:00:07.040 --> 00:00:10.230
So that we don't mess up our lovely long document,

00:00:10.230 --> 00:00:13.800
we're going to do this exercise in a new document, just a blank one.

00:00:13.800 --> 00:00:16.640
Just keep it separate because we can do lots of versions of

00:00:16.640 --> 00:00:19.595
it and we've got no real space to do it in the other document.

00:00:19.595 --> 00:00:24.940
What we need to do is show you the different ways that you can bring in tables into Word.

00:00:24.940 --> 00:00:27.230
Lots of the time they'll come through and just be fine.

00:00:27.230 --> 00:00:31.245
I go to "File" and I go to "Place" and I find out,

00:00:31.245 --> 00:00:34.260
we're going to use Table Example Word One.

00:00:34.260 --> 00:00:36.430
So make sure you bring it in from Word first.

00:00:36.430 --> 00:00:40.690
Click "Open" and we click and drag it out and the table was perfect in Word,

00:00:40.690 --> 00:00:44.070
so it's come through perfect in InDesign and no real dramas there.

00:00:44.070 --> 00:00:46.520
Where the dramas do happen if I go to File Place

00:00:46.520 --> 00:00:49.250
now and I bring in the Example of Word Two,

00:00:49.250 --> 00:00:51.510
and I drag this out, this can happen.

00:00:51.510 --> 00:00:53.790
It still looks fine, but it's not a table.

00:00:53.790 --> 00:00:55.725
It's been damn with tabs,

00:00:55.725 --> 00:01:00.440
so there's no actual tables for the lines or it's actually just people have gone through,

00:01:00.440 --> 00:01:03.590
gone to hear, hit "Tab" to separate them out and that's fine.

00:01:03.590 --> 00:01:06.625
But formatting becomes a little bit hard because it's not a table.

00:01:06.625 --> 00:01:08.445
It's easy to adjust to a table.

00:01:08.445 --> 00:01:10.880
Select all the bits you want to be in the table.

00:01:10.880 --> 00:01:12.245
I've just highlighted them all.

00:01:12.245 --> 00:01:15.185
Go to "Table", go "Convert Text To Table".

00:01:15.185 --> 00:01:18.635
By default, it's using the column separator as the Tab.

00:01:18.635 --> 00:01:20.290
You might have commas or something else.

00:01:20.290 --> 00:01:24.080
I'm going to click "Okay" and hey presto, it's a table.

00:01:24.080 --> 00:01:28.310
I might have to do some adjustments just to kind of tidy that in.

00:01:28.310 --> 00:01:30.440
That needs to be a little bit smaller maybe,

00:01:30.440 --> 00:01:32.570
and that needs to be a bit bigger.

00:01:32.570 --> 00:01:35.300
You can mess around with it like we did in the previous example.

00:01:35.300 --> 00:01:37.270
I'm going to put them over him.

00:01:37.270 --> 00:01:41.345
Another example that might come through from Word is

00:01:41.345 --> 00:01:45.095
either the table is not set up right in Word and it comes through a bit weird,

00:01:45.095 --> 00:01:46.790
or you copy and paste it.

00:01:46.790 --> 00:01:48.605
I'm going to open up that example.

00:01:48.605 --> 00:01:51.425
This is my table example Word two.

00:01:51.425 --> 00:01:56.040
I'm just going to copy it and paste it in, and this happens.

00:01:56.040 --> 00:02:00.060
So the tab's there but InDesign hasn't converted them nicely.

00:02:00.060 --> 00:02:02.445
It works just the same as the last example.

00:02:02.445 --> 00:02:05.405
Select everything that you want to be part of this table.

00:02:05.405 --> 00:02:06.750
Go to Table.

00:02:06.750 --> 00:02:08.310
Convert Text To Table. It's the same.

00:02:08.310 --> 00:02:09.725
The tab's separating them,

00:02:09.725 --> 00:02:11.765
and it comes back to looking good again.

00:02:11.765 --> 00:02:14.300
We can go through and play with the lines between them and

00:02:14.300 --> 00:02:17.110
the style formatting like we did in the previous exercise.

00:02:17.110 --> 00:02:20.150
The last one we'll do is I'm just going to move him off to the side,

00:02:20.150 --> 00:02:21.490
is getting it from Excel.

00:02:21.490 --> 00:02:23.135
Same process as Word.

00:02:23.135 --> 00:02:27.710
File Place and there's one in here called Table Example Excel One.

00:02:27.710 --> 00:02:31.955
Click and drag it out and it comes through the same kind of problem.

00:02:31.955 --> 00:02:33.125
This is our Excel file.

00:02:33.125 --> 00:02:35.270
If you need a course on Excel, I've got one.

00:02:35.270 --> 00:02:37.620
I've also got one on Word as well if you want to go check that out.

00:02:37.620 --> 00:02:39.920
But anyway, I'm going to select all of these.

00:02:39.920 --> 00:02:41.660
So this what happens when you place from Excel.

00:02:41.660 --> 00:02:44.150
It does this kind of weird tabbed thing as well.

00:02:44.150 --> 00:02:47.830
But I can fix it just like I did with Word.

00:02:47.830 --> 00:02:50.520
Convert text to table and we're on our way again.

00:02:50.520 --> 00:02:54.425
The nice thing about Excel though is let's say it's a monthly thing,

00:02:54.425 --> 00:02:57.470
its revenue reports or sales reports or something.

00:02:57.470 --> 00:03:00.890
So you go through and you format it and you spend ages making it look nice.

00:03:00.890 --> 00:03:02.600
We'll do a little bit of formatting.

00:03:02.600 --> 00:03:05.440
We'll do Alternating Fills.

00:03:05.440 --> 00:03:08.430
Every Other Row, skip the first row even.

00:03:08.430 --> 00:03:11.265
We've got this, having done some formatting to it.

00:03:11.265 --> 00:03:12.875
Terrible formatting, I know,

00:03:12.875 --> 00:03:14.510
but let's say I want to update it now.

00:03:14.510 --> 00:03:16.460
Instead of importing it and then like saving

00:03:16.460 --> 00:03:18.875
table styles and all sorts of advanced stuff,

00:03:18.875 --> 00:03:20.305
you can just jump to Excel.

00:03:20.305 --> 00:03:26.705
Let's say this is the data for another month or it's just being adjusted or changed.

00:03:26.705 --> 00:03:28.800
I'm not sure why we're changing the height of all these.

00:03:28.800 --> 00:03:31.460
But let's say it was like a financial data and we're changing every

00:03:31.460 --> 00:03:34.370
month instead of having to go and re-import it and style it,

00:03:34.370 --> 00:03:37.385
just select all the bits you want to change. Hit "Copy".

00:03:37.385 --> 00:03:40.115
So Edit, Copy in Excel,

00:03:40.115 --> 00:03:41.480
and then jump into InDesign.

00:03:41.480 --> 00:03:44.110
What you're going to do is select the whole table.

00:03:44.110 --> 00:03:45.930
Well, select everything you've copied.

00:03:45.930 --> 00:03:48.710
If you're only going to select the whole table and hit "Paste",

00:03:48.710 --> 00:03:50.210
and you'll notice that it goes from height,

00:03:50.210 --> 00:03:51.500
and it just adjusts,

00:03:51.500 --> 00:03:54.080
but it also retains all the style that we've done.

00:03:54.080 --> 00:03:57.560
So any changes that get made you can go and adjust now.

00:03:57.560 --> 00:03:59.630
This is true if it's just one file.

00:03:59.630 --> 00:04:02.840
So say you've got red here and I go through and it's all become red,

00:04:02.840 --> 00:04:08.465
I can select this whole column to color all the way down click "Copy", go into InDesign.

00:04:08.465 --> 00:04:11.945
Click in this, there's a little arrow at the top here to get that whole column.

00:04:11.945 --> 00:04:14.765
Hit "Paste". As long as these match up.

00:04:14.765 --> 00:04:16.130
We're you're copying and pasting,

00:04:16.130 --> 00:04:18.830
it will update and retain the InDesign styles.

00:04:18.830 --> 00:04:20.260
Super awesome. All right.

00:04:20.260 --> 00:04:22.460
So that is a few different ways to work with tables

00:04:22.460 --> 00:04:24.905
when coming from different Microsoft platforms.

00:04:24.905 --> 00:04:27.480
Let's move on to the next video.