Friday, December 19, 2008

Daily Tips and Tricks Special Delivery

Tips and Tricks Special Delivery
Making tomorrow more productive than today
For Microsoft Office Excel 2007
Microsoft Office Excel 2007
To Enter a Series of Data Using Fill Series
1. Type the first value in the series into a cell.
2. Type the second value into a cell below or to the right of the first cell.
3. Select the cells.
4. Drag the Fill Handle (a black square that appears at the bottom right corner of the last selected cell) over the cells into which you want to extend the series.


.
For Microsoft Office Project 2007
Managing Resources in Office Project
When you start assigning resources to tasks in Microsoft Office Project, the durations of the tasks automatically change. To understand why, you need to understand how Project allocates resources.

Project follows one formula for all internal resourcing calculations: Work = Duration × Resources. In other words, if two men take two hours to mow a lawn, one man will take four hours, or four men will take one hour, to mow the same lawn. Now you know why task durations constantly change if you add or remove the resources allocated to those tasks.

You can stop Project from recalculating time schedules in this way by configuring it to keep one parameter fixed and calculate just the others.
1. Open the task's properties.
2. On the Advanced tab, configure the task type as being Fixed Duration, Fixed Work, or Fixed Units (that is, resources). By changing this setting, you can tell Project which parameters in the equation should remain the same, no matter what changes you make to the task.

Microsoft Office Project 2007

Quick Links
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
Sign up for other newsletters | Unsubscribe | Update your profile
© 2008 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement
Microsoft

Your cOmment"s Here! Hover Your cUrsOr to leave a cOmment.


Subscribe to: Post Comments (Atom)