Videos to Help You Get Started
With The QI Macros
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.
QI Macros Overview
Watch an overview of the QI Macros. The QI Macros SPC Software for Excel has five parts and numerous wizards to assist with your data analysis:
30 Chart Macros
To create a chart using the QI Macros simply click and drag over your data and then select the chart you want to create from the QI Macros menu. Here are some videos of sample charts. See how easy it can be to create these Six Sigma charts in Excel using the QI Macros:
-
Watch Now
Watch Now
Watch Now -
Watch Now -
Box Whisker Plot - Watch Now
Watch Now- Overview video showing how to create various SPC charts using macros from the QI Macros menu
Templates
Fill-in-the-Blanks-Templates, 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 for your six sigma needs. Watch a video of:
-
Lean Six Sigma Templates Overview video -
Watch Now
Watch MSA Gage R&R Now -
Design of Experiments (DOE) Template
Anova and Analysis Tools
The QI Macros also includes easy to use 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 a video of:
- Statistical Tools Overview video
- ANOVA Single Factor - Analysis of Variance
- Data Normality Test
Data Transformation Tools
Watch a video of:
Pivot Table Wizard - the easy way to do PivotTables
Word Count Wizard - an easy way to analyze call center notes
Stack and Restack - simple tools for reorganizing data
Control Chart Dashboards
- Control Chart Dashboard Tutorial - to simplify monthly reporting with control charts
See our QI Macros You Tube Channel for more Videos






Watch QI Macros Overview video

