Planning multiple projects using Excel based Gantt charts

Excel is an excellent tool for creating and managing projects, if you used properly. Use by a professional Gantt chart template, you can use the substantial flexibility offered by Excel. These benefits, the really in the get your own if you're looking for consolidating or manage multiple projects by creating a consolidated Gantt chart or multiple Gantt charts.

A quality, professional excel Gantt chart allows you to create relationships, you simply in large Gantt chart and project planning software. Enterprise editions of big Gantt chart software have considerable administration overheads that are simply required with an Excel based Gantt chart template. Gantt chart templates with an Excel based you can perform the following key activities:

Set resource pools and sharing resources between projects
Create dependencies between projects or tasks
Standard Microsoft collaboration tools allow multiple simultaneous editors to use
If you use a professional Gantt chart template for excel, such as ChartGantt, are in a position, simply copy the most important planning worksheet to create additional planning sheets. From there, you can create links between tasks or projects with Microsoft Excel default links. IE, =, or commands.

Setting up a resource pool for sharing resources between projects
When establishing a connection to a resource pool, you must simply create a new workbook. Format the columns to take information you believe is relevant for each resource. These include phone number e-Mail address. Select the column with the names of project resources planning and create a named range. Each worksheet for planning, simple data validation you can name your area around a common resource pool list for each of your tasks to produce.

Create dependencies between projects or tasks
After he for some of the largest consulting companies of World?s is a simple question relating to BIG projects. The lost the immense time management reporting may cause this issue. High level dependencies are maintained outside of the core plans.

With the Excel template approach you are able to use standard Excel functions to solve that problem for you. The last task from another project starting the first task in a project just insert depending on. This ensures that your work is your plan synchronously and improves your ability to quickly generate project management reports, the current and meaningful.

Standard Microsoft collaboration tools allow multiple simultaneous editors to use
If you have a workbook that contains 5 separate plans, you can have 5 separate concurrent users in your organization, by using the workbook share functionality or Microsoft SharePoint.

In summary there are many advantages in managing projects, both large and small in MS Excel. Lower costs and improved flexibility are two main benefits.

Blog URL:
http://Chart-Gantt.blogspot.com/
Please visit http://www.chartgantt.com/ more information on Gantt chart

View the original article here