This week, we have seen how we can format our workbooks to make them more attractive. Another option we have to make our workbooks more attractive and our data easier to understand, is to include graphical elements. And we're going to look at how to do that here. When we want to insert a graphical element, we're going to start by coming to the insert tab on the ribbon. The group called illustrations allows us to insert quite a large variety of graphics. Let's start by looking at how we can add a shape. We're going to come to the shapes button, and click on it. There is quite a large variety of shapes we can choose from. Let's start with a simple rounded rectangle. This is often found in the recently used shapes or in the rectangles. Click once to select the shape. When you now move into your workbook, you should see a small crosshair. Start by positioning the crosshair at the top left corner where you wanted to begin. So I'm going to start over here. Now, I'm going to click my mouse and hold down but not release until I've finished drawing the shape in. Once in place, release your mouse button. The moment you have inserted the shape, a new ribbon tab will appear called the drawing tools. This allows you to format that shape. So for example, come to shape styles and click the drop-down. These are our theme colors. But you can not only change color, you can also add some quite nice stylings like a drop shadow or a fade effect. Select the style you want, and click to apply it. If you don't like those colors, you can come to the shape fill, click the drop-down, go for a theme color or even go for more fill colors. And I need a nice dark red. So I'm going to select that, and say, okay. You can also add an outline to your shape which is like a border, or you can add different effects. To add text to the shape, with the shape selected, just start typing. So this workbook is going to store my monthly expenses. When you have finished typing the text, you can either select the text, or if you click away and click back on the shape, any changes you make to text formats will affect all the text within that shape. So I'm going to now come to my home tab, I'm going to change my font size to 28, and I'm going to center it both vertically and horizontally. So I've now created a nice big heading without too much complexity. The newer versions of Excel also lets you insert icons, and these can be quite good fun. If you don't have one of the newest versions, don't worry, there are lots of other things we can do as well which I'll show you in a moment. So come to the insert tab, click icons. And as you scroll down, you'll see you have quite a nice selection. Now we're looking at monthly expenses, so we're going to select cash and then say, insert. And then to move this, just click somewhere in the middle of it, you'll see this four headed black arrow. Click, hold, and drag to position it where you want it. Now, it's possible you may wish to actually include a company logo or a graphic that explains what's happening in that spreadsheet. You can do this as well. So back onto my insert tab, there are two picture options, pictures and online pictures, or if you have an older version, this will say, clip art. Online pictures or clip art will allow you to get copyright free images from the web. Pictures allows you to get a picture from your hard drive or your network. I'm going to click on the pictures icon. And you can use any picture you have but I'm going to use my company logo. So, I'm going to select it and then click insert to put the logo in. To resize a picture, use any of the corner bubbles, hover over them. Click and drag to make it bigger, or drag it towards the middle to make it smaller. Finally, let's look at something quite exciting called SmartArt. We don't typically use SmartArt in Excel, but it's nice to see what your options are. I'm going to come to my insert, and find the SmartArt tool. SmartArt is really a diagramming tool. So if you want to put a simple process flow or set of instructions in your Excel spreadsheet rather than a bullet list, use a graphic. So I'm going to choose SmartArt and then I'm going to go for a process, and I'll go for a nice simple one. Yeah, that'll do nicely. And then say, okay. Now you can either type in the shapes themselves, or you can type into the box on the left. So my process is going to be, a complete expenses, then manager to sign. And I'm just clicking down each time to get to the next one, and submit to HR. Now with my SmartArt still selected, you'll notice I now have a SmartArt tool. I can change the colors, I'm going to go for something a little bit more gray. And you can change your effects as well. So you have these SmartArt styles, so I'm going to go for this effect. I'm then going to position it, make it a little bit smaller at the bottom but then drag it across the bottom to make it take up the full width. When I click away from the SmartArt, that little box disappears. So, there is my attractive looking spreadsheet. All it needs now is some numbers.