Pareto Analysis Using Pivot Tables

On today's episode of Call forHelp, I will show you how to use pivot tables to do a pareto analysis of manufacturing defect data. Your defect database may have 10,000+ rows of problems, but what do you do with that information?

Using a pivot table, you can start to figure out which manufacturing cells are the biggest problems and then drill down to find out if your problems are one one certain manufacturing line or if they started when someone left on vacation.

Read the complete details here: http://www.mrexcel.com/tip098.shtml