
Academy

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.

What is an array formula
An array formula allows you to perform multiple calculations at once, or, it can perform one or more calculations multiple times within a selected cell range.

What is a circular reference
A circular reference refers to a formula, that visits its own or another cell more than once in its chain of calculations, creating an infinite loop which slows down your spreadsheet significantly.

Use consistent labels
Numbers without meaning are worthless. Excel is a program for numbers, but it’s only useful when it’s clear to the user what the numbers mean.

Document your work
What separates the great spreadsheets from the rest, is documentation. Documentation will help future users of the spreadsheets to really understand your work.