Can You Really Manage A Project Using Spreadsheets?

Must read

4 steps from project requirements to executing tasks

Any project, regardless of size, will include a project scope statement, as you'd expect to be taught on most courses for project...

IT Project Teams are STILL driving competitive advantage

In conclusion, IT Projects are perfectly placed to shape the future of business as we emerge from this pandemic. Businesses need to be leaner and more innovative. It’s time for IT Project teams to say, “Hold our coffee, watch us do our thing” – this is our moment.

Securing a Better Position – How To Get Promoted As a Project Manager

Whether you’ve entered at ground level and feel you’re experienced enough to take the next step up the career ladder as a...

Mentoring and project managers – get the best out of a team

Project management isn’t just based on cost and analysis and dealing with stakeholders and your existing team – you also need to...

In small, relatively simple projects it is not uncommon to find the project manager using a set of spreadsheets to manage the project schedule, the budget and the scope of the project. If the project involves just one internal department and a small project team using spreadsheets often avoids the necessity for stakeholders to get to grips with a project software package they are unfamiliar with. In business spreadsheets are frequently used for many purposes so everyone will be familiar with their capabilities.

 

Spreadsheets are readily available, simple to use and understand and a convenient way to share data between the client, the stakeholders, the project manager and the project team. The basic data can be used to generate project schedules and reports, and will even provide the option of connecting to a database to retrieve additional information.

 

Spreadsheets have many advantages but because they are under the control of individuals, they are not so well-suited to complex projects involving departments across an organisation and externally where it is important to have a single, central data repository and a controlled suite of reports and metrics. Indeed there very flexibility and ease-of-use can be counter-productive, encouraging individuals involved in the project to update worksheets, re-format them and modify them to add their own data. The central, common set of data can, over time, become lost in a variety of personalised worksheets and uncontrolled versions making it difficult to be certain of the accuracy of the data.

 

But, more importantly, spreadsheets lack the controls that are required to prioritise tasks, manage key decision points and effectively handle milestones in a project particularly with respect to changes to the schedule.

 

So, spreadsheets can be, and are, used for project management in small, simple projects, which are well-defined, but for larger and/or more complex projects they do not offer the controls and standards required to manage and report the project status accurately across a large organisation.

- Advertisement -

More articles

- Advertisement -

Latest article

4 steps from project requirements to executing tasks

Any project, regardless of size, will include a project scope statement, as you'd expect to be taught on most courses for project...

IT Project Teams are STILL driving competitive advantage

In conclusion, IT Projects are perfectly placed to shape the future of business as we emerge from this pandemic. Businesses need to be leaner and more innovative. It’s time for IT Project teams to say, “Hold our coffee, watch us do our thing” – this is our moment.

Securing a Better Position – How To Get Promoted As a Project Manager

Whether you’ve entered at ground level and feel you’re experienced enough to take the next step up the career ladder as a...

Mentoring and project managers – get the best out of a team

Project management isn’t just based on cost and analysis and dealing with stakeholders and your existing team – you also need to...

How to equip yourself for a distance learning course

If you are planning to do a distance learning course then read on to see our tips on how you should best...