Breakthrough Improvement with QI Macros and Excel: Finding the Invisible Low-Hanging Fruit (eBook)

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 www.qimacros.com/breakthrough. Links to YouTube videos for each chapter of the book can be found at www.breakthrough-improvement-excel.com 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