Input sources
How to find external links in Excel
What happens when Excel can’t find your external source anymore? What happens when you get broken links?
Keep a formula close to its input
Place a formula close to its input variables. It’ll reduce the chance of mistakes, you’ll make optimal use of Excel’s support, and your spreadsheet becomes easier to carry over to someone else. Essentially, having formulas near their input makes your spreadsheet better.
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.
Separate input and output
We advise you to distinguish separate input and output sheets as well as sheets for calculations, documentation and dashboards.