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.
A large library of Clip Art, including drawings, videos, sounds, and photographs, is available from Office.com. To insert Clip Art 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.
In this exercise, you will search for Clip Art available from Office.com and insert an image into a worksheet.
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:
Selecting a shape in Excel brings up the Drawing Tools tab:
There are preset Quick Shape styles available in Excel from the Drawing Tools Format tab.
In this exercise, you will add a shape to a worksheet.
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.
The Insert Icon dialog box opens. To insert an icon, click it and then click Insert.
The icon is now inserted into your worksheet. You can click and drag to move it or rotate it.
SmartArt diagrams include process diagrams, list diagrams, hierarchy diagrams, pyramid diagrams, and much more. To insert SmartArt into a Microsoft Excel workbook:
Selecting a SmartArt diagram in Excel brings up the SmartArt Tools tabs:
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 .
Then, check the Draw check box and click OK.
Here are the options available on the tab. These are the Microsoft Ink features.
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.