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

by Jay Arthur
     
 

View All Available Formats & Editions

Maximize speed, quality, productivity, and profits with QI Macros for Excel

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

…  See more details below

Overview

Maximize speed, quality, productivity, and profits with QI Macros for Excel

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.

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 improvement
  • Use Excel formulas to prepare data for charting or analysis
  • Reduce data to a manageable size using Excel's built-in functions
  • Master the Magnificent Seven Tools of Breakthrough Improvement--value-stream maps and spaghetti diagrams, PivotTables, control charts, Pareto charts, histograms,
    fishbone diagrams, and matrix diagrams
  • Follow the money to identify and plug leaks in your cash flow
  • Identify and eliminate defects, mistakes, and errors in your processes
  • Transform your data into visually stunning shortcuts to decisions, actions, productivity, and profits
  • Consolidate data into well-designed Excel charts to quickly communicate performance trends
  • Maximize QI Macros for Excel power tools to analyze and graph data
  • Find invisible low-hanging fruit using PivotTables
  • Sustain breakthrough improvement with control charts, histograms, and dashboards
  • Use statistical tools, including hypothesis testing, analysis of variance, and regression analysis

Product Details

ISBN-13:
9780071822831
Publisher:
McGraw-Hill Professional Publishing
Publication date:
03/14/2014
Pages:
208
Product dimensions:
8.80(w) x 5.90(h) x 0.40(d)

Meet the Author

Jay Arthur, The KnowWare Man, teaches individuals and organizations how to solve problems involving delay, defects, and deviation in one day using Excel and the QI Macros. He is the author of Lean Six Sigma Demystified and Lean Six Sigma for Hospitals. Mr. Arthur also created the QI Macros SPC software for Excel which is used by more than 3,000 hospitals. Using the Magnificent Seven Tools, he helped one hospital system save $5 million a year in denied charges and a telecom company save $3 million a year caused by order errors.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >