Try now!

Validate your spreadsheet for free



Excel Guidelines for Professionals

We have been researching spreadsheets for almost a decade! We’ve seen it all: from spreadsheets that neatly solve a business need to complete horror stories. Over the years, people have often asked us: What defines a good spreadsheet? How do I make it better? Subscribe now to find out with new Excel Guidelines for Professionals every other week!

Subscribe Now

Subscribe Now

Introduction

Excel is easy, right? Enter some figures, formulate some calculations and you’ve got immediate results. A spreadsheet is born. But then it grows, and grows, and… On average, spreadsheets continue to be developed for five years, and they are used by not just one or two, but thirteen different users. Not surprising then, that spreadsheets tend to get rather entangled. It’s been estimated that on average 7 billion dollars are lost each year due to errors in spreadsheets. Excel isn’t so easy after all!

Read more

Guideline 01: Document your Work 

What separates the great spreadsheets from the other ones, is documentation! This will help future users of the spreadsheets to really understand your work. Even when the future user is you. Your spreadsheet should contain a ‘Documentation’ sheet as first, or last worksheet. Explain the future reader what the spreadsheet is for, where you obtained the data and where the results may be used.

Read more

Guideline 02: Never Use Fixed Numbers in Formulas

We have all seen “magic numbers” like this = SUM(A4:A12)*0.145. However, the use of magic numbers is a bad idea. A future user will not know where the number originates from. And a magic number does not change when needed, and thus might be overlooked when a change is made.

Read more

Guideline 03: Calculate Only Once

Sometimes, you need the exact same formula, based on the same numbers, in multiple places, like a calculation for inflation, on which you base several other formulas.

Read more

Guideline 04: Separate Input & Output

When you read a book or a report or a website, we read from top to bottom and from left to right. Remember that setup when you create a spreadsheet and follow this structure, both within a worksheet and between them.

Read more

Guideline 05: Delete What You Don't Need

Compare transferring a spreadsheet to renting your house via Airbnb. It remains more neat when you clean it first, right? Messy stimulates messy, neat stimulates neat. Remember an average spreadsheet will have 12 users after you! What would happen when the chain starts with a messy file?

Read more

Guideline 06: Do Not Merge Cells

It is so tempting! Merge cells in Excel so they form a header above two or more columns. Yes, it looks nice but resist the temptation because it can be dangerous.

Read More

Guideline 07: Use Consistent Labels

Numbers without meaning are worthless. Excel is a program for numbers, but it is only useful if it is clear to the reader or user what these numbers mean. So, make sure that you provide all data and formulas of textual information. Let’s call these information labels.

Read More