Free Excel Tips and QI Macros Articles

QI Macros and Excel Tips
home · products · services · search · view cart · contact

NAVIGATION

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 work with companies
that want to fire up their profits using
Lean Six Sigma

QI Macros Lessons
QI Macros Trial Lessons
QI Macros and Excel Tips
Lean Six Sigma Lessons and Articles
Technical Support
Tools Table with links to explanation of each chart (click here)!
Sign Up for Free Webinars
Watch QI Macros Videos
Other Free QI Macros Training Resources

QI Macros Lessons

For Users

QI Macros Trial Overview

For Those Evaluating the QI Macros

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

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

Download the QI Macros Business Case Calculator

QI Macros and Excel Articles

Control Charts	Control Chart Templates
Add Target or Goal Lines to Control Charts Change Control Chart Stability Rules Choosing the Right Control Chart Comparative Control Charts 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 Stability Analysis Rules	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
Control Chart Menu Functions	Control Chart Menu Functions on Templates
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 Show/Hide 1-2 Sigma Lines (June 2011)	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
Histograms and Capability Analysis	Miscellaneous Charts and Analysis
Cp Cpk Template Histograms - Changing number of bars and X axis formatting. Histograms - Common Errors Stability Analysis vs Capability Analysis Relationship between Process Capability and Stability 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 Multiple Pareto Charts Pareto Chart Analysis Pareto Charts of Text Data Pareto Charts vs Mosaic Charts Time Between Charts Tools for Labs - Levey Jenning Chart and Youden Plot Variation Charts
Design for Six Sigma	Measurement System Analysis
Design of Experiments DOE DOE Two Factors at Three Levels Using ANOVA Failure Mode and Effects Analysis FMEA Quality Function Deployment QFD House of Quality	Measurement System Analysis MSA Gage R&R Study Attribute Gage R&R Study 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?
Data Analysis	Data Presentation Tips
Analyze Text using Word Count and Cross Tab Case Study - Choosing the Right Chart to Analyze Your Data Data Analysis 101 How to Organize Your Data in Excel Pivot Tables - Is There an Improvement Project Lurking in Your Data? Text Mining in Excel What Do I Do With My 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
Statistical Tools
Anova One Way Anova Two Way Without Replication Anova Two Way With Replication Chi-square Contingency Table Chi-square Goodness of Fit Correlation Covariance Descriptive Statistics Exponential smoothing Fisher Exact Test Hypothesis testing f-Test two sample for variances Levene's Test for non-normal variances Moving average Multiple Regression Analysis	NonParametric Tukey Quick Test Normality Test Proportions Hypothesis testing Test of a Proportion Test of Two Proportions Rank and percentile Regression Analysis Sample Size Calculator t-test One Sample t-test Two-Sample assuming equal variances t-test Two-Sample assuming unequal variances t-test Paired Two-Sample for Means Tukey Quick Test z-test two sample
Excel Functions	Case Studies
Excel's Autofilter Function Excel's Custom Fill Series Excel's Conditional Formatting to Create a Hospital Bed Management System Excel's Data Validation Functions and Features Excel Drawing Toolbar and Select Objects - Excel 2003 vs Excel 2007 & 2010 Excel's Drawing Toolbar and Chart Formatting Tips - Use Excel to Create an Improvement Story Excel Formulas Excel's Text to Columns and Concatenate Functions to Separate and Combine Data into cells Excel's Tables -Running Charts on Data in Tables Excel 2007 Ribbon Interface Switch Ribbon Menus (2007-2010 to 2003) Merge Worksheets or Workbooks Using VLookup or Offset and Match Functions Office and Excel 2007-2010 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
QI Macros Training Resources	QI Macros Other Info
Free One Hour Webinars QI Macros Help File QI Macros User Guide QI Macros Video Tour QI Macros One Day Workshop QI Macros You Tube Channel	Announcing QI Macros 2007 Change Default Language Data Format and Selection Tips QI Macros FAQs QI Macros Tech Support Real Time SPC for Excel Switch Between the 2003 Classic Pull Down Menu and the 2007 Ribbon Menu QI Macros SPC Software for Mac computers

The QI Macros SPC Software for Excel has Five Parts and Numerous Wizards to Assist With Your Data Analysis:

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. If you are not sure, select the Chart Wizard to run various charts on your data or the Control Chart Wizard to select the right control chart.
Over 90 Fill-in-the-blank templates and tools including fishbones, FMEA, DOE, Gage R&R, PPAP forms and more.
Statistical tools including Anova, f-test, t-test, regression, data normality test, sample size calculator and more. Select your data and click on the Statistics Wizard to run the most common statistical tests for your data.
Data Transformation Tools to help organize and analyze your data including stack and restack. Includes WordCount and PivotTable Wizards to help you summarize and organize your data.
Automated Control Chart Dashboards - just drop your data into these pre-formatted templates.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

	Macintosh	PC
QI Macros - One License Per Computer - Download Now and Get Backup CD & User Guide (#230) in 1-3 days - $199 + S&H
QI Macros - One License Per Computer - Download Only - No Shipping or Customs Duties (#W230) $199

Download
QI Macros
30-Day Trial Now!

QI Macros and Excel Tips

QI Macros and Excel Articles

The QI Macros SPC Software for Excel has Five Parts and Numerous Wizards to Assist With Your Data Analysis: