Share this Page URL

Part VII: Integrating Excel with Other A... > Building Presentations with Excel - Pg. 692

692 Chapter 28. Building Presentations with Excel In this chapter Using Excel with Other Microsoft Office Programs Copying Excel Data to a Word Document Copying Excel Data to a PowerPoint Presentation Copying Word and PowerPoint Data to an Excel Worksheet Combining Word, Excel, and PowerPoint Files with Hyperlinks Using Excel with Other Microsoft Office Programs Interoperability is probably the main reason that users purchase a suite of products rather than buying word-processing programs, spreadsheet software, and presentation products individually. The pricing of suite software is generally attractive, but the capability to share content between applications easily, with predictable results, is a powerful incentive. Office 2003's focus on Web-enabled collaboration improves upon previous versions' collaborative tools. Microsoft's vision for the workplace requires that everyone's efforts be shared, and toward that end, HTML becomes the common file format among applications. The result? Through the Clipboard and Insert menu, you can insert as much or as little as you like of one application's content into another application's file quickly and easily, retaining as much or as little as you like of the source application's formatting. Copying Excel Data to a Word Document You can add Excel content to a Word document to save time and effort in reentering existing text and/or numbers, and to ensure consistency between files. If your Word document discusses num- bers already entered into an Excel worksheet, don't create a Word table and reenter the numbers --copy them from Excel and paste them into the Word document. The result is an instant table, containing the numbers as they appeared in Excel. Using Excel for tables that contain numeric data also gives you access to Excel's tools for calculation and numeric formatting, which you don't have to the same extent in Word. Therefore, you should try to create, format, and add formulas to the table in Excel--before you copy the table into a Word document. Figure 28.1 shows the Word and Excel application windows tiled, with a selection in Excel pasted into a Word document as an Excel Object by using Paste Special.