Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Statistical Process Control (SPC) Using Microsoft Excel

via Udemy

Overview

A Deep Dive into Analyzing your Process Data to Drive Quality Improvements within your Organization

What you'll learn:
  • Basic Statistical Concepts
  • Statistical Process Control, SPC
  • Pareto Analysis
  • Variable and Attribute Control Charting
  • Process Capability Analysis
  • Linear and Multiple Regression Analysis
  • Correlation and Excel’s Correlation Matrix
  • Quality Engineering Statistics within Microsoft Excel
  • Key concepts of Quality Engineering and Quality Management

Unlock the full potential of your manufacturing process data and drive continuous improvement across your organization with this comprehensive, hands-on course. Designed for manufacturing, quality, and engineering professionals, this course equips you with the practical skills needed to analyze, interpret, and report process data effectively using Microsoft Excel.

This course is divided into four key sections:

1. Foundations of Statistics for Manufacturing and Quality

Even if you're new to statistics or Excel, we start from the basics. Learn the core concepts like Measures of Central Tendency, Dispersion, and Data Scales, which are fundamental for effective process analysis. I’ll guide you step-by-step through Excel to calculate these statistics quickly, with easy-to-follow examples that connect directly to real-world manufacturing scenarios.

2. Powerful Pareto Analysis for Prioritizing Improvement

Many professionals underestimate the power of Pareto analysis. Learn how to apply the “80/20 Rule” to identify the most impactful areas for improvement in your processes. I'll also introduce you to Excel’s Pivot Tables—an indispensable tool for organizing and analyzing your data, making decision-making faster and more efficient.

3. Mastering Control Charting for Process Monitoring

Control charts are the backbone of SPC. This section shows you how to use them to monitor your processes over time, highlight trends, and identify areas for improvement. You’ll explore seven types of control charts—both for variable and attribute data—and I’ll teach you how to interpret them with practical Excel demonstrations. You’ll also get reference tools and Excel reports you can implement in your own projects.

4. Regression Analysis for Predicting and Optimizing Processes

Unlock the power of Regression Analysis to define relationships between variables and make accurate predictions about your process performance. Whether it’s Simple Linear or Multiple Linear Regression, this section builds the foundation for analyzing the cause-and-effect relationships in your manufacturing processes, and lays the groundwork for more advanced statistical techniques.

What’s Included:

  • Practical, Hands-On Learning: With detailed Excel worksheets and real-life examples, you'll not only understand the theory but also apply it to improve your daily processes.

  • Ready-to-Use Excel Templates: Use the same tools I demonstrate in the course for your own work, saving time and enhancing your process improvement initiatives.

  • Exam Prep Support: If you’re preparing for certifications like ASQ Certified Quality Engineer, Six Sigma Green Belt, or Black Belt, this course will provide a solid foundation in the statistical techniques you’ll need to pass.

  • LIFETIME ACCESS to all course materials AND all other materials we may add later.

  • A Certificate of Completion with your name, the course's name, and the time duration of the course (useful for fulfilling the need of some CEU requirements)

  • Q&A access through the Udemy platform to a 30+ year manufacturing, quality, engineering, and business professional.

Join thousands of professionals who have successfully leveraged SPC to enhance their manufacturing processes and quality initiatives.

What Students Are Saying:

"This is by far the best course I've taken on Udemy! Very well structured and provided a comprehensive overview of SPC. A gem on Udemy!" – Greg S.

"An invaluable resource for any quality professional looking to excel!" – Sachin K.

"What could otherwise be rather dry and boring information, has been delivered in an engaging manner. Ray is clearly very knowledgeable and passionate about the topic." - Chad B.

"Ray is very knowledgeable and explains each topic in depth. I would be interested in other courses he teaches." - Emily

"It's a very complete course even if you are in a beginner or in an advanced level; examples used are very illustrative and helpful" - Francisco P.

"Great course. Highly recommend for everyone who is working in supply chain manufacturing operation." - Siriluck S.

"Clear and concise explanations with examples to illustrate concepts; uses practical examples to illustrate the theory." - Tom F.

PLUS over 1,100 5-star reviews!!

Sign up today and take the next step in your career.

Taught by

Ray Harkins, The Manufacturing Academy

Reviews

4.6 rating at Udemy based on 1838 ratings

Start your review of Statistical Process Control (SPC) Using Microsoft Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.