Excel for Begginers

Thiago has a degree in Production Engineering, a graduate course in statistics and a degree in administration from the Federal University of Juiz de Fora (UFJF). Black Belt in Lean Six Sigma, worked with methodologies for cost reduction and process optimization at Votorantim Metais, subsequently joining MRS Logística as a trainee, where he held positions of manager and specialist in continuous improvement. With Microsoft Office Specialist (MOS) certification and ISO 9001 Auditor Lead Advisor, attended several companies in consulting projects, in addition to training and lectures related to Lean Six Sigma, Career Entrepreneurship in nationally renowned congresses such as ENEGEP (National Meeting of Production Engineering) and international as International Six Sigma Brazil congress. In the academic environment, he works as a professor of undergraduate and graduate courses in the areas of management and entrepreneurship. Thiago had the opportunity to participate in projects of several segments. Founder of the Voitto Group, he was selected in the Promessas Endeavor Program, having the opportunity to receive valuable mentoring to accelerate his business. He is currently a business mentor and dedicates himself to the executive front of Voitto, carrying with his team the vision of being the best online school of management in Brazil.

Founder of Voitto Group, currently a business mentor and dedicated to the executive front of Voitto, carrying with his team the vision of being the best online business school in Brazil.

Understand what statistical process control (SPC) is, what it is used for, and how to use it.

Learn how to apply Statistical Process Control (SPC) for problem detection.

The control phase of the DMAIC method aims to monitor the results achieved after the implementation of the improvements, establish controls that ensure the sustainability of the results, define the &quot;process owner&quot; and how the process will be monitored on a daily basis.The estimated time for this stage of the Lean Six Sigma project is approximately 2 to 4 weeks. And its main tools are: Control Charts, OCAP, Standard Operating Procedure and Poka Yoke.But do you know what a Statistical Process Control Chart is? Or what SPC is in this context? Do you also know what it is for and how to do it? If you answered no to any of these questions, keep reading this post to find out.In this article you will learn:<ul><li>What is Statistical Process Control?</li><li>What is the importance of SPC?</li><li>How to follow up the Statistical Process Control?</li><li>How to analyze a Statistical Process Control?</li></ul><h2>What is Statistical Process Control?</h2>Statistical process control, also known as SPC, is a quality tool that can be defined as a method for preventing and detecting defects/problems in evaluated processes.It was developed by Walter Shewhart in the beginning of the 20th century and spread around the world in the 1960s by Edwards Deming with the application in the PDCA cycle.CEP is a study that aims to monitor a product or service during its production process, in order to identify the non-compliant outputs, so that the root cause can be eliminated and the process is stabilized, preventing further variations from occurring.Every process has small variations, and we can classify them into two groups: Causes of common variations: These are random and unavoidable variations that occur within certain limits, without a systematic cause that can be eliminated. Special causes of variation: This occurs when the process exhibits systematic deviations or variations outside its limits, as a consequence of clearly identifiable reasons within the process that can be eliminated.<h2>What is the importance of statistical process control?</h2>The importance of statistical process control is undoubtedly to have a holistic view of the process. But why control a process? The answer to this question is given with another question: What can be said about an unstable process? Very little! And that is why we must control processes.If there are special causes of variation, the process output is not stable and is not predictable over time. Therefore, we have no way of knowing what will happen tomorrow, for example. So we will have control charts like this. <Image quality="95" width="253" height="116" src="https://images.prismic.io/voitto-blog/f56b2915-82e4-4d4f-ab7d-5b515e9611db_1.jpg" alt="Graph without" title="Graph without" />If only the common causes of variation are present, the output of a process forms a distribution that is stable and predictable over time. Thus generating graphs that look like this. <Image quality="95" width="248" height="119" src="https://images.prismic.io/voitto-blog/e86393ad-3b5f-4a7b-b0d9-d1c7c9b28b77_2.jpg" alt="Balanced Chart" title="Balanced Chart" />Control helps maintain the improvements achieved, and sets a new benchmark for best practices. <Image quality="95" width="449" height="254" src="https://images.prismic.io/voitto-blog/c589de9a-5cb3-4198-a391-292eda05e134_3.jpg" alt="Improvement x Control Chart" title="Improvement x Control Chart" /> Are you tired of missing out on incredible career opportunities because you don&#39;t know about the main Excel tools?So you are in the right place! In the<a target="_blank" rel="nofollow" href="https://thinkleansixsigma.thinkific.com/courses/excel-for-beginners"> Excel for Beginners</a> course, you will learn to work with data in an agile way.In addition, the course is available for FREE, just click on the banner button below and embark on this journey of knowledge!<a target="_blank" rel="nofollow" href="https://thinkleansixsigma.thinkific.com/courses/excel-for-beginners"> <Image quality="95" src="https://images.prismic.io/voitto-blog/45fd4463-eb50-470d-a2e2-1a98155e7fdc_Bot%C3%A3o++Banner+-+Cursos+TLSS+%282%29.png" width="980" height="180" alt="Excel for Beginners" title="Excel for Beginners"/></a><h2>How to analyze a Statistical Process Control?</h2>To analyze statistical process control, you must evaluate control charts. Below, you will learn more about them.<h3>What are control charts?</h3>The control charts are nothing more than a set of points (samples) ordered in time, which are interpreted as a function of horizontal lines, called UCL (Upper Control Limit) and LCL (Lower Control Limit). <Image quality="95" width="564" height="282" src="https://images.prismic.io/voitto-blog/554d9570-fdd4-4742-a814-0e6922d50dc0_4.jpg" alt="Control Limits" title="Control Limits" />They are designed for data with normal or approximately normal distributions. They are tools for monitoring variability and evaluating process stability.Through Control Charts, we can distinguish the action of common causes and special causes in the process.With the process presented in this example, we can observe that it is subject only to common causes and is therefore considered stable and predictable. We say that the process is under statistical control.The statistical theory developed by Shewhart for calculating the control limits is based on the idea of the normal distribution, and since the process is stable, the sample data will have a probability very close to 100% of being within -3 sigma to +3 sigma from the population mean.There are 5 tests that must be performed to find that a process is non-compliant. This indicates a potential special cause acting on the process and consequently shows the need for the series of points to be investigated. These tests are: 1.Points outside Control Limits:One or more points cross the LCL or UCL lines. <Image quality="95" width="615" height="365" src="https://images.prismic.io/voitto-blog/02ae56d2-b266-4c6f-8358-c883a640f3bd_5.jpg" alt="Out limit points" title="Out limit points" />2.Periodicity: The plotted curve repeatedly shows an upward and downward trend at similar amplitude time intervals. <Image quality="95" width="561" height="335" src="https://images.prismic.io/voitto-blog/6dfcf678-8675-4791-a67c-febd1972dc3e_6.jpg" alt="Periodicity" title="Periodicity" />3.Sequence:Seven or more consecutive points appear on only one side of the midline. <Image quality="95" width="610" height="364" src="https://images.prismic.io/voitto-blog/32c668d1-175a-434b-aa28-1f9b3d7d3970_7.jpg" alt="Sequence" title="Sequence" />4.Trend:Seven or more consecutive points show a continuous upward or downward movement. <Image quality="95" width="564" height="342" src="https://images.prismic.io/voitto-blog/c79129b1-e43c-43b1-af3b-f8444c912a94_8.jpg" alt="Trend" title="Trend" />5.Approaching the Control Limits: Occurrence of two, of three consecutive points, between the +2 sigma and +3 sigma lines, or between the -2 sigma and -3 sigma lines. <Image quality="95" width="497" height="297" src="https://images.prismic.io/voitto-blog/f0efca57-b728-495a-8696-58df1a693f13_9.jpg" alt="Control Limits" title="Control Limits" />You can still use the control chart to decrease the process variation more and more, by decreasing the variation of the control limits and analyzing the causes of instabilities.You can use tools such as the Ishikawa diagram to find root causes and the 5W2H to develop action plans.Several times we get lost in so many Excel functions, and we don&#39;t know where to start and what to learn. To help you, we created the <a target="_blank" rel="nofollow" href="https://conteudo.voitto.com.br/ebook-primeiros-passos-no-excel">First Steps eBook in Excel</a> to guide your practice with the tool, as well as how and where to learn about its most complex resources. Learn how to solve everyday problems quickly and efficiently in Excel.By downloading our eBook, you will learn the first steps to create your spreadsheets and use their basic and essential functions.Let&#39;s get started?<a target="_blank" rel="nofollow" href="https://conteudo.pocketbook4you.com/ebook-fist-steps-in-excel"> <Image quality="95" src="https://images.prismic.io/voitto-blog/5ad839f3-56eb-4c5b-a198-380f5e858ce8_Bot%C3%A3o+Banner+Cursos+-+TLSS+%2817%29.png" width="1025" height="205" alt="[EBOOK] Fisrt Steps in Excel" title="[EBOOK] Fisrt Steps in Excel"/></a>

Why applying Statistical Process Control (SPC) can be a business differential? Check it out!

Learn how to apply Statistical Process Control (SPC) and find out how to prevent and detect problems in your company's processes to drive gains.