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.

This post explains how to calculate Weighted Average in Excel with percentages. In a standard arithmetic average where the sum of values is divided by the number of values, each data value is ...

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.

The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with Microsoft Excel.

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

How to Calculate Overtime & Double Time in Excel. To avoid problems with your employees or the government, your company payroll spreadsheet should not only be accurate, but it should also comply ...

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

Everyone likes a bonus, but sometimes calculating one can be a bit complicated--at first. Here's how to calculate the amount in Microsoft Excel that you or your staff will get paid.

The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days.