Getting Started With The QI Macros

Shopping cart

0 Product(s) in cart

Total $0.00

> Checkout

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2009

The QI Macros are an affordable easy to use set of add ins for Microsoft Excel. See our QI Macros FAQ page for answers to frequently asked questions about pricing, ordering, technical support, etc.

Take this video tour to learn more about the QI Macros functionality and how they work. See our free QI Macros Training page for all of our free training resources.

Installing the QI Macros

To install the QI Macros simply close Excel and run the QI Macros Installation Wizard. Once you run the wizard, open Excel and see the QI Macros on your Microsoft Excel toolbar. Watch a video of the Installation Process.

The QI Macros SPC Software for Excel has five parts:

1. Over 30 charts including histograms, pareto charts, scatter plots, box whisker plots and all variable and attribute control charts. Just select your data and then click on the QI Macros menu and select the chart you want to run.
2. Over 80 Fill-in-the-blank templates and tools including fishbones, FMEA, DOE, Gage R&R, PPAP forms and more.
3. Statistical tools including Anova, f-test, t-test, regression, data normality test, sample size calculator and more.
4. Data Transformation tools to help organize and analyze your data including stack and restack, and WordCount and PivotTable Wizards.
5. Automated Control Chart Dashboards - just drop your data into these pre-formatted templates.

Watch an overview of the QI Macros Menu.

30 Chart Macros

To create a chart using a macro simply click and drag over your data and then select the chart you want to create from the QI Macros pull down menu. Here are some videos of sample charts:

• Watch a Macros Overview video
• Watch a video of a Control Chart
• Watch a video of a Histogram
• Watch Create Charts Tutorial - 18 minutes

Fill-in-the-Blanks-Templates

The QI Macros has over 80 fill-in the-blanks templates including the flowcharts, fishbones, Gage R&R, DOE, QFD and PPAP forms. To open a template click on Fill-in-the-Blanks-Templates and then one of the sub menus. Most input areas are highlighted in yellow. Here are some sample fill-in the-blanks templates.

• Watch a Templates Overview video
• Watch a video of the Gage R&R Template
• Watch a video of the DOE Template
• Watch a video of the Ishikawa Diagram Template
• Watch Templates Tutorial - 16 minutes

Anova and Analysis Tools

The QI Macros also includes and easy to use interface into Excel's data analysis toolpak. Statistical tools include anova, regression analysis, data normality test and sample size calculator. Here are some sample videos of the Anova and Analysis Tools:

• Watch an Anova and Statistical Tools Overview video
• Watch a video of Anova Single Factor
• Watch a video of the Data Normality Test
• Watch a video of the Sample Size calculator
• Watch Anova Statitistical Tools Tutorial - 11 minutes

Data Transformation Tools

• Watch a Data Transformation Tools Overview video
• Watch a video of Pivot Table Wizard
• Watch a video of Word Count Wizard
• Watch a video of Stack and Restack
• Watch Data Transformation Tools Tutorial - 14 minutes

Control Chart Dashboards

Watch Control Chart Dashboard Tutorial - 6 minutes

Other Free QI Macros Training Resources

Other QI Macros Training Resources

Try QI Macros
FREE
For 30-Days

Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee