Mastering the Seven Basic Quality Improvement Tools 2022

Master the 7 QC tools for process improvement using MS Excel + Certification || 2 case studies included.
Mastering the Seven Basic Quality Improvement Tools 2022
File Size :
1.38 GB
Total length :
2h 50m



Sandeep Kumar, ­ Quality Gurus Inc.


Last update

Last updated 2/2022



Mastering the Seven Basic Quality Improvement Tools 2022

What you’ll learn

Seven basic quality tools proposed by Ishikawa can solve more than 90% of the quality related problems in an organization.
These tools were orginally proposed in 1970s. Even after more than 50 years these are still relevant.
Apply these tools with Microsoft Excel to solve quality problems
Understand how these tools could be applied in the modern environment, where data collection is automated. (unlike 1970s)

Mastering the Seven Basic Quality Improvement Tools 2022


Some knowledge of using Excel
Understanding that any process can be improved


Using the Seven Basic Quality Tools in 2022: In this course, you will learn the theory behind these seven quality tools and will also learn, to take the power of these tools to the next level using the current computing power.During the post-war industrial revolution, Kaoru Ishikawa proposed seven basic quality tools to improve quality. These seven tools were the backbone of quality improvement in Japan. All workers, supervisors and managers were taught these seven tools to solve a problem and to improve the quality.These were initially introduced in the 1970s. These tools are still relevant even after more than 50 years. By using the power of computers and Microsoft Excel, we can use them today to solve complex problems. Many organizations today might not be collecting data using the manual check sheets (which is one of the tools in this list), but the equivalent of that could be a pivot table in Excel. Note: Students who complete this course have an option to apply for the certification exam by Quality Gurus Inc. and can achieve the Verified Certification from Quality Gurus Inc. It is optional and there is no separate fee for that.The seven quality tools covered in this course include:Cause and effect diagramCheck sheetControl chartHistogramPareto chartScatter diagramFlow ChartIn addition, you will also learn about Run Chart and Stratification. Different sources list the seventh tool differently. In the end, I will present two case studies, to understand how do we use these tools in different situations.✔ The first case study is for an organization that was finding a high repair rate for the painting job. That was leading to the rework of the paintwork and the waste of time and effort in correcting these.✔ The second case study is related to the use of Control Charts to ensure that the required product dimensions are achieved.


Section 1: Introduction

Lecture 1 Introduction

Lecture 2 History of Seven Quality Tools

Lecture 3 Download Course Material

Section 2: Tool #1: Cause and Effect Diagram

Lecture 4 [Theory] Cause and Effect Diagram

Lecture 5 [Demonstration] Cause and Effect Diagram using Excel

Section 3: Tool #2: Check Sheet

Lecture 6 [Theory] Check Sheet

Lecture 7 [Demonstration] Check Sheet vs Excel Pivot Table

Section 4: Tool #3: Pareto Chart

Lecture 8 [Theory] Pareto Principle and Pareto Chart

Lecture 9 [Demonstration] Pareto Chart using Excel

Section 5: Tool #4: Scatter Plot

Lecture 10 [Theory] Scatter Plot

Lecture 11 [Demonstration] Scatter Plot using Excel

Section 6: Tool #5: Histogram

Lecture 12 [Theory] Histogram

Lecture 13 [Demonstration] Histogram using Excel

Lecture 14 [Demonstration] Overlapping Histogram using Excel (for Stratification)

Section 7: Tool #6: Control Chart (and Run Chart)

Lecture 15 [Theory] Run Chart

Lecture 16 [Theory] Control Chart

Lecture 17 [Demonstration] Run Chart using Excel

Lecture 18 [Demonstration] Control Chart using Excel – Part 1 (Data Preparation)

Lecture 19 [Demonstration] Control Chart using Excel – Part 2 (Plotting X-bar, R Chart)

Section 8: Tool #7a: Flow Chart (and Stratification)

Lecture 20 [Theory] Flow Chart

Lecture 21 [Demonstration] Flow Chart using Excel and

Lecture 22 [Theory] Statification

Section 9: Case Studies / Projects

Lecture 23 Case #1: Problem Statement

Lecture 24 Case #1: Solution / Approach

Lecture 25 Case #2: Problem Statement

Lecture 26 Case #2: Solution

Lecture 27 Course Conclusion



Quality Professionals,Project Managers,Problem Solvers,Process Improvement Professionals,Process Owners,Supervisors and Managers

Course Information:

Udemy | English | 2h 50m | 1.38 GB
Created by: Sandeep Kumar, ­ Quality Gurus Inc.

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

New Courses

Scroll to Top