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

Prework:

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

Participants:

Up to 25

Facilities:

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

Investment:

  • $10,000 (additional days $7000/day)
  • $1,000 travel expenses ($1,500 if less than 30 days in advance)
  • 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
  • Call 1-888-468-1537 now to book Jay for a QI Macros and Data Mining Workshop.