From the course: Microsoft Project 2013 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Creating a project from an Excel workbook

Creating a project from an Excel workbook - Microsoft Project Tutorial

From the course: Microsoft Project 2013 Essential Training

Start my 1-month free trial

Creating a project from an Excel workbook

“

Suppose you have a list of tasks in Excel and get estimates of work or duration from team members, you can pull that information from Excel into a new Project file. If you include headings in the worksheet columns it's easy to map them to Project fields. So here is an Excel workbook with some information about tasks. You can see that the first row has the headings. So we've got WBS codes, task Names, and Estimated_Duration and then the values. The headings in this first row are helpful for mapping the data in the Excel file to Project fields. Now that we've looked at the Excel workbook we're going to close it so we can import it into Project. Now over in Project, click New, and in this case click New from Excel workbook. The Open dialog box appears. So we have to tell Project where that Excel workbook is. So in this case I go to Desktop, the exercise files folder, and go to the folder for chapter 02. There is nothing there, but don't worry. You have to go down to the File type and…

Contents