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.

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.

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.

The forward P/E ratio measures the relationship of the current stock price to the forecasted EPS figures. Here's how to calculate a company's forward P/E ratio for the next period using Microsoft ...

In Excel, folks can use the RRI to calculate Compound Annual Growth Rate, also known as CAGR. What are the 5 functions in Excel every professional should use?

Investors use the dividend payout ratio to understand how much of a company’s income is paid out as dividends. Learn more about the dividend payout and how to calculate it.