Mastering Seven Basic Tools for Quality Improvement (Excel)

Ishikawa proposed seven basic tools to improve quality in 1970s | Let's use the power of MS Excel to use them.

Course Summary

 During the post-war industrial revolution, Dr. 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.

 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.

The seven quality tools covered in this course include: Cause and effect diagram, Check sheet, Control chart, Histogram, Pareto chart, Scatter diagram and Flow Chart

In 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.

Rupali Dodmise


"Very insightful information that other courses do not necessarily go over.Good quality of teaching .Very good explanation on each and every Quality tools process and exercises shown."

Course Curriculum

Sandeep Kumar

Sandeep Kumar has more than 35 years of Quality Management experience. He has worked as Quality Manager/Director on a number of projects, including Power, Oil and Gas and Infrastructure projects.

In addition, he provides consulting services to implement Lean Six Sigma to improve performance. 

His areas of specialization include Quality Assurance, ISO 9001:2015, Lean, Six Sigma, Risk Management, QMS Audits, Supplier Quality Surveillance, Supplier Pre-qualification, Construction Quality, Mechanical Inspection and Quality Training.

Professional Qualifications:

His professional qualification/certifications include: 

• ASQ-CSSBB, Certified Six Sigma Black Belt
• ASQ-CMQ/OE Certified Manager of Quality/Organizational Excellence
• PMI-PMP Certified Project Management Professional

• IRCA Registered Lead Auditor (QMS-2015)

• IIA-CIA Certified Internal Auditor
• ASQ-CSSGB, Certified Six Sigma Green Belt

• ASQ-CQA Certified Quality Auditor

• ASQ-CQE Certified Quality Engineer

Course Pricing

  • Best Value
  • $9.99 USD

    Get the course at the best price. Anytime.

    Buy Now
  • 365 Day Subscription
  • Certificate of Completion