In the consulting work we do at EzyTeck, we review a lot of Excel files built by real professionals — finance officers, HR managers, operations staff, administrators. And across almost every file, regardless of the person's experience level, we see the same five mistakes appearing over and over.

None of these mistakes are obvious in the moment. That is what makes them expensive. They feel like normal ways of working until you see the alternative — and then you cannot unsee it.

1
Mistake One
Hardcoding Numbers Inside Formulas
You write =A2*0.175 to calculate VAT. It works. Three months later, VAT changes. Now you have to hunt through 47 formulas across 6 sheets to find every place you typed 0.175. You will miss some. The file will silently give wrong answers. This happens constantly in real business files and the errors are almost impossible to catch without a full audit.
The Fix
Put all your rates, percentages, and constants in a dedicated "Settings" or "Config" sheet. Name the cells. Write =A2*VAT_Rate instead. When the rate changes, you update one cell and every formula in the entire workbook updates automatically.
2
Mistake Two
Merging Cells in Data Tables
Merged cells look clean. They feel organised. They also break sorting, break filtering, break VLOOKUP, break Pivot Tables, and make your data nearly impossible to work with programmatically. Every time you merge cells in a data range, you are choosing aesthetics over functionality — and you will pay for it the moment you try to do anything analytical with that data.
The Fix
Use "Centre Across Selection" for visual alignment instead of merging — it looks identical but does not break your data structure. For reports that need visual merging, create a separate "display" sheet that pulls from your clean data sheet.
3
Mistake Three
Using Colour as Data
You highlight overdue invoices in red. Approved items in green. It makes sense visually. But colour is invisible to formulas. You cannot SUMIF by colour. You cannot filter by colour reliably. You cannot export colour meaning to any other system. All that information exists only in someone's head — and the moment a different person opens the file, or you come back to it in six months, the meaning is gone.
The Fix
Add a "Status" column with text values: "Overdue", "Approved", "Pending". Then use conditional formatting to colour based on that column. Now the data is real, filterable, and formula-accessible — and the colour is just a visual layer on top of actual information.

"The most dangerous Excel mistakes are the ones that feel like they are working — right up until you need to scale them."

4
Mistake Four
Not Converting Data Ranges to Tables
Most Excel users have never pressed Ctrl+T. This is one of the most consequential gaps in spreadsheet knowledge. When your data is a plain range — just cells — every formula you write has to manually reference exact row numbers. Add a row and your formulas break. Delete a row and references shift. Working with raw ranges at scale is like building a house without a foundation: it holds until it does not.
The Fix
Select your data and press Ctrl+T. Your range becomes a structured Table. Formulas now reference column names instead of row numbers. Add new rows and every formula expands automatically. Pivot Tables built on Tables refresh without restructuring. This single habit removes more errors than almost anything else.
5
Mistake Five
Mixing Raw Data, Calculations, and Presentation in One Sheet
Your raw data is in columns A to F. Your calculations are somewhere in columns H to M. Your formatted output table is in columns P to T. Everything is on one sheet. When something breaks, you spend 20 minutes tracing which cell feeds which. When someone else opens the file, they have no idea what is input and what is output. This is the most common structural mistake in professionally used Excel files.
The Fix
Separate your workbook into three types of sheets: Data sheets (raw input only, no formatting), Calculation sheets (where logic lives, ugly is fine), and Report sheets (clean output that pulls from calculations). This structure makes files maintainable, auditable, and shareable.

These five fixes are not advanced Excel. They are not about knowing obscure functions. They are about building the right habits and understanding why structure matters — which is exactly the kind of thinking that separates someone who "uses Excel" from someone who builds reliable business systems with it.

If you recognised your own files in any of the mistakes above, that is a good sign — it means you are paying attention. The next step is building the habits that make these errors impossible.