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

Microsoft Excel is a powerhouse when it comes to calculating numbers. With its vast assortment of functions, you can construct formulas to derive virtually any numeric result.

How to Use Microsoft Excel to Calculate Seasonal Indexes. A seasonal index is a way of measuring the seasonal variation -- that is, to measure the change that is due to seasonal changes in demand ...

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

Microsoft Excel’s Subtotal feature is a great tool, but you can make the results even better by customizing the format.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

Discover how to calculate the modified Macaulay duration of a bond or other fixed-income security using Microsoft Excel.