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

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

Excel 2010 provides two basic formulas for calculating fluctuations, depending on whether your worksheet includes a sampling or entire set of data.

Excel for the web supports all three ranking functions. If you’re unfamiliar with Excel’s three ranking functions, consider reading How to calculate rank in an Excel sheet.

The median function in Excel can be categorized as a statistical function. It can be entered as part of a formula in a cell of a worksheet. The syntax of the MEDIAN function is as follows: MEDIAN ...

Understand the basics of the current ratio, including its use in assessing a company's liquidity and learn how it is calculated in Microsoft Excel.

How to Make Excel Calculate Faster. Whenever you change something on a Microsoft Excel 2010 spreadsheet, the program will recalculate some of the cells in the worksheet, even some of those that ...

Calculate sporadic totals in Excel easily using this technique. Having intermittent cells and blank cells in Excel makes calculating the sum of intermittent cells tedious.

To determine the value of a bond today—for a fixed principal (par value) to be repaid in the future—we can use an Excel spreadsheet.

After tackling the basic and formatting capabilities of Microsoft Excel, we come to formulas, which are an integral part of the worksheets, and without which an electronic spreadsheet wouldn't be ...