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.

Slicers are a great tool for filtering a data set or PivotTable. Learn how to use one slicer to manipulate more than one PivotTable or PivotChart.

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

A PivotTable report in Excel is an interactive table that enables you to easily combine and compare large amounts of data. The values in its rows and columns can be rotated to look at different ...

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.

We've then clicked in the table of data and chosen to Insert a PivotTable. (Excel 2003: Data menu, PivotTable and PivotChart report). The customer CompanyName is set as the row label, the Age as the ...