The problem
Excel is excellent for calculating something quickly. But in many businesses it has quietly become a business system: for planning, reconciliation with the accounts, reporting or moving data between systems. Research into spreadsheets in practice found errors in almost nine out of ten spreadsheets audited, and even carefully built sheets contained incorrect formulas.
Why it keeps coming back
- Everyone can use it, so everyone starts with it.
- There are no checks: a wrong reference or a forgotten row goes unnoticed.
- The work is redone by hand every month, with copying, pasting and lookup functions.
- The knowledge sits in the sheet and in the head of the person who made it.
Our approach
- Map the data flow. Where does the data come from, what happens to it, where does it go?
- Automate what repeats. Fetch the data straight from the source, convert it with fixed rules and have the result ready. The same every time, in minutes instead of hours.
- Build in checks. Do the totals add up, is anything missing, does anything differ from the source? The system flags what is wrong by itself.
- Calculate in code. Calculations live in one place, are tested and give the same answer every time.
What to watch out for
- Start with the sheet that takes the most time or where an error is most expensive.
- Spreadsheets can stay for analysis and exploration, but not as the only source of truth.
- Involve the people who do the work now: they know the exceptions.
Would you like advice on replacing Excel as a business system? Request a free advice conversation.
Sources
Updated on