m aking a table in e xcel and using m ail merge melissa thompson

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