Flowcharts are useful for documenting and visualizing processes. Here we will cover nuances of using PowerPoint for drawing flowcharts. We will also cover ways in which new shapes can be created. If you want professional flowcharts you must use Visio or similar dedicated tools.
Category Archives: Quality
Quality Management 6: Scatter Chart
When you have two columns of numeric data, Scatter chart helps you understand how they affect each other (jargon: correlation). Creating a scatter plot is easy. But interpretation can be misleading or even absurd. Let us explore how to create effective Scatter plots.
Quality Management 5: Histogram and Pareto
Quality Management 5: Pareto Chart
Pareto chart is used to analyze important factors and prioritize action items. It is a combination of bar and line chart. Bar chart shows the data in descending order of importance and line chart shows cumulative percentage. It is popularly known as the 80:20 rule. We will see three ways of creating this chart using Excel.
Quality Management 4: Histogram in Excel 2016
Well, the histogram articles don’t seem to be ending. I promise, this is the last one. With Excel 2016, a new chart type called Histogram was introduced. Now we don’t need either Data Analysis ToolPak or Pivot Table to create a histogram. Have a look.
Continue reading Quality Management 4: Histogram in Excel 2016
Quality Management 3: Create Run Charts in Excel
Run charts are simple line charts drawn against time. The idea is to visualize the pattern and trend of captured data. The data could be about defects, issues, observations or variability. Let us see how to manage this using Excel.
Photo credit: tudedude / Foter / CC BY-NC-SA
Continue reading Quality Management 3: Create Run Charts in Excel
Quality Management 2. Check Sheet
This is a simple check sheet. Usually done on paper. But with ubiquitous tablets being available, it can be done on Excel as well.
Photo credit: The U.S. Army / Foter / CC BY
Quality Management 1. Fishbone (Cause and Effect) Diagram
With this article, I am starting a mini-series about Quality management tools. Fishbone diagram is drawn easily using paper and pencil. Here is how you do it using Microsoft Visio.
Photo credit: ro_buk [I’m not there] / Foter / CC BY-NC
Continue reading Quality Management 1. Fishbone (Cause and Effect) Diagram
Excel Tables 11 – Auto Update Dependent Formulas and References
MOST IMPORTANT BENEFIT of Excel Tables. Spend 10 minutes. Read it.
Continue reading Excel Tables 11 – Auto Update Dependent Formulas and References
Excel Tables 6 – Miraculous Formula Auto-Copy
Most probably, you have been missing this Auto-copy feature for the last 8 years. Take 3 minutes to find out how it can simplify your life and increase accuracy.
Continue reading Excel Tables 6 – Miraculous Formula Auto-Copy