Are you missing some of the biggest cost-reducing improvements
in your company because you aren't quite sure how to analyze the
volumes of data available? You are if you don't know how to use
Excel's PivotTables to find the million dollar improvement projects
lurking in your data.
PivotTables (a.k.a. crosstab) are one of the most underused and
overlooked tools in the Green Belt and Black Belt toolkit.
Over the years, I realized, that I have used PivotTables on every
million dollar improvement project:
-
Saved $20 million in postage expense
-
Save $16 million in adjustment costs
-
Reduced order errors in a wireless phone company
from 17% to 3% in just four months saving $250,000 a month in
rework.
-
Reduced denied insurance claims in a healthcare
system that saved $330,000 a month with simple process changes
that could be implemented immediately.
What
Are PivotTables?
PivotTables can take up to 65,000 rows of line-by-line transaction
data and:
- Count the occurrences of a keyword, phrase or number
- Sum or Average Numbers
- Turn Raw Data Into Knowledge
- Help Drill Down into Mounds of Data
This kind of analysis is almost impossible to do by hand, but PivotTables
can do it in seconds.
Once summarized, it's easy to draw control charts, pareto charts
and other charts from the PivotTable.
Isn't
It Time You Learned How To Use PivotTables?
 I've
created a one-hour video that shows you, step-by-step, how to
identify Million Dollar Six Sigma improvement projects using Excel
PivotTables and the QI Macros.
In this video, you’ll learn how to:
-
Identify the kind of data to analyze with PivotTables
-
Use PivotTables to summarize your data
-
Use the QI Macros to generate the control charts,
pareto charts and fishbone diagrams needed for your Million
Dollar Improvement stories.
The video includes several examples from healthcare and manufacturing.
The
Cost? $97 + S&H
Even if your company's revenues are only a million dollars, there
are still projects worth $50,000 or more. The bigger the company,
the more million dollar improvement projects are waiting to be
found.
|
view cart · contact 
view cart | contact