~ 1 MIN READ
The Road to Excel Hell is Paved with Good Intentions [infographic]
It is arguably the most famous piece of software in the world. Its dominance in the data marketplace is undeniable. It features calculations, graphing tools, pivot tables, and macros. It is Microsoft Excel… and it is treacherous.
You know the drill. You are tracking metrics and Excel is your obvious go-to. It’s easy, or so you think. You go down this road, but only after you set out on this journey do you discover all the threats and Excel forces working against you.
The project builds momentum and more people get involved. Excel is so ubiquitous many people on the team do not want to admit they are not very good at using the program. Spreadsheets get passed around via email and manipulated by different users. There is no way to debug and there is no audit trail to track changes. Numbers get overwritten without you even knowing it, and there is no way to test how Excel spits out the values it does. Which version are we looking at now?
More data is requested and spreadsheets pile up in your inbox. Where is this data coming from? What are these formulas? The creator of these legacy spreadsheets left the company five years ago.
Spreadsheets that should be producing the same results are creating data duels. Errors go unnoticed… until they don’t. You’re not alone on this journey. The road is crowded with big banks and leading researchers advising global economic policy.
Later you figure out the road you are following is not paved with yellow bricks and steering you toward the magical land of Oz. Be careful. You are on a highway to Excel Hell. Don’t let this happen to you. Learn from this infographic road map.