Page 519 - Excel 2013 All-in-One For Dummies

Excel 2013 Data Sharing Basics 501
to the Word or PowerPoint document and pasting it in place with the Paste command button (or pressing Ctrl+V).
Excel maintains a very close relationship with Microsoft Access, thus making it easy to import data from any of the tables or queries set up for a database into your Excel worksheet. For details on how to bring in data from Access, see Book VI, Chapter 2.
Excel and Word 2013
Of all the Office programs (besides our beloved Excel), Microsoft Word 2013 is the one that you are most apt to use. You will probably find yourself using Word to type up any memos, letters, and reports that you need in the course of your daily work (even if you really don’t understand how the program works). From time to time, you may need to bring some worksheet data or charts that you’ve created in your Excel workbooks into a Word document that you’re creating. When those occasions arise, check out the information in the next section.
Although Word has a Table feature that supports calculations through a kind of mini-spreadsheet operation, you probably will be more productive if you create the data (formulas, formatting, and all) in an Excel workbook and then bring that data into your Word document by following the steps outlined
in the next section. Likewise, although you can keep, create, and manage the data records that you use in mail merge operations within Word, you probably will find it more expedient to create and maintain them in Excel — considering that you are already familiar with how to create, sort, and filter database records in Excel.
Getting Excel data into a Word document
As with all the other Office programs, you have two choices when bringing Excel data (worksheet cell data or charts) into a Word document: You can embed the data in the Word document, or you can link the data that you bring into Word to its original Excel worksheet. Embed the data or charts when you want to be able to edit right within Word. Link the data or charts when you want to be able to edit in Excel and have the changes automatically updated when you open the Word document.
Happily embedded after
The easiest way to embed a table of worksheet data or a chart is to use
the good old drag-and-drop method: Simply drag the selected cells or chart between the Excel and Word program windows instead of to a new place in a worksheet. The only trick to dragging and dropping between programs is the sizing and maneuvering of the Excel and Word program windows themselves. Figures 4-4 and 4-5 illustrate the procedure for dragging a table of worksheet data with the 2013 annual sales for Chris’s Cookies from its worksheet (named Cookie Sales) into a memo started in a new document in Word 2013.
Book IV Chapter 4
Sharing Workbooks and Worksheet Data