• Word
    C1L1 Employee Memo C1L2 Tell me About You C1L3 Personal Letter C1L4 Themes and Style C1L5 Make a Memo - iPad C1L6 Move a File C1L7 Business Cover Letter C1L8 Add Graphics C1L9 Use Template iPad C1L10 Word 911 C1L11 Modified Block Letter C1L12 Letter A1 Letter C2L1 Lists C2L2 Add Envelope C2L3 Making Envelopes C2L4 Safari Letter C2L5 Safari Letter Part 2 C2L6 flyer C2L7 Christmas
  • PowerPoint
    C1L1 Theme C1L2 Slides C1L3 Move C1L4 Graphics C1L5 Transitions C1L6 Photo Album
  • Photoshop
    C1L1 Remove Background C1L2 Red Eye C1L3 Spot Healing Brush C1L4 Spot Healing Brush2 C1L5 Crop and Adjust C1L6 Combine 1 C1L7 Adjustment Layers C1L8 Clone Stamp A1 Assessment C2L1 Collage C2L2 Collage iPad C2L3 Adjustment iPad C2L4 Meme iPad C2L5 Inspiration iPad C2L6 Curves iPad A2 Assessment
  • Excel
    C1L1 Basic Use C1L2 Formating C1L3 Stock Tracker - Part 1 C1L4 Yearly Income C1L5 Stock Tracker - Part 2 C1L6 Sales Data C1L7 Stock Tracker - Part 3 C1L8 Backpacking Totals C1L9 Statistics
  • Illustrator
    C1L1 Simple Shapes C1L2 Drawing Lines C1L3 Combine C1L4 Tracing C1L5 Pen Tool C1L6 Project A1 Assessment
  • Premiere
    C1L1 Premeire Rush Basic A1 Premeire Rush Layers C2L1 Premiere Pro News Anchor A2 Premiere Pro Assessment
  • After Effects
    C1L1 After Effects Title C1L2 After Effects Cloud Animation C1L3 After Effects Motion Tracking C1L4 After Effects Lightning C1L5 After Effects Intro Assessment

    • Word C2L3 Create Envelopes

    1. Open Microsoft Excel on the Computer
    2. Save the file as E2YourName
    3. Create a spreadsheet with 30 addresses like the example below. Be sure you use the same first line as shown below and then add the 30 addresses below. Use a random address generator online for ideas
    5. Close the Excel file
    6. Turn in the Excel file
    7. Open Microsoft word on the computer
    8. Save it in onedrive with the name E2YourName
    9. Change to Layout to an #10 Envelope. Click Layout -> Click Size -> Envelope #10. If there is no #10 Envelope option, choose more paper sizes -> scroll to the bottom of the paper size options -> choose custom size. Enter a width of 9.5 inches and height of 4.125 inches
    10. Change to Landscape. Click Orientation -> Click Landscape
    11. Change Margins to .18 on all sides. Click Margins -> Custom Margins -> Change top, Bottom, Left, and Right Margins to .18
    12. Switch to the No-Spacing Style
    13. Type in your address like the same picture below:
    15. Set a tab at 3.75 inches
    16. Hit enter until you are down to the middle of the envelope from top to bottom
    17. Hit Tab
    18. Start a Mail Merge. Click Mailings -> Click Start Mail Merge -> Click Step-by-step Mail Merge wizard -> Click Next Starting document -> Click Next: Select recipients -> Click Browse -> Find your E2YourName spreadsheet file with your 30 addresses -> Make sure First row of data contains column headers is selected -> Click OK -> You should see sample addresses from your spreadsheet. Click OK
    19. Select Next: Write your letter
    20. Insert Codes for a good address in the middle of the letter like the picture below: Click Insert Merge Field -> Insert FirstName -> type a space -> Insert Lastname -> Hit enter -> Hit tab -> Insert Address-> Hit enter -> Hit tab -> Insert city -> Type , and a space -> Insert state -> hit space -> insert zipcode -> Your address should look like the picture below:
    22. Select Next: Preview your letters
    23. The codes should now be your first address from your spreadsheet
    24. Select Next: Complete the merge
    25. Select Edit individual letters
    26. Select All and press OK. Word will create a new document that has all of your 30 envelopes with all 30 address. Save this Word document that has all letters with the name E2MergedYourName
    27. Turn in the file with the name E2MergedYourName



    COPYRIGHT © 2023-2024 LEARNSOFTWARETODAY.COM