Search -
Breakthrough Improvement with QI Macros and Excel: Finding the Invisible Low-Hanging Fruit
Breakthrough Improvement with QI Macros and Excel Finding the Invisible Low-Hanging Fruit Author:Jay Arthur Best practices for using Excel and QI Macros to achieve breakthrough improvements in speed, quality, productivity, and profitability 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 in improvement. Video tra... more »ining and software are included: EZ Chart XL?an Excel addin to simplify Excel charts QI Macros for Excel?extends the capabilities in EZ Chart to include control charts, pareto charts, histograms, process mapping, and much more. 90-day trial version available for download. YouTube training videos for EZChartXL, QI Macros and "Money Belt" improvement linked to each chapter This practical guide focuses on one of the most widely used software packages (Excel) to drive improvement?there?s no need to rely on expensive training in a new methodology. The combination of the book, software, and video training will provide you with the skills you need to solve the three key problems facing every business: delay, defects and deviation. Coverage includes: Spreadsheets: Spreadsheet Design for Breakthrough Improvement * Data Collection for Breakthrough Improvement * Mistake-Proof Data Collection Data Analysis: Filtering Data for Breakthrough * Excel Tools For Data Analysis Magnificent Seven Tools for Breakthrough Improvement: Value Stream Map & Spaghetti Diagram * PivotTables * Control Chart * Pareto Chart * Histogram * Fishbone Diagram * Matrix Diagrams Follow the Money for Breakthrough Improvement: Faster + Better = Cheaper and More Profitable! * Reducing Denied Claims In Five Days * Reducing Reject Claims in Five Days * Reducing Appealed Claims in Five Days * How to Get a Cheaper Hospital in Five Days Where's the Pain: Delay, Defects and Deviation * Defects, Mistakes and Errors * Deviation from Perfection A Picture is Worth 1,000 Words: Excel Charts * Time Series Charts * Category Charts * Dot Charts Excel Power Tools for Breakthrough Improvement: EZ Chart Introduction * QI Macro Introduction * Power Tools for Lean Six Sigma * Analyzing Customer Service Data Hidden in Trouble Reporting Systems * Chartjunk Finding the Invisible Low Hanging Fruit: PivotTables * Data Mining with Microsoft Excel and The QI Macros PivotTable Wizard * Word Count * PivotTable Wizard * Using the QI Macros to Analyze Your Data Sustaining Improvement: Process Flow Chart * Control Charts for Sustaining Improvement Control Plan Excel Drawing Tools for Breakthrough Improvement Lean Tools Statistical Tools for Breakthrough Improvement: Hypothesis Testing * Hypothesis Testing for Variation * Hypothesis Testing for Means * Analysis of Variance * Is Your Data Normal? * Tests of Proportion * Chi Square Tests in Excel * Determining Sample Sizes * Regression Analysis« less