Every Spreadsheet Needs a Second Opinion

You’ve created an amazing spreadsheet. You feel satisfied and proud and fully confident to send it to all relevant coworkers. But within one minute after hitting ‘send’, the first colleague is standing beside your desk, pointing out a fatal mistake. A mistake that could have been avoided. 

Excel Guidelines for Professionals - No 17 :: Every Spreadsheet Needs a Second Opinion :: PerfectXL

There are two important reasons why even your beautiful piece-of-art spreadsheets contain mistakes or at least risks:

  1. Almost everyone becomes blind for mistakes in his own work. It doesn’t matter what type of job you do. Whether you paint houses, write books or develop spreadsheets. When you work on something for a long time, you just don’t see it anymore.
  2. Spreadsheet developers suffer from a unique characteristic: it doesn’t matter how skilled they are, they always make just about the same amount of mistakes. Why is this you ask? Because someone who is a better developer will automatically try to resolve more complicated issues. Complicated issues call for more complex spreadsheets. Complex spreadsheets contain more risks and errors.

Have Your Spreadsheet Checked

Our conclusion and advise to you is: always have your spreadsheet checked. A second opinion costs a little more time, but it is worth the effort. The most obvious choice for a second opinion is to ask a coworker to check your spreadsheet. But this solution is time-consuming and error-prone. It is better to use a tool to check it, possibly complemented by the sharp eye of a colleague. PerfectXL validates your spreadsheet within minutes and guarantees to point out major mistakes and errors in your spreadsheet.

Start Free Trial Now

 

Clean Your Input Data

Garbage in, garbage out? Not if you pay serious attention to cleaning your input data first.
The importance of cleaning your input data

 

More Guidelines

Go to the overview of Excel Guidelines

Never miss a Guideline!