Page 144 - Lean six sigma demystified

Chapter 4 e xC e L Power Too LS for Lean Six Sigm a 123

FIGURE 4-22 • Creating custom error messages.

FIGURE 4-23 • Error message example.

Excel’s Data Validation functions will train users to enter data correctly.
Users can spend days in training, or Excel can just force them to learn the
right way to enter data. Using Excel is faster and more effective.
Mistake-proof your data collection. It’s just this easy.

QI Macros Introduction

There are many graphs, forms, and tools used in Lean Six Sigma and SPC. There
are four key elements of the QI Macros: macros, templates, statistics, and data
manipulation.
Ninety percent of common problems can be diagnosed with control
charts, histograms, Pareto charts, and Ishikawa diagrams. Control charts will