Christmas Greetings and Hints and Tips
Word
If you have ever wanted to rotate text, you may have tried using a text box to do this. If so, you will probably have noticed that it is quite limited in its capability. For more control over your rotated text, try these alternatives. Firstly, you could use Word Art (which you can format as a straight line shape in a smaller, plain black font to match the rest of the document text if you need to). Once your Word Art is formatted to your requirements, you can rotate it. The rotation tool is found:
In the Draw menu on the Drawing toolbar in Word 2003 in the Arrange group of the Format tab in Word 2007.
To freely rotate this object, ensure its wrapping option is Square – if you see the green rotation handle, you can simply drag it to the required angle:
                                                               
Alternatively, you can use the Paste Special command to turn your text into a picture:
1. Select the text to be rotated.
2. Either Cut or Copy the selection.
Word 2003 Word 2007
3. On the Home tab, click the drop-down arrow under Paste and select Paste Special.
4. Click Picture (Windows Metafile) and click OK and your text is pasted as a picture.
 3. Select Paste Special from the Edit menu.
4. Select Picture (Windows Metafile) and click OK.
5. Right-click the picture of your text and select Format Picture.
6. On the Layout tab, change the wrapping option to Square and click OK.
Word  

Add a document information Field
To include information about a document, such as its file name or the date it was last saved or printed,
use the following key words.

filename, filesize, createdate, savedate, printdate, numwords, numchars, revnum, edittime, author, lastsavedby
1. Select the word and press CTRL + F9 to convert it to a field.
2. Position the insertion point in the key word and press F9 to update it.
3. If you have more than one field in your document, press CTRL + A to select the entire document and then press F9 to update all fields.
Excel
Conditional Formatting based on another cell’s value
If you want to provide your spreadsheet with colour coding that tells you at a glance the status of a list item, conditional formatting may be the answer. To make this easier to follow, in our example we wish to format the whole row with green fill if the status is accepted.
1. Select the range to which the conditional formatting should apply.
Excel 2003 Excel2003
1. On the Home tab, in the Styles group, click Conditional Formatting and select New Rule.
 1. From the Format menu, select Conditional Formatting.
2. Select Use a formula to determine which cells to format. 2.In the Condition 1 dropdown, select Formula Is.
3. In the formula box, type the required formula. Using our example, this would be =($D1=”Accepted”)
4. Click the Format button and select the fill tab and the colour you wish to apply. Click OK and then click OK again to close the Rule dialogue box and it will be applied to your selection.
OUTLOOK
 Add a Custom Field in Outlook Contacts
 There may be information specific to your organisation’s business that it would be more convenient to store with other contact information, such as the date a contact was last invoiced, or who should receive newsletters etc. You may have entered this information in the Notes section, or even maintained a separate list in another application, however with Custom Fields you can track this for each contact, and you can perform an advanced search for contacts based on this extra information.
 
1. Open an Outlook contact.
Outlook 2003 Outlook 2007
2. Click the All Fields tab on the contact window
(the last tab).		 2. Click All Fields in the Show group of the Contact tab on the ribbon.
3. Click the New button at the bottom of the window that appears.
4. In the New Field dialogue box, type a name for the field in the Name box.
5. From the Type list, select a field type and an option from the Format list, and click OK.
For each contact you wish to complete these new fields for, make sure Select from User-defined fields in folder is selected in the All Fields window, click Value and enter the required information. Save and Close your contact form.