Limit search to available items
Book Cover
Author Arthur, Jay, 1951- author.

Title Breakthrough improvement with QI macros and Excel : finding the invisible low-hanging fruit / Jay Arthur
Published New York : McGraw-Hill Education, [2014]
Online access available from:
AccessEngineering    View Resource Record  


Description 1 online resource (xvi, 190 pages) : illustrations
Contents 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
Summary 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 focuses on using Excel, one of the most widely used software packages, to drive improvement--no need to rely on expensive training in a new methodology. Free video training and a 90-day trial version of QI Macros for Excel can be found at Links to YouTube videos for each chapter of the book can be found at The combination of the book, software, and video training will provide you with the tools you need to eliminate the three silent killers of productivity: delay, defects, and deviation. You'll make and sustain breakthrough improvements that will catapult your business ahead of the competition. LEARN HOW TO:Design well-organized spreadsheets for breakthrough improvementUse Excel formulas to prepare data for charting or analysisReduce data to a manageable size using Excel's built-in functionsMaster the Magnificent Seven Tools of Breakthrough Improvement--value-stream maps and spaghetti diagrams, PivotTables, control charts, Pareto charts, histograms, fishbone diagrams, and matrix diagramsFollow the money to identify and plug leaks in your cash flowIdentify and eliminate defects, mistakes, and errors in your processesTransform your data into visually stunning shortcuts to decisions, actions, productivity, and profitsConsolidate data into well-designed Excel charts to quickly communicate performance trendsMaximize QI Macros for Excel power tools to analyze and graph dataFind invisible low-hanging fruit using PivotTablesSustain breakthrough improvement with control charts, histograms, and dashboardsUse statistical tools, including hypothesis testing, analysis of variance, and regression analysis
"Breakthrough 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 focuses on using Excel, one of the most widely used software packages, to drive improvement-no need to rely on expensive training in a new methodology."
Bibliography Includes bibliographical references (pages 175-177) and index
Notes English
Print version record
Subject Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Electronic spreadsheets -- Computer programs.
Six sigma (Quality control standard) -- Computer programs
Business & Economics.
Electronic spreadsheets -- Computer programs.
Marketing & Sales.
Form Electronic book
LC no. 2014453056
ISBN 0071822127