Join Anne-Marie Concepción for an in-depth discussion in this video Automatically update InDesign tables from Excel, part of Managing Conversions Between Adobe CC and Microsoft Office.
- [Voiceover] Here is a neat feature…that you might find in handy.…Instead of just placing an Excel spreadsheet data…into InDesign and formatting it as a table,…as I showed in the previous video.…You could also link, to that external Excel file,…so that as people change the data in Excel file.…Like here is the Excel file,…if they change something here…and save it,…you'll be notified in InDesign that the data is different.…Here is the table that I created from that data…And then you can easily just click one button…to update all of the changed data,…and it will automatically update…without losing your formatting.…
Now it's not something that…most people need to do,…usually just bringing in once…and then format it.…But if it's something that…you know it's part of your work flow…the people are constantly updating the data,…and you need to constantly update your InDesign file,…it can come in extremely handy.…But let me show you how to do that.…The're two things you need to do.…The first one is you need to create a Table Style.…
She begins with an overview of the major differences between the suites and platforms and between Office for Mac and Office for Windows. From there, she breaks down common challenges such as importing and editing Adobe art and text in PowerPoint, using PowerPoint elements in Adobe apps, integrating Excel data and charts in Adobe apps, and more. Find solutions to your most common challenges, improve your workflow, and get the results you want.
- Understanding essential differences in the way Office and Adobe CC treat fonts, graphics, and color
- Using proprietary Adobe-to-Office conversion software
- Using the "secret weapon," Acrobat, to do conversions
- Editing Illustrator graphics in PowerPoint
- Extracting PowerPoint art for use in Adobe apps
- Creating InDesign tables from Excel spreadsheets
- Importing Excel data into Illustrator's chart worksheet
- Recreating InDesign layouts as editable Word files
- Converting Word art into high-res vector files
Skill Level Intermediate
1. Overview of Essential Differences
Understand color differences6m 12s
2. Converting with Specialized Software
Use Snagit for screenshots4m 37s
3. Between Adobe Creative Apps and Microsoft PowerPoint
4. Between Microsoft Excel and Adobe Creative Apps
5. Between Adobe Creative Apps and Microsoft Word
Next steps2m 50s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.