microsoft: 2009-02-22

Saturday, February 28, 2009

Daily Tips and Tricks Special Delivery

Derive a Strategic Value Score for Projects
You can use the intuitive prioritization wizard in Portfolio Optimizer to derive a strategic value score for projects.

1. Select an organization in the Builder Scorecard, and then click the Optimizer link on the main navigation bar.
2. Click the Analyze link to open the Open Dialog page in the wizard.
3. Select a completed pairwise comparison matrix and impact matrix, and then start the wizard.
4. Click Next Step to derive the business driver priorities.
5. Click Next Step to open the project to business driver impact matrix.
6. Click Next Step to derive a strategic value score for each project.

Find Related Messages
Searching for related messages in Microsoft Office Outlook 2007 is easy. Open an e-mail message, and in the Find section of the Ribbon, click Related, and then click Related Messages. Outlook quickly displays a list of related messages.

•	Tips and Tricks Web site
•	Microsoft Office Online
•	Help

Privacy note: Microsoft respects your privacy and that of your friends. Please do not use the Tell a Friend button to send mail to more than 10 people. Microsoft cannot collect any data about the people you send mail to unless they sign up for Tips and Tricks Special Delivery.

To cancel your subscription to this newsletter, reply to this message with the word "unsubscribe" in the subject line. You can also unsubscribe at the Microsoft.com Profile Center. You can manage all your Microsoft.com communication preferences at this site.

Legal information

Microsoft Corporation
One Microsoft Way
Redmond, WA 98052

Friday, February 27, 2009

[+/-]

Daily Tips and Tricks Special Delivery

Fill In the Blanks in Spreadsheets the Easy Way
1. Select all the rows in your Microsoft Office Excel spreadsheet data set.
2. On the Home tab, in the Editing section, click Find & Select, click Go To, click Special, click Blanks, and then click OK.
3. Click the equal sign (=) on the toolbar, select the cell above, and then hold down the CTRL key while you press ENTER. Blanks in the spreadsheet will be filled automatically.
4. Copy all the data, click Paste Special, and then click Values. This will overwrite the formulas and enable you to sort the data by filling in each empty cell with the same information as the one above. This tip will work on any size of data set.

Minimize the Ribbon
The Ribbon helps you access more of the commands you need, when you need them. But if you want to see the Ribbon only when you need it, you can minimize it so that only the tab names appear all the time. To minimize the Ribbon in any program, double-click any tab name, or press CTRL+F1. You can also right-click any tab name for the option to minimize the Ribbon.