Tips To Excel Consultants While Using Drawings And Diagrams
Excel consultants can add drawings and diagrams to their worksheet to make it eye catching and for giving it an appealing look. But before you add drawing or diagrams to your worksheet you must know what kind of a picture you are going to use. The picture used by you can be bitmap or drawn. In any of the situation the formatting and the editing options, are different.
Bitmap pictures, also known as raster image basically look like a graph paper with dots that form an image. Normally these kinds of an image are created and edited using Microsoft paint option and usually, when resized, the picture disappears and the dot in the image becomes visible. On the other hand drawn pictures are created using lines and shapes, this makes it easier for the excel experts to change the color of either one part or all part of the picture. This picture can also be resized according to the requirement.
If your file size in bigger than a certain threshold, then you can select the compress option that is present in Microsoft office program. The compress options available in the program automatically compress the picture that best suits to its type before inserting. By compressing the picture, it might lose some quality present in it, but it becomes appropriate for your worksheet. You can also save a room in your hard disk or save download time, when formatting the picture. For this excel consultant can use the compress picture option and reduce its resolution and also discard all unnecessary information present in the picture before compressing it.
The clip organizer in the Microsoft excel contains all the important aspects like drawing, photographs, sound, video and other media files that can be used to make the worksheet attractive. This clip organizer makes it easy for you to add drawings and diagrams. Excel consultant can add and organize media clip using clip art task pane. You can find appropriate pictures, quickly and easily with the help of clip art. You just need to search for clips by using keywords and phrases that are being used in everyday life. The clip collection option helps in narrowing the search. You can find only certain type of drawings and diagrams using the clip collection option.
Once the search begins the task pane in the clip art begins listing all the relevant drawing and diagrams depending on your search, and in case the if the clip art option isn’t installed in your computer you will find a icon on the lower left side of the thumbnails, which gives the information about where the clip can be found. Excel experts can also use macros that is present in the visual basic application program. Once you have selected the drawing and the diagram, you can then align arrange and edit, depending on your worksheet. Lastly you can paste the drawing b selecting it and then holding down the shift key while clicking copy picture option on the edit menu.
Excel consultant can add and organize media clip using clip art task pane. Excel experts can also use macros that is present in the visual basic application program.