facebook google plus twitter
Webucator's Free Intermediate Microsoft Excel 2013 Tutorial

Lesson: Working with Illustrations

Welcome to our free Intermediate Microsoft Excel 2013 tutorial. This tutorial is based on Webucator's Intermediate Microsoft Excel 2013 Training course.

Adding illustrations to Microsoft Excel worksheets is a great way to improve their look and feel, and also to illustrate your points. Fortunately, it's easy to add pictures (your own or choose from a large library of pictures provided by Microsoft) and shapes.

Lesson Goals

  • Add pictures to your worksheets.
  • Use Clip Art to illustrate your worksheets.
  • Insert shapes into Microsoft Excel worksheets.
  • Use SmartArt to illustrate your worksheets.

Working with Clip Art

A large library of Clip Art, including drawings, videos, sounds, and photographs, is available from Office.com. To insert Clip Art into your worksheet:

  1. From the INSERT tab, in the Illustrations group, click Clip Art (in Excel 2007/2010, this option is called Clip Art): Clip Art Option
  2. In the Insert Pictures dialog box that appears:
    1. Type in your search word(s) and press Return.
    2. View the results of your search: Search Results
  3. Double-click one of the results to add it to your worksheet.
  4. Resize the image and/or cell to fit the image into your worksheet.

In Word 2007/2010, you will use the Clip Art dialog box that appears at the right to search for and select clip art files.

Working with Clip Art

Duration: 5 to 10 minutes.

In this exercise, you will search for Clip Art available from Office.com and insert an image into a worksheet.

  1. Open Clip Art.xlsx from your Excel2013.2/Exercises folder.
  2. Insert a baseball-related picture from Clip Art at the top of the worksheet.
  3. Resize the image and/or cell to fit the image into your worksheet.

Solution:

  1. From the INSERT tab, in the Illustrations group, click Online Pictures (if you are using Excel 2007 or 2010, select Clip Art): Online Pictures Option
  2. In the Insert Pictures dialog box (Clip Art pane in Excel 2007/2010):
    1. Type the word "baseball" in the Search for box.
    2. Press Enter. Search for Box
  3. Double-click one of the results to add it to your worksheet.
  4. Resize the image and/or cell to fit the image into your worksheet.

Using Shapes

You can easily add a wide variety of shapes to your Microsoft Excel worksheets, including squares, circles, stars, arrows, smiley faces, lines, equation shapes, callouts, and more. To insert a shape into a Microsoft Excel worksheet:

  1. From the INSERT tab, in the Illustrations group, click Shapes: Shapes Command
  2. Select a shape by clicking on it: Selected Shape
  3. Your cursor will change to a plus sign: Plus Sign
  4. Click in your worksheet where you want to place the shape, drag your mouse until the shape is the size you want it to be, and then release your mouse.

Selecting a shape in Excel brings up the DRAWING TOOLS tab: DRAWING TOOLS Tab

Adding Shapes

Duration: 5 to 10 minutes.

In this exercise, you will add a shape to a worksheet.

  1. Open Shapes.xlsx from your Excel2013.2/Exercises folder.
  2. Insert a smiley face shape to the right of the baseball mitt.

Solution:

  1. From the INSERT tab, in the Illustrations group, click Shapes: Shapes Command
  2. Select the smiley face shape by clicking on it: Smiley Face Shape
  3. Click in your worksheet to the right of the baseball mitt, drag your mouse until the shape is the size you want it to be, and then release your mouse:Dragged Shape

Working with SmartArt

SmartArt diagrams include process diagrams, list diagrams, hierarchy diagrams, pyramid diagrams, and much more. To insert SmartArt into a Microsoft Excel workbook:

  1. Place your cursor in the location in your worksheet where you want your SmartArt graphic to appear.
  2. From the INSERT tab, in the Illustrations group, click SmartArt: SmartArt Option
  3. In the Choose a SmartArt Graphic dialog box, select a SmartArt graphic to preview it on the right: SmartArt Graphics
  4. Click OK to add the SmartArt graphic to your worksheet.

Selecting a SmartArt diagram in Excel brings up the SMARTART TOOLS tabs:

  1. DESIGN: DESIGN Tab
  2. FORMAT: FORMAT Tab