Join Bonnie Biafore for an in-depth discussion in this video Creating a project from an Excel workbook, part of Microsoft Project 2010 Essential Training.
- Suppose you build a task list in Excel…and you get estimates of worker 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.…Here's a workbook with task information in Excel…and let's say that I've gotten that from some team members.…It has three columns.…It's got the work breakdown structure codes…for the tasks.…The task names and estimated durations for those tasks.…
These headings in row 1 are really helpful…when you wanna map the data from Excel into Project.…I'm gonna close this workbook so I can import it.…Now when I'm in Project, I'm ready to import…that Excel data into a new project file.…To do that, I head to the File tab…and then click New.…Now, in the new from existing section…there's a button, New from Excel Workbook.…That sounds like what we want…so I'm gonna click that button.…That takes me to the Open dialogue box…so I'm gonna go to the Desktop…to my Exercise Files and it's in Chapter 2.…
- Setting up projects and calendars
- Creating tasks and milestones
- Linking and timing tasks
- Setting up and assigning resources
- Understanding duration, work, and units
- Filtering and grouping items with views
- Adding tasks to a baseline
- Updating progress and costs
- Viewing project status
- Running reports
- Importing and exporting projects
Skill Level Beginner
1. Working with Project
2. Setting Up Project Files
3. Creating Tasks
4. Linking and Timing tasks
5. Creating Resources
6. Assigning Tasks to Resources
7. Working with Views
8. Fine-Tuning the Project Schedule
9. Tracking and Managing a Project
10. Viewing and Reporting Project Information
11. Sharing Projects
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.