I'd like to type " XYZ1234 " as the Item_ID in cell A2 and have it return " ACME Rocket Car 2.0 " as the Item_Name in B2 and " 5 " as my OnHandQty in C2.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.