Uploaded April 2014 | Updated November 2026, 3 hours ago
The required complexity of formulas often depends on the design of the Excel model.
If a model is designed well then simple formulas - pivots may be enough.
However, if the design is awkward then heavier formulas are required.
This video shows you an example of an awkward data layout, how it should be changed (if time permits) and a solution to get the required answers if there is no time to change the layout.
The required complexity of formulas often depends on the design of the Excel model.
If a model is designed well then simple formulas - pivots may be enough.
However, if the design is awkward then heavier formulas are required.
This video shows you an example of an awkward data layout, how it should be changed (if time permits) and a solution to get the required answers if there is no time to change the layout.










