How do I convert tables from Microsoft Word or Microsoft Excel into Adobe InDesign
Lesson 68 from: Adobe InDesign FundamentalsDaniel Walter Scott
How do I convert tables from Microsoft Word or Microsoft Excel into Adobe InDesign
Lesson 68 from: Adobe InDesign FundamentalsDaniel Walter Scott
Lesson Info
68. How do I convert tables from Microsoft Word or Microsoft Excel into Adobe InDesign
Lessons
Overview
1InDesign Tutorial Basics Class Introduction
01:50 2Exercise files & Projects
02:39 3What Does Adobe InDesign do?
01:34 4What are the differences between InDesign and PageMaker, Illustrator, Photoshop, Quark?
05:10PROJECT 1: One page flyer
5How to change MM to Inches & changing UK to US dictionary in InDesign?
01:39 6New document in InDesign - what is bleed & slug?
08:08How to create your own RGB & CMYK colors in Adobe InDesign
08:39 8How do I steal colors from a logo using InDesign?
03:14 9How to color the background of a page in InDesign?
03:33 10Importing resizing rotating & flipping images & Logos inside InDesign
07:53 11How to Import text from Microsoft Word into Adobe InDesign
05:46 12How to group, ungroup & rotate images in Adobe InDesign
05:12 13How to make a dotted line, dashed line & borders in InDesign
05:20 14How best to preview your work in Adobe InDesign
05:16 15How to make a simple PDF from InDesign
06:43 16How to save your InDesign file as a JPEG
02:27 17Why should I use CC Libraries in InDesign?
05:08 18How to share your InDesign files with others by using package document
04:26 19Class Exercise 1
03:24 20Quiz - One Page Flyer
PROJECT 2: Other people's files
21Ideas, Inspiration & starter templates
04:59 22Working with other people's InDesign documents, missing images
03:12 23How to find missing fonts in InDesign?
04:27 24How to replace images in InDesign?
01:30 25Opacity, transparency and see through ness in Adobe InDesign
02:29 26Why is InDesign adding [Converted] and making me 'save as'
01:06 27What if I can’t find the InDesign file - can I open the PDF?
02:37 28Quiz - Other people's files
PROJECT 3: Company Newsletter/Brochure
29Creating a new company newsletter or brochure, what are spreads in InDesign
06:58 30How to use a Master Page in Adobe InDesign
05:33 31How do to add automatic page numbering to a InDesign file
04:11 32Removing a master page & deleting parts off the master page in InDesign
02:30 33Production Video 1
02:53 34What is Effective PPI & Image resolution in the InDesign links panel
06:52 35How to add drop shadows to an image or logo in InDesign
04:20 36What is TypeKit used for in Adobe InDesign?
08:37 37How to add the Copyright, Registered & Trademark symbols in InDesign
05:08 38Where can I find the different versions of letters in InDesign - Ligatures.
03:35 39How to add placeholder text & lorem ipsum & get a word count in InDesign
03:04 40Importing Text from Microsoft Word & keeping or removing the formatting
02:58 41Creating Columns in a text box using Adobe InDesign
01:46 42How do I justify text & turn off hyphenation in InDesign?
03:59 43What is the space after & leading in Adobe InDesign?
05:22 44How to underline text with a full width line in Adobe InDesign?
01:53 45How do I make a paragraph style in Adobe InDesign?
06:06 46How do I update a Paragraph Style in Adobe InDesign?
04:28 47How to use Find & Change to remove double spaces after a period or full stop.
02:37 48Stealing colours from images, is there a format painter in Adobe InDesign?
03:09 49InDesign Class Exercise 2 - Magazine Spread
04:22 50Quiz - Company Newsletter/Brochure
PROJECT 4: Long Business Document
51How to bring in lots of text into InDesign at once
08:11 52How do I import paragraph styles from another document
12:45 53How do I insert completely blank pages in Adobe InDesign
02:03 54How do I create a gradient in Adobe InDesign
07:20 55Do I need to use layers in Adobe InDesign
05:27 56Opacity advanced, mater marks and Transparency Effects in Adobe InDesign
04:24 57How do I add rounded corners to an image or box in Adobe InDesign?
02:52 58How to add a large first letter to my text aka Drop Cap
02:16 59How do I increase the space between letters in Adobe InDesign aka Tracking or Kerning
02:32 60How do I get text to move around an image or shape using text wrap
03:57 61Why can’t I put text over anything that has text wrap applied?
03:25 62How to draw an arrow or triangle or star in Adobe InDesign
06:40 63How do I put an image inside other shapes like a circle - cropping
02:47 64What is Adobe Stock
04:17 65Where can I find free images & icons that I can use for my business
04:23 66How do I add bullets and numbered lists in Adobe InDesign?
00:51 67How can I create a table inside Adobe InDesign?
07:10 68How do I convert tables from Microsoft Word or Microsoft Excel into Adobe InDesign
04:26 69How do I get images to move with the text in Adobe InDesign using anchored objects?
03:22 70How do I create a Line Break, Column Breaks & Page Breaks in Adobe InDesign?
04:16 71How do I make an automatic table of contents in Adobe InDesign?
04:46 72How do you change the tabs in Adobe InDesign?
04:30 73Can I change the numbering of my pages so 1 starts later in the InDesign file?
03:26 74Quiz - Long Business Document
PROJECT 5: Conference Name Badge
75How do I combine Microsoft Excel spreadsheet in InDesign?
09:04 76CLASS EXERCISE: Create your own business card
01:16 77Quiz - Conference Name Badge
What next
78How to create a mockup for your portfolio using InDesign
04:07 79InDesign cheat sheet & shortcuts
12:45 80BONUS: Software Updates
40:41 81What to do after this InDesign tutorial class?
01:07 82Quiz - What Next
Final Quiz
83Final Quiz
Lesson Info
How do I convert tables from Microsoft Word or Microsoft Excel into Adobe InDesign
Okay. So that we don't mess up our lovely long document. We're going to do this exercise in a new document. Just a blank one. Okay, just keep it separate because we're gonna do lots of versions of it and we've got a real space to do it in the other document. So what we need to do is show you the different ways that you can bring in tables into word lots of the time they'll come through and just be fine. Okay? So if I go to file and I go to place, okay? And I find our we're gonna use table example, word one. Okay, so make sure you were gonna get them from word first, click open and click and drag it out and the table was perfect inward. So it's come through. Perfect. And in designs and no real drummers there where the drummers do happen if I go to file place now and I bring in the example of word two and I dragged this out. This can happen and it still looks fine, but it's not a table. It's been done with tabs. Okay? So there's no actual tables to put the lines. So it's actually just pe...
ople have gone through, gone to hear his tab to separate them out and that's fine. But formatting becomes a little bit hard because it's not a table, it's easy to adjust to a table select all the bits you want to be on the table. Okay. So I've just highlighted them all. Go to table, Go convert text to table by default. It's using the column separator is the tab, you might have commerce or something else. I'm going to click OK. And Hey, presto, it's a table, I might have to do some adjustments just to kind of tidy that in and that needs to be a little bit smaller maybe, and that needs to be a bit bigger and so you can mess around with it like we did in the previous example, so I'm gonna put them over here. Another example that might come through from word is either the table is not set up right in word and it comes through a bit weird or you copy and paste it. So I'm going to open up that example. Okay, so this is my table example word to I'm just going to copy it and paste it in and this happens. Okay, So the tabs there, but in design hasn't converted them nicely. Okay, so it works just the same as the last example. Select everything that you want to be part of this. Table. Go to table, convert text to table is the same. The tabs separating them and it comes back to looking good. Again, we can go through and play with the lines between them and the style formatting like we did in the previous exercise, The last one will do is I'm just gonna move him off to the side is getting it from Excel. Same processes word. Okay, fireplace. And there's one in here called table example XL1. Ok. And then click and drag it out and it comes through the same kind of problem. This is our Excel file. If you need a course on Excel. I've got one. I've also got one onward as well. If you want to go check that out. But anyway, I'm going to select all of these. So that's what happens when you place from excel. It does this kind of weird tabbed thing as well but I can fix it just like I did with word. Okay, convert text to table and we're away. Again. The nice thing about Excel though is let's say it's a monthly thing. Okay. It's revenue reports or sales reports or something. So you go through a new format it and you spend ages making it look nice. We'll do a little bit of formatting or do alternating fills. Okay. Every other Rose get the first row even. Okay, so we've got this and we've done some formatting to it. Terrible formatting. I know, but let's say we want to update it now instead of importing it and then like saving table styles and all sorts of advanced stuff, you can just jump to excel and let's say this is the data for another month or it's just been adjusted or changed. I'm not sure why we're changing the height of all these. But let's say it was like a financial data and changing every month instead of having to go and re import it and style. It Just select all the bits you want to change. Hit copy. Okay so edit copy and exhale, then jump into in design and what you're gonna do is select the whole table. Okay? We'll select everything you've copied. If you're only going to select the whole table and paste and you'll notice that it goes from height and it just adjusts but it also retains all the style that we've done. Okay so any changes that get made, you can go and adjust now this is true if it's just one file so say you've got red here and I go through and it's all become red. I can select this whole columns of color all the way down, click copy. Get in design, click in this there's a little error at the top here to get that whole column and paste. As long as these match up. Okay we're copying and pasting. It will update and retain the end. Design styles. Super awesome. Alright so that is a few different ways to work with tables when coming from different Microsoft platforms. Let's move on to the next video
Class Materials
Bonus Materials with Purchase
Ratings and Reviews
Jerome Clark
I think Dan is very good at explaining and breaking down complex content. I like the way there are lots of small sessions which is good for keeping focus. I would advise anyone who does this course and is taking notes to label which session the notes are referring to as I have struggled to find a few looking back and this helped me. It really made me realise how much I didn't know and had been fudging. Thank you Dan I will be taking plenty more of your courses in the coming months it's been a great help.
Giuseppe Lipari
Excellent course, instructor is great well spoken, clear and a great teacher. I highly recommend this class for beginners and those who learned indesign on their own.