Back to homepage Contact us  
List of training courses View trainer's profile

Course Details

(Using Microsoft® Excel)
"Construct SPC charts fast & easy with just a few clicks of a button on the computer keyboard. Automate charting to improve on accuracy and speed. Spend more time analyzing what your data is telling you about the process and take corrective actions.. These are some advantages this course has over traditional SPC course."

Statistical Process Control (SPC) is a worldwide standard and a proven technique used in the manufacturing and service industry, especially for process control and quality improvement initiatives.   Its worldwide usage, recommended by Quality Management Gurus, creates huge impact to any organization’s quality and process control successes. This course provides the foundational skills and tools necessary for quality improvement personnel, such as Quality Managers/Engineers, QCC/Project Team Leaders and LEAN Practitioners who need a good grasp of the foundational statistical principles, concepts and best practices of SPC to execute correctly the process improvement projects in their daily work.  This is also a foundational course for LEAN Six Sigma initiatives.

This training program will explore a smarter and a more effective way of learning SPC skills fast & easy. Differentiated from the “traditional” SPC course, this training course utilizes Microsoft Excel spreadsheet technique to accelerate the construction of the important control charts in a fast past manner.  In doing so, it will allows participants to have more time to focus on important skills such as the analysis/interpretation of the control charts/patterns, establishing action plans to reduce process variances and improve process stability. The MS Excel charting techniques used throughout the course to will help better explain the workings of statistics and reveal the power of SPC techniques to assist with problem solving and process control.  This training program is a must for those who are serious about acquiring Statistical Process Control skills using an effective and accelerated learning method.

**NOTE: Value-add MS Excel working templates will be provided to participants in this training course. With it they can construct control charts hands-on in a fast and easy manner. These working templates can save participants hundreds of hours in creating charts and building tables. With this valuable tool, participants can transfer what they have learned to their workplace immediately.

Participants are encouraged to bring along their own laptop (installed with MS Excel version 2007 & above) for hands-on SPC charting & data analysis practices in the class.



At the end of the course, participants will be able to:

  • Describe the overall concepts, principles and methods of “Statistical Process Control (SPC)"
  • Recognize why and how SPC is important in performing Quality Control and Process Improvements initiatives.
  • Perform data analysis on statistical models and control charts.
  • Select the correct control charts for variable & attribute data-types, and how to implement SPC charting at their workplace.
  • Sharpen the skills to quickly & accurately construct control charts using the MS Excel templates.
  • Analyze the control charts and recognize its process trends and patterns.
  • Take positive actions to control operational processes at the workplace
  • Conduct Capability Studies and calculate the Cp, Cpk values


In order to maximize participants' learning impact and retention, this course uses the following methods:
  • Hands-on computer SPC charting simulations.
  • Real work case studies and small group discussions
  • Data Analysis exercises
course contents:


  • What is SPC?
  • Why Use SPC?
  • Worldwide usage of SPC for Quality Control & Improvements

Using MS Excel to construct Control Charts:

  • Benefits of using MS Excel as a statistical tool.
  • Using MS Excel to construct SPC charts - - Demonstration and exercises.

Understanding Data & Basic Statistics

  • Types of Data. Data availability and presentation
  • Frequency distribution and measurements
  • Histograms and Normal Curve
  • Normal Distribution
  • Central Limit theorem

Introduction to Statistical Process Control

  • Concepts, Principles & Usage of Statistical Process Control Charts
  • A Process Control System: Prevention Vs Detection
  • Variation: Common and Special (Assignable) causes
  • Process Control and Process Capability

Introduction to Control Charts

  • Basic principles of control charts
  • Process model simulations.
  • Variables and Attribute charts
  • Selection of control charts
  • Constructing control charts with MS Excel
  • Interpretation of what the data/pattern reveals
  • Stratifications and making decisions based on interpretation of data

Control Charts for Variables

  • Xbar-R chart
  • Interpretation of control chart
  • Control limits vs Specification limits
  • Calculation of process capability: Cp, Cpk
  • Xbar-S chart
  • XmR chart

Control Charts For Attributes

  • Proportion defective charts (p-chart, np-chart)
  • Number Defect charts (c-chart, u-chart)

Practical Procedures

  • Process capability study procedure
  • Tips: Using MS Excel working templates
  • Case studies
  • Control Charts Benefits


1). Participant should have prior knowledge of basic MS Excel spreadsheet skills (e.g. using formula, edit graphs, printing, etc).

2). For hands-on practices, laptops or computers (preloaded with MS Excel 2007 or above) must be made available for participants in the class.

who should attend:
  • Operations/Quality Managers, QA/Process Engineers, Supervisors, Technicians
  • QCC/LEAN Project Leaders & Team Members
administrative details :
Duration : 2 days
Time : 9.00am - 5.00pm
Venue : In-house or public program
Language medium : English
Trainer :
Nelson Kok (please click here to see trainer's profile)

Click on the above banner to find out more about other Accelerated Learning Courses
Home | Courses | Trainer Profile | Testimonials | Contact Us
Train for Personal Effectiveness and Organizational Growth
2014, All Rights Reserved.