8.5. Word 2007 and Excel 2007 PivotTables

One might ask why Word is included in a discussion of business intelligence tools; the answer is that many real-world reports are produced in Word doc format, which is always easy for people to read. Additionally, narrative elements of a BI presentation can be included in Word using the phenomenal power of its editing tools.

We will look briefly at the interaction between Word and Excel, and Figure 8-25 shows how we start the simple process of copy and paste.

  1. Using the left mouse button, drag the mouse to select the desired PivotTable.

  2. Right-click over the selected PivotTable, and choose Copy on the pop-up menu.

In Figure 8-25 we've simply selected an example Excel 2007 PivotTable and proceeded to copy ...

Get Microsoft ® Office 2007 Business Intelligence now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.