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:
If you have been using spreadsheet to manage your project you might agree for following benefits of using spreadsheet:
- It is a multipurpose solution to various business & personal activities not just Project Management
- It is a known tool & lets you format data as you need (DIY)
- If file size is within limits, it can ben shared with colleagues over email
- 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.
- 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
- 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’?>
- 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
- 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.
- Spreadsheets do not have trailor-made facility to track issues, bugs/errors, unless you circulate the template in your team
- 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
- 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
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
- Avoid These 10 Most Common Mistakes That Leads to Project Failure
- Transition of A Good To Great Project Manager
- Looking for a robust task management software: Best of Both Worlds: Gantt Chart + Kanban Board?
- Project Management Tool for Software/ IT Projects
- 7 Reasons Why SMBs Prefer All In One Project Management Tool
Your life can be become easier with the right project management system. ZilicusPM is the right PM tool for you and your team.
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 management, Gantt chart, best project management tool, project management office, project management tips, project planning guide, project risk management, project scope management, effective project management, project manager guides and know more about Project Portfolio Management Software, Project Management Software Guide.
[…] developed as a spreadsheet tool. And if we are trying to make it work in any different way, it is not going to give us the best result compared to the alternatives available for us. There are cloud based software for most application […]
[…] call Microsoft Excel as hammer to which everything else is a nail. Throw any problem at MS Excel and you will be able to fit it, in those tables, rows-columns and cells. Though MS Excel may solve […]
[…] involved. It gets so complicated, confusing and frustrating to work with MS Project, Emails, Excel-spreadsheet. It is certainly NOT a project planning at […]
[…] the same time makes it really simple for project team members to stay on top of things. Do you use Excel or spreadsheet to manage projects or even templates or emails to add further complexity? it is the right time to start using online […]
[…] – You would like everyone to refer to only one copy of project schedule […]
[…] Do you use spreadsheets to manage your projects? Do you really think managing project can be done easily with spreadsheet. Wait a minute, think about it. […]
[…] misunderstanding. Hence merely communicating project tasks verbally or via email or through spreadsheet will lead to such problem; and team members will end up working on non-priority […]
[…] What is important in project collaboration is, it should be unified, consistent across departments and it should not result in slower or ineffective project collaboration. […]