There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever. Returning the top or bottom n ...

PivotTables in Microsoft Excel are a great way to get insights from big data sets in just a few seconds. However, most people don't make full use of their capabilities, sticking to their basic ...

Most people build a PivotTable, drag a field into Values, get a sum, and walk away. That's fine if all you need is a total, but totals on their own are just numbers sitting there. They don't tell you ...