Academy

In this article we’ll discuss some of the best practices that will help you build Excel files with a logical and solid structure.

We advise you to distinguish separate input and output sheets as well as sheets for calculations, documentation and dashboards.

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.

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.

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.

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