QI Macros and Excel Tips

© 2007 KnowWare International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224

Jay Arthur
888-468-1537
303-756-9144
Email Us

We help people think!

• QI Macros Lessons
• QI Macros and Excel Tips
• QI Macros Trial Lessons
• Design for Six Sigma
• AIAG Measurement System Analysis
• Six Sigma Tools
• Other Resources

QI Macros Lessons

1. Installation Tips
2. Tips for Creating Charts
3. Chart Templates and Other Tools
4. Control Charts and Histograms for Stability and Capability Analysis
5. Other Advanced Features and Tips
6. Anova and Other Statistical Analysis Tools
7. Measurement System Analysis - Gage R&R
8. Choosing the Right Control Chart
9. Control Chart Limits
10. Histograms
11. Data Transformation Tools
12. Pareto Charts

QI Macros and Excel Tips

• Announcing QI Macros 2007
• Analyze Text using Word Count and Cross Tab
• Applications for QI Macros Templates
• Automatically Create Control Charts using Control Chart Templates
• Case Study - Choosing the Right Chart to Analyze Your Data
• Chart Junk
• Choosing the Right Control Chart
• Control Chart Limit Calculations
• Control Chart Rules
• Custom Fill Series
• Comparing Data using the QI Macros
• Conditional Formatting to Create a Hospital Bed Management System
• Cusum and EWMA Charts for Detecting Small Shifts in Process
• Data Analysis 101
• Data Normality Test
• Data Transformation Tools - stack, unstack, get sample, etc.
• Drawing Toolbar and Chart Formatting Tips - Use Excel to Create an Improvement Story
• Excel's Autofilter Function
• Excel 2007 Ribbon Interface
• Formatting Your Data Before You Run a Chart
• Format Charts - Tips for Formatting Charts
• Gen Table Macro restacks one column of data into rows and columns
• Graphical Excellence
• Histograms - QI Macros purchased before Jan 2007
• Histograms - QI Macros purchased after Jan 2007
• Manufacturing Scrap Improvement Story
• Quality Magazine Jan 2005 Brain Teaser
• Office and Excel 2007
• Pivot Tables - Is There an Improvement Project Lurking in Your Data?
• QI Macros Help File
• Real Time SPC for Excel
• SPC Case Study - Analyzing Different Machines
• Tell Us What You Want
• Time Tracking with Excel to Reduce Cycle Time such as Patient Length of Stay (LOS)
• Visual Presentation of Data

QI Macros Trial Overview Lessons

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
7. Real Time SPC

Design for Six Sigma

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

  AIAG Measurement System Analysis

• AIAG Measurement System Analysis MSA Gage R&R
• Gage R&R Bias and Linearity
• Gage R&R Destructive Testing

Six Sigma Tools

• How to Choose Six Sigma Charts
• Box and Whisker Plot
• Choosing the Right Control Charts
• Control Charts
• DOE Software
• Excel add ins
• Excel macros
• Excel templates
• Flow Chart
• Gantt Chart
• Histogram with Cp and Cpk
• Ishikawa Fishbone Diagram
• Line Graph
• Pareto Chart
• PPAP Forms
• Run Chart
• Scatter Plot Matrix
• Scatter Plot Diagram
• Sample Size Calculator
• Six Sigma Software
• SPC Charts
• SPC Chart
• Statistical Process Control Software

Other Lean Six Sigma Resources

• Lean Six Sigma and Lean Thinking
• Six Sigma Articles
• Six Sigma How to Articles
• Application of Six Sigma in Various Industries
• Six Sigma Pitfalls
  

  QI Macros 30-day Trial & FREE QI Macros Course
  Name:
  E-mail
  	How did you hear about us? Friend/Co-Worker Google Yahoo! Lean Six Sigma Demystified AIAG ASQ Conference Consultant Direct Mail Email/Ezine Harrington IHI iSixSigma Magazine Microridge NAHQ Other Web Search QI Macros 30day Demo Quality Expo Quality Digest Quality Magazine Quality Progress Seminar/Training

  
  Or Buy It Now!
  Unconditional
  90-Day
  Money-Back
  Guarantee
  

  The QI Macros for Excel $139, is an inexpensive easy to use set of Excel add-ins for statistical process control and Lean Six Sigma. It draws line, pie, bar, pareto, box whisker, histogram (Cp, Cpk), scatter and control charts (with stability analysis).

  It contains over 70 fill in the blank templates such as the Ishikawa diagram, QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test, and regression analysis.

  
  

  Quantity Discounts

  Customer Testimonials

  Minitab Comparison

  QI Macros FAQs

  FREE Lean Six Sigma Course & QI Macros 30-day Trial
  Name:
  E-mail
  	How did you hear about us? Friend/Co-Worker Google Yahoo! Lean Six Sigma Demystified AIAG ASQ Conference Consultant Direct Mail Email/Ezine Harrington IHI iSixSigma Magazine Microridge NAHQ Other Web Search QI Macros 30day Demo Quality Expo Quality Digest Quality Magazine Quality Progress Seminar/Training

  
  

© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home | Lean Six Sigma | QI Macros | KnowWare | Site Map

Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee

It contains over 70 fill in the blank templates such as the Ishikawa diagram, QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test, and regression analysis.

Quantity Discounts

Customer Testimonials

Minitab Comparison

QI Macros FAQs