Vista normal Vista MARC Vista ISBD

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

por Arthur, Jay [author.].
Tipo de material: materialTypeLabelLibroNúmero de ubicación: 658.4013 Editor: Chicago, Ill. : McGraw-Hill Education LLC., c2014Descripción: xvi, 190 p. : ill.ISBN: 9780071822831 (print); 0071822836 (print).Materia(s): Microsoft Excel (Computer file) | Electronic spreadsheets -- Computer programs | Quality control -- Data processing | Six sigma (Quality control standard) -- Computer programsRecursos en línea: Haga clic aquí para acceso en linea Also issued in print and PDF version.
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.
    valoración media: 0.0 (0 votos)
Tipo de ítem Ubicación actual Colección Signatura topográfica Estado Fecha de vencimiento
Recurso Electrónico Recurso Electrónico Biblioteca Fundación Área Andina - Medellín
Colección digital Disponible
Recurso Electrónico Recurso Electrónico Biblioteca Fundación Área Andina - Pereira
Colección digital Disponible
Recurso Electrónico Recurso Electrónico Biblioteca Fundación Área Andina - Valledupar
Colección digital Disponible
Recurso Electrónico Recurso Electrónico Biblioteca General Fundación Área Andina - Bogotá
Colección digital Disponible

Includes bibliographical references and indexes.

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.

Also issued in print and PDF version.

Description based on cover image and table of contents, viewed on July 24, 2014.


Fundación Universitaria del Área Andina
Sede Principal Bogotá: Cra 14A No.70A-34. Sede Administrativa Bogotá: Calle 71 No.13-21. PBX.: (57+1) 7424218. (57+1) 7423931. EXT. 1208, 1206, 1205.
Seccional Pereira: Calle 24 No. 8-55. PBX.: (57+6) 3255992. Sede Medellín: Calle 34A No. 77-08, Barrio Laureles. PBX.: (57+4) 2505651 - (57+4) 2503401
Sede Valledupar: Transv. 22 Bis No. 4-105, Av. Circunvalar - Sector Callejas. PBX.: (57+5) 5894093
Línea de atención al aspirante en Bogotá: (57+1) 7449191. Línea gratuita nacional: 018000 180099