The course Excel in the Analysis and management of Processes is aimed at increasing the efficiency of work using Excel in evaluating the capability of processes and in improving processes using the Six Sigma method.
- Under the guidance of an experienced lecturer, participants apply the content mainly using exercises and examples from practice.
- Top lecturers with experience and experts in their field.
- High degree of satisfaction of course participants .
The form of realization of the course is face-to-face or online (or both forms) .
The working methods used in the training programs are chosen in such a way as to ensure interactivity, adapt the content to the needs of the participants and prioritize the transfer of knowledge into practice .
- Using specific examples, teach participants how MS Excel software can be effectively used in practice when applying statistical methods of analysis, improvement and process management.
- Master the use of software and make time more efficient in the statistical processing of data and their evaluation.
Introduction to MS Excel
· basic windows and menus
· work with a table
· graphs
· Formulas, calculations
Graphical tools – Histogram
· Location, variability
· form of the process – diagnostics: examples
Statistics
· Xp, Xm, s, R Gaussian distribution – normality/distribution test – diagnostics
Graphic tools intro
· Dot plot, Box plot + position variance process – diagnostics + examples
Graphic tools I
· Scatter plot
· Pie Chart
· Pareto chart – examples
Graphic tools II
· Multi-vari chart – diagnostics + examples
Capability Analysis
· Basics – principles of process capability assessment
Process stability I
· Basics – principles, Shewart UCL, LCL calculations, process monitoring
Process stability II
· Variables Xp-R, Xp-s examples + diagnostics 8 Tests
Process stability III
· Variables X individual – examples + diagnostics
Process stability IV
· Attribute Charts – types of monitoring, example np
Process stability V
· Attribute Carts – np, p, c, u – examples
Repetition summary
· Process Capability, Stability
MSA
· basic principles, definitions
· Accuracy
· Precision
Bias
· Definition, procedure, analysis – Gage study
· Linearity – Bias (stopwatch example)
RaR I
· Definition, procedure, analysis – example Micrometer
· Gage study RaR Crossed – interpretation of results, graphs
· Corrective Actions (Nested)
