Office 2013 Bible: The Comprehensive Tutorial Resource

Chapter 40

Integrating Office Application Information

IN THIS CHAPTER

Sending data between Excel and Word

Copying tables between Excel and Word

Exchanging outlines between Word and PowerPoint

Using the Outlook Address Book in Word

Sharing data between Word and OneNote

In some ways, using the Office suite is like using a single multipurpose program. Features from the different programs mesh together almost seamlessly. For example, when you create a chart in a Word 2013 document, the data also lives in Excel 2013, almost as if Excel were an extension of Word.

In this chapter, you explore the ways in which Excel, PowerPoint, Word, Outlook, and OneNote communicate with each other. Some things are perfectly intuitive, and others aren’t. The casual PowerPoint user might never stumble on how to send outlines back and forth with Word. Do you ever wonder about the array of picture options available to you when copying images between Word and other programs? Which format should you use, and what are the consequences of using this one or that? How can pasting a 40K picture into a Word file add 900K to its size? In this chapter, the focus is on the less intuitive, to get you over some hurdles and stumbling blocks, and to make sense of some of those little mysteries that can make using Word seem like a struggle.

Excel

Although sharing work between Word and Excel often works well, differences in how the two programs operate can produce confusing results. This can be addressed by becoming aware ...