Spreadsheet development
Good formatting in Excel
Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills. The downside of this, however, is that many users format cells in an ad-hoc manner, creating messy spreadsheets.
Create & maintain good spreadsheets
To create and maintain consistently good spreadsheets, there are a number of Excel best practices which we’ll share with you in this article.
Clean your input data well
Input data is the foundation of your spreadsheet, so pay serious attention to clean it properly. If possible, clean it in such a way that it becomes an automated process for the next time you use the same spreadsheet.
Structure changes: columns and rows
What happens when you add or delete columns and rows? It happens frequently in Excel and it changes the very structure of the sheet you’re working on.
Best practices for a solid structure of Excel files
In this article we’ll discuss some of the best practices that will help you build Excel files with a logical and solid structure.
Separate input and output
We advise you to distinguish separate input and output sheets as well as sheets for calculations, documentation and dashboards.