Loading...

PRDV252: Intermediate Excel

Unit 8: Graphics in Excel®   Although graphics are not necessarily needed in Excel® to get the point across, it is sometimes good to use them to help the reader understand the information. Just as charts help to explain complex data in a visual format, graphics can point out or help to emphasize information that you want the reader to easily grasp. This unit will look at many of the features on the Insert ribbon in the Illustrations and Text groupings. The only caveat I would put on this is that you should remember that you are only using graphics to enhance the document. Too much visual busyness will distract from the important information that is on the spreadsheet. You will be learning all different types of graphics in this unit, but only use a few on an actual business document.

Unit 8 Time Advisory
Completing this unit should take youapproximately 3 hours.
☐    Subunit 8.1: 1.5 hours

☐    Subunit 8.2: 30 minutes

☐    Subunit 8.3: 1 hour

Unit8 Learning Outcomes
Upon successful completion of this unit, you will be able to: - explain how to add shapes and graphics to a worksheet or chart; - explain how to insert and format a hyperlink in text or on a graphic; - describe how symbols are similar to font styles; - identify categories of Symbols; and - create a Header and/or Footer that automatically inserts the date, page number, and file path.

8.1 Add Callouts and Clipart to Charts or Spreadsheets   - Web Media: The Saylor Foundation's Callouts and Clipart Link: The Saylor Foundation's "Callouts and Clipart" (YouTube)
 
Instructions: Watch the video showing how to insert shapes and clipart into a spreadsheet. Note that a toolbar pops up once a picture is added and/or selected, for further formatting and editing of the object. Once you have seen it done, open up a spreadsheet and try it on your own using some of the tools from the new toolbars that show up when you insert these objects.
 
Completing this assignment should take approximately 30 minutes.

8.1.1 Adding a Picture to a Spreadsheet   - Web Media: The AppTrainer’s “MS Office 2010. Excel® Basic: Unit 2 Topic C: Inserting Basic Pictures” Link: TheAppTrainer’s MS Office 2010. Excel® Basic: Unit 2 Topic C: Inserting Basic Pictures (YouTube)
 
Instructions: Watch the short video showing how to insert a saved picture into a spreadsheet. Note that the picture Format toolbar pops up once a picture is added and/or selected. Once you have seen it done, open a spreadsheet and try it on your own using some of the tools from the picture Format toolbar.
 
Completing this assignment should take approximately 15 minutes.
 
Terms of Use: This resource is licensed under a Creative Commons Attribution 3.0 Unported License. It is attributed to TheAppTrainer, and the original version can be found here.

8.1.2 WordArt and Symbols   - Web Media: The Saylor Foundation's "WordArt and Symbols" Link: The Saylor Foundation's "WordArt and Symbols" (YouTube)
 
Instructions: Watch the short video showing how to use WordArt and Symbols. Once you have seen it done, open up a spreadsheet and try it on your own using some of the tools from the picture Format toolbar.
 
Completing this assignment should take approximately 30 minutes.

8.1.3 Adding a Hyperlink   If your document is going to be shared electronically, then you may want to add a hyperlink to another worksheet, workbook, or an external site on the web or within a company intranet site.

  • Web Media: The Saylor Foundation's "Adding a Hyperlink" Link: The Saylor Foundation's "Adding a Hyperlink" (YouTube)
     
    Instructions: Watch the short video showing how to create hyperlinks, both to internal links within the Excel® workbook and external links on the web or to another file. The video will show text and graphics as the link. Once you have seen it done, open up a spreadsheet and try it on your own.
     
    Completing this assignment should take approximately 15 minutes.

8.2 Headers and Footers   - Web Media: The Saylor Foundation's "Headers and Footers" Link: The Saylor Foundation's "Headers and Footers" (YouTube)

 Instructions: Watch the short video showing how to use WordArt and
Symbols. Once you have seen it done, practice setting up headers and
footers in Excel.  
    
 Completing this assignment should take approximately 30 minutes.

8.3 Unit 8 Exercise   - Activity: The Saylor Foundation’s “Practice Exercise for Unit 8” Link: The Saylor Foundation’s “Practice Exercise for Unit 8” (PDF)
 
Instructions: Follow the instructions on the PDF. This exercise will be using skills you learned in Units 6–8.
 
Completing this activity should take approximately 1 hour.