From the course: Microsoft Project 2016 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

From the course: Microsoft Project 2016 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's 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. Well 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. In this case, click New from Excel workbook. The Open dialogue box appears. So we have to tell Project where that Excel workbook is. So in this case, I go to the Desktop, the Exercise Files folder, and go to the folder for chapter two. Well, there's nothing there but don't worry. You have to go down to…

Contents