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 Spaghetti Diagram is and its relationship with improvement processes. Learn how to do it and be able to analyze and optimize the layout of your business.

 Spaghetti diagram: what is it and what is it for?

Have you ever heard of Spaghetti Diagram? Oh, my God! It&#39;s even hungry now!But calm down, today we&#39;re going to talk about a <a target="_blank" rel="noopener" href="https://www.thinkleansixsigma.com/article/lean-manufacturing">Lean Manufacturing</a> tool, not that delicious Sunday lunch noodle!Spaghetti Diagram is an essential tool for companies that want to remain competitive by eliminating waste, because this tool attacks one of the 8 wastes listed by the Lean methodology: unnecessary movements.Were you curious to know how? Keep reading the article. In it you will learn:<ul><li>What is Spaghetti Diagram?</li><li>What is the Spaghetti Diagram for?</li><li>How to make a spaghetti diagram</li><li>Software to create a Spaghetti Diagram</li><li>Example of a process optimized by Spaghetti Diagram.</li></ul>Prepared?<h2>What is Spaghetti Diagram?</h2>Spaghetti Diagram is a very important visual tool for the Lean Manufacturing segment.It consists of a tangle of drawn lines, usually on an A3-shaped plant. The lines represent the entire trajectory traveled by an employee in a company during the execution of tasks of a given process. <Image quality="95" width="1024" height="498" src="https://images.prismic.io/voitto-blog/748696e9-2c25-4e66-a232-2be1fb5586ad_tlss.jpg" alt="Example of an Spaghetti Diagram" title="Example of an Spaghetti Diagram" /> 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 make a spaghetti diagram?</h2>What you need to do is: draw a map that contains all the paths taken by people and/or products. But be careful!If you make your diagram anyway, this simple tool can become very confusing and extremely difficult to analyze. That&#39;s why I&#39;m going to help with a very good recipe for making your spaghetti. Let&#39;s go? Step 1: Decide which process or flow of people will be analyzed. It is important, and also necessary, to evaluate how much value the change in this layout will add to the business.Step 2: After deciding on the layout to be optimized, it is necessary to design the plan for it, maintaining all the current characteristics of the system. This schematic is done, as said before, in an A3 format.Step 3: Draw, continuously, the entire path traveled by the employee and/or material to represent the entire flow of the process, defining well the distances traveled and the time spent on each one. If necessary, use more than one color to represent them.Step 4: Make, together with your work team, a careful analysis of the paths designed seeking to identify unnecessary and improvable movements. Don&#39;t forget to take into account the time and distance harvested in the previous step.Step 5: Look for an organization that reduces as much as possible all undesirable paths, preparing proposals that meet industry employees and achieve the expected levels of improvement. Some other factors also help to assemble a Spaghetti Diagram and therefore facilitate decision-making. Among them, it is worth mentioning:<ul><li>Describe well all the stopping points, or bottlenecks, between processes and also the time spent on each one</li><li>Analyze the tasks of the current layout that require resources from other sectors.</li><li>Seek to transform the production system or administrative environment as linear as possible</li><li>Eliminate all steps that do not add value to the product.</li></ul><h2>Software to create the Spaghetti Diagram</h2>Several software’s can help create more complex and complete spaghetti diagrams. Among them are: Microsoft Visio: a complete and easy-to-use tool that has several templates from the most diverse areas, such as offices and factories. AutoCAD: a technical tool that is more complex than the previous one, it presents excellent results in terms of detail.<h2>Process example optimized by Spaghetti Diagram</h2>The image below shows a process before (left) and after (on the right) application of the spaghetti diagram: <Image quality="95" width="1024" height="498" src="https://images.prismic.io/voitto-blog/748696e9-2c25-4e66-a232-2be1fb5586ad_tlss.jpg" alt="Process optimized by Spaghetti Diagram" title="Process optimized by Spaghetti Diagram" />In this application, it is possible to observe the great reduction in movement that was made possible through the analysis of the Diagram.<h2>I bet you&#39;re now going to prepare such a spaghetti!</h2>After a good look at the image above, it is very clear the importance of this tool for systems that use Lean Manufacturing.Spaghetti Diagram helps the work team see how they can rearrange craft sites, seeking to improve process efficiency, reducing and even eliminating all waste.If you want to learn more about other Lean Manufacturing tools, here at Voitto we have what you need!Adopt Lean Manufacturing to reduce waste!Porter&#39;s Five Forces model has as main purpose to relate the company to its organizational environment, analyzing its internal and external environment, through five criteria: Suppliers, New Entrants, Buyers (Customers), Substitute Products / Services and Competitors.Do not waste time and download your excel spreadsheet right now.<a target="_blank" rel="nofollow" href="https://conteudo.pocketbook4you.com/spreadsheet-poter-s-5-forces"> <Image quality="95" src="https://images.prismic.io/voitto-blog/f1eac67c-fb69-46f3-a79d-229b9a7a8046_Bot%C3%A3o+Banner+Cursos+-+TLSS+%2810%29.png" width="1025" height="205" alt="Porter's five forces" title="Porter's five forces"/></a>

Spaghetti Diagram acts as a great ally in layout optimization projects

Understand what Spaghetti Diagram is and its relationship with improvement processes. Learn how to do it and be able to analyze and optimize the layout of your business.