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

Statistical Process Control (SPC) is a worldwide standard and a proven technique, used in the manufacturing and service industry, to reduce variations in processes, to establish process controls and quality improvements.   Its worldwide usage, recommended by Quality Management Gurus, creates huge impact to any organization’s quality and process control successes.

This course provides both the crucial foundational knowledge and skills for statistical data analysis and control charting. It includes the use of Microsoft (MS) Excel software as a tool to construct SPC charts fast and accurately. This course will help participants correctly execute the process improvement initiatives in their daily work. Participants will learn how to analyze in-control and out-of-control patterns; to establish action plans to reduce process variations, and to improve the process stability. Value-added MS Excel templates will also be provided to assist participants to practice SPC chartings hands-on. With it, they can construct control charts fast and easily, making the transfer of SPC knowledge/skills learned here back to their workplace more effective.

This training program is a must for all quality improvement personnels; such as Quality Managers/Engineers, QCC/Project Team Leaders and those embarking on LEAN SIX SIGMA initiatives.

**NOTE: Value-add MS Excel working templates will be provided to participants in this training course. These working templates can save participants hundreds of hours in constructing charts and building tables. Participants are encouraged to bring along their own laptop (installed with MS Excel version 2007 & above) to the class for hands-on practices.



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

  • Describe the overall concepts, principles and methods of “Statistical Process Control (SPC)"
  • Explain why and how is SPC used in performing Quality Control and Process Improvements initiatives.
  • Perform data analysis on statistical models and control charts
  • Select the correct types of control charts for variable & attribute data.
  • Implement SPC control charting; to collect the appropriate data and construct control charts fast & accurately using MS Excel.
  • Analyze the control charts and recognize its process trends and patterns.
  • Take positive actions to control operational processes at the workplace
  • Conduct Process Capability Study 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
who should attend:
  • Operations/Quality Managers, QA/Process Engineers, Supervisors, Technicians
  • QCC/LEAN Project Leaders & Team Members
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
  • Central tendency and dispersion
  • 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.
  • Types of Variables and Attribute charts
  • Selection of control charts: Which SPC chart to use?
  • Accelerated method of 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

  • Step-by-step Xbar-R charting.
  • Interpretation of control chart
  • Control limits vs Specification limits
  • Process Capability Study. Calculation of process capability: Cp, Cpk
  • Construction of Xbar-S chart & interpretation.
  • Construction of X-mR chart & interpretation.

Control Charts For Attributes

  • Proportion defective charts (p-chart, np-chart)
  • Construction of p-chart, np-chart and interpretations
  • Number Defect charts (c-chart, u-chart)
  • Construction of c-chart, u-chart and interpretations

Practical Procedures

  • Real work case studies
  • Tips on using MS Excel working templates
  • Conducting Process Capability Study
  • Hands-on data analysis using MS Excel.


1). To achieve the accelerated learning objectives of this course, participant should have prior knowledge of basic MS Excel spreadsheet skills (e.g. using formula, edit graphs, create tables, 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.

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.