First you need to create the TABLE in excel, work with your calculations, format you table and then "transfer" the table to Word. I will try to explain how to do it:
To create your table with excel, check this Basic Excel Spreadsheet Tutorial
For excel 2003 http://inpics.net/tutorials/excel2003/basics.html
http://www.baycongroup.com/excel.htm
For excel 2007 http://inpics.net/tutorials/excel2007/basics.html
http://www.baycongroup.com/el0.htm
Now that you have your table ready in excel, it's time to "TRANSFER" it to word, to do this you have these options:
OPTION 1: COPY & PASTE
• Open your word document and your excel spreadsheet.
• WORKING WITH EXCEL: Like you have done before, you could use copy and paste to copy the information from excel to word: just select the data in Excel, copy it (by pressing the keys
+ or from the menu/ribbon choose COPY)
• WORKING WITH WORD: In your Word document position the cursor where you would like the table inserted and paste it by pressing the keyboard keys + or from the from the menu/ribbon choose PASTE.
When you paste it, word will automatically converted the table into a WORD table with all of the limitations inherent in Word tables.
LIMITATIONS:
• If you modify the Excel file, the change wont be reflected in your word document.
OPTION 2: Link to excel with COPY & PASTE SPECIAL
When you want that any change on your excel spreadsheet to be updated on the word document, then you need to link both documents and this is done using the PASTE SPECIAL option. In this way if you make changes to the source Excel worksheet, the next time you open the Word document into which you pasted a link to that Excel workbook, you will be asked if you’d like to update the linked information in your Word document from original Excel files.
To link a excel file:
• Open both the Word document and the Excel spreadsheet
• WORKING WITH EXCEL: In Excel, select the range of cells you want to include and copy them
On the Edit menu or Home-Clipboard_group, select Copy
• WORKING WITH EXCEL: In your Word document position the cursor where you would like the table inserted
2003: On the Edit menu select Paste Special
2007: On the Home tab, clipboard group open the Paste option and select Paste Special
The next steps are the same for 2003 and 2007
Click the radio button beside Paste link
Under the label As:, select Microsoft Excel Worksheet Object
Click OK
LIMITATIONS:
• If you move the Excel file you will need to re-establish the link
• If you plan to transport the Word file for use on another computer, you will need to remember to include the Excel file
• You must do all your editing in Excel
OPTION 3: Embedding a Excel Object with COPY & PASTE SPECIAL
The process of embedding an Excel worksheet in your Word document is essentially the same as linking to an Excel worksheet. The only difference is in the options you specify in the Paste Special dialog box:
Instead of choosing the radio button beside PASTE LINK, choose the radio bottom beside PASTE.
While the results might appear the same at first, they are TOTALLY different.
This option will copy the excel table without any link to excel this mean that the information is no longer tied to the original Excel workbook. The table will be a Word table but with excel functionability, so if you need to modify the data or formulas, double click the table in word and you can do anything you do in excel with this table but working on word.
LIMITATIONS:
• If you make any change on your Excel table, those changes will not be reflected in your Word document.
Hope this help you