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

Course Details

(Using Microsoft® Excel)
"Construct SPC charts with just a few clicks of a button on your 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 extensively in the manufacturing and service industry, especially for process control and quality improvement initiatives. People frequently make decisions based upon their past experiences and intuitions only.  Face with increasing complexity in industry, experience and intuition alone has no place in decision making because it can become highly questionable when decision involves the choice among several courses of action and the variables are too many. Furthermore, it is difficult to convince customers and improvement team members using past experience and intuition.  Hence, there is a need to train people to use statistical methods to manage their process accurately and efficiently.  Using statistical process control methods will help improve productivity and better convince a wider audience since it is a proven scientific method. 

This training program is a follow-up program of SPC level 1. It provides the principles and concepts of Statistical Process Control (SPC) that is so vital to Quality Improvement programs in the industry.  It demonstrates the power of proven techniques to assist with problem solving and further reduce the process variability.  This SPC Level 2 course emphasizes on Advanced Control Charting, Process Capability Study, Cusum & EWMA control charts to detect small shifts, Hypothesis testing, ANOVA and Regression techniques.  Different from traditional method of teaching SPC, this program capitalizes on the utilization of common computer spreadsheet (Microsoft Excel) software to accelerate all those meticulous calculations, graphing and searching of statistical table activities.  In doing so, it allows participants to construct SPC charts fast & easy, thus, have more time to focus on process analysis and take actions to improve the process.  Apart from lectures and practice sessions, this program also includes computer simulations to help reinforce participant’s understanding of the control charts functionalities with an emphasis on participation throughout. 

NOTE: Value-add MS Excel working templates will be given to participants after completion of this course. These working templates can save participants hundreds of hours in creating charts and building tables. With this valuable tool, participants can transfer all that is taught into their workplace immediately.


At the end of the course, participants will be able to:
  • Increase the knowledge of Statistical Process Control at Intermediate Level and its practical applications in business and quality management.
  • Know which control charts to use at different stages of the process.
  • Analyze common and special causes and it patterns.
  • Conduct practical Process Capability Studies
  • Use Cusum and EWMA control charts to detect small shifts
  • Sharpen the skills to quickly construct various control charts using MS Excel spreadsheet.
  • Conduct statistical hypothesis testings
  • Use ANOVA technique to further reduce variability
  • Analyze correlation and conduct Regression analysis


In order to maximize the participants' learning and retention, this course uses the following methods:
  • Hands-on computer simulation and data analysis
  • Quizzes & Assignment exercises
  • Case studies & Small Group Activities
course contents:


  • Introduction to computerized statistical calculations & graphing techniques.
  • Using computer spreadsheet for Control Charting

Revision of Statistical Process Control I (SPC 1)

  • A Process Control System
  • Setting up control charts: Variables
  • Setting up control charts: Attributes
  • Selection of control charts
  • Special purpose control charts

Process Capability Analysis

  • Understanding Cp, Cpk, Six sigma
  • Determining the correct Cp, Cpk
  • Conducting Short-term & Long-term Capability Analysis
  • Conducting Process Capability Studies, Pp, Ppk
  • Introduction to Six Sigma quality

Control Charts for Detecting Small Shift

  • Cumulative Sum (Cusum) Control Chart
  • Rapid construction of Cusum chart using MS Excel
  • Exponentially Weighted Moving Average (EWMA) control chart

Special Considerations Using Control Charts

  • Short run processes
  • Deviation from Nominal Value (DNOM) control chart
  • Calculating Capability indices for non-normality processes
  • Other considerations for skewed process

Statistical Inferences for Optimization and Reduced Variability

  • Statistical Hypothesis Testings
  • Comparison test (1-sample & 2-samples), t-test, F-test
  • Multiple sample comparison: ANOVA single-factor, ANOVA two-factor
  • Normality test

Regression Analysis

  • Using scatter diagram to identify correlation
  • Simple Regression Method
  • Understanding R-square, Standard Error for slope, etc
  • Multi-Regression Method
  • Using ANOVA method for Multi-Regression

Practical Procedures

  • Shopfloor considerations for Process capability study
  • Practical exercises using MS Excel working templates
  • Case studies


1). To achieve the accelerated learning objectives, participants should have prior MS Excel spreadsheet skills (e.g. using formula, create tables, edit graphs, printing, etc).

2). Participants are encouraged to bring their own laptop (preloaded with MS Excel 2007 or above licensed software) to the training class. Value-Added MS Excel working templates will be given to equip participants for immediate transfer of training to their workplace.


who should attend:
  • Project Managers, Operation Managers, Engineers, Foreman, Project Team Leaders who have completed SPC-Level1 course.
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.