From the course: Microsoft Project 2013 Essential Training
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Creating a project from an Excel workbook - Microsoft Project Tutorial
From the course: Microsoft Project 2013 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.