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

Available Sessions

Excel for QI (Setting up your Excel for QI Analysis)

Oct 14, 2022, 8am - 4pm

Virtual


Login to register or to see more information

Contact Info

GILES, TRACEY

tracey.giles@fraserhealth.ca

For technical issues, please submit a ticket through LearningHub Help Site.