Checkbox is not a new Excel feature. We were able to add checkboxes to Excel reports earlier, by choosing some of the controls offered in the Developer ribbon (Form Controls, ActiveX Controls). Recently, Microsoft has made this option much more accessible, and in the following post you will find out how to add a checkbox to your report and how you can analyze such reports.
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.
When someone tells you, “I’m left without text” this usually means a state of shock and confusion. Ignoring text related functions will not leave you in shock, but you will certainly be deprived of some useful tools. These functions are numerous, and in the “recipe” that follows I’ll describe these that allow merging of two or more texts into one, converting text to number or number in text, determining the length of text …