Home » QI Macros » Getting Started

QI Macros Getting Started

Learn to Use the QI Macros in Less than Five Minutes

Completely quit out of Excel.
PC: Right-click on the "qimacros-30-day-trial.zip" or "QIMacrosSetup.zip" file to unzip the compressed file. Once completed, double-click the .exe file to launch the PC install.
Mac: Double-click the "QIMacrosTrialMac.zip" or "QIMacrosLicensed.zip" file to unzip the compressed file. Next, select Ctrl-Click-Open on the "QIMacrosTrialMac" or "QIMacroLicenseds" file to launch the Mac install.
Answer the installation wizard prompts and then open Excel. You should see the QI Macros on your Excel menu bar. If not, see easy fix here.

To create Control Charts, Histograms, Pareto charts, Box Whisker Plots, etc.

Click and drag over your data to select it.
Next click on the QI Macros Menu and select the chart you want, the Chart Wizard or the Control Chart Wizard.
QI Macros will perform the calculations & create the chart for you.

Learn more about the charts you can create using the QI Macros.

QI Macros contain 90+ templates which can be accessed under various sub menus. Just click on the arrow next to one of the sub menus and a complete list of templates will open.

In addition to the sub menu areas, these templates fall into the following categories:

Control Chart Templates and Chart Templates: Just open a template, input your data into the yellow shaded cells and the charts are created as you type. There are templates for control charts, histograms, box and whisker charts, etc.

DOE, Gage R&R and Other Templates to Perform Complex Calculations: Designed to make complex analysis as simple as possible. Just drop your test results into the yellow shaded areas and the templates perform all of the calculations, draw charts and help you interpret the results.

Drawing Templates: Get a head start on creating fishbones, flowcharts, value stream maps and more.

Documentation Templates: Save time on documenting steps in your improvement projects like voice of the customer, project charter, countermeasures, SIPOC, A3 report, etc.

Learn More about the Lean Six Sigma Tools and Templates

To perform statistical tests like ANOVA, regression, f-tests, t-tests, etc.

Click and drag over your data to select it.
Click on the QI Macros Menu and select the statistical test you want to perform or the Stat Wizard.
Answer the prompts for level of significance, etc.
QI Macros will perform all of the calculations and interpret the results for you.