From the course: Cert Prep: Word 2016 Microsoft Office Expert (77-726)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Link to external document content
From the course: Cert Prep: Word 2016 Microsoft Office Expert (77-726)
Link to external document content
- [Voiceover] Sometimes we have data in another Word document or in another program that we need to reference. I'm going to demonstrate how to import data from an Excel worksheet and link it back to the worksheet, so that if any changes are made to the Excel document, our Word document will be updated when we refresh the link. I'll also walk you through inserting text from a Word document, and linking it back to the original document. You can also import and link data back to a PDF file or an Access database. Let's take a look at the documents that I have open. First, I have my Excel worksheet with the room rates on it. I also have a separate Microsoft Word document called About, that has information about our new Landon Hotel. The third document that I have open is our original 02_04 Import document. I'll scroll down to page two, and you'll see that I have placeholders for both the room rates and the About text. Let's go ahead and import the room rates first. I'll select the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Modify existing templates1m 40s
-
(Locked)
Copy styles, macros, and building blocks to documents or templates3m 7s
-
(Locked)
Compare and combine multiple documents2m 49s
-
(Locked)
Link to external document content3m 24s
-
(Locked)
Configure Word options3m 50s
-
(Locked)
Track Changes and manage comments2m 55s
-
(Locked)
✓ Challenge: Manage and share documents31s
-
(Locked)
✓ Solution: Manage and share documents4m 44s
-
-
-
-
-
-