Learn Excel Episode 266: Pivot Doubts
They say that every data set has errors. Once you are able to summarize those 50,000 rows to a 5 line summary, people start spotting all kinds of errors. Wait a second! We never sold that product to this customer! You can double click to view the detail behind any pivot table cell. Episode 266 shows you how.