Monday, April 20, 2009

Daily Tips and Tricks Special Delivery - Microsoft

Post Type :

For Microsoft Office Excel 2007

Microsoft Office Excel 2007

Turn Multiple Hyperlinks into Text in Microsoft Office Excel
1. Select the cell or group of cells that contain hyperlinks, right-click, and then click Copy.
2. Select the cells where you want your text to go (this might be the same selection as in step 1).
3. Right-click, and then click Paste Special.
4. In the Paste section, click the option that you want applied to the text (such as Values or Comments), and then click OK.


.

Side by Side

2003 to 2007 Categories and Tasks
In Microsoft Office Outlook 2003, you can use colored quick flags to flag e-mail messages for follow-up based on their relation to each other. For example, you can use blue flags for action items related to an upcoming sales meeting, yellow flags for personal items, and red flags for urgent issues. However, these flags are visual cues only; they do not automatically create an Outlook task that you can track and manage.
In Microsoft Office Outlook 2007, colored quick flags are broken out into Colored Categories and Flags. If you need to visually group related items together, you can assign a color category. If you need to act on something, you can assign a flag. When you flag a message in Outlook 2007, it's automatically added to your Outlook task list, your calendar, and the To-Do Bar (which shows your upcoming appointments and tasks for the day). You can assign categories and flags by right-clicking the appropriate icon in your Inbox, or by opening the e-mail message and clicking the commands on the Ribbon.

2003 vs. 2007 Side by Side

For the 2007 Microsoft Office system

The 2007 Microsoft Office system

Keep Important Documents Handy at All Times
When you click the Office button in the 2007 Microsoft Office system programs Word, Excel, or PowerPoint, you see a Recent Documents list, similar to that which appeared on the File menu in previous releases. However, in the 2007 release, you now see a pushpin icon next to each file name. Click that icon to pin the applicable document to the Recent Documents list so that it’s always accessible at a click. When you click the pushpin icon, it changes in appearance to show that the pin has been activated for that document.
Also note that you can change the number of recent documents that appear in the list. To do this, click the Office button, then click [Program] Options (for example, Word Options), and then click Advanced. Scroll down to the Display section, where you’ll see the option to change the number of recent documents displayed.


.

For Microsoft Office Outlook 2007

Manage Meeting Resources
Here’s how Microsoft Office Outlook can help you schedule resources and plan meetings within a group.
1. Create a group schedule.
a. Go to Calendar view in Outlook, and on the Actions tab, click View Group Schedules.
b. In the Group Schedules dialog box, click New, and then type the name of your schedule.
c. Click OK.
2. Add all the resources you need to the Group Members column (for example, all the conference rooms in your building). You will see the free/busy information for all the resources in one view. You can use the same technique to book other resources, like audio/video equipment.
3. Plan your meeting.
a. By using the Group Schedule view, find the appropriate resources that are free for your time slot.
b. Click the Make Meeting button, and then click New Meeting as Resource.
4. A meeting request form appears, prefilled with the time booking information and the resource allocation. Just fill in the rest of the meeting details, and then click Send. The resources you requested will be booked automatically for you.

Microsoft Office Outlook 2007

For Microsoft Office Visio 2007

Microsoft Office Visio 2007

Use Shape Operations to Customize Shapes
You can split a shape into multiple shapes, cut pieces out of a shape, or merge multiple shapes into one. To customize shapes, first select the shapes on which you want to act. On the Shapes menu, point to Operations, and then click the operation you want from the available options. For example, to draw horizontal lines completely through a triangle, select the triangle and all lines, and then click Fragment on the Operations menu to create a custom pyramid diagram in no time. In this example, the fragment operation uses the lines to split the triangle and does not retain the lines.


.

For Microsoft Office Outlook 2007

Delete a Meeting Without Notifying Invitees
If you have set up a meeting, and your attendees have declined to come, it's obviously an irritation for them to then receive an e-mail message confirming the cancellation of the meeting. Instead, you can delete the meeting without sending a notification.
1. Right-click the meeting, and then click Delete.
2. In the notification e-mail message, delete all the addresses from the To field, and type your own e-mail address instead.
3. Click Send.

Microsoft Office Outlook 2007

For Microsoft Office PowerPoint 2007

Use Your Own Pictures in SmartArt
You can insert your own pictures into Microsoft SmartArt graphics in your presentation.
1. Click the Insert tab on the Ribbon, click SmartArt, and then click the SmartArt graphic that you want to insert.
2. Select the picture that you want to add to your presentation.
3. Right-click an individual shape in SmartArt, and then click Paste to insert the picture you selected.
4. Repeat steps 2 and 3 for each shape.
5. Complete your presentation by applying your preferred background design.

Microsoft Office PowerPoint 2007


No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...