Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft-project-training-courses - importing excel

Forum home » Delegate support and help forum » Microsoft Project Training and help » microsoft-project-training-courses - Importing from Excel

microsoft-project-training-courses - Importing from Excel

ResolvedVersion Standard

Peter has attended:
Project Intro Intermediate course

Importing from Excel

I have a brainstorm of the tasks that will be needed for my current project in Excel, showing task name, start date and duration. There's no import function for Project - is there a simple way to get the data across into Project - whilst preserving Project's wish to schedule tasks flexibly rather than fix dates?

RE: Importing from Excel

Hi Peter

Thanks for your question. You should be able to select your list of cells in Excel, copy them and then paste directly into the name column on the the table on your Gantt chart.

Hope this helps - let us know if you have further questions.

Kind regards,

Andrew

MS Project tip:

Typing Links Between Tasks

In the Entry table, use the Precessors column to type in links. Type the previous task's ID to link. To change the link, add FS (Finish-Start), FF (Finish-Finish), and so on, and + duration to add a Lag, or - duration for a Lead time. Example: for task 5, 4FS+1w ... task 4 preceeds task 5, finish to start, with a week lag between.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.