QI Macros and Excel Tips

These lessons provide an overview plus links to detailed "how to" articles and videos for QI Macros users.

1. Installation and Overview
2. Create Charts with Macros
3. Fill in the Blank Templates
4. ANOVA and Statistical Analysis Tools
5. Data Transformation Tools
6. Dashboards and Scorecards

These lessons provide a high level overview with links to videos for those evaluating the QI Macros.

1. Installation and Overview
2. Create Charts with Macros
3. Fill in the Blank Templates
4. ANOVA and Statistical Analysis Tools
5. Data Transformation Tools
6. Dashboards and Scorecards

• Add Target or Goal Lines to Control Charts
• Change Control Chart Stability Rules
• Choosing the Right Control Chart
• Control Chart Dashboards
• Control Chart Limit Calculations
• Control Chart Rules Menu
• p chart and u chart format options
• Show/Don't Show 1 & 2 Sigma Lines

• Automatically Create Control Charts using Control Chart Templates
• Complete List of Control Chart Templates
• Control Chart Templates for Rolling Data
• Control Chart Templates with Center Line Based on the Median
• Control Chart Templates with Fixed Control Limits
• Short Run Control Chart

• Add Data to Control Charts
• Remove (Ghost) Point from Control Chart Calculations
• Delete a Point from Control Chart
• Add Text to Data Point
• Show Process Change on Control Chart
• Analyze Stability with Control Chart Rules

• Add Data to Control Charts
• Remove (Ghost) Point from Control Chart Calculations
• Delete a Point from Control Chart
• Add Text to Data Point
• Show Process Change on Control Chart
• Analyze Stability with Control Chart Rules

• Cp Cpk Template
• Histograms - QI Macros purchased before Jan 2007
• Histograms - QI Macros purchased after Jan 2007
• Histograms - Common Errors
• Stability Analysis vs Capability Analysis

• Analyzing Data With More Than One Variable
• Applications for QI Macros Templates
• Comparing Data using the QI Macros
• Cusum and EWMA Charts for Detecting Small Shifts in Process
• Gap Analysis using the Transition Matrix
• Pareto Charts
• Time Between Charts
• Tools for Labs - Levey Jenning Chart and Youden Plot
• Variation Charts

• Design of Experiments DOE
• Failure Mode and Effects Analysis FMEA
• Quality Function Deployment QFD House of Quality

• AIAG Measurement System Analysis MSA Gage R&R
• Gage R&R Bias and Linearity
• Gage R&R Destructive Testing
• Measurement Variation - Gage RR
• Gage R&R Example: If My Parts Are So Good, Why is My Gage R&R So Bad?

• Analyze Text using Word Count and Cross Tab
• Case Study - Choosing the Right Chart to Analyze Your Data
• Data Analysis 101
• Pivot Tables - Is There an Improvement Project Lurking in Your Data?

• Chart Junk
• Data Display Tips Using Airline Quality Data
• Format Charts - Tips for Formatting Charts
• Formatting Your Data Before You Run a Chart
• Graphical Excellence
• Project Reporting Tips - Do You Really Need Powerpoint?
• Say It With Charts
• Visual Presentation of Data

• Custom Fill Series
• Conditional Formatting to Create a Hospital Bed Management System
• Drawing Toolbar and Chart Formatting Tips - Use Excel to Create an Improvement Story
• Excel's Autofilter Function
• Excel 2007 Ribbon Interface
• Office and Excel 2007
• Time Tracking with Excel to Reduce Cycle Time such as Patient Length of Stay (LOS)

• Choosing the Right Chart - Case Study
• Manufacturing Scrap Improvement Story
• Mail House Six Sigma Case Study
• Mail Order Fulfillment Case Study pdf
• Quality Magazine Jan 2005 Brain Teaser
• SPC Case Study - Analyzing Different Machines

• Free One Hour Webinars
• QI Macros Help File
• QI Macros User Guide
• QI Macros Video Tour

• Announcing QI Macros 2007
• Change Default Language
• Data Format and Selection Tips
• QI Macros FAQs
• QI Macros Tech Support
• Real Time SPC for Excel