Become a Quality Analytics Expert Using Excel

Published 5/2023
Created by Michael Parent
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 99 Lectures ( 18h 5m ) | Size: 10.8 GB

Quality Analytics for Quality Management using Excel
Free Download What you’ll learn
Fundamental Quality Management Principles
Basic and intermediate Data Analytics
Excel functions and applications for quality management and data analytics
Create and use control charts to monitor and improve business operations
How to create and use Pivot Tables for root cause analysis and comparisons
Create and use Monte Carlo Simulation to understand and predict operational risk
Statistical Process Control
Conduct a Capability Analysis to understand quality performance and limitations
Requirements
Microsoft Excel
No prior data analysis experience needed for this course
No additional software is needed.
Some general knowledge about manufacturing and business operations preferred.
Description
This 2 course bundle includes the best of both worlds as two of the most popular courses in my catalog are combined to bring novel and exciting value to students of quality management. First, students will be introduced to Excel through the data analytics course. Here they will become masters of the Excel environment. Students will learn everything from the basics of excel navigation and worksheet functions, to the more meaningful and exploratory applications of excel such as data visualizations (Bar charts, line charts, combo charts and more), pivot tables for root cause analysis, category analysis and comparative analysis,, statistics including hypothesis testing, monte Carlo simulation and much more. Then, after the mastery of excel, students will take on exciting topics of quality analytics. Students of this course will apply the data analytics curriculum to real world applications of quality management for business operations. Topics within this module include understanding what statistical process control is and how it is used to improve and predict business performance. Topics within this module include control charting in excel (with and without data visualizations) and capability analysis which allows businesses to understand their their ability to meet and exceed their customer tolerances and expectations.
Who this course is for
Quality Engineers
Industrial Engineers
Quality Managers
Plant Managers
Operations Managers
Process Engineers
Lean Six Sigma Green Belts
Lean Six Sigma Black Belts
Lean Six Sigma Yellow Belts
Manufacturing and Production Managers
Homepage

www.udemy.com/course/quality-analytics/