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.

How to Calculate Negatives in Excel. Microsoft Excel has the ability to automatically recognize a positive or negative number that you enter in a cell. However, if an incorrect format is selected ...

You can wrap text in Excel in several ways to ensure that all the text in a cell is visible at once. You may also want to edit the cell height.

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.

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