Excel in analysis and process management

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


· 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


· basic principles, definitions
· Accuracy
· Precision


· Definition, procedure, analysis – Gage study
· Linearity – Bias (stopwatch example)


· Definition, procedure, analysis – example Micrometer
· Gage study RaR Crossed – interpretation of results, graphs
· Corrective Actions (Nested)

Find out more

We will provide you with more detailed information about the price, possible dates and training schedule.

Contact us

We also recommend the following courses

Arrange a consultation