PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO INSERT PICTURES, CLIP ART , icons AND SMART SHAPES IN EXCEL?

INTRODUCTION

Beautification is a part of the presentation skills. When we present our report to somebody, the first and foremost aspect which strikes somebody’s mind is the look of the report.

How we are trying to present our data???

Is the blend of text and graphics correct or its just a boring report containing pages filled with  numbers and text.

Insertion of pictures or clip art (pictures provided by Excel) or the different shapes (e.g. a line, line with arrow, directional arrows etc.) are needed for the better presentation of data. It can be done easily using these options.

Let us find out the location of the buttons.

WHERE TO USE PICTURES, CLIP ART, ICONS, SHAPES AND SMART ART

All these options are going to be used a lot. Let us try to enlist the situations when we can use each of them in our reports.
PICTURE: The picture needs to be inserted into report frequently. If we are presenting some real time report in which we need to show the current situation of any space, the picture needs to be inserted into the report.
 
CLIP ART , ICONS : The clip art or icons [icons has replaced clip art in newer versions of EXCEL] contains a data base of graphic images which we can use in our report at some apt places if we feel so. We have got online support too, if we can’t find the one we need. It is completely on our discretion where to use these icons or clip arts.
 
SHAPES: Excel offers the insertion of different ready shapes. We can use shapes in various problems such as creating some graphics for the description of any issue, creating customized charts, creating any marks etc.
 
SMART ART: It was a very new and unique option given by the Excel. It is used extensively in showing some hierarchy, some process, any sequence of steps etc. There are many options available.
Let us see how we can insert all of these.

LOCATION OF BUTTON FOR ILLUSTRATIONS

The option for inserting picture, clip art , icons or smart art is present under the INSERT TAB under ILLUSTRATIONS SECTION as shown in the picture below.
insert picture excel
BUTTON LOCATION FOR ILLUSTRATIONS
INSERT ICONS IN EXCEL SHEET
BUTTON LOCATION FOR ILLUSTRATIONS IN EXCEL 2019

HOW TO INSERT PICTURE IN EXCEL?

STEPS:

  • Click the location, where we want to insert the picture.
  • Click on the picture button.
  • Picture Selection dialog box will open, as shown in the picture below.
  • Browse the picture to be inserted.
  • Click INSERT.
  • The picture will be inserted at the selected location.
  • After the insertion, picture becomes an entity and we can change the style of the picture play with its colors etc.
insert excel pictures
INSERTING THE PICTURES

HOW TO INSERT CLIP ART IN EXCEL?

STEPS:

  • Click the location, where we want to insert the clip art.
  • Click on the clip art button.
  • Picture Selection dialog box will open, as shown in the picture below.
  • We can search the clip art or choose the selections.
  • Choose the clip art to be inserted.
  • Double Click it.
  • The clip art will be inserted in the location.
insert clipart excel
INSERTING CLIP ART

HOW TO INSERT ICONS IN EXCEL?

ICONS ARE PRESENT IN THE NEWER VERSIONS OF EXCEL. [2019 AND 365]

STEPS:

  • Click the location, where we want to insert the icon.
  • Click on the icon button.
  • A detailed icon dialog box will open. [ As shown in the picture below]
  • Choose the category on the left, and choose the desired icon from the right as mentioned in the pictures.
  • Double click the icon.
  • The icon will be inserted.
  • After the insertion, icon becomes an entity and we can change the style of the picture play with its colors etc.
INSERT ICONS INTO EXCEL
INSERTING ICONS

HOW TO INSERT SHAPES IN EXCEL?

STEPS:

  • Click on the SHAPES button.
  • A Choice box will open.
  • Double Click on the desired shape and the shape will be inserted into the sheet.
SMART SHAPES EXCEL
INSERTING THE SHAPE IN EXCEL SHEET

HOW TO INSERT SMARTART IN EXCEL?

The smart shapes are used for describing different types of lists, processes, cycles , hierarchy, relationships, matrix and pyramid etc.

 

STEPS:

  • Click on the SMART ART BUTTON.
  • Choose the type of smart art you want from the given list.
  • Double click on the smart art you want to insert.
  • Add the data to the smart art.
INSERT SMARTSHAPES EXCEL
INSERTING SMART ART

EDITING THE DATA

  • Click on the center of the shapes one by one.
  • As we click, the cursor will change to the EDIT TEXT.
  • Put the text in all the shapes one by one.
  • The smart shape is ready.
  • Refer to the picture below for reference.
EDITING SMART ART IN EXCEL
EDITING SMART ART

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

YOU MAY LIKE

PREVIOUS ARTICLE
NEXT ARTICLE

LEARN

Encourage us by following at …

Facebook
Twitter
Pinterest

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]