Breakthrough improvement with QI macros and excel : finding the invisible low-hanging fruit /

Annotation Maximize speed, quality, productivity, and profits with QI Macros for ExcelBreakthrough Improvement with QI Macros and Excel: Finding the Invisible Low-Hanging Fruit reveals proven techniques for identifying and analyzing data that will lead to immediate results. This practical guide focu...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Arthur, Jay, 1951- (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York, N.Y. : McGraw-Hill Education, [2014]
Edición:First edition.
Colección:McGraw-Hill's AccessEngineering.
Temas:
Microsoft Excel (Computer file)
Electronic spreadsheets > Computer programs.
Quality control > Data processing.
Six sigma (Quality control standard) > Computer programs.
Electronic books.
Acceso en línea:Texto completo
Tabla de Contenidos:
  • A. About the author
  • B. Finding the invisible low-hanging fruit
  • Every picture tells a story
  • The goal
  • Problems you can solve with qi macros and excel
  • Good data, bad decisions
  • 1. Spreadsheet design for breakthrough improvement
  • Horizontal or vertical?
  • Defect tracking with microsoft excel
  • Warning: mistake-proof data collection
  • Data for service companies: defects and turnaround times
  • Time data
  • Summary
  • 2. Excel formulas for breakthrough improvement
  • Calculate ratios
  • Excel will guide you
  • Text formulas
  • Time and date formulas
  • Logic
  • Here's my point
  • 3. Filtering data for breakthrough improvement
  • Create subsets of your data using "autofilter"
  • Custom filters
  • Sort the data
  • Even huge spreadsheets can be manageable
  • 4. The magnificent seven tools for breakthrough improvement
  • The magnificent seven tools
  • 5. Follow the money for breakthrough improvement
  • The lesson is simple: follow the money!
  • Health care case study
  • Don't wait for storm season
  • Conclusion
  • 6. Where's the pain?
  • Where's the pain?
  • The dirty-30 process for breakthrough improvement
  • Common problems
  • Conclusion
  • 7. A picture is worth a thousand words
  • Say it with charts
  • Chart junk
  • Qi macros chart wizard
  • Here's my point
  • 8. Excel power tools for breakthrough improvement
  • Setting up your data in excel
  • Data collection and measurement
  • The qi macros for excel
  • The qi macros are easy to use
  • Qi macros introduction
  • Power tools for breakthrough improvement
  • Troubleshooting problems
  • Technical support
  • 9. Breakthrough improvement using microsoft excel
  • Data mining with excel
  • Qi macros pivottable wizard: the shortcut to breakthrough improvement
  • Breakthrough improvement projects
  • Small data analytics for breakthrough improvement
  • Lost time analysis
  • Get the idea?
  • 10. Sustaining breakthrough improvement
  • Quality and process indicators
  • Common and special causes
  • Choosing the right control chart for sustaining improvement
  • Stability analysis
  • Analyzing capability
  • Control plan
  • Qi macros for monitoring stability and capability
  • Summary
  • 11. Excel drawing tools for breakthrough improvement
  • Visual thinking for breakthrough improvement
  • Problem solving is a story told with pictures
  • Breakthrough improvements in speed
  • Breakthrough improvement exercises
  • 12. Hypothesis testing for breakthrough improvement
  • Hypothesis testing
  • Statistics with qi macros and excel
  • Chi-square tests in excel
  • Regression analysis
  • Conclusion
  • Exercises
  • A. Bibliography
  • B. Learning resources.

Ejemplares similares