Viewing tasks

The UK's most regular instructor-led training courses.
Training information: ms project server consultancy · Project training · Microsoft Project Training London
See also · microsoft project training courses · microsoft.project.course · microsoft+project+courses

Resolved · Medium Priority · Version 2003

Viewing tasks

Josh has attended:
Project Intro Intermediate course

by - delegate Josh [2 posts] (2008 Apr 3 Thu, 10:23) Reply

In excel I have created two task views - one based on the flow of tasks over time and another where the tasks are broken into key business areas. This is very useful when managing the work of different teams across a project - what is the best way of doing this in Project?

Many thanks

Josh

Version	Date	Location	Places available	Book	Next place rate:
Project Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 28 Thu + 29 Fri	Bayswater	4	book now	£475	£485
2007	2008 Aug 28 Thu + 29 Fri	Bloomsbury	5	book now	£485	£490
2003/XP	2008 Sep 8 Mon + 9 Tue	Southwark	6	book now	£450	£485
2003/XP	2008 Sep 11 Thu + 12 Fri	Bloomsbury	2	book now	£495	£495
2007	2008 Sep 11 Thu + 12 Fri	Bloomsbury	6	book now	£450	£475
2003/XP	2008 Sep 18 Thu + 19 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 72 Project Intro Intermediate course dates. Bookings currently available until 26th November 2009.

RE: Viewing tasks

by - trainer Alan silver contributer [59 posts] (2008 May 18 Sun, 17:20) Reply

A simple way would be to use OLE to link cells in Excel to the relevant cells in a new Project file. Do this for both your Excel views - you will end up with two Project files. Then incorporate both into a new master file by using Insert Project in the task name column.

Use Excel as usual - the changes you make in Excel will reflect in your new Project files and in the master.

· Microsoft Project Training Courses
· Microsoft Project 2007: New Features
· Basic Project Management Skills
· How to Get the Most from MS Project Training Courses
· Microsoft Project Training: The Backbone of Effective Project Management

Please browse our web site to find out more about
ms project server consultancy and other Microsoft training courses.