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.

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.

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

Learn Excel 365 formulas fast! From AutoSum to Intellisense, learn how to work smarter and analyze data with ease. Tips, ...

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

Learn how to calculate all the particulars of a loan using Excel and how to set up a schedule of repayment for a mortgage or any other loan.

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

Excel can quickly calculate amortization. Microsoft Excel is a widely used spreadsheet program that can use formulas to compute and display values.

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

How to Calculate a Model in Excel. Mathematical models are a way to attempt to predict the probable outcome of a complex situation. From climate, stock market and physics models, you can use ...

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.