Excel formula for percentage decrease and percentage difference

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.…

Comments Off on Excel formula for percentage decrease and percentage difference

Excel formula for quarterly compound interest

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,…

Comments Off on Excel formula for quarterly compound interest

Excel formula for units of production depreciation

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…

Comments Off on Excel formula for units of production depreciation

How to calculate Percentage using excel formulas

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…

Comments Off on How to calculate Percentage using excel formulas

Excel formula for every other row color

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…

Comments Off on Excel formula for every other row color

Excel formula for Amortization

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…

Comments Off on Excel formula for Amortization

Excel formula for average balance

Average balances are closely associated with bank transactions and credit cards. One can easily calculate his or her average balance depending on the amounts spent.   1. Simple average balance…

Comments Off on Excel formula for average balance

How to sort alphabetically in Excel and keep rows together

I understand using excel can be a daunting task, especially to newbies. The good thing is that there are many online resources to help you maneuver every corner of MS…

Comments Off on How to sort alphabetically in Excel and keep rows together

How to apply the same formula to multiple cells in Excel

For excel, nothing saves time than the use of formulas. As a matter of fact, this is the bread and butter of this Microsoft Office application. However, crafting a useful…

Comments Off on How to apply the same formula to multiple cells in Excel