Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. ... Use RANK.EQ() to create a helper column.

In Excel, rank is a value that represents the position of one value within a group of values. You’ll want to rank all kinds of data: student GPAs, sport statistics, product sales and so on.

How to Create a Bracket in Excel. Whether you are helping your employees gear up for March Madness or pitting one salesperson against another in a race to the top, trying to figure out the ...

Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

In our example, Excel offers to create 10 different pivot tables that take a look at a number of different angles on our sales data. Note that how you label your columns matters; ...