Excel Applications for QA and Laboratory Personnel (EMU 160W)

 

Course Description: (16 Hours)

This “hands-on” workshop is designed to introduce Microsoft Excel spreadsheet’s capability to the Laboratory and QA personnel with practical applications. Practical instruction with hands-on approach is provided where attendees work with data to comprehend Quality, Testing and Calibration Laboratory applications. Attendees will develop useful tools and techniques during the class that they will be able to implement immediately in their work environment.

Course Learning Outcomes:

After attending this workshop, attendees will be able to:

• Organize and manage laboratory data in Excel spreadsheets
• Analyze data using the statistical tools provided in Excel
• Create and Validate Excel templates.
• Create reports in Excel

Course Conditions:

1. Laptop (PC or Mac)
2. Excel (PC or Mac) – minimum level
3. Google Sheets
4. “The Excel on tablets does not have the full functionality (no Analysis ToolPak), “Microsoft Teams” as well

Competency Level

1. Open, save, cut, copy, paste, print
2. Formatting
3. Conditional Formatting

Workshop Content

• Excel Shortcuts & Fast Keys
• Managing Data
  • Formatting
  • Data Manipulation
  • Data Conversion
  • Conditional Formatting
  • Basic Tables
• Excel Math and Statistical functions and its application for:
  • Accuracy, Precision
  • Repeatability, Reproducibility, Intermediate Precision
  • Population and Sample distribution statistics
  • Risk calculation
• Excel Analysis ToolPak
  • ANOVA
  • Regression
• Excel Charting application
  • Regression
  • Control Charting (X-Bar R and XMR Charts)
  • Pareto Analysis
  • Histogram
• Creating Excel Templates
  • Measurement Uncertainty
  • Control Charts
  • Validation
  • Error Checking
  • Spreadsheet and Data Protection
• Creating Reports
  • Print Formatting
  • Header, Footer, Quick Parts, Date and time, Object

Contact

Tweet

Share

Email