Master Statistical Process Control in Excel: Control Charts

Using and Applying Control Charts in Industry

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.

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.
  • Statistics.
  • Data Visualizations.

Course Content

  • Control Chart Fundamentals –> 5 lectures • 46min.
  • Module 2: Signals –> 7 lectures • 1hr 17min.
  • Module 3: Control Charts with Categorical Data –> 2 lectures • 22min.
  • Module 4: Control charts without Control Charts –> 5 lectures • 43min.
  • Module 5: Cases –> 1 lecture • 25min.

Master Statistical Process Control in Excel: Control Charts

Requirements

  • 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:

Module 1:

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

 

Module 2:

Key assumptions

Change in mean signals

External influence signals

Change in process stability/capability signals

 

Module 3:

Exercises for building individual range charts

Exercises for building moving range charts

Exercises for building P charts

Exercises for building U charts

 

 

Module 4:

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

Get Tutorial