Excel Project Management Chart

RSS

Previous | Next | View all files

Excel Project Management Chart

Written by Linda Richter (82,028 pts

) in Project Management Media Gallery
Last Edited on Sep 20, 2011

5 comments

Downloads: 21,419

File size: 32.5kB

Download

For project management, this Excel workbook is already formatted to calculate your time, fiscal, and staffing usage. As you enter dates and amounts in the primary worksheet, charts in additional worksheets become populated with your data, and you are prompted to identify basic information relevant to your project.

For more information on how to use this chart, see Linda Richter's article A Microsoft Excel Project Planning Form.

If you're looking for more sample forms and downloadable templates, check out Bright Hub's resource guide Over 50 Free Project Management Templates and Sample Forms.

Comments

Showing 1-5 of 5 comments

May 24, 2011 7:28 PM

milciades castillo

Love all your templates and projects

Mrs. Linda Richter, let me thank you so much for posting this. It's been very useful. I used it once in my personnal project and I have recommended it to all my friends and students since. Thanks so much.

Aug 3, 2010 4:43 AM

shibu

Office projects

it may help

May 20, 2010 12:15 PM

Joe

Excel Gantt

Thank you for providing this Excel PM chart. I wonder if you could help me determine if/how I can modify that to suit my particular needs. In addition to tracking tasks and resource allocation, I need to plot temporal component. My goal is to come up with a quick, high-level resource planning tool to prioritize approximately 10 different projects across about 10 different internal resources. From there, I’d like to be able to stagger start dates and projected durations based on changing priorities to see how it all (hopefully) fits together. I’m by no means an Excel pro. And I’m really trying to avoid using MS Project because when I do I always seem to get bogged down with too many details and dependencies that throw my results off. Please let me know if you have any suggestions.

Thank you again,

- Joe

Nov 15, 2009 9:26 PM

Linda Richter

Excel 2003

Mr. Stewart, I used Excel 2003 to post this chart, so wouldn't you be able to use it on the computers at school? Actually I'm not very savvy about converting from one software version to another. Let me know if you can't use it on your school's software. Maybe I can get someone at Bright Hub management to help you! I'm very pleased that you are trying to use this chart. --Linda Richter.

Nov 15, 2009 10:14 AM

Tom Stewart

School Projects

I'm tasked with developing Project Management (Gantt) Charts for all staff in our department so that teachers' and assistants can follow a designated program of work and reflect on lessons presented. This should allow for individual pupils to be uploaded into the project structure so that progress can be monitored by all staff as well as looking at special educational needs. As this is my first ettempt at using Excel for this purpose can you help with a structure. I use 2007 and the school uses 2003. We can't afford to purchase custom software due to major cutbacks in education so it is a do it ourselves approach. Thanks, in advance, for any help, suggestions given.

Regards

Tom

blog comments powered by Disqus