Creating Reports using Excel, Word, and PowerPoint

Film by Dr. Cynthia Calongne demonstrating on how to complete a capstone project for a computer literacy class. In the video, we create two reports using Excel, Word and PowerPoint and save them as a PDF. Skip ahead to the topic you need. Topics covered: Excel: 1. How to copy/paste the table into Excel 2. How to shade and reformat it 3. How to remove the Sort arrows from the header row - Data ribbon and Filter 4. How to create a pie chart (don't select the totals row) 5. How to reformat your pie chart colors, background and style 6. How to change the title in the pie chart 7. How to copy/paste the pie chart and table into a Word document Word: 1. How to set up a Word Art title for your report 2. How to change font colors and styles 3. How to change styles to reformat your text 4. How to use a one cell table to control content on the page - useful for columns 5. How to remove the borders from a table that organizes your columns 6. How to check to ensure that it fits on one page 7. How to resize your pie chart & check the chart's legend (names for the slices of pie) PowerPoint: Create 3 slides that look like the example 1. How to use the Snipping tool to copy and save a photo for use 2. How to rearrange the areas of a slide 3. How to change a slide's Layout 4. How to Insert the table into a slide 5. How to Insert a Picture into the slide 6. How to copy/paste your pie Chart 7. How to Duplicate the slide to try more than one design style 8. How to Crop an image (and undo it!) 9. How to Arrange the images and text with Bring to Front, Send to Back 10. How to transform Word Art into text, change the Color and Bold 11. How to use Shape Fill behind text to give it contrast (to read it clearly) 12. How to use Shape Fill More Colors to make the color transparent 13. How to use Shape Effects to soften the edges and blend the color behind your text 15. How to save your PowerPoint into a PDF Report