MAKING A TABLE IN EXCEL AND USING MAIL MERGEMelissa Thompson
MAKING A SPREADSHEET First, open Microsoft excel. If you have never used excel before the link
may be of help to you. http://www.usd.edu/trio/tut/excel/
The screen is divided into a series of rows and columns. The rows are numbered down the left-hand side.The columns are lettered across the top.The point where the row and column meet is called the cell. Each cell has a reference number e.g. C2, D5, F8.
SPREADSHEET CONTINUED
All formulas need to begin with an equal sign (=). There is a list of the functions available within
Excel under the menu INSERT down to Function. You can select several cells together if you specify
a starting cell and a stopping cell. This will select ALL the cells within this specified BLOCK of cells.
If the cells that you want to use are not together you can use the comma to separate the cells or by holding down the control-key and selecting cells or blocks of cells the comma will be inserted automatically to separate these chunks of data.
SPREADSHEET CONTINUED
When creating a spreadsheet first fill the titles of your data
Next fill in the data under the correct titles You can change the cell color by selecting the
fill button (looks like a paint bucket) select the down arrow and choose the color
Once you have finished inputting data and are finished with your spreadsheet you can use Mail Merge.
MAIL MERGE
After you have filled in the spreadsheet save the document and close excel
Open Microsoft Word Fill in the address, date etc To use mail merge:
Select the Mailings tab Select the Select Recipients button Select Use existing list
MAIL MERGE CONTINUED
Select Data Source will come up Find your saved excel document Once you have selected this you can
continue to fill in your letter and enter data without having to keep referring back to the excel document
When you want to enter data from excel select the Insert merge field down arrow and choose from the selection
After you are finished select the Finish and Merge button and the data will compute
LINKS FOR EXTRA HELP
For extra help making a spreadsheet use the following link
http://www.usd.edu/trio/tut/excel/index.html Help with Formulas http://www.youtube.com/watch?v=xOU_hL2_zBo