You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.

The MEDIAN calculation function sorts through the provided values/arguments to find the value that falls arithmetically in the middle of the group.

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

How to Calculate the Total Hours Formula in Excel. As a spreadsheet software program, Microsoft Excel has many useful features for a small business's productivity. Chief among these is the ability ...

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.

How to Use Excel to Calculate a Bond's Yield to Call. Bonds are investment vehicles that make regular coupon payments until maturity, at which time the bond's face value is paid.

Microsoft Excel will rank whatever you want automatically. Susan Harkins will show you how.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

After tackling the basic and formatting capabilities of Microsoft Excel, we come to formulas, which are an integral part of the worksheets, and without which an electronic spreadsheet wouldn't be ...

Calculate the standard deviation of the historical returns compared to the mean determined in Step 3. In Excel, this can be achieved by using the STDEV function.