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.

To calculate statistical variance in Microsoft Excel, use the built-in Excel function VAR.

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 interquartile mean is a measure of central tendency. While all values in a data set are used to calculate the mean, only the interquartile range -- the central portion of a data set -- is used ...

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.

How to Calculate Breakpoints in Excel. A price breakpoint is a discount you offer your customers based on the amount of units that they order. The breakpoint is the lower value of the range that ...

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.

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

AVERAGEIF and AVERAGEIFS aren't the only functions in Excel that calculate the average of a dataset. For example, the AVERAGE function produces a straightforward arithmetic mean of a set of data, and ...