Power BI Desktop got another new feature in its November release. For visuals that contain too much detail, it is possible to turn on the Zoom Slider option. It allows you, without the need to create additional filters, to zoom the contents of the slider and gain a better insight into the displayed data. This option does not affect any trend lines that you may have added on the chart that we want to zoom.
Conditional formatting is an Excel functionality that is often used, and allows you to emphasize certain parts of the report. Typically, conditional formatting is used within the same column, but how do we display “traffic lights“, icons that indicate a change in business, within another column? This is a very simple procedure, and if you want to find out how this is done, you have it in this “recipe”.
The Paste Special option provides a number of ways to manipulate the values that need to be pasted back into the document. One of them is calculation, where it is possible to select a cell that contains a value, and then a range with values for calculation that will perform one of the four elementary mathematical operations (addition, subtraction, multiplication, division). This can increase productivity, let’s see how it is used!
Financial functions in Excel allow for a variety of discounting operations. PMT function, for given present value, interest rate and number of periods calculates the total repayment value (annuity). How much, in this case, goes for the principal and how much for interest? To get answers to these questions you need to use the PPMT and IPMT functions.
The Registry of the National Internet Domain of Serbia (RNIDS) has been supporting Cyrillic (.срб) domains for some time, which is a good way to promote Serbian alphabet. The Internet also supports a number of other fonts that you can use freely within the Internet browser, but there are situations when it is necessary to “translate” terms in other languages into one understandable to computer, the so-called Pun Code. To perform this we use the ENCODEURL function.