All articles with 'project management' Tag

Get a Copy of Excel Project Management Templates Today!

Published on Mar 4, 2010 in products

Some of you know that I sell a bundle of Project Management Excel Templates. The bundle includes 24 ready to use templates for Gantt Charts, Timesheets, Project Dashboards, Status Reports, Time Line Charts, Issue Logs, To do Lists and more. Launching these templates is one of the best moves in my life. They have been […]

Continue »

Group Project Activities to Make Readable Gantt Charts

Published on Feb 11, 2010 in Charts and Graphs, Learn Excel
Group Project Activities to Make Readable Gantt Charts

In Excel Gantt Charts part of our project management series, we have discussed about how using Conditional Formatting and Formulas we can make a gantt chart like this: But when you have large project plans, gantt charts like above can get pretty intense and hard to read. So a better approach is to group various […]

Continue »

One Hundred Project Managers have chosen to be better, what about you?

Published on Nov 20, 2009 in products

As of yesterday, the project management templates have crossed 100 customer milestone. That is right my friend, one hundred project managers have chosen to manage their projects better using our templates. I have asked our customers to share their feedback and this is what they say: I think that the templates are excellent. A million […]

Continue »

Project Dashboard + Tweetboard = pure awesomeness!!!

Published on Oct 27, 2009 in Charts and Graphs
Project Dashboard + Tweetboard = pure awesomeness!!!

Check out an implementation of project dashboard along with tweetboard by our reader Fernando. He says, it “turned out to be a great success”. I am so happy for him.

Btw, the post includes a link to download the workbook so that you can see the dashboard and tweetboard in action.

Continue »

The Project Management Bundle for Excel is Here, Download your copy today

Published on Oct 14, 2009 in excel apps, Featured, products
The Project Management Bundle for Excel is Here, Download your copy today

I have a super exciting news for all our members. During the last several weeks, I have been working on making 24 strikingly remarkable and easy to use excel templates for better project management. Finally the bundle is ready. You can get a copy of the bundle starting today.

Continue »

Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]

Published on Oct 6, 2009 in Charts and Graphs, Featured, Learn Excel
Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]

Project management dashboards, project status reports help stakeholders, project sponsors and team-members can understand project status very quickly. In the last installment of project management using excel, learn how to make project management dashboard using excel in this tutorial. Also download the excel project status dashboard template.

Continue »

Issue Trackers & Risk Management using Excel [Project Management using Excel – Part 5 of 6]

Published on Sep 8, 2009 in Charts and Graphs, Featured, Learn Excel
Issue Trackers & Risk Management using Excel [Project Management using Excel – Part 5 of 6]

Tracking issues and risks is where most of the project management time goes. Once the project planning and organizing activities are in good shape, most of the project management activities are around risk management and issue tracking. In this installment of project management using excel, we will learn how to create a simple issue tracker template using excel and how to analyze issues using excel.

Continue »

Excel Time Sheets and Resource Management [Project Management using Excel – Part 4 of 6]

Published on Aug 5, 2009 in Charts and Graphs, Featured, Learn Excel
Excel Time Sheets and Resource Management [Project Management using Excel – Part 4 of 6]

Timesheets are like TPS reports of any project. Team members think of them as an annoying activity. For managers, timesheets are a vital component to understand how team is working and where the effort is going. By using Microsoft Excel capabilities you can create a truly remarkable timesheet tracking tool.

In this installment of project management using excel series, we will learn 3 things about timesheets and resource management using Excel
1. How to setup a simple timesheet template in excel?
2. How to make a more robust timesheet tracker tool in Excel?
3. How to use the timesheet data to make a resource loading chart?

Continue »

Use burn down Charts in your project management reports [bonus post]

Published on Jul 21, 2009 in Charts and Graphs
Use burn down Charts in your project management reports [bonus post]

A burn down chart is a good way to understand the progress of a project. It is like a run chart that describes work left to do versus time. In this tutorial we will learn how to make a burn down chart using excel. This is a bonus installment to the project management using excel series.

Continue »

Project Management: Show Milestones in a Timeline [Part 3 of 6]

Published on Jul 9, 2009 in Charts and Graphs, Featured, Learn Excel
Project Management: Show Milestones in a Timeline [Part 3 of 6]

Learn how to create a timeline chart in excel to display the progress of your project. Timelines are a good way to communicate about the project status to new team members and stake holders. Also, download the excel timeline chart template and make your own timeline charts.

Continue »

Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]

Published on Jun 25, 2009 in excel apps, Featured, Learn Excel
Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]

In today’s installment of project management using excel, we will learn about project tracking tool – to-do lists. Projects are nothing but a group of people getting together and achieving an objective – like building system or constructing a bridge. While it is important to have a overall project plan and vision, it is equally important to understand how various day to day project activities are going on. This is where to do lists can help you a lot. Read on…

Continue »

Gantt Charts – Project Management Using Excel [Part 1 of 6]

Published on Jun 16, 2009 in Charts and Graphs, Featured, Learn Excel
Gantt Charts – Project Management Using Excel [Part 1 of 6]

This is a 6 part tutorial on project management using microsoft excel. These posts represent few of the things related to project management using excel that I have learned over the years. The first installment deals with Preparing & tracking a project plan using Gantt Charts in MS Excel.

The other parts I am planning are, Day to day operations – using to do lists, Preparing a project time line, Time sheets and Resource management, Tracking issues and risks, Project Status Reporting – Dashboard.

Read the first part of the article to learn how to make excel gantt charts / project plans.

Continue »