15 49.0138 8.38624 1 0 4000 1 http://blog.zilicus.com 800 true

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 activities 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 intended 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.

There is way better alternative to MS Excel

Effective project management : Explore ZilicusPM

 

You need a project management software that will in turn has task management features

  • 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 documents, 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.

What do you think?

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.

Effective project management : Explore ZilicusPM

About Zilicus

Zilicus offers the best project portfolio management tool ZilicusPM, with robust project management tools capabilities and easy ways to track project management KPI,

Know more about project portfolio managementGantt chartbest project management toolproject management office, project management tips, project planning guideproject risk managementproject scope management, effective project management, project manager guides and know more about Project Portfolio Management Software, Project Management Software Guide.

Share:
PREVIOUS POST
Invite for ZilicusPM Beta
NEXT POST
Success of Innovation & Role of Early Adopters
ABOUT
Dhan

I am a co-founder of Zilicus Solution and I write about project management, collaboration, productivity, project management software, cloud computing, requirement management and business empowerment.

8 Comments