PivotTable Exercise Dojo

Practice Using PivotTables to Develop Improvement Stories

Load QI Macros 30-day trial. Next click on QI Macros Help on the far right side of the menu to open the test data folder.

QI Macros Test Data Menu

Open the pivottable.xlsx file and follow the Practice application to:

  1. Draw Control Charts to show defects or costs over time.
  2. Draw Pareto Charts to narrow the focus.
  3. When appropriate, in the PivotTable, double click on a Total for the "big" bar on the pareto to "drill down". Can you do another level of pareto?
  4. Insert an Ishikawa/Fishbone diagram into the PivotTable.
  5. Modify the problem statement to reflect one of the "big bars" on the pareto chart.
  6. Each of the three sheets should have a control chart, pareto chart and fishbone diagram when you're done.


Books by Jay Arthur