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

With named ranges, you can label specific data within a spreadsheet, making it easy to refer to them in formulas. Excel's Name Manager tool simplifies the process of creating, editing, and ...

How to Calculate Fluctuations in Excel. Calculating data fluctuations-- also called variance -- is a multi-step process that requires total accuracy. Excel 2010 provides two basic formulas for ...

How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

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

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

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 .

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.

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.