In some cases, CPAs find they want to further refine their PivotTable reports using Excel’s full complement of editing tools, but their hands are tied by the PivotTable structure. In this situation, ...

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

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.

Use Tables in Excel You can also analyze columns of data using a list or table. In Excel 2003 the feature is called Lists, and in Excel 2007/2010 it is a Table. Click somewhere inside the data and, in ...