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.

Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

How to Calculate Fluctuations in Excel. Calculating data fluctuations-- also called variance -- is a multi-step process that requires total accuracy. Excel 2010 provides two basic formulas for ...

How to Excel at Options Valuation Build a flexible, spreadsheet-based lattice model for better calculations.

Thanks -- and Fool on! 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 .

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.