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
Read Histogram and Pareto articles first. Excel Data Analysis tool can create a Pareto chart while creating a histogram. Small tweak but very useful.
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
Capture important moments while conference videos, eLearning, etc. using a powerful OneNote shortcut. These could be specific slides / demos / whiteboard content. Find out how to do it.
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
This is continuation of the previous article. In this article, we will see another way of creating Histogram using Pivot Table.
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
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 /
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.
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
