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.

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

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

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

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

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 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 ...

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 .

Reviewed by Charlene Rhinehart Fact checked by Vikki Velasquez Businesses depreciate long-term assets for both tax and accounting purposes. For tax purposes, businesses can deduct the cost of the ...

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...

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.