1
00:00:07,040 --> 00:00:10,230
So that we don't mess up our lovely long document,

2
00:00:10,230 --> 00:00:13,800
we're going to do this exercise in a new document, just a blank one.

3
00:00:13,800 --> 00:00:16,640
Just keep it separate because we can do lots of versions of

4
00:00:16,640 --> 00:00:19,600
it and we've got no real space to do it in the other document.

5
00:00:19,595 --> 00:00:24,945
What we need to do is show you the different ways that you can bring in tables into Word.

6
00:00:24,940 --> 00:00:27,230
Lots of the time they'll come through and just be fine.

7
00:00:27,230 --> 00:00:31,250
I go to "File" and I go to "Place" and I find out,

8
00:00:31,245 --> 00:00:34,265
we're going to use Table Example Word One.

9
00:00:34,260 --> 00:00:36,430
So make sure you bring it in from Word first.

10
00:00:36,430 --> 00:00:40,690
Click "Open" and we click and drag it out and the table was perfect in Word,

11
00:00:40,690 --> 00:00:44,070
so it's come through perfect in InDesign and no real dramas there.

12
00:00:44,070 --> 00:00:46,520
Where the dramas do happen if I go to File Place

13
00:00:46,520 --> 00:00:49,250
now and I bring in the Example of Word Two,

14
00:00:49,250 --> 00:00:51,510
and I drag this out, this can happen.

15
00:00:51,510 --> 00:00:53,790
It still looks fine, but it's not a table.

16
00:00:53,790 --> 00:00:55,730
It's been damn with tabs,

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

18
00:01:00,440 --> 00:01:03,590
gone to hear, hit "Tab" to separate them out and that's fine.

19
00:01:03,590 --> 00:01:06,630
But formatting becomes a little bit hard because it's not a table.

20
00:01:06,625 --> 00:01:08,445
It's easy to adjust to a table.

21
00:01:08,445 --> 00:01:10,885
Select all the bits you want to be in the table.

22
00:01:10,880 --> 00:01:12,250
I've just highlighted them all.

23
00:01:12,245 --> 00:01:15,185
Go to "Table", go "Convert Text To Table".

24
00:01:15,185 --> 00:01:18,635
By default, it's using the column separator as the Tab.

25
00:01:18,635 --> 00:01:20,295
You might have commas or something else.

26
00:01:20,290 --> 00:01:24,080
I'm going to click "Okay" and hey presto, it's a table.

27
00:01:24,080 --> 00:01:28,310
I might have to do some adjustments just to kind of tidy that in.

28
00:01:28,310 --> 00:01:30,440
That needs to be a little bit smaller maybe,

29
00:01:30,440 --> 00:01:32,570
and that needs to be a bit bigger.

30
00:01:32,570 --> 00:01:35,300
You can mess around with it like we did in the previous example.

31
00:01:35,300 --> 00:01:37,270
I'm going to put them over him.

32
00:01:37,270 --> 00:01:41,350
Another example that might come through from Word is

33
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,

34
00:01:45,095 --> 00:01:46,795
or you copy and paste it.

35
00:01:46,790 --> 00:01:48,610
I'm going to open up that example.

36
00:01:48,605 --> 00:01:51,425
This is my table example Word two.

37
00:01:51,425 --> 00:01:56,045
I'm just going to copy it and paste it in, and this happens.

38
00:01:56,040 --> 00:02:00,060
So the tab's there but InDesign hasn't converted them nicely.

39
00:02:00,060 --> 00:02:02,450
It works just the same as the last example.

40
00:02:02,445 --> 00:02:05,405
Select everything that you want to be part of this table.

41
00:02:05,405 --> 00:02:06,755
Go to Table.

42
00:02:06,750 --> 00:02:08,310
Convert Text To Table. It's the same.

43
00:02:08,310 --> 00:02:09,730
The tab's separating them,

44
00:02:09,725 --> 00:02:11,765
and it comes back to looking good again.

45
00:02:11,765 --> 00:02:14,305
We can go through and play with the lines between them and

46
00:02:14,300 --> 00:02:17,110
the style formatting like we did in the previous exercise.

47
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,

48
00:02:20,150 --> 00:02:21,490
is getting it from Excel.

49
00:02:21,490 --> 00:02:23,140
Same process as Word.

50
00:02:23,135 --> 00:02:27,715
File Place and there's one in here called Table Example Excel One.

51
00:02:27,710 --> 00:02:31,960
Click and drag it out and it comes through the same kind of problem.

52
00:02:31,955 --> 00:02:33,125
This is our Excel file.

53
00:02:33,125 --> 00:02:35,275
If you need a course on Excel, I've got one.

54
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.

55
00:02:37,620 --> 00:02:39,920
But anyway, I'm going to select all of these.

56
00:02:39,920 --> 00:02:41,660
So this what happens when you place from Excel.

57
00:02:41,660 --> 00:02:44,150
It does this kind of weird tabbed thing as well.

58
00:02:44,150 --> 00:02:47,830
But I can fix it just like I did with Word.

59
00:02:47,830 --> 00:02:50,520
Convert text to table and we're on our way again.

60
00:02:50,520 --> 00:02:54,430
The nice thing about Excel though is let's say it's a monthly thing,

61
00:02:54,425 --> 00:02:57,475
its revenue reports or sales reports or something.

62
00:02:57,470 --> 00:03:00,890
So you go through and you format it and you spend ages making it look nice.

63
00:03:00,890 --> 00:03:02,600
We'll do a little bit of formatting.

64
00:03:02,600 --> 00:03:05,440
We'll do Alternating Fills.

65
00:03:05,440 --> 00:03:08,430
Every Other Row, skip the first row even.

66
00:03:08,430 --> 00:03:11,270
We've got this, having done some formatting to it.

67
00:03:11,265 --> 00:03:12,875
Terrible formatting, I know,

68
00:03:12,875 --> 00:03:14,515
but let's say I want to update it now.

69
00:03:14,510 --> 00:03:16,460
Instead of importing it and then like saving

70
00:03:16,460 --> 00:03:18,880
table styles and all sorts of advanced stuff,

71
00:03:18,875 --> 00:03:20,305
you can just jump to Excel.

72
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.

73
00:03:26,705 --> 00:03:28,805
I'm not sure why we're changing the height of all these.

74
00:03:28,800 --> 00:03:31,460
But let's say it was like a financial data and we're changing every

75
00:03:31,460 --> 00:03:34,370
month instead of having to go and re-import it and style it,

76
00:03:34,370 --> 00:03:37,390
just select all the bits you want to change. Hit "Copy".

77
00:03:37,385 --> 00:03:40,115
So Edit, Copy in Excel,

78
00:03:40,115 --> 00:03:41,485
and then jump into InDesign.

79
00:03:41,480 --> 00:03:44,110
What you're going to do is select the whole table.

80
00:03:44,110 --> 00:03:45,930
Well, select everything you've copied.

81
00:03:45,930 --> 00:03:48,710
If you're only going to select the whole table and hit "Paste",

82
00:03:48,710 --> 00:03:50,210
and you'll notice that it goes from height,

83
00:03:50,210 --> 00:03:51,500
and it just adjusts,

84
00:03:51,500 --> 00:03:54,080
but it also retains all the style that we've done.

85
00:03:54,080 --> 00:03:57,560
So any changes that get made you can go and adjust now.

86
00:03:57,560 --> 00:03:59,630
This is true if it's just one file.

87
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,

88
00:04:02,840 --> 00:04:08,470
I can select this whole column to color all the way down click "Copy", go into InDesign.

89
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.

90
00:04:11,945 --> 00:04:14,765
Hit "Paste". As long as these match up.

91
00:04:14,765 --> 00:04:16,135
We're you're copying and pasting,

92
00:04:16,130 --> 00:04:18,830
it will update and retain the InDesign styles.

93
00:04:18,830 --> 00:04:20,260
Super awesome. All right.

94
00:04:20,260 --> 00:04:22,460
So that is a few different ways to work with tables

95
00:04:22,460 --> 00:04:24,910
when coming from different Microsoft platforms.

96
00:04:24,905 --> 00:04:27,485
Let's move on to the next video.