Master Statistical Process Control in Excel: Control Charts
What you'll learn
- Statistical Process Control
- how to use and interpret Control Charts
- how to understand Process Variation
- Six Sigma concepts and tools
- Process Improvement concepts and tools
- Continuous Improvement concepts and tools
- how to perform statistical Data Analysis
- Data Visualizations
- Basic Excel Skills (Formulas, Charts)
- Basic knowledge of statistics (Mean, St. Dev, normal distribution)
Statistical process control and control charts are an important part of operations management. For years, these tools have been used in all kinds of industries including healthcare, manufacturing, software development finance and Human Resources. With the increasing accessibility and the increasing demand for data analysis and data-based decision making, control charting is an important tool to be able to create, understand and apply.
This course will walk through the fundamentals of what control charts are, what insights can be gathered from them and how different control charts can be used to answered different strategic and operational questions.
Each module features several lectures, downloadable lecture files and a quiz to test your learning.
Additionally, The course features an entire module tackling specific real-world cases for using control charts and statistical process control.
Topics covered include:
The history of statistical process control (SPC) and control charting
Parts of a control chart
Advantages of using control charts
Types of control charts (I chart, U chart, P chart, etc.)
Change in mean signals
External influence signals
Change in process stability/capability signals
Exercises for building individual range charts
Exercises for building moving range charts
Exercises for building P charts
Exercises for building U charts
Applying control charts to hospital wait times
Applying control charts to manufacturing process control
Applying control charts to A/B testing in software development
Applying control charts to an inspection process
Control Chart Case Examples
Who this course is for:
- Six Sigma Green Belt
- Six Sigma Yellow Belt
- Operations Managers
- Process Engineers
- Design Engineers
- Industrial Engineers
- Data Analysts
- Quality Engineers
- Quality Managers
Michael Parent is a Lean Six Sigma Black belt and Managing Director of Right Brain Consulting, a Management Consulting Firm. He has consulted in many functions and industries including manufacturing, HR, insurance, sales, and logistics/supply chain. Additionally, Michael is the author of the forthcoming book “The Lean Innovation Cycle” to be published by Taylor & Francis.
Michael holds a degree in Industrial & Operations Engineering from the University of Michigan, Ann Arbor, an MBA from William & Mary in Williamsburg Virginia, and is received his Lean Six Sigma Master Black Belt Candidate from Lawrence Tech University in Southfield, MI.