Breakthrough Improvement with QI Macros and Excel Data Mining

A One Day Workshop

QI Macros and Data MiningEven though the QI Macros are easy to learn and use, you might want a more in depth class on all of the functions. 

Learning Objectives:

  • Understand how to use the QI Macros charts for Process Improvement and Lean Six Sigma.
  • Understand how to use the QI Macros templates
  • Understand how to use the Anova and Analysis Tools
  • Understand how to use the Data Transformation Tools


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 improvement stories using line graphs, pareto charts and fishbone diagrams.
  2. Use the Control Chart Wizard to select and draw control charts. Use control charts to analyze the stability of processes (Are they repeatable and predictable?)
  3. Use Histograms to analyze process capability
  4. Use the QI Templates for Lean Six Sigma.
  5. Use Anova and other tools for analysis.
  6. Use Excel PivotTables to turn corporate data into powerful improvement stories.
  7. Use Data Transformation tools to manipulate tables of data and analyze "comments".

Post Workshop Webinar:

Webinar held one to two weeks after the workshop to solidify participants knowledge and answer additional questions.

Course Materials Provided to Each Participant:

  • QI Macros Tools Workbook 
  • Lean, Six Sigma and SPC Quick Reference Cards

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. $9,500 includes QI Macros SPC Software for Excel licenses for all 25 participants.
  2. $16,500 - Option 2 plus an additional day of individual and/or team coaching/ to analyze data or develop improvement projects. (Must be the day before or after the one day workshop.)
Call 1-888-468-1537 now to book Jay for a QI Macros and Data Mining Workshop.