How to Get Loan Amortization Schedule in Excel

How to Get Loan Amortization Schedule in Excel

To start it all up, loan amortization is a fancy way to define a loan that is paid back in installments throughout the entire term of the loan. So, all loans are amortized in nature in one way or another. To elaborate all this in a simpler method let me give you an example; if … Read more

How to Calculate Age Using Excel

How to Calculate Age Using Excel

Have you ever wondered how you could calculate the age of a number of people in a short period of time? Well, excel simplifies this task for you. Since calculating age goes hand in hand with dates and numbers in excel, it is easier to calculate age when you follow a few steps. It is … Read more

How to calculate variance in Excel

How to calculate variance in Excel

Variance is a measure of distance between numbers in a data set. Its measures the distance difference each number is from the mean. This distance is also known as the error term in which the variance is measured. It's very easy to calculate variance in Excel if you have all the data set already entered … Read more

How to Calculate Correlation Coefficient in Excel

How to Calculate Correlation Coefficient in Excel

Excel is a powerful statistical tool. It can be used to calculate various statistics problems. Finding a correlation between two data series is a common statistical calculation that many statistical analysts come across. To solve these calculations, various methods are used. Using Excel to calculate correlation problems has proven to be one of the simplest … Read more

How to calculate work hours in Excel

How to calculate work hours in Excel

Every employer would like to track the hours worked by his employees. However, this may be challenging and time-consuming if manual methods are used. Luckily, Excel allows its users to calculate the working hours for someone using some in-built functions. This has greatly simplified the process of tracking employees' working duration. Below are some tips … Read more

How to calculate Standard Deviation in Excel

How to count unique values in Excel

Standard deviation is a statistical way of measuring the dispersion of a dataset. It is time confusing and tiresome to calculate standard deviation manually. To ease the process of calculating standard deviation, new methods have been developed. Excel is a powerful tool that can be used to calculate standard deviation in just a few steps. … Read more

How to calculate discount in Excel

How to calculate discount in Excel

Discount is the amount deducted from the regular price of a commodity. This is usually found by deducting the selling price from the regular or marked price of a commodity. Discount can also be expressed in percentage by taking the regular price multiplied by the rate of discount. Regular Price × Rate of Discount = … Read more

How to calculate compound interest in Excel

How to calculate compound interest in Excel

Compound interest is where interest is credited on a loan or deposit with consideration of the initial principal and the cumulative interest from the time before. A good example is when you invest 700,000/= with a 10% annual interest rate, compounded annually. When a year lapses from the initial principal, you get 70,000/= (700,000 x … Read more