It is always nice for callers who have to leave a Voice Mail to know that they are leaving the message for the right person. Personalizing your Cisco IP Phone Voice Mail is fast and easy, and can help reassure these callers.

To set up your voice mail:

1. Press the Message button on the right hand side of the keyboard.
2. Enter the default password 12345 followed by the # key.
3. Follow the instructions given to record your personal greeting and create your new password.

Now, with the Holiday Season approaching quickly knowing how to set up an alternative greeting is important. This is also easy to do and can be helpful for callers.

To set up your temporary (or alternate) greeting

1. Dial 4790 from on campus or (336) 278-4790 from off campus.
2. Login using extension and password if on campus; off campus do * then extension and password.
3. Press 4 to reach setup options.
4. Press 1 for Greetings.
5. Press 3 and choose alternate greeting.
6. Follow instructions to record your alternate greetings.
7. Press 2 to turn on alternate greeting and set expiration day and time.

For more information on the IP Phone Voice Mail system be sure to visit the Desktop Phones page on the technology wiki.

Labels: IP Phones

Many of the phones located in offices around campus are Cisco IP Phones. Here are some phone tips to help you use all the features that are available on this phone:

Placing a Call - You can place a call with your telephone by:

1. Lift the handset from the rest and dial the number.

2. Press a line button and dial the number.

3. Press the New Call soft key and dial the number.

4. Press the Redial soft key. If the number was just dialed, you will be connected.

5. To use the speakerphone, press SPEAKER and dial the number.

Answering a Call - You can answer a call by:

1. Lift the handset from the earpiece rest.

2. Press the Answer soft key or the SPEAKER button.

Ending a Call-To end a call:

1. Put the handset on the earpiece rest.

2. Press the SPEAKER button.

Transferring a caller to another number

1. Press transfer
2. Dial extension
3. Note who you are transferring and why
4. Press transfer again to transfer caller, then hang up

Transferring a caller directly to someone's voicemail

1. Press transfer
2. Dial * and extension
3. Press transfer quickly again, then hang up

Forwarding a phone extension directly to voicemail (all calls to the extension will go into voicemail)

1. Press CFwdALL button on phone
2. Dial * and your extension
3. To end call forwarding directly to voicemail , press CFwdALL button

For more information on placing calls be sure to visit the Desktop Phones page on the technology wiki.

Stayed tuned for tips on the Cisco IP Phone Voice Mail!

Did you know that you can implement certain rules to check for errors in formulas when using Microsoft Excel? These rules can help you find common mistakes when using formulas and these rules can be turned on or off individually.

Errors can be marked and corrected in two ways: one error at a time or immediately when they occur on the worksheet as you work. Either way, a triangle appears in the top-left corner of the cell when an error is found.

Errors that cannot return a result (such as dividing a number by zero) require attention and display an error value in the cell. Other errors can be less serious, such as a formula that appears to be inconsistent with adjacent formulas. The formula returns a correct result, but the error advises you that you should examine the formula.

You can resolve an error by using the options that appear or you can ignore the error by clicking Ignore Error. If you ignore an error in a particular cell, the error in that cell does not appear in further error checks. However, you can reset all previously ignored errors so that they appear again.

To find out more about checking common errors in excel and how to turn these rules on or visit Microsoft Office Online.

Labels: Excel

One of the most helpful toolbar buttons in Office programs is the Format Painter. This button offers a quick way to copy formatting from one item to another.

Using Format Painter saves you time and effort. Instead of having to manually apply the font, font effects, centered paragraph alignment, and other formatting to each new section heading, you can quickly copy all of the formatting attributes by using one toolbar button.

To copy formatting:

1. Do one of the following:
To copy both paragraph attributes (such as alignment, indentation, and so on) and character attributes (such as font and font effects), select the text whose formatting you want to copy plus the paragraph mark that follows the text.
To copy only character attributes, select the text without selecting the paragraph mark.

2. On the Standard toolbar, click Format Painter.

3. Select the text you want to apply the formatting to.
The text takes on the new formatting.

If you want to apply the same formatting to more than one item, select the formatting you want, double-click Format Painter, and then select each word, phrase, or paragraph you want to apply formatting to. When you're finished, press ESC.

For more information about the Format Painter visit Microsoft Office Online.

Labels: Word

The Microsoft Office Clipboard allows you to copy up to 24 multiple text and graphical items from Office documents or other programs and paste them into another Office document. Whether you need to copy text from a website, e-mail message or a graphic, office Clipboard can help you arranged the copied items the way that you want in the document.

Word

1. Open the file that you want to copy items from.

2. Select the first item that you want to copy.

3. On the Home tab, in the Clipboard group, click Copy.

Keyboard shortcut To copy an item, press CTRL+C.

4. Continue copying items from the same or other files until you have collected all of the items that you want. The Office Clipboard can hold up to 24 items. If you copy a twenty-fifth item, the first item on the Office Clipboard is deleted.

If you open the Clipboard task pane in one Office program, the Clipboard task pane does not automatically appear when you switch to another Office program. However, you can continue to copy items from other programs. If the Show Status near Taskbar When Copying option is selected (to verify, click Options in the Clipboard task pane), a message is displayed above the status area to indicate that an item has been added to the Office Clipboard.

As items are added to the Office Clipboard, an entry is displayed in the Clipboard task pane. The newest entry is always added to the top. Each entry includes an icon representing the source Office program and a portion of copied text or a thumbnail of a copied graphic.

Paste items

You can paste items from the Office Clipboard individually or all at the same time.

1. Click where you want the items to be pasted. You can paste collected items into any Office program.

2. Do one of the following:

§ To paste items one at a time, in the Clipboard task pane, double-click each item that you want to paste.

§ To paste all the items that you copied, in the Clipboard task pane, click Paste All.

Note   The Paste Special command is available from the Clipboard group but is not integrated into the Office Clipboard task pane functionality.

Delete items from the Office Clipboard

You can delete items from the Office Clipboard individually or all at the same time.

In the Clipboard task pane, do one of the following:

To clear one item, click the arrow next to the item that you want to delete, and then click Delete.

To clear all items, click Clear All.

For more information on how to use the Office Clipboard in other Microsoft Programs visit Microsoft Office Online.

Labels: Word

Have you ever been typing a document in a foreign language and wished you had spell check to review your work?  Well, with the help of three simple steps in Microsoft Word 2007 you can!

1. Select the text that is in the language you want to set

2. In Word 2007, on the Review tab, click the Set Language command.

3. Select the language that the text is in, select Detect language automatically, and then click ok.

By setting the language of the text, you tell the spelling checker which dictionary language to use to check your spelling.

When you check the spelling and grammar of text in a language you are using the proofing tools for that language. You can be sure the language’s proofing tool is installed on your computer if the Spelling & Grammar icon appears to the left of the language in the Language dialog box.

For more information on checking spelling and grammar in another language listen to the tutorial from Microsoft Office Online.

Labels: Word

Do you dread working in Excel in fear of having a workbook with multiple sheets? Don’t you just hate when you get to the point where you cannot see all the tabs in one view. Wouldn’t it be great if there was a way to see all the sheets and be able to click on the one you want! Well, you’re in luck…there is a way!

All you need to do is right-click the tabs navigation buttons and a floating list of all the worksheets in the workbook will appear.

Also, two keyboard shortcuts when working with worksheets in Excel:

CTRL+PageUp- activates the previous sheet in your workbook

CTRL+PageDown- activates the next sheet

For more information visit Microsoft Office Online to view the Hidden Gems in Excel 2007 page.