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.
Are you overweight? Weight gain is not just an aesthetic problem, it can be the cause of many diseases, so companies conduct an annual physical examination to check the health of their employees. In this example, you will learn how to calculate BMI (Body Mass Index), a coefficient that indicates whether you are below or above the optimal body weight, and how to use conditional formatting to mark those who have unfavorable BMI.
Pivot tables often store data in the cache, and some of that data is also that about slicer elements. Slicers take values from the source table. If we add some of them and then delete them, it may happen that the slicers show phantom values. They are shown in pale color, as if there is no data. And indeed, if we pick such a value, we will get an empty pivot table report. How can slicer elements always be up to date?