Discover how to replace traditional Excel chart objects with clean, customizable in-cell visualizations using a single ...

If you've ever been confused by Excel's three different ranking functions, you aren't alone. A rank is a rank, right? But they actually differ in how they handle ties and which versions of Excel they ...

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

When I first discovered Excel's dynamic array functions, my entire approach to spreadsheet design shifted. They replaced my clunky, multistep workarounds with smart, self-expanding formulas that adapt ...

Microsoft Excel’s new FILTER() function is a great tool for reporting and dashboards. We’ll show you how to use it to get more done. Filtering is a huge part of many Microsoft Excel sheets, and ...

Q. I get a detailed revenue transaction export from the client, and then I get it again, revised, usually after I’ve already filtered, sorted, and documented my selections. I’m tired of reapplying ...