Excel Table Mail Merge 7 Excel Creating a

Excel Table+ Mail Merge 7

Excel: Creating a Table Some Basic Vocabulary Columns - run vertically, they are the letters Rows - run horizontally, they are the numbers Cell - the intersection between a column and a row

Excel: Creating a Table Your data will decide how you will need to organize your Excel table. To avoid error make sure you do not leave any empty cells.

Excel: Creating a Table Create headings, making sure the corresponding information stays within the same columns and rows. You can make the cells bigger or smaller by moving your mouse in between the letters of the columns or the numbers of the rows.

Excel: Creating a Table When you are finished filling in your data you can clean it up by adding color to columns or rows, and centering your data in the cells.

Excel: Oh the things you can do with your data Excel formulas are a great way to cut out work. Formulas can include sums, averages and much more. Use Fx to decide what you want to do. Also, by dragging the cross to more cells the answers will automatically be calculated with the existing formula.

Excel Extras: V Lookup To create comments that correspond to the data, use a different sheet within the excel document and type your comments. • Click • In Fx, under select category click “all” function, find VLOOKUP and select it For our specific comment to grade correspondence in the Vlookup table we chose… Lookup_value- whatever column current average was in Table_array- the columns and rows the comments were in with $ before every letter and number ($A$1, $B$10) Col_index_num- whatever column your comments were in (2) Range_lookup- TRUE

Mail Merge The easiest letters you’ll ever write Using the data from the excel table 1. Make sure your excel table is closed 2. Open a new Microsoft Word document 3. Go to the Mailings tab and click Start Merge 4. Click: Letters, Select Recipients, Use Existing List, don’t forget to edit recipient list 5. Select the Excel document you want the information to come from making sure you choose the right sheet from it.

Mail Merge cont… Insert Merge field: this will have the list of information that you can add to your letter. Put the cursor where you want your information to appear. • You can edit individual letters • You can preview them by clicking Preview Results Click Finish Merge to Finish TA DA! Wasn’t that EASY!