Mastering the Seven Quality Tools with Microsoft Excel

A Deep Dive into the theory and application of the 7 Quality Tools for root cause analysis and continuous improvement.
Mastering the Seven Quality Tools with Microsoft Excel
File Size :
2.42 GB
Total length :
4h 18m



Ray Harkins, The Manufacturing Academy


Last update

Last updated 9/2022



Mastering the Seven Quality Tools with Microsoft Excel

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

Mastering the Seven Quality Tools with Microsoft Excel


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


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:Cause and effect diagramCheck sheetControl chartHistogramPareto chartScatter diagramFlow ChartIn 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 4,700+ 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 500 5-star Reviews!!


Section 1: Introduction

Lecture 1 Introduction to The Seven Quality Tools

Lecture 2 Control Charts, Part 1

Lecture 3 Control Charts, Part 2

Lecture 4 Control Charts, Part 3

Lecture 5 Control Charts, Part 4

Lecture 6 Pareto Diagrams

Lecture 7 Checksheets

Lecture 8 Histograms, Part 1

Lecture 9 Histograms, Part 2

Lecture 10 Histograms, Part 3

Lecture 11 Cause and Effect Diagram

Lecture 12 Flowcharts

Lecture 13 Scatterplots

Lecture 14 Closing

Section 2: Extra Material

Lecture 15 Introduction to Extra Material

Lecture 16 Making a Scatterplot in Excel

Lecture 17 Finding the Trendline and R-Square

Lecture 18 Using Linear Regression to Make Predictions

Lecture 19 Excel’s Descriptive Statistics Tool

Lecture 20 Understanding Correlation

Lecture 21 The Correlation Matrix

Lecture 22 Building Histograms in Excel

Lecture 23 An Introduction to Pivot Tables

Lecture 24 Using a Pivot Table to Create a Pareto Diagram

Lecture 25 Building Pareto Diagrams in Excel

Lecture 26 Flowcharts in Excel, Pt 1

Lecture 27 Flowcharts in Excel, Pt 2

Lecture 28 The Containment Checklist

Lecture 29 Additional Resources in Quality Engineering

Lecture 30 Bonus Lecture

Quality Professionals,Manufacturing Supervisors,Manufacturing Engineers,Quality Technicians,Anyone studying for their CQE, CQIA, CQT or 6-Sigma Green Belt exams,Industrial Engineers,Problem Solvers

Course Information:

Udemy | English | 4h 18m | 2.42 GB
Created by: Ray Harkins, The Manufacturing Academy

You Can See More Courses in the Business >> Greetings from

New Courses

Scroll to Top