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.

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

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.

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...