Breakthrough Improvement with Qi Macros and Excel: Finding the Invisible Low-Hanging Fruit

4.33 avg rating
( 3 ratings by GoodReads )
 
9780071822831: Breakthrough Improvement with Qi Macros and Excel: Finding the Invisible Low-Hanging Fruit

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

"synopsis" may belong to another edition of this title.

About 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.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Arthur Jay
Published by McGraw-Hill Education (2014)
ISBN 10: 0071822836 ISBN 13: 9780071822831
New Paperback Quantity Available: 4
Seller
Arroway Books
(Narberth, PA, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2014. Paperback. Book Condition: New. Brand New and Unused. Bookseller Inventory # 130529

More Information About This Seller | Ask Bookseller a Question

Buy New
5.78
Convert Currency

Add to Basket

Shipping: 3.22
Within U.S.A.
Destination, Rates & Speeds

2.

Arthur Jay
ISBN 10: 0071822836 ISBN 13: 9780071822831
New Quantity Available: > 20
Seller
Jersey Shore Books
(Vineland, NJ, U.S.A.)
Rating
[?]

Book Description Book Condition: New. SHIPS DIRECTLY FROM AMAZON. New- great shape. Bookseller Inventory # 37O9AH001GAE

More Information About This Seller | Ask Bookseller a Question

Buy New
8.19
Convert Currency

Add to Basket

Shipping: 2.42
Within U.S.A.
Destination, Rates & Speeds

3.

Arthur Jay
Published by McGraw-Hill Professional (2014)
ISBN 10: 0071822836 ISBN 13: 9780071822831
New Softcover Quantity Available: 1
Seller
Book Deals
(Lewiston, NY, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Professional, 2014. Book Condition: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: Best practices for using Excel and QI Macros to achieve breakthrough improvements in speed, quality, productivity, and profitability. Bookseller Inventory # ABE_book_new_0071822836

More Information About This Seller | Ask Bookseller a Question

Buy New
10.67
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

Arthur Jay
ISBN 10: 0071822836 ISBN 13: 9780071822831
New Paperback Quantity Available: > 20
Seller
Marlton Books
(Rosenhayn, NJ, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. Book is brand new! Fast Shipping - Safe and Secure Bubble Mailer!. Bookseller Inventory # 38V9EM002LPS

More Information About This Seller | Ask Bookseller a Question

Buy New
7.48
Convert Currency

Add to Basket

Shipping: 3.23
Within U.S.A.
Destination, Rates & Speeds

5.

Arthur Jay
Published by McGraw-Hill Education 2014-03-11 (2014)
ISBN 10: 0071822836 ISBN 13: 9780071822831
New PAPERBACK Quantity Available: 3
Seller
The Book Cellar, LLC
(Nashua, NH, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education 2014-03-11, 2014. PAPERBACK. Book Condition: New. 0071822836 BRAND NEW. Over 1,000,000 satisfied customers since 1997! We ship daily M-F. Choose expedited shipping (if available) for much faster delivery. Delivery confirmation on all US orders. Bookseller Inventory # Z0071822836ZN

More Information About This Seller | Ask Bookseller a Question

Buy New
9.22
Convert Currency

Add to Basket

Shipping: 3.23
Within U.S.A.
Destination, Rates & Speeds

6.

Arthur Jay
ISBN 10: 0071822836 ISBN 13: 9780071822831
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97800718228311.0

More Information About This Seller | Ask Bookseller a Question

Buy New
13.49
Convert Currency

Add to Basket

Shipping: 3.22
Within U.S.A.
Destination, Rates & Speeds

7.

Arthur Jay
Published by McGraw-Hill Education (2014)
ISBN 10: 0071822836 ISBN 13: 9780071822831
New Quantity Available: > 20
Print on Demand
Seller
PBShop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2014. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # IQ-9780071822831

More Information About This Seller | Ask Bookseller a Question

Buy New
19.89
Convert Currency

Add to Basket

Shipping: 3.22
Within U.S.A.
Destination, Rates & Speeds

8.

Arthur Jay
Published by McGraw-Hill Education - Europe, United States (2014)
ISBN 10: 0071822836 ISBN 13: 9780071822831
New Paperback Quantity Available: 10
Print on Demand
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2014. Paperback. Book Condition: New. 231 x 155 mm. Language: English . Brand New Book ***** Print on Demand *****.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. Bookseller Inventory # APC9780071822831

More Information About This Seller | Ask Bookseller a Question

Buy New
25.29
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

9.

Arthur Jay
Published by McGraw-Hill Professional (2014)
ISBN 10: 0071822836 ISBN 13: 9780071822831
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Professional, 2014. Paperback. Book Condition: New. book. Bookseller Inventory # 0071822836

More Information About This Seller | Ask Bookseller a Question

Buy New
25.43
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

10.

Arthur Jay
Published by McGraw-Hill Education - Europe, United States (2014)
ISBN 10: 0071822836 ISBN 13: 9780071822831
New Paperback Quantity Available: 10
Print on Demand
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2014. Paperback. Book Condition: New. 231 x 155 mm. Language: English . Brand New Book ***** Print on Demand *****. 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. Bookseller Inventory # APC9780071822831

More Information About This Seller | Ask Bookseller a Question

Buy New
25.90
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book