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