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

If you need a visual clue to hype a worksheet, use Excel’s Conditional Formatting feature to help values stand out. If you maintain inventory in an Excel worksheet, you probably need to know when ...

Stop doing more than you have to in Excel—built-in tools can automate repetitive tasks instantly.