Breakthrough Improvement With Microsoft Excel

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 training 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

Jay Arthur, The KnowWare Man, works with companies that want to fire up their profits using Lean Six Sigma. He is the author of Lean Six Sigma Demystified and the QI Macros SPC software for Excel which is used by over 3,000 hospitals to meet the accreditation needs of the Joint Commission. Jay has worked with Tenet Healthcare, Kindred Healthcare, Centura Healthcare, and Christus Healthcare on projects to improve patient flow and to reduce clinical and operational errors. Besides consulting with healthcare companies, Jay has been researching what works and what doesn't work in healthcare for over a decade.