Breakthrough Improvements Using QI Macros add-in and Excel

The Long Suppressed SECRET to Maximizing Profits

Every company wastes one-third of total revenues:

• Fixing stuff that shouldn't need fixing (rework)
• Throwing stuff away that can't be fixed (waste)
• Doing stuff that no one wants (waste)

3:33

Excel PivotTables are the Secret for Finding Hidden Riches in Any Business!

Breakthrough Improvement eliminates waste and rework. It's easy using Excel and QI Macros.

Preface - Book Introduction by Jay Arthur

Download Quick Reference PDF

Videos by Chapter

Chapter 1: Spreadsheet Design for Breakthrough Improvement

How to Format Excel Data for Charting

6:55

Excel Tips

5 Essential Microsoft Excel Skills Every Quality Improvement Professional Should Learn

Biggest Mistakes Everyone Makes in Excel Spreadsheets

Biggest Mistakes Everyone Makes with Excel Charts

Chapter 2: Excel Formulas for Breakthrough Improvement

Excel Formulas

8:37

Excel Text Formulas

4:33

Chapter 4: The Magnificent Seven Tools for Breakthrough Improvement

The Magnificent Seven Tools

Chapter 5: Follow the Money for Breakthrough Improvement

Healthcare Denied Claims Case Study

7:23

False Fire Alarms Case Study

7:43

Chapter 6: Where's the Pain?

Service Order Errors Example

6:55

Pareto Charts

1:50

Fishbone Diagrams

1:37

Chapter 8: Excel Power Tools for Breakthrough Improvement

Reducing Defects

4:40

Reducing Variation

4:13

Checklist for Data Collection

3:22

Countermeasures Matrix

3:24

Chapter 9: Breakthrough Improvement Using Excel

Pivottable Overview

26:56

Packaging Defects Example

8:36

Denied Claims Example

8:23

Emergency Room Example

7:49

ICU Medications Example

6:42

Pivottable Exercises

Install QI Macros 30-day trial. Open pivottable.xlsx sample data under QI Macros Help tab on far right of menu. Create a Pivottable and:

1. Use Control Charts to show defects or costs over time.
2. Use Pareto Charts to narrow the focus.
3. In the PivotTable, double click on a Total for the "big" bar on the pareto to "drill down". Can you do another level of pareto?
4. Insert a Fishbone diagram into the sheet.
5. Modify the problem statement to reflect the "big bar" on the pareto chart.

Each of the three sheets should have a control chart, pareto chart and fishbone diagram.

Chapter 10: Sustaining Breakthrough Improvement | Chap 11: Excel Drawing Tools

Control Charts

4:28

Histograms

2:24

Capability Analysis

1:7

Wafer Strength Example

4:12

Auto Diameters Example

2:35

Flowcharts

2:33