1 / 9

Excel Table+ Mail Merge

Excel Table+ Mail Merge. 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.

katen
Download Presentation

Excel Table+ Mail Merge

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Table+ Mail Merge

  2. 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

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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 Fx, under select category click “all” In 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

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

  9. 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!

More Related