Sabtu, 25 Oktober 2008

How to use SmartArt Diagram in 2003 to 2007

2003 to 2007 SmartArt Diagram
To make your Microsoft Office PowerPoint 2003 presentation more compelling, you might insert a diagram. Unfortunately, clicking the Insert menu and then clicking Diagram presents only six available commands, and all of your supporting text must be entered in individual text boxes.

With Microsoft SmartArt in the 2007 Microsoft Office system, you can right-click an existing bulleted list in Microsoft Office PowerPoint 2007 or Microsoft Office Word 2007, and then click Convert to SmartArt. Then select from the 20 default options, or click More SmartArt Graphics and browse through a large gallery of available diagrams.

You can use the SmartArt Tools contextual command tabs to change the diagram type or apply interesting effects like three dimensions or color options. To edit SmartArt text, click the diagram, and then edit your text in its familiar list format in a box that appears to the side of the diagram. Watch your diagram dynamically change to match the new text.

How to Add and Editing Comments in MS Excel

Adding and Editing Comments in MS Office Excel
You can add and edit comments in Microsoft Office Excel by using the keyboard. To add a comment:
1. Press SHIFT+F2 to insert a comment in the current cell.
2. Type the text of your comment, and then press ESC twice.

To edit a comment:
1. Go to the cell that contains the comment and press SHIFT+F2. The comment opens.
2. Make your changes, and then press ESC twice.

Kamis, 16 Oktober 2008

How to use Color-Code in an Individual Sender's E-Mail Messages in MS Outlook

Color-Code an Individual Sender's E-Mail Messages in MS Outlook
You can color-code your incoming e-mail to spot quickly what's important.
1. Click an e-mail message, and then click Tools.
2. Click Organize.
3. Click Using Colors, and then select your color of choice. All future e-mail from that sender will appear in that color.

How to Arrange Your Meetings in One All-Day Session in Office Live Meeting

Arrange Your Meetings in One All-Day Session in Office Live Meeting
Using Microsoft Office Live Meeting to organize several meetings all on the same day, or perhaps over two days, can create a confusing list of different meeting URLs and invitations. So long as the displays used for each meeting aren't confidential, you can create a single meeting to cover the entire day and invite the attendees for each meeting by using the same URL. As the host for each meeting, you can stay signed in to the same meeting for the entire day, while participants need to sign in only for their own meetings. That way, you'll avoid having to send different invitations and different URLs to each attendee. It also means you'll no longer need to continually sign out of one meeting and sign in to another.

Jumat, 10 Oktober 2008

How to Delete E-Mail Messages Permanently in MS Outlook

Deleting E-Mail Messages Permanently in MS Outlook
To delete e-mail messages from Microsoft Office Outlook:
1. Select the e-mail messages that you want to delete. You can select messages that appear in your mailbox consecutively by holding down the SHIFT key while clicking the first and last messages that you want to delete from the list. Alternately, hold down the CTRL key while you click the individual e-mail messages that you want to delete.
2. Hold down the SHIFT key and press DELETE to permanently delete your selected e-mail messages.
3. To complete the deletion, you must confirm it in the dialog box that appears when you close Outlook. But be careful, because permanently deleted e-mail messages are eliminated immediately, not stored in the Deleted Items folder. In other words, they cannot be recovered if you find you've made a mistake.

How to Insert Predefined Fields in MS Office Access

Inserting Predefined Fields in MS Office Access
To insert a predefined field:
1. In datasheet view, on the Ribbon, in the Fields and Columns section, click New Field.
2. In the Field Templates pane, select the field you want, and then drag it to your table.

How to Create Pages, Sections, and Notebooks in MS Office OneNote

Create Pages, Sections, and Notebooks in MS Office OneNote

To create a new notebook:
1. On the File menu, click New. This opens the task pane from which you can create a new page, section, or notebook.
2. On the File menu, click Print.
3. Select Send to Microsoft OneNote in the list of available printers.
4. Click Print.
5. Drag the resulting Microsoft Office OneNote page to the relevant section of your notebook.

Jumat, 03 Oktober 2008

How to Select Excel Ranges by Using the Name Box

Selecting Excel Ranges by Using the Name Box
In Microsoft Office Excel, you can select a range of cells by typing it in the Name box. This is particularly useful if the range is large and will therefore take time and a lot of scrolling to select by hand

How to Save a Search in Microsoft Vista

Saving a Search in Microsoft Vista
Whenever you perform a search in a Windows Vista folder, you can save it for reuse. Saving searches can speed up your efforts to find important information, especially as you save more and more files. Here’s how:
Click Save Search. The search file is saved in a separate folder under your user folder, titled Saved Searches.

Kamis, 02 Oktober 2008

How to Use a Voice Command in MS Word

Use a Voice Command in MS Word 
You can use sound in Microsoft Office Word.
1. In the Word document, place your cursor where you want your voice message to go.
2. Click Insert, and then in the Text section, click the Insert Object button.
3. In the Object dialog box, on the Create New tab, in the list of object types, select Wave Sound.
4. Click OK, and then record your own voice note

How to Use the Floating Toolbar for Formatting in Microsoft Office

Use the Floating Toolbar for Formatting in Microsoft Office
You can use a floating toolbar to quickly change document formatting in Microsoft Office. When you use the mouse to select text that you want to change, a floating toolbar appears automatically, giving you easy access to basic formatting commands.

How to Use Your Outlook Calendar to Schedule Work More Effectively

Using Your Outlook Calendar to Schedule Work More Effectively
You can allocate time slots for work activities as if they were meetings. For example, after each contact with a customer, you can schedule any resulting tasks in your Microsoft Office Outlook calendar as if they were meetings. That way you'll be less likely to forget anything, and you can allocate sufficient time to complete your follow-ups more efficiently.

How to do Task Updates and Timesheet Submittal and Approval in MS Office Project

Task Updates and Timesheet Submittal and Approval in MS Office Project
Team members update project work in the Tasks, My Work section of Microsoft Office Project Web Access. After they submit their task updates, the project manager approves or rejects their time on tasks in the Approvals, Task Updates section of Project Web Access.

At the end of each timesheet period, team members use Import Task Progress to show progress on their timesheets along with any other administrative time spent during the period. Resource managers can review, approve, and reconcile timesheets against reported project work, non-project work, and non-working time.

Use the following steps to review and approve timesheets:
1. In Project Web Access, click the Action pane.
2. In the Approvals section, click Timesheet.
3. In Review My Timesheet Summary, click My Timesheet.
4. Click the Review Timesheet Detail page.
5. Click Approve to complete the approval process.
6. In the Approvals section, click Admin Time.
7. Click the Review Admin Time Detail page.
8. Click Approve to complete the approval process.