13 Chapter 13

In this chapter we will integrate programs at a very basic level.

• Word and Excel
  First we will bring a chart into MS Word. There are several ways to bring the chart in, so we will discuss those.
  1. Open up a new blank word document
  2. Save the file as ‘Hours Summary.docx’
  3. Open up the Excel Document ‘Hours.xlsx’
  4. Select the Hours table (not one of the charts) and click the Copy button or ctrl-c on your keyboard
  5. Go back to ‘Hours Summary.docx’ and click the Paste button or ctrl-v on your keyboard
  6. You should see a ctrl button in the bottom right corner of the table. Click on it and you will see:
     
     You will see several Paste Options. In order from left to right are:
     Keep Source Formatting – This option will paste the table in as is into the Word Document
     Use Destination Styles – This option will paste the table using the default table style in Word (whatever theme you have chosen, in this case we haven’t chosen a theme, so it’s using the default)
     Link and Keep Source Formatting – This option will link the table to ‘Hours.xlsx’ so that way every time you update the hours in Excel, Word will automatically update. It will also paste the table in as is into the Word Document.
     Link and Use Destination Formatting – This option will also link the table to ‘Hours.xlsx’ so that way every time you update the hours in Excel, Word will automatically update. It will paste the table in using the default style in word.
     Picture – This will convert and paste a picture of the table from excel into your Word Document
     Keep Text Only – This will get rid of the table and keep only the text
  7. Choose Link and Use Destination Formatting
  8. Save the document
  9. Change some of the hours in Excel and watch Word auto-update! Save the document.
  10. Now lets paste in the Bar Chart from ‘Hours.xlsx’
  11. Go to the Excel File, click on the Bar Chart, and click the Copy button
  12. Go to MS Word and type ‘Hours Chart’ below your table and hit the Enter Key
  13. Click the Paste Button
  14. You will see a ctrl button in the bottom right hand corner, click on it for the following options:
      
      Use Destination Theme and Embed Workbook – This will use the default theme in Word for Charts and Embed the chart so you can edit it within Word.
      Keep Source Formatting and Embed Workbook – This will use the formatting from Excel for Charts and Embed the chart so you can edit it within Word.
      Use Destination Theme and Link Data – This will use the default theme in Word for Charts and Link the Data so that if you make a change in Excel it is reflected here.
      Keep Source Formatting and Link Data – This will use the formatting from Excel for Charts and Link the Data so that if you make a change in Excel it is reflected here.
      Picture – this will convert the chart and paste a picture of your chart into the document
  15. The default option is Use Destination Theme and Link Data – so we will leave it that way. Save the file.
  16. No go back into Excel and change hours in the original table. Go back to Word and see the Chart has updated!
  17. Close Word and Excel
• Word and PowerPoint
  1. Open up a blank Word Document and save it as PowerPoint Outline
  2. Click on the View tab and look for Outline in the Views Grouping
  3. This will bring you into Outline Mode
  4. Type Symptoms on the first line
  5. Then type Frequent Urination
  6. In the Outline Ribbon that appeared above, find the Level option:
     
  7. Using the single green arrow pointing right button, bring the Level to Level 2
  8. You will notice that Frequent Urination indents
  9. Hit the Enter key and type Increased Thirst – it should stay at Level 2
  10. Hit the Enter Key and use the single green arrow pointing left button to return to Level 1
  11. Type Causes and hit Enter
  12. Type Obesity and bring it to Level 2 and hit Enter
  13. Type Family History
  14. Save the document as ‘Outline.docx’ and close the document (it is important that you close the document or you will get an error at step 19)
  15. Open up PowerPoint and start a Blank Presentation
  16. In the Home Tab in the Slides Grouping choose the New Slide button
  17. At the bottom choose ‘Slides from Outline’
  18. Search for your Word Document ‘Outline.docx’ and click the Insert button
  19. PowerPoint will create slides for you based on the indentation levels of the word outline! You should have 2 slides – one that is titled ‘Symptoms’ and one that is titled ‘Causes’ with the appropriate points on each slide!
  20. Close PowerPoint
• PowerPoint and Excel
  1. Open up your ‘Hours.xlsx’ workbook in Excel
  2. Copy your Bar Chart
  3. Open up a new Blank Presentation in PowerPoint
  4. Choose New Slide – Title and Content
  5. Click the Content box and click the Paste button
  6. This will paste your Bar Chart into PowerPoint
  7. You will notice you have the same options as when you pasted it into Word:
     
     Use Destination Theme and Embed Workbook – This will use the default theme in Word for Charts and Embed the chart so you can edit it within Word.
     Keep Source Formatting and Embed Workbook – This will use the formatting from Excel for Charts and Embed the chart so you can edit it within Word.
     Use Destination Theme and Link Data – This will use the default theme in Word for Charts and Link the Data so that if you make a change in Excel it is reflected here.
     Keep Source Formatting and Link Data – This will use the formatting from Excel for Charts and Link the Data so that if you make a change in Excel it is reflected here.
     Picture – this will convert the chart and paste a picture of your chart into the document
  8. Make sure Use Destination Theme and Link Data is chosen so your PowerPoint automatically updates if you make changes to the Excel file
  9. The Design Ideas tab should automatically open – go ahead and choose a design for the slide.
  10. Save the presentation as ‘Hours.pptx’ and close PowerPoint and Excel