There is a time of Christmas holidays, the time when everybody, more or less, decorates the Christmas tree, and this served as an inspiration for the text on the application of one more type of Excel chart. It is a subtype of the Scatter called Bubble and by which we can get a “XY” chart whereby a multicolored “balls” are found on the section. To create this diagram all we need are: a table of data, a picture of the Christmas tree and a little work in Excel!
Bulleted lists are functionality that is more commonly used when working with MS Word than with Excel. There is no adequate translation into Serbian, but it is about the lists of items that we quote “under theses”. Excel does not support automatic numbering, but with the option to insert symbols, we can add squares, circles, and other bullet symbols to achieve the desired effect.
Break-Even point is a method for calculating the profitability of a business. Income is calculated as the product quantity and the cost, and the costs are the sum of fixed costs and the product of the variable costs per unit with the amount. Therefore, breaking point is calculated by division of fixed costs and the difference of price and variable costs per unit of production. In following „recipe“ you will see the practical application of this method.
The term “mixed apples and oranges” is used to describe attempts to link some completely incompatible things. In Excel this often refers to making a strange conglomerate of a Pivot and traditional table. I personally never recommend it, but there are times when such reports are still necessary. With some ingenuity and little help of GETPIVOTDATA and OFFSET functions we’ll be able “to mix apples and oranges”. None of the above were hurt during the process!
Each one of you, who was in the situation of writing a user manual, certainly used one of the options for capturing screen content. To remind you, by pressing the PrtScr or SHIFT + PrtScr (shortcut from the Print Screen) key, the full screen image is transferred to the computer’s memory. Pressing Alt + PrtScr camptures only the contents of the active window. Some recent versions of Excel have an option that allows you to capture screen content.