How To Enter a Series of Data Using Fill Series in 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. 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.