lacell.blogg.se

You have them use the Microsoft Project Task List Template in Excel, as follows:Ģ In the New Workbook task pane, click General Templates.ģ In the Templates dialog box, click the Spreadsheet Solutions tab.Ĥ Click Microsoft Project Task List Import Template and then click OK.Ī new file is created that contains columns that correspond to the default Gantt Chart in Microsoft Project.ĥ Enter the task information in the Task_Table sheet (see Figure 17-17). They want to develop a list of detailed tasks in Excel. Microsoft Project is supplied with an Excel Task List template set up for this very purpose.įor example, suppose that the marketing department is suggesting an addition to the project plan that will provide more detail for their test marketing efforts. The standard Excel importing process involves mapping the Excel columns to the corresponding Microsoft Project columns to ensure that the right information ends up in the right places in your Gantt Chart task table. Using the Microsoft Project Task List template in Excel, introduced in Project 2002, this process becomes seamless. Specifically, you can have others on the team create a task list from an Excel workbook and quickly incorporate it into Microsoft Project.

You can make your project plan more accurate and inclusive by integrating the suggestions and concrete input of team members and stakeholders into the project plan.