We have several mathematical functions provided in or by the Microsoft Excel. Some of these functions are; v-lookup, min, max, mean, mode, and median. They all have their basic function…
Max, as used in the above statement, is the short form for the word maximum. Maximum is a mathematical function used when we are referring to the value with the…
Whenever we are handling numbers, values, ranges, and figures there is always the need to identify the minimum value of all the values and the maximum values of all the…
Formatting is a very crucial aspect of Word editing. You can bold, underline, italicize, set paragraphs, etc. using well-arranged commands and shortcuts. Formatting is also tenable on Excel. There are…
The analysis involves the calculation of differences between two values. You can also carry out simple percentage operations on your excel spreadsheet. The difference between the two values means change.…
Compound interest is one of the most popular functions in economics and finance. It is a standardized method of cumulating the interest accrued within a given time. In compound interest,…
In production, depreciation occurs whenever an asset losses its value due to heavy use. When considering the units of production, depreciation is not calculated based on the duration an asset…
1. Excel formula for percentage change Normally in mathematics, the percentage change is usually given by; %Change = (change/initial value) *100. The change is usually a difference between the two…
Formatting makes our documents look appealing to our eyes. The power of conditional formatting is far-reaching. Excel has not been left behind since we can use a specific formula to…
The process of amortization involves paying back a loan for a given period of time until the loan is fully paid. For a long time, amortization calculation used to be…