Skip to main content
SAGE
Search form
  • 00:01

    SPEAKER 1: Hello.Now in this section, we're going to learn how to insert graphicsinto Excel worksheets.And what I mean by graphics, I meanimages, pictures, also shapes and arrows and thingslike that.A lot of times, you'll have a table like this,and then you'd like to call someone's attentionto a particular part of the sheet.And so we'll learn how to do that.

  • 00:22

    SPEAKER 1 [continued]: The first thing I want to do, and it's kind of funactually, if you want to insert any of these things,you go off to the Insert tab.We've been here before many times.We have inserting tables and inserting charts.In between them, we have inserting pictures.So let's go ahead and click that.You can navigate to whatever directory you want.I'm going to insert this image, whichis an image of me doing a science experiment.

  • 00:45

    SPEAKER 1 [continued]: And it's a very large image, so it'sgood to illustrate that you can grab the cornersand you can drag and resize the location of this thing.And Excel is smart enough to make it look really nice.And by the way, this is an image of a bubblefilled with carbon dioxide, dry ice gas, basically.And it's a little science experiment that I've done.

  • 01:05

    SPEAKER 1 [continued]: So but you could be inserting, you know, anythingfrom images of yourself to a logo,like a company logo or whatever.So let's say, for whatever reason,I want to put this at the top, above this table.So I want to move this table down.I'll go ahead and highlight everything there.I'll right click, and I'll hit Insert,which is inserting rows.So the table is bumped down, and now I have plenty of room.

  • 01:27

    SPEAKER 1 [continued]: Well, maybe not quite plenty of room.I can make this a little bit smaller.And I can put it up here.This could again be a company logo, could be a tagline,could be an image of yourself, whatever.You have complete control over where these things go in Excel.Now, that's how to insert images.But frequently, we want to insert shapesfor one reason or another.

  • 01:47

    SPEAKER 1 [continued]: And so over here to the right of the imagethere, I'll go to the Insert tab.And again, here's pictures, if you're goingto search for pictures online.But here is what we call inserting shapes.So let me click this dropdown.And you have an entire potpourri of thingsthat you can choose, from hearts to smiley faces

  • 02:07

    SPEAKER 1 [continued]: to different kinds of block arrows, flowchart shapes,you can draw your own flowchart here.There's basically infinite amountof things you can choose.Here I'm going to choose a rounded rectangle justto kind of illustrate it for you.And once I've done that, my cursor changes to a cross.And so once you start clicking and dragging,then this rounded rectangle comes to life

  • 02:30

    SPEAKER 1 [continued]: with a default color, which is, again, selected up here.And I've got a blue color.Now, notice that once this shape is created and selected,I've got on the ribbon menu a Drawing Tools Format tab.This is only visible when the shape is selected.If you click off of it, it disappears.It's just like the table.When I click on the table, I have

  • 02:51

    SPEAKER 1 [continued]: design tools for the table.When I click on the picture, I haveformat tools for the picture.When I click on the rectangle, I have drawing toolsthat relate to this rectangle.So if I click on that tab, there are many, many thingsthat I can do right away.The easiest thing to show you is that Ican change the fill color of this rectanglejust by clicking.So let's say I want to do, you know, something like that.

  • 03:13

    SPEAKER 1 [continued]: I can change the outline color to be a different color,if I want the outline color to be,you know black, for instance.I can something like that.I can do other things, like I can make it look beveled.I can make it have a little bit of a shadow.You know, so you can go in there and play aroundwith making it look exactly like you want.

  • 03:34

    SPEAKER 1 [continued]: And if you don't want to fiddle aroundwith any of those things, just click on this button righthere, and you have kind of a predefined setof nice-looking shapes.So I like this blue one here.So I'm going to click that.It's a nice gradient a little bit.You can see it's got a little bit of a shadow there.I like to stick with the standard ones here.But you can certainly go off and play aroundwith making it look exactly the way you like.

  • 03:59

    SPEAKER 1 [continued]: So now that we have our rectangle created,if we clicked to select it, we can justbegin typing right now.We can say 2013 quarterly-- or let's say annual results.So I could make this rectangle basically a titlebox, if I'd like.Instead of just putting it in a cell, whichwould serve its purpose, I can jazz it up a little bit

  • 04:20

    SPEAKER 1 [continued]: and make it look like this.Now this text in here I can select and highlight, justlike any other text.I can go to the Home menu.I can make this text bold.I can change the font.I can actually move it to the center.I can move it and align it vertically like this.And if I really want to make it stand out,maybe I want to use, instead of black,maybe I want to use white text, because white text will show up

  • 04:42

    SPEAKER 1 [continued]: really nicely on a blue background.So this is a very quick way to create a title bar thatis just a little bit more catchy than justtyping it into a cell like that.So this is just one shape, don't forget.This is a rounded rectangle.Let me go down here.And let's go into insert shape again.And notice all the other things that we want to do.Let's say here is an oval, but if you just draw an oval

  • 05:06

    SPEAKER 1 [continued]: and just drag it, you notice how you can make it fat or skinny,like this.What if you want a perfect circle?If you want a perfect circle, go back to Insert.Go back to Shapes.Go back to Circle.What you need to do is hold the Shift key down.I'm holding the Shift key down while I drag.Now, notice now, as I move my mouse around with the Shiftkey held, it kind of constrains the proportions

  • 05:29

    SPEAKER 1 [continued]: so it looks like a circle.If I go up here and insert a shapeand I choose that rounded rectangle again,and now I hold Shift while I do it, then it becomes a square.So I'm forcing the proportions to basically make itinto a perfect shape.So just don't forget that, as you insert these shapes,you have triangles and rectangles and circles,

  • 05:50

    SPEAKER 1 [continued]: but you can also make them look like squares and ovals.And you can make this diamond, for instance.You can make it long and skinny, or youcan make it short and fat and so on, justby doing something like that.Also, we have things like arrows.You know, we can draw arrows right on the sheet.So for instance, what if I want to draw, you know,someone's attention to this entry right here.

  • 06:13

    SPEAKER 1 [continued]: I can drag the end of the arrow.I can drag the head of the arrow like that.I can go in here to change the color under Shape Outline.I can go and change it to black, for instance.And then if I wanted to, I could go to Insert Shape.I can do a regular hard rectangle.And I can hold the Shift key and kind of

  • 06:34

    SPEAKER 1 [continued]: make this into a square.And I can type in here, and I'll just say, look at the moneywe lost.Or something like that.And then I can take this head of this arrowand kind of connect it.So you can kind of just play aroundwith Excel creating little boxes and little shapes.And you can kind of do as many things as you want.But the problem is you've got to rein yourself in,

  • 06:55

    SPEAKER 1 [continued]: because if you put too many shapes and too many arrows,I mean, you can have arrows pointing everywhere.And then the worksheet becomes completely unreadable.So in order to get rid of things,just highlight them and delete them.Or you can simply do something like this.You can delete the text first, or you can clickon the entire thing, delete it.Click on the arrow, and delete it like that.

  • 07:16

    SPEAKER 1 [continued]: OK.Now up till now, we've talked about inserting pictures,we've talked about inserting graphics, and justkind of shapes, basic shapes.But there's one other thing that I wantto make sure you understand.If you click on Insert, right under Insert Shapethere is insert Smart Art Graphic.Insert Smart Art Graphic.When you click that, and you see a whole entire subset of things

  • 07:38

    SPEAKER 1 [continued]: that you can create.You've got different lists that you can create,like almost like bulleted lists thatlook really nice and beautiful.Process flow charts.If you're a scientist, engineer, somebody dealingwith process flows, you can createentire beautiful graphics that deal with this.Hierarchy is something very common also.You might have, for instance, a org chart or something

  • 07:60

    SPEAKER 1 [continued]: like that with the president, CEO.So if you wanted to click something like that,and then go ahead and hit OK, then youwould see this graphic here.Now let me go and zoom out of the spreadsheetjust a little bit so we can see what we're doing.And then I can take this whole graphicand kind of move it down here.And you can just-- you can see you can either type in here,or you can type in here, but basically youknow, of course, Jason's going to be at the top of the list.

  • 08:22

    SPEAKER 1 [continued]: You know, you can have Alexander.And as you type, it's going to go in here.And I could have-- under here, I could have CEO.And I could have Alexander being vice president, et cetera.So you see the point there.I can go in there and create these smart chartgraphics, where I can go in there and add crazy things.

  • 08:45

    SPEAKER 1 [continued]: Now as I highlight them, I have smart tools, I have a designand I have a format tab up here.I'll leave it to you to play with this stuff.I mean, you can change the font colorsand the background fills.All this stuff starts to look very similar in Excelbecause they've using the same interface for allof these different features.I can change the type.I can put a picture in here, Jason's picture and Alexander's

  • 09:06

    SPEAKER 1 [continued]: picture, and so on.And if I click this down arrow here,then I have lots of different other typesof these types of org charts that Ican create that would just make them lookall a little bit different.So that's how you insert the smart graphics.You know, it's something that some people use.It definitely can jazz up your spreadsheet

  • 09:27

    SPEAKER 1 [continued]: and make it look nice.But you just have to be careful because there issuch a thing as overdoing it.You know, if you add too many things to your worksheet,you can just make it confusing and cluttering, cluttered.But I do encourage you to go playwith them because it has some pretty neat capabilities there.The most common thing you're going to do hereis drop a picture in, drop a shape in, drop an arrow in.

  • 09:47

    SPEAKER 1 [continued]: Everything else is just kind of goingto depend on your situation, what you're really tryingto go for in your worksheet.

Video Info

Series Name: Mastering Microsoft Excel: Essential Skills

Publisher: MathTutorDVD.com

Publication Year: 2013

Video Type:Tutorial

Methods: Practical skills

Keywords: computer literacy; computer programs; Microsoft; Software; Spreadsheets

Segment Info

Segment Num.: 1

Persons Discussed:

Events Discussed:

Keywords:

Abstract

Jason Gibson explains inserting graphics into an Excel worksheet.

Looks like you do not have access to this content.

Insert Shapes, Pictures, Arrows, SmartArt

Jason Gibson explains inserting graphics into an Excel worksheet.

Copy and paste the following HTML into your website