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

If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.

To help you get around this issue, Excel 2010 includes a conditional formatting option that will automatically search through a data field and highlight every cell that hold a value that exists ...