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. Ranking data is common ...

Calculating percentages in Excel often means wrestling with absolute cell references and division symbols. But why do the work when a built-in tool can do it for you? By using the PivotTable Show ...