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

Lesson: Working with Illustrations

Welcome to our free Intermediate Microsoft Excel tutorial. This tutorial is based on Webucator's Intermediate Microsoft Excel 2019 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

  • Learn to add pictures to your worksheets.
  • Learn to use Clip Art to illustrate your worksheets.
  • Learn to insert shapes into Microsoft Excel worksheets.
  • Learn to 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 Online Pictures (in Excel 2010, this option is called Clip Art): Online Pictures 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: Picture 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 Excel 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 Excel2019.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 Command
  2. In the Insert Pictures dialog box (Clip Art pane in Excel 2010):
    1. Type the word "baseball" in the Search for box.
    2. Press Enter. Image Search
  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: Shape Selection
  3. Your cursor will change to a plus sign: Cursor 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

Quick Shape Formatting

There are preset Quick Shape styles available in Excel from the Drawing Tools Format tab.

Theme Styles

Adding Shapes

Duration: 5 to 10 minutes.

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

  1. Open Shapes.xlsx from your Excel2019.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:Finished Shape

Working with Icons

New in Excel 2019 is the ability to insert Scalable Vector Graphics (SVGs), or icons. To do so, from the Insert tab in the Illustrations group, select Icons.Icons

The Insert Icon dialog box opens. To insert an icon, click it and then click Insert. Insert Icon

The icon is now inserted into your worksheet. You can click and drag to move it or rotate it. Inserted Icon

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 Command
  3. In the Choose a SmartArt Graphic dialog box, select a SmartArt graphic to preview it on the right: Choose a SmartArt Graphic Dialog Box
  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

Using Office Ink

If you are using a touch-enabled device, you will see the Draw tab on the Ribbon in Excel. If you are not, you can add that tab to your Ribbon by right-clicking the Ribbon and selecting Customize the Ribbon Customize Ribbon.

Then, check the Draw check box and click OK. Add Draw Tab

Here are the options available on the tab. These are the Microsoft Ink features. Draw Options

You can use the pens to write and highlight. Each pen has various thickness and color options. Use the Eraser to erase your ink. The Lasso Select tool allows you to select a shape. The Ink to Shape tool allows you to convert ink drawings to shapes. Ink to Math allows you to convert drawn data into text.