PQI - Setting up your Excel for QI Analysis
Objective:
In this class, you will learn how to set up your excel properly for QI analysis. Later in the PQI course, you will use SQCpack software to create Shewhart Charts. The goal for this course is to help you tailor your spreadsheet so that it will be ready for SQCpack analysis.
Topics:
• Formulas & Functions
- 2-3 basic formula and functions (countif, if, & if(and))
- Relative vs Absolute
• PivotTables
- Create PivotTables
- Sort and Filter data
Participants in PQI training program and PQI Alumni |
|
| 8 hours | |
| 26081 |
This course has no upcoming sessions. Email the course contact for information on the course.
Contact Information
Sun, Haichao