Microsoft Office Tutorials and References
In Depth Information
Creating a PivotTable
5
Select Microsoft Excel Worksheet Object; click the Paste link radio button, and then
click OK. Word displays the data. Double-click the imported data, and Excel tools
become available to use for editing and formatting.
The Paste Special dialog box displays options to paste in various formats.
6 In the Excel program, choose File > Save, and then choose File > Close. In the Word
program, choose File > Save, and then choose File > Exit.
Creating a PivotTable
A PivotTable is a versatile method of summarizing data. You tell Excel the i elds to display
and how to display them.
To open the i le you need for this lesson:
1
Choose File > Open and navigate to the Excel07lessons folder.
2
Click excel0706 and then click Open.
3
Select File > Save As. Excel displays the Save As dialog box.
4
In the Save As text box, type excel0706_done and then click Save.
Before you begin creating a PivotTable you will always want to:
Remove any blank rows or columns
Be sure that each column has a heading
Be sure that the cells have the proper formatting for their data types
5
Click cell A1 and drag over to cell F1, and then down to row 20.
Search JabSto ::




Custom Search