4 Tricks On creating project plans with Gantt Charts

Published: 09th February 2012
Views: N/A

A must read article for all Project Managers when considering Project Planning in Excel many project managers have tried adopting MS Project and other proprietary tools, but generally find the way these systems operate imposes severe restrictions on the way they plan and manage projects many project managers are not aware that Excel based project planning exists. They do not fully understand the immense graphic capabilities that Excel offers, enabling the simple creation of gantt and pert charts. There are a multitude of leading excel based tools that are used by large and small companies alike. Companies as large as NASA are moving to excel based project planning for greater flexibility and control of their project functions.

Tip 1 - Don't slavishly use proprietary project planning solutions

Whilst proprietary solutions such as MS Project are approximately accepted as mainstream planning solutions, this doesn't mean that the necessarily meet the needs of each project manager. Some organisations mandate the use of proprietary project planning solutions, often against the advice of experienced project managers. Look around, there are a slew of existing solutions and excel also offers you the ability to build your own with a minute knowledge and ingenuity. Search for gantt chart excel in Google. This search will provide you with excellent information on existing tools that may meet the needs of your organisation.

Tip 2 - make sure you explore the freedom you might get by using Excel as a platform

Existing platforms have significant issues with the way that effort and duration relationships are handled. This leads to mis-leading progress indication and even worse, incorrect cost calculations. a lot project managers are not acquainted that alternatives to highly businesslike and programmed solutions exist. Search for alternative excel based solutions. The sales pages on these websites will deliver you a good overview of what is achievable by using excel based gantt charts. lots of websites offer a free trial download. It doesn't cost anything but your time to further explore what might be likely when you move your planning platform to excel.

Tip 3 - Find out what is attainable by adopting MS Excel as a platform

Imagine that you could enumerate anything in your project plan in any way you want. You could also insert rows and columns as you like, and easily compose custom status indicators. You can also without difficulty and easily relate your projects together. lots of project managers simply haven't considered the possibilities of adopting excel. When they are exposed to an excel based solution, the smile on their face is priceless. 44 Milne St Think creatively, with excel anything you can imagine is most possible possible. Write a wish list of things you might like to achieve with your project plaining solution. Be design and imagine possibilities not achievable with traditional approaches.

Tip 4 - Also Consider buying an off the shelf solution rather than spending weeks constructing your own

Building your own excel based solution can take months of development. Remember you are building a solution, not just a quick gantt chart. For some reason some project managers are hell bent on creating their own solution. In a lot cases, people are fearful of macros that may be built into off the shelf solutions. Write a list of requirements for an off the shelf solution. lots of leading providers of excel based planning tools can very easily customise their solution to your needs. Check out the wide array of solutions available online, and select one that is macro free, flexible, and lets you achieve your project planning dreams.

Summary

Some Project Managers find that lots of project managers are not apprised that Excel based project planning exists. They do not fully understand the immense graphic capabilities that Excel offers, enabling the simple creation of gantt and pert charts. There are a volume of leading excel based tools that are used by large and small companies alike. Companies as large as NASA are moving to excel based project planning for greater flexibility and control of their project functions. To resolve this issue there are a plenitude of key steps that can be taken. buying an off the shelf solution rather than spending weeks constructing your own many websites offer a complimentary trial download. It doesn't cost anything but your time to further explore what might be possible when you move your planning platform to excel. Write a wish list of things you might like to achieve with your project plaining solution. Be compose and imagine possibilities not achievable with traditional approaches.

About Chartgantt.com
Chartgantt.com is the leading provider of Professional Excel Based Gantt Chart Excel. They have spent 3 years building and developing templates that are now the best available in the world. Smart coding and structuring mean that the product offers far superior flexibility to any other planning tool available on the market
Gantt Chart Excel

Report this article Ask About This Article


Loading...
More to Explore