Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Project Training and help » Extracting data from project into Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Extracting data from project into Excel

Resolved · Medium Priority · Version 2007

Reply Mon 21 Sep 2009, 16:22Delegate Richard said...

Richard has attended:
Project Intro Intermediate course

Extracting data from project into Excel

During the course we went through how to extract data from Project and importing it directly into excel. However, i cannot remember how to configure the report to show me how to show week by week planned progress information. How can i achieve this?

Thanks

For upcoming training course dates see: Pricing & availability

Reply Tue 22 Sep 2009, 09:52Trainer Simon said...

RE: Extracting data from project into Excel

Hi Richard,

Thank you for your question.

We looked at using filtering. Select the filtered for option under the Project menu and choose Date Range. Enter the earliest and latest dates.

Alternatively you can use the Autofilter option which appears at the bottom of the Filtered for menu and produce a custom filter.

If you have a baseline saved you can change your view to tracking gantt. Then either use Save as Excel or copy and paste what you see by clicking on the button which is at the intersection between the row and column headings. Then copy and paste special as a project object.

I hope this answers your question.

Regards

Simon

Mon 28 Sep 2009: Automatically marked as resolved.

MS Project articles

· Avoiding Project Failures
· Plan your wedding with the help of Microsoft Project
· Make Friends With Social Networking Sites
· When Is A Task Not Quite Task? Find Out Via Project
· Getting Your Project Started With Project

Please browse our web site to find out more about
exchange server 2003 distant learning and other Microsoft training courses.

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