{"id":16592,"date":"2018-08-30T00:00:00","date_gmt":"2018-08-30T05:00:00","guid":{"rendered":"https:\/\/blog.planview.com\/how-to-migrate-processes-away-from-spreadsheets\/"},"modified":"2018-08-30T00:00:00","modified_gmt":"2018-08-30T05:00:00","slug":"how-to-migrate-processes-away-from-spreadsheets","status":"publish","type":"post","link":"https:\/\/blog.planview.com\/how-to-migrate-processes-away-from-spreadsheets\/","title":{"rendered":"How to Migrate Processes Away from Spreadsheets"},"content":{"rendered":"

<\/p>\n

Spreadsheets can be fine in the right context, but all too often they’re being used for everything apart from their intended use. Excel files are also one of the worst ways to try and coordinate projects and task-flows, resulting in endless iterations adjusting for project updates with no-one really ever sure they have up-to-date information on anything.<\/span><\/p>\n

<\/p>\n

Not only are they being overused and spreading inefficiencies, they are also renowned for being awash with mistakes. <\/span>Research has shown that nearly 90% of spreadsheets have errors<\/span><\/a>, with their proliferation around an organization leading to the compounding of those errors with the potential for causing major long-term issues. Investigations into disgraced energy provider, Enron, for example, uncovered one spreadsheet with a whopping 83,000 errors.<\/span><\/p>\n

So, we all know why we have to move on from spreadsheets, but the next issue is actually weaning your team off their ubiquitous use and migrating processes from spreadsheets <\/span>to project management software<\/span><\/a> that was actually purpose-built for that reason. <\/span><\/p>\n

As a project manager, it is among your major responsibilities to ensure the full integration of more efficient processes that will lead to greater productivity. So, what are the best ways to stop your team from falling back into old habits with regards to spreadsheet use?<\/span><\/p>\n

Lead by example<\/b><\/p>\n

Of course, you can’t expect any of your reports to start adopting different work practices if you’re not doing so yourself. As a project leader, the team looks to you to set the standard, so as difficult as it might be for you to also move away from Excel, it’s important to completely commit yourself to new processes.<\/span><\/p>\n

\n
Increase your business agility with Planview AdaptiveWork’s project management software<\/div>\n
Take a Product Tour<\/a><\/div>\n<\/div>\n

Hold integration and information meetings<\/b><\/p>\n

It would be quite unfair to send your team a directive or memo, telling them to change the habits of a lifetime without also providing information and education on how they can make those changes successfully. <\/span><\/p>\n

Host full-on integration and information meetings to help get your team up-to-speed with the usage and features of your new software. If some members are still having difficulties let them know that you are available to deal with any queries.<\/span><\/p>\n

Define what constitutes acceptable and unacceptable use<\/b><\/p>\n

Though spreadsheet use now far exceeds its remit<\/span><\/a>, it does still have a function within an office environment, especially with regards to accounting and tracking numerical data. A blanket ban on the use of Excel can be too much of a shock for any team. Make it clear which uses are allowed and which definitely aren’t. Try breaking up these different uses and putting them into easy categories, such as:<\/span><\/p>\n