PQI - Setting up your Excel for QI Analysis

Course Type: Classroom Course
Length: 8 hours
Category: Conferences / Workshop / Seminars

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

Target Audience	Participants in PQI training program and PQI Alumni
Course Length	8 hours
Course Code	26081

Available Sessions

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

Date/time

Oct 14, 2022, 8am - 4pm

Location

Virtual

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

Date/time

Jan 26, 2023, 8am - 4pm

Location

Central City Office - 4th floor, IM Computer Lab

Contact Info

GILES, TRACEY

tracey.giles@fraserhealth.ca

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