<h4>Best practices for using Excel and QI Macros to achieve breakthrough improvements in speed, quality, productivity, and profitability</h4><p><i>Breakthrough Improvement with QI Macros and Excel: Finding the Invisible Low-Hanging Fruit </i> reveals proven techniques for identifying and analyzing data that will lead to immediate results in improvement. Video training and software are included:<ul><li>EZ Chart XL—an Excel addin to simplify Excel charts<li>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. <li>YouTube training videos for EZChartXL, QI Macros and "Money Belt" improvement linked to each chapter</ul></p><p>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. <p>Coverage includes:<ul><li><b>Spreadsheets</b>: Spreadsheet Design for Breakthrough Improvement * Data Collection for Breakthrough Improvement * Mistake-Proof Data Collection <li><b>Data Analysis</b>: 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 <li><b>Follow the Money for Breakthrough Improvement</b>: 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 <li><b>Where's the Pain</b>: Delay, Defects and Deviation * Defects, Mistakes and Errors * Deviation from Perfection <li><b>A Picture is Worth 1,000 Words</b>: Excel Charts * Time Series Charts * Category Charts * Dot Charts <li><b>Excel Power Tools for Breakthrough Improvement</b>: EZ Chart Introduction * QI Macro Introduction * Power Tools for Lean Six Sigma * Analyzing Customer Service Data Hidden in Trouble Reporting Systems * Chartjunk <li><b>Finding the Invisible Low Hanging Fruit</b>: PivotTables * Data Mining with Microsoft Excel and The QI Macros PivotTable Wizard * Word Count * PivotTable Wizard * Using the QI Macros to Analyze Your Data <li><b>Sustaining Improvement</b>: Process Flow Chart * Control Charts for Sustaining Improvement Control Plan <li><b>Excel Drawing Tools for Breakthrough Improvement Lean Tools</b> <li><b>Statistical Tools for Breakthrough Improvement</b>: 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