Jay Arthur's QI Macros One-Day Workshop

Data Mining to Deliver Breakthrough Improvements

Microsoft Excel combined with the QI Macros provides power tools for analyzing and dramatically improving performance in service and manufacturing industries. 

Breakthrough Improvement with QI Macros and Excel Workshop

Learning Objectives:

  • Learn how to analyze data to find the key leverage points for breakthrough improvement
  • Learn how to layout data in Excel for the most effective and efficient analysis
  • Learn how to use the Magnificient Seven Tools of Breakthrough Improvement
  • Learn how to mine existing performance data using Excel PivotTables and the QI Macros PivotTable Wizard to achieve breakthrough improvement
  • Learn how to create the charts necessary for breakthrough improvement


To maximize learning, we use your data for examples. Excel files of delay, defects and variation must be available at least one week before class begins. We'd be happy to sign a nondisclosure statement.

Workshop Outline:

  1. Create breakthrough improvements using the Magnificient Seven Tools.
  2. Learn how to layout Excel data for optimum analysis and breakthrough.
  3. Use Excel PivotTables to turn corporate data into powerful improvement stories.
  4. Use the Control Chart Wizard to create control charts to analyze existing performance. Use control charts to analyze the stability of processes (Are they repeatable and predictable?)
  5. Use Pareto Charts to eliminate defects
  6. Use Histograms to eliminate deviation (i.e., variation).
  7. Use Ishikawa/Fishbone diagrams to document root causes.
  8. Use countermeasures, action plans and other tools to project manage the improvement.
  9. Create control chart dashboards to sustain the improvement

Course Materials Provided to Each Participant:

  • Breakthrough Improvement with QI Macros and Excel Book
  • Breakthrough Improvement Workbook

Jay Arthur QI Macros Additional:

QI Macros SPC Software for Excel

Course Length:

8 hours


Up to 25


A computer lab or laptop computers are essential to learning the QI Macros.

Investment Options:

(Includes all US travel and training materials)

  1. One-Day Workshop $10,000 (additional days $7000/day), plus $1000 travel expenses ($1,500 if less than 30 days in advance) and QI Macros licenses for up to 25 participants (required) at $199 per license. (Additional, printed training materials are provided for each attendee at no additional cost.) Total investment: $16,000
  2. Two-Day Workshop - $16,000 + $7,000 = $23,000 - Option 1 plus an additional day of individual and/or team coaching/ to analyze data or develop breakthrough improvement projects. (Must be the day after the one-day workshop.)
  3. Ongoing Online Coaching - $350/One hour team meeting.
    Improvement teams sometimes need some help getting started. Jay can meet online with teams to help analyze their data and focus the improvement effort.
  4. Ongoing refresher training - Free! Participants can watch video training about any method or tool online at www.lssyb.com.
Call 1-888-468-1537 now to book Jay for Breakthrough Improvement with QI Macros and Excel.