Calculations

How to Calculate Percentiles in Excel

Excel is a beast when it comes to calculations. This means you can use it to calculate percentiles. If you are looking for a way to calculate Percentiles quickly, then this guide is for you. First, I will take you through what a percentile means and then show you three functions you can use.  What […]

How to calculate Standard Deviation in Excel: Easy Guide

Standard deviation is a popular term used in business, academia, manufacturing, finance, medicine, etc. It refers to a measure of data dispersion or variation in relation to the mean. This is very useful when it comes to understanding how different a given data is. You can easily calculate standard deviation in Excel with the help

How to convert CM to inches in Microsoft Excel

1 inch is equivalent to 2.54 centimeters. In other words, 1 centimeter is equivalent to 0.3937 inches. Knowing these values, you can easily create a calculator in Excel to help you convert centimeters to inches and vice versa. Methods to convert CM to Inches in Excel Let’s look at a few methods which you can

How to Calculate Percentage Change in Excel

When working with numbers, it’s very likely that you will need to calculate percentages. Besides, it’s an integral part of the finance, business, and education world. The percentage is also used in various careers such as Engineering, IT, and Surveying. What is percentage change? Before we dive into the tutorial, it’s important to understand the

How to Calculate the YTM of a Bond in Excel: Easy Guide

YTM stands for yield to maturity. It is a common term used in the financial industry. Whether you are buying or selling a bond then, you need to calculate YTM. Bonds are mostly sold by companies, financial institutions, and even Governments. As an investor, it is important to calculate the YTM of a bond in