Lesson 11 Objectives

1. Lesson 11 Objectives • Insert a picture. • Add a picture to a header or footer. • Create a hierarchy SmartArt shape. • Build a cycle SmartArt shape.

2. Inserting a Picture • An image adds visual appeal to a worksheet. • Excel treats an image as an object on the draw layer. • The size, position, and other properties of a picture can be changed, depending on the image format.

3. Inserting a Picture You can use images that are saved in a format that Excel recognizes. Typical image formats are TIF, GIF, PCX, PNG, JPEG, and more. The Insert Picture from File button is on the Insert command tab.

4. Inserting a Picture

5. The Picture Tools Format Tab This context-sensitive command tab appears when an image is selected. It provides many editing and formatting commands for the image.

6. The Size and Properties Dialog Box This dialog box can be opened from the Dialog Box Launcher in the Size group on the Picture Tools Format tab.

7. Inserting Clip Art • Clip Art is a category of images that is catalogued and provided with Excel. • In addition to those on your computer, you can also search the online clip art gallery for more images. • The Clip Art button is on the Insert command tab.

8. The Clip Art Task Pane

9. Cropping an Image Cropping an image is a way to hide part of an image. You can crop clip art or a picture from file. It takes practice to learn how to crop quickly.

10. The Picture Styles Gallery Not all styles are appropriate for all images.

11. Adding a Picture to a Header/Footer • You can insert a picture from a file in a header or footer. • In the header/footer section, the code is &[Picture]. • Header/footer images can be formatted from the Format Picture dialog box in the Header and Footer Elements group.

12. Adding a Picture to a Header/Footer

13. Creating a Hierarchy SmartArt Shape • SmartArt is a feature that provides high-quality text illustrations. • SmartArt shapes are not linked to worksheet data. • SmartArt shapes include a text pane for working with the text. • SmartArt shapes include bulleted lists, organization charts, cycles, pyramids, and matrices.

14. Choosing a SmartArt Shape

15. Creating an Organization Chart • An organization chart displays relationships among workers. • The SmartArt shape is in the Hierarchy category. • You can add or delete individual shapes within the chart as needed.

16. Creating an Organization Chart

17. Adding a Shape to an Organization Chart You can choose whether to add a shape above or below an existing shape.

18. Adding Text to the Shapes You can add/edit text within an individual shape or in the Text pane.

19. Building a Cycle SmartArt Shape • A cycle is a diagram that illustrates a business concept. • Cycle diagrams show a series of tasks or events that continue and repeat in a circular manner. • Some diagrams are cycles; others are radials.

20. The Cycle SmartArt Group

21. Summary • You can place images on a sheet or a chart. Images can be taken from a disk or the Clip Organizer. • Pictures have properties that depend on how the image was originally created. You can edit some of these properties. • You can use pictures in headers and footers. Some images, based on their size and color, can be used to mimic a watermark.

22. Summary • Pictures have most of the same style elements as shapes. • Cropping an image enables you to hide or mask part of the picture.

23. Summary • SmartArt graphics include many common business diagrams including Cycle, Target, Radial, Venn, and Pyramid designs. • SmartArt graphics include organization charts with various levels to illustrate relationships among workers.

24. Summary • Most SmartArt graphics have a Text pane for easy text entry and editing. • SmartArt graphics have their own styles and colors. Many can be easily changed into another layout, too. • SmartArt graphics are not linked to worksheet data.