Minus and plus

When, as a result of subtracting two values in an Excel table, you get a negative result, sometimes you don’t want the negation sign to be seen. This requirement can be solved in several ways: by formatting the display of the number using the Accounting style, by using function that calculates the absolute value of the number or by creating custom format that will display number in a manner that suits you better.

LED chart

The LED chart is not a chart, in the true sense of the word, but it looks nice and is a good choice to illustrate Variance analysis report. We make it so that, after analyzing the percentage for which the plan was exceeded or missed, with the help of the REPT function, generate a certain number of “squares” to illustrate the obtained result.