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

Course Details

(Using Microsoft® Excel)
"Today common spreadsheet software allows you to construct SPC charts in a fast & easy manner with just a few clicks of a button on the computer keyboard. It improves accuracy and remove the hassles of re-calculations. So that participants like you can spend more productive time analyzing what your data is telling you about the process/trends in order to take the correct next-step actions. These are some advantages this course has over traditional SPC course."

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. Participants should have taken SPC level 1 course first before taking this course. It provides the principles and advance 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, various Process Capability studies, Cusum & EWMA control charts to detect small shifts, Hypothesis testings, ANOVA and Regression techniques. 

This training program capitalizes on the utilization of MS Excel application to accelerate all those meticulous calculations, charting and searching of statistical table activities.  In doing so, it enables participants to focus more on critical process analysis and get results fast. Apart from lectures, case studies 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.  This training program is a must for those embarking on LEAN SIX SIGMA initiatives and for all those quality improvement personnels who are serious about advancing their Statistical Process Control techniques and skills.


NOTE: Value-add MS Excel working templates will be given to participants in this course. These working templates can save participants hundreds of hours in creating charts and building tables. Participants should bring their own laptop (loaded with MS Excel, version 2007 onwards) to the class for hands-on practices.



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 & special considerations.
  • Analyze common and special causes and it patterns.
  • Conduct practical Process Capability Studies
  • Use Cusum and EWMA control charts to detect small shifts in the process
  • Sharpen the skills to quickly construct various control charts using MS Excel spreadsheet.
  • Conduct and conclude experiments using statistical hypothesis testings techniques.
  • Use ANOVA technique to further reduce process variability
  • Analyze correlation and conduct Regression analysis


In order to maximize the participants' learning and retention, this course uses the following methods:
  • Hands-on SPC charting simulation and data analysis
  • Quizzes & Assignment exercises
  • Real work case studies & Small Group Activities
who should attend:
  • Project Managers, Operation Managers, Engineers, Foreman, Project Team Leaders who have completed SPC-Level1 course.
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 charting for Variables data.
  • Setting up control charting for Attributes data
  • Selection of control charts
  • Special purpose control charts

Various 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
  • Six Sigma quality standard.

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

Using Different Control Charts for Special Considerations

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

Concluding Experiments Using Hypothesis Testings

  • Statistical Inferences for optimization and reduced variability
  • Setting up statistical Hypothesis Testings
  • Comparison test (1-sample & 2-samples)
    - Z-test , t-test
    - F-test
  • Multiple sample comparison: Analysis of Variance (ANOVA)
    - ANOVA single-factor,
    - ANOVA two-factor
  • Normality test

Regression Analysis

  • Using scatter diagram to identify correlation
  • Using 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 studies.
  • Practical exercises using MS Excel working templates
  • Real work case studies and charting simulations


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 provided for participants to practice hands-on.


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.