10 Tips & Tricks for “Write Personalized Reports” MS Office Image Processing#
![10 Tips & Tricks for “Write Personalized Reports 10 Tips & Tricks for “Write Personalized Reports](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLgPukl23dqikEUJjazK38zwxa-Gk9-zgc5mG7TUPvA7XyiRdhLAUHtfSTu77jVcTW5cQsA2pzd35a9gNgtdFQl4kfdFLqC3-7GLZdiNIzkLnn6u0u7q5QoXpaqiFL9wrrkyDr-bD5eeEd/w640-h454/Pink+Office+Icons+Administrative+Professionals+Day+Card.png)
Documents, spreadsheets, and presentations require images
such as a creative company logo, eye-catching charts, and great photos.
Microsoft's Office applications have built-in useful tools that allow you to
use images in your documents, but these features are not easily noticeable.
In this article, you will find tips and tricks for
decorating images in Office work, from converting an Excel chart column to a
superimposed image, creating an image animation with one click in PowerPoint,
and creating a circle and heart-shaped image in Microsoft Word. I want to
share.
These tricks are specific to Office 2010, but similar tools
can be found in previous Office versions.
1. Image processing function of messed up word
Unlike Word 2007, Word 2010 has a new graphics engine built
into Excel 2007 and PowerPoint 2007.
However, Word inserts the image in the "in line of
text" format. This setting is a feature that has no use at all unless the
user puts the image inside a table cell. Because of this setting, images are
treated like text characters and do not move smoothly within the page. The user
can rotate the image, but since the text isn't properly positioned around the
image, you need to change the image placement settings before continuing.
I recommend changing the word setting to control the image
insertion method rather than changing the placement setting for each individual
image. To do this, select File, Options, and Advanced tab before inserting an
image. Select the method other than'In line of text' in the [Picture
Insert/Paste Format] position of the [Cut/Copy/Paste] option. Personally, I
recommend the square option.
![10 Tips & Tricks for “Write Personalized Reports 10 Tips & Tricks for “Write Personalized Reports 10 Tips & Tricks for “Write Personalized Reports](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCuZBypovS8d26GmJi5Uld0uc1K88K95fWgGdx5p6xJ5Xpn1U3qJo08QhKzZJrAgg-7b5h1NFtlUNxxWbaVi6xiS5lgJvLqZNgpbSKCy31QUW7xGXAjXb_KwPHBrUE6YyMPioOiBfsozbN/w640-h528/I+recommend+the+square+option.++1.jpg)
2. Inserting an image into a frame such as a circle or heart
Users can create embedded images of almost any kind in
Microsoft Word. This function is done by selecting Insert, Shape and then the
desired shape. Let's say you have selected an ellipse. If you do this while
holding down the Shift key, you can draw a perfect circle. Once you have
selected the shape, the Drawing Tools tab appears. In the Format tab, select
Shape Fill and Picture, then select the picture you want to use and click
Insert. Users can use all built-in shapes this way. You can also create your
own shapes using curves or freeform tools and fill them with images.
![10 Tips & Tricks for “Write Personalized Reports 10 Tips & Tricks for “Write Personalized Reports](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNbAToMwTfj2YHXJNjWFCOQXfVFWa7yj7drPSz9CXgwBJUkFRSGlVS8pwA4iuQycdTmU8sYxs57SVzChlo74FNwkoh8vavpoYAX-yke7gaddXjlKbwG6DXqphAE6A1dNUsVXazfTEv8X8M/w640-h448/.+You+can+also+create+your+own+shapes+using+curves+or+freeform+tools+and+fill+them+with+images.+2.jpg)
If the image does not fit within the shape, select the shape
and right-click to select the shape format. Select the size option and increase
the width setting if the image is stretched and taller than its original
height. Similarly, if the image is stretched and wider than its original width,
increase the height setting. If you want to increase both the width and height,
you can adjust the position of the image within the shape using the scale
option. If you want the image to remain horizontal even if the shape rotates,
deselect the Rotate menu along with the shape.
You can adjust the transparency of the image in the shape by
selecting one of the fill options in the'Picture or Texture Fill Area'.
3. Place text around or in front of an image
If you select the image placement setting to square or
tight, the text is placed around the image. Since most images are square, the
layout will be square, but you can change this if you want. Select the image,
select Picture Tools, Format, Text Placement, and then Edit Text Placement
Area.
![10 Tips & Tricks for “Write Personalized Reports 10 Tips & Tricks for “Write Personalized Reports](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWRgu90_XjKmi0RdV9cL-UJKpMC3gaQzwSL4bwhfNPh7ZjagQqwiFraXXVLv6RucjPhqkEsljvZMeTB_8as2XuJv_y3MNUsumpd_LwQxY28WcLiPBogbmfvhdHnONfueWatc-0P-xJ0LSU/w640-h530/Select+the+image%252C+select+Picture+Tools%252C+Format%252C+Text+Placement%252C+and+then+Edit+Text+Placement+Area.+3.jpg)
By adjusting the nodes that control how the text is placed
around the image, the user can overlap the text and the image or place the text
around the image. To add more nodes, simply click and drag the desired location
on the line. To remove a node, click on the node while holding down the Control
key.
When you're done, just click outside the marked area to make
the adjustment handles disappear. To apply the same function to a shape filled
with an image, select the shape, select drawing tools, format, and then select
shape edit and point edit.
4. Using your signature or logo as clip art
It is easy to register images such as a user's corporate
logo or scanned signature as a clip art image. To do this, select Microsoft
Clip Organizer from the Microsoft Office 2010 tool in the program at the start
of the computer, then select File, Add Clip, Direct. Next, find the file that
contains the signature or logo you want, then click Add.
Select Edit Keywords from the drop-down list on the right
side of the image and add keywords to make it easier to find the image in the
future. Click Apply to apply the changes and click OK to close the Clip
Organizer.
When adding a logo or signature to a document in the future,
select Insert, Clip Art, enter one of the keywords you added to the image,
deselect Include Office.com content, and select illustrations and
illustrations. Just select Photos and Photographs and click Go. At the point when
the picture shows up in the board, click it to embed it into your record.
5. Using Picture Chart in Excel
Instead of filling a 2D column or bar chart with a single
color or boring pattern, you can also fill it with images. To do this, select
the column or graph you want to change and right-click with the mouse. Select
Format Data Series, select Fill, and then select Picture or Texture Fill.
Choose from images saved on disk, clip art, or clickboard. It's a good idea to
choose a simple line-art image. Make sure to select Stacked so that the image
does not stretch, and click Close.
![10 Tips & Tricks for “Write Personalized Reports 10 Tips & Tricks for “Write Personalized Reports](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEl_eYgOs6TWoRhh5zaDTgA2-7nGfY7IFS5SBB_YBlVMss-dOsYc67JEFrFgxFcG1k8bFgX-Oe8Ea_XQs4UuID-u9fi7j9d0QlGMTSl0ztlZkolLCpkga-nKF1fnU6Wnu3C8Beqk02uwt2/w640-h514/Make+sure+to+select+Stacked+so+that+the+image+does+not+stretch%252C+and+click+Close.+5.jpg)
Users can add a single image to the entire data series, or
select a single graph or column and use Format Data Point to add different
images to each column or graph.
6. Adding images behind charts and worksheets
In addition to swapping graphs and columns, users can add
pictures to the back of the chart or after the plot area of the chart. To do this, select a chart, then
select Chart Tools, Layout. Select Chart Area or Picture Area as desired from the
drop-down list in the upper left corner of the Ribbon toolbar. Click Format
Selection just below the Selector, choose Fill, Picture, or Texture Fill, then
choose the image you want. Here, the user can change the transparency of the
image if he wants to see the chart through the image. Finally, click Close.
If you add an image to the chart area and the picture area
is filled with solid color, the user will not be able to see the image located
below it. To solve this problem, repeat the above procedure after selecting a
picture area, a selection area format, fill, and No Fill. Alternatively, you
can select Solid Fill, select a color to fill, and set the transparency to a
high value.
7. Adding a logo to the Excel printout
Users can easily add a company logo or other image to the
header of an Excel worksheet so that the image is displayed on all sheets. To
do this, select Insert, Header&Footer and click one of the boxes at the top
of the sheet. Click the Picture button and select the image you want to insert.
![10 Tips & Tricks for “Write Personalized Reports 10 Tips & Tricks for “Write Personalized Reports](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvRKPXBycGHIs45hyphenhyphenpkm0WSGDqBR4z14iyhoTe8TxJQRbZsfA1jUYpF0j2HGTa9OOdxsE7dm8NxVmNf4yq8beDqA5Oetyy3BgAiKHUmi1NKc0BbCo0kA9Ebw2F7PRAKe1hUVZhrIEQ15GT/w640-h524/Click+the+Picture+button+and+select+the+image+you+want+to+insert.+7.jpg)
If the image is larger than the header, it will be placed
around or below the worksheet. Therefore, you must check the size. To do this,
click on the picture format and select the Lock Aspect Ratio checkbox so that
the ratio of the image is fixed.
Now adjust the height
value to about 0.75 inches or a size that fits the header area. Select View,
Page Layout to check the result. To increase the header margin by adjusting it,
select Page Layout, Margins, and Custom Margins and set the header margin value,
or drag the vertical ruler's Marker downward to adjust the size.
8. Save the worksheet as a picture
If you need a picture of a worksheet or chart to use as a
thumbnail or cover page, you can do this with Excel. First, select the data
area of the cells you want to convert
into pictures. For charts, choose the chart itself. Select Copy as Picture from
the Copy drop-down list in the Home tab of the ribbon toolbar.
The user can then capture the image as it appears on the
screen or as it appears on print. If possible, select the Picture or Bitmap
option and click OK. You can now paste pictures into any application.
9. Create an Image Map in PowerPoint
When putting an image on a PowerPoint slide, users can add a
clickable hotspot to the inserted image, just like creating a clickable image
map on a website. First, let's add an image to the blank slide. Select Insert,
Shape and choose the shape you want. Draw a shape over the image.
![10 Tips & Tricks for “Write Personalized Reports 10 Tips & Tricks for “Write Personalized Reports](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpk8gxjG_sLjP-Mc1942YWwze2nHOLaqx3y9ZiQmMiI8uVN9J-9qEDkgvobGvrAAkhGQS0y48TZOTBF6ipulZi5r2Io6YRwfIldLG01iko7cOxRm2LVjG_vPoyHS4MA3N5EEjnlSAbrrTt/w640-h492/Select+Insert%252C+Shape+and+choose+the+shape+you+want.+Draw+a+shape+over+the+image..jpg)
If you select the redraw tool, format, fill in shape, no
fill, and then select Shape Outline or No Outline, the figure will not be
visible. With the shape selected, select Insert, Action, and then select the
function you want to be executed when the user clicks the shape. For example,
you can choose to go to another slide or URL. Select Hightlight Click and click
[OK].
Users can check this by adding multiple clickable shapes to
this slide and then running the presentation. When you place the mouse point on
the clickable area and click, the designated action is executed.
If desired, the user can set the shape to change color,
become partially transparent, outline, or display text on the shape.
10. Creating a simple image animation
To create a simple animation in PowerPoint, first add shapes
and pictures to the slide. After selecting Animations, click on the picture and
click on an option such as Fly In.
![10 Tips & Tricks for “Write Personalized Reports 10 Tips & Tricks for “Write Personalized Reports](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGpI1sfuS_nnIofuMw_terwiUdgtGlMMnW83Cu7o6KpeiYkAYr4voJi7qNk_vIQw2mgHXbla7U9dNR_NNnzQ7BuNktDo5o1lsipvtKDdluuNmVWogIYJA5JKAF157eOBvaYy0AslRJ_lV2/w640-h458/After+selecting+Animations%252C+click+on+the+picture+and+click+on+an+option+such+as+Fly+In..jpg)
Click the Custom Animation button. In the settings pane,
click the drop-down list that appears in the picture animation area. Select
Effect Options. On the Timing tab, select Triggers, then Start Effect, select
the shape name from the list, and click [OK]. When playing the slide, click on
the shape and the picture will appear.
0 Comments