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

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.

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.

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.

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.