Quality Improvement Tools
Also known as quality management tools, quality assurance template, or 7 Basic Tools of Quality
The Seven Basic Quality Tools
Root Cause Analysis
aka Cause and Effect Diagram, Ishikawa Fishbone Diagram
Your Root Cause Analysis template (RootCause.xlsx)
makes it easy to:
- Quickly record people's ideas as fast as they can generate them
with "handwriting" that everyone can read
- Keep asking "why?" until you begin to
arrive at the root causes for your problem
so you can "dig out the roots" instead of "hacking at the leaves"
- Easily re-arrange ideas into logical groups — spawning even better ideas
And when the cause and effect analysis session is over,
everyone (including the leader) can get right back to work
because everything is perfectly organized in your Excel fishbone diagram,
ready to email to all team members, and to store electronically for future reference.
Use your Check Sheet template (CheckSheet.xlsx)
to gather data when it happens where it happens
using hand written hash check marks.
Once your data is gathered -
you will usually want to summarize and analyze it
using your Trends Scorecard (Trends.xlsx)
which is designed to be very easily personalized
using everything you know about familiar Microsoft Excel.
Use your Pareto Chart template (Pareto.xlsx)
to identify the 20% of problems causing 80% of your headaches —
so you know where to focus your continuous improvement efforts.
Easily enter or import either horizontal or vertical data.
Simply click the Copy Chart button to copy a picture of your chart to the clipboard
where it can then be easily pasted to ANY other type of document.
(such as Word, PowerPoint, Visio, etc.)
Run Chart / Trend Chart / Control Chart
Your Control Chart template (ControlChart..xlsx)
allows you to choose between 3 special types of run chart,
that you use to determine whether a process is in a stable state of control.
An unstable process that is statistically out of control will exhibit patterns of variation -
which will be highlighted in red — to be investigated for possible 'special causes' —
which should be systematically eliminated — so that the process becomes more and more stable.
XY Scatter Plot
Use a Scatter Diagram to analyze the relationship between
two sets of data.
For example, the relationship between the inputs to a process
and the resulting outputs from that process.
One common use of a scatter diagram is the Stratification Diagram
to make patterns visible when data is coming from a wide variety
See our free online training for how to create a scatter diagram,
using just standard Excel.
Use a histogram to graphically illustrate the probability distribution
of something happening.
See our free online training for how to create a histogram
using the free Data Analysis Toolpak,
as well as another free download that is better for creating
histograms from data that is continuous, rather than discrete.
Your Systems2win templates empower you with
several different types of flow chart templates, including:
- a simple flowchart to graphically illustrate "who does what"
and what decisions to make along the way
- a cross-functional flowchart that has pre-programmed math
to answer the most common questions for process improvement
- many more types of flowcharts that you will find useful for specific challenges that you are likely to encounter as you progress on your Lean Journey
Additional Quality Improvement Tools
In addition to the seven basic tools of quality,
Use your Tool Selection Matrix (1ToolSelection.xlsx)
to see all 150+ tools,
and to use Excel's powerful Filter features
to select the right tool for whatever you need to do next
If your organization has not yet provided you with a license,
you can download your free trial now
Standardized Quality Management Tools
As soon as you complete the New User Training,
you will know how to use many features that are common to every one of your 150+ Systems2win templates.
You will leverage the value you squeeze from your quality improvement tools
- by becoming a whole lot more competent with familiar Microsoft Excel
- by becoming familiar with the many ways that your Systems2win add-ins extend the power of Excel
Empower every one of your team members
for a very affordable price
Call toll free