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

Excel Slicers are easy to use visual controls added to Excel that allows to quickly and easily filter data in an interactive way by selecting values from a list.

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.

A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.