Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Mastering the Seven Quality Tools (with Microsoft Excel)
Rating: 4.4 out of 5(2,397 ratings)
8,851 students

Mastering the Seven Quality Tools (with Microsoft Excel)

Master the Seven Quality Tools: Root Cause Analysis, Control Charts, Pareto, Decision Making and More Using Excel
Created byRay Harkins, The Manufacturing Academy
Last updated 5/2026
English

What you'll learn

  • Understand and apply the Seven Quality Tools
  • Learn the fundamental tools of problem solving and root cause analysis
  • The Scatter Plot, Histogram, Pareto Diagram, Control Chart, and much more
  • Essential elements of the Six Sigma Improvement Process
  • The Seven Quality Tools with Real World Applications
  • Linear Regression and Predictive Modeling in Excel using your Scatter Plot
  • Use Pivot Tables to Build Pareto Diagrams
  • A Useful Checklist Template called the "Containment Checklist"
  • Rapidly Build Flowcharts in Excel

Course content

2 sections • 30 lectures • 4h 18m total length

  • Introduction to The Seven Quality Tools6:33

    An introduction to the Seven Quality Tools course, and an overview of each of the tools.

  • Control Charts, Part 18:22

    An introduction to run charts and control charts; sample size; building an X-bar run chart.

  • Control Charts, Part 212:42

    Completing the run chart; Dependent and independent variables; Using the table of control chart constants.

  • Control Charts, Part 317:26

    Calculating and applying control limits; Building an R run chart.

  • Control Charts, Part 417:08

    Interpreting control chart trends including shifts, recurring patterns, lack of discrimination, truncation and others.

  • Pareto Diagrams10:54

    Building a Pareto diagram; the "80/20" rule; applications and interpretation of Pareto diagram results.

  • Checksheets4:53

    Applications of a checksheet; the checksheet as a foundation for the Pareto diagram and histogram.

  • Histograms, Part 19:15

    An introduction to the histogram as a graphical depiction of the frequency distribution of a data set.

  • Histograms, Part 211:04

    Building a histogram in Excel; Using a histogram for measurement data; Introduction to capability analysis; Introduction to using the histogram as an estimation of the probability distribution of a data set.

  • Histograms, Part 39:22

    Continued discussion of probability distributions; the Normal distribution, Discussion of bin size and quantity; Interpreting the histogram.

  • Cause and Effect Diagram7:43

    Building a cause and effect diagram; Introduction to root cause analysis; the 6 M's.

  • Flowcharts12:33

    Use of the flowchart in 6 sigma applications; meaning and use of specific flowchart symbols; Special types of flowcharts including the process flow diagram and swim lane diagram.

  • Scatterplots11:13

    Building and interpreting the scatterplot; Introduction to linear regression and correlation; Graphical examples of the range of correlation values.

  • Closing1:18
  • The Seven Quality Tools quiz

Requirements

  • Experience in the manufacturing or service industries
  • Desire to improve problem solving skills
  • Basic organizational skills
  • Some experience in Excel is helpful

Description

Mastering the Seven Quality Tools (with Microsoft Excel) provides an in-depth review of what are commonly called the Seven Basic Quality Tools. Manufacturing and service industry professionals, quality technicians and auditors, and industrial engineers will all benefit from understanding these tools. Once mastered, they will serve as the foundation for your root cause analyses, data analysis and visualization efforts, problem-solving sessions, and continuous improvement projects.

The tools covered in this course include:

  1. Cause and effect diagram

  2. Check sheet

  3. Control chart

  4. Histogram

  5. Pareto chart

  6. Scatter diagram

  7. Flow Chart

In addition to the theory and concepts, this class also examines several real-world applications of the Seven Quality Tools AND a few more advanced topics using Microsoft Excel. Several Excel templates included with the class.

Drawing from decades of practical industry experience, "Mastering the Seven Quality Tools" covers far more than the textbook theories. But instead, you will learn practical applications and real-life examples of using these tools.

Also, if you are preparing for the Certified Quality Engineer (CQE), Certified Quality Technician (CQT), or Certified Quality Improvement Associate (CQIA) exam through the American Society for Quality (ASQ), or your Six Sigma Green Belt exam through any of several different organizations, this course will provide an excellent survey of the Seven Quality Tools plus other topics relevant to those certifications.


What have a few of the 8,100+ past students said about this course?

"Your Control Chart series has been extremely helpful in assisting me with my PMP exam prep." - Judith R.

"This is an excellent tutorial for beginners and people who are new to the manufacturing world. It is often overlooked in the production world today." - Ann W.

"Great content and examples contained in this course. This is my 3rd class from Ray Harkins, and have picked up useful tools to use from each. Thanks!" - Ken C.

"The course is easy to understand for beginners, each and every tool is well explained with examples and every person who attend this course can easily implement the tools on live projects." - Hari B.

"One of the best courses I have taken so far!" - Rushanth G.

Plus over 1,000 5-star Reviews!

See you in class!

Who this course is for:

  • Quality Engineers, Manufacturing Engineers, Process Engineers, Quality Managers
  • Six Sigma Green Belts, Six Sigma Black Belts, Continuous Improvement Engineers, Operations Managers
  • Industrial Engineers, Production Supervisors, Quality Technicians, Production Planners
  • Supplier Quality Engineers, Lean Manufacturing Specialists, Test Engineers, Data Analysts
  • Calibration Technicians, Process Development Engineers, Plant Managers, Project Engineers
  • Technical Trainers, ASQ Certification Candidates (CQEs, CQTs, CQIAs), Operations Analysts

Report abuse