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.

4.41 (1678 reviews)
Udemy
platform
English
language
Operations
category
6,641
students
4.5 hours
content
Feb 2024
last update
$99.99
regular price

What you will 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

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 6,500+ 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 750 5-star Reviews!

See you in class!

Content

Introduction

Introduction to The Seven Quality Tools
Control Charts, Part 1
Control Charts, Part 2
Control Charts, Part 3
Control Charts, Part 4
Pareto Diagrams
Checksheets
Histograms, Part 1
Histograms, Part 2
Histograms, Part 3
Cause and Effect Diagram
Flowcharts
Scatterplots
Closing
The Seven Quality Tools quiz

Extra Material

Introduction to Extra Material
Making a Scatterplot in Excel
Finding the Trendline and R-Square
Using Linear Regression to Make Predictions
Excel's Descriptive Statistics Tool
Building Histograms in Excel
Building Pareto Diagrams in Excel
An Introduction to Pivot Tables
Using a Pivot Table to Create a Pareto Diagram
Flowcharts in Excel, Pt 1
Flowcharts in Excel, Pt 2
The Containment Checklist

Bonus Section

Keep Learning!!

Screenshots

Mastering the Seven Quality Tools (with Microsoft Excel) - Screenshot_01Mastering the Seven Quality Tools (with Microsoft Excel) - Screenshot_02Mastering the Seven Quality Tools (with Microsoft Excel) - Screenshot_03Mastering the Seven Quality Tools (with Microsoft Excel) - Screenshot_04

Reviews

Andrea
August 14, 2023
Really good, thanks a lot. Maybe can be good also to have more exercises of each tool in editable version, or templates to use in each case. Thanks a lot!
Lori
March 5, 2023
As always, Ray's courses are informative, timeless and presented in a way for all levels of quality personnel to understand.
Christopher
March 1, 2023
Presenter's visuals are atrocious, the presentation itself lacks engagement. Content is fine, but if I wanted to learn via content only I'd just pick up a book with words.
Soumit
February 21, 2023
I had good experience and I had gained a lots of knowledge which could help me for my future aspects and outputs working in the quality department.
Rajesh
February 4, 2023
Really good explanations till now.... but need the solutions with business cases instead of just numbers. But till now i feel very good about course (2 videos)
Nel
January 17, 2023
El profesor es muy claro en sus explicaciones, da muy buenos ejemplos y en sus clases siempre usa materiales didácticos de gran utilidad. Además, regala sin costo alguno materiales de apoyo al aprendizaje, así como los contenidos que va actualizando en su curso.
Gurupreet
October 28, 2022
nice course... it will be more helpful if you provide more resources for practical & readings... thanks
Marzia
September 5, 2022
it was explained in a very lay mans language. just need to see how do we apply in excel , this was done manually.
Peta
July 25, 2022
I took Sandeep's root cause analysis course and this course was an awesome refresher regarding 7 basic statistical tools.
Daniel
June 26, 2022
Excellent review on the Quality tools subject. Easy to understand, easy to apply tools that helps a lot. Thank you so much.
Jabulani
May 28, 2022
This was an amazing course for me, I have learned a lot of new things which I am intending to use right away in my field of work!
BettyAnn
May 27, 2022
I do not appreciate videos (# 30) created for the sole purpose of promoting your classes. Nor do I appreciate videos (#29) to answer questions related to one group of students.
Jun
April 1, 2022
Great, informative review of the seven quality tools mentioned in this course. There is another section called "Extra Material" which have lectures on how to use Excel with some of these quality tools. Unfortunately, even though they are "extra", this section is still required to be completed to get your certificate. Nonetheless, I enjoyed the teacher and the course.
Fdesai
February 22, 2022
It’s great to know and understand all the skills which are highly required to evaluate data easily in such format method. It would be great and highly recommended to add other languages as well to understand detailed method in more efficient way.
Apadhiyar
February 22, 2022
some time is difficult to understand how we can use this on a daily basis Kindly show the live excel Example in the video so that we can understand better.

Charts

Price

Mastering the Seven Quality Tools (with Microsoft Excel) - Price chart

Rating

Mastering the Seven Quality Tools (with Microsoft Excel) - Ratings chart

Enrollment distribution

Mastering the Seven Quality Tools (with Microsoft Excel) - Distribution chart
1331639
udemy ID
8/26/2017
course created date
11/9/2019
course indexed date
Bot
course submited by