Do you use spreadsheets to manage your projects?

Do you use spreadsheets to manage your projects?

Do you really think managing project can be done well & easily with spreadsheet. Wait a minute and think about it:

Do you use spreadsheets to manage your projects

Benefits

If you have been using spreadsheet to manage your project you might agree for following benefits of using spreadsheet:

  1. It is a multipurpose solution to various business & personal activitities not just Project Management
  2. It is a known tool & lets you format data as you need (DIY)
  3. If file size is within limits, it can ben shared with colleagues over email
  4. Ohh, you have issues – create a spreadsheet with a name as Project Issues. You have risks too – all right, create one more sheet named Project Risks also.
  5. You can wait till you get feedback from team & update project details at your convenience

I guess,these benefits just ends here and you realize the flipside of using spreadsheet

Do you use spreadsheets to manage your projects

Pitfalls

  1. As an explicit endeavour to make it collaborative, you need to find a central location to store spreadsheet file which team members can access. <Will central location necessarily has to be on the ‘network’?>
  2. Now team members can either update spreadsheet file(s) concurrently or wait for other member to release control.
    • If you allow concurrent updates, be ready to spend time for conflict resolution
    • If you allow synchronized access or one-at-a-time; then team members will end up creating their own copies & versions to modify & upload it later

In short either way, you limit your team members from collaborating effectively. What is even more worrisome is, not just you, your entire team has to waste time just to update & reconcile entries from multiple versions of document

  1. As you team members will not find it easy to update project activities, there is no easy way for you to know real time progress of your project unless you ask each one of them. Forget about real time reports & dashboard presentation.
  2. Spreadsheets do not have trailor-made facility to track issues, bugs/errors, unless you circulate the template in your team
  3. Intrinsically, spreadsheets are not inteded for seamless communication. The only ways in which you can inform your team member of any update in project activities are
    • Talk to him/her
    • Email him/her
    • Enforce him/her to keep checking some document frequently
  4. Use of external media (e.g. USB drives) and email attachments makes your computer & company network vulnerable to security threat or have versions of spreadsheets running around, in your network through emails

Project management is about ‘GETTING THINGS DONE’ and not to wasting time in struggling with tools that supposedly helps to manage project. And any project management tool is useful, only to the extent your team members use it.

Alternative

Do you use spreadsheet to manage your projects? Switch to online project management softwareYou need a project management software that

  • Your team members will find it intuitive and easy to use
  • Your team members can access securely without any constraint of location or time
  • A central place to collaborate – store project information, upload doucments, submit issue. It helps every one in the team to have same information (be on the same page)
  • Immediately notifies team members of change in schedule, assignment of tasks or issues in the project management tool as well as through email notification
  • Provide real time update on project details through reports & dashboard
  • You would have noticed that we are deliberating and discussing about online project management tool rather than stand-alone or installed ones.
I would love to hear your feedback on this post.

You May Also Like to Read

Whether Your Organization Needs PMO , Top 4 Goals for Project Manager, Essentials of Software Project Management by ZilicusPM. Want to Know How ZilicusPM is Helping Professional Services Companies Manage Projects Better.

Additional readings about project management, leadership

Your life can be become easier with the right project management system. ZilicusPM is the right PM tool for you and your team. Get started now.

About Zilicus

Zilicus offers All-In-One online project management software that provides complete project management control for project and portfolio managers; at the same time makes it really simple for project team members to stay on top of things. If you have been managing projects with conventional spreadsheet/ MS Excel templates or emails, it is the right time to start using online project portfolio management software. ZilicusPM is great platform for better project collaboration. Take a screenshot tour of project management software ZilicusPM and Sign up for 30-days free trial of project management software ZilicusPM

Trackbacks & Pings

Leave a Reply

Your email address will not be published. Required fields are marked *