Search

# Category: best practices

###### 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

###### Quality Management 5: Histogram and Pareto

Read Histogram and Pareto articles first. Excel Data Analysis tool can create a Pareto chart while creating a histogram. Small tweak but very useful.

###### 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

###### OneNote: Instant visual notes while watching Videos

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.

###### 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

###### Quality Management 4: Histogram using Pivot Table

This is continuation of the previous article. In this article, we will see another way of creating Histogram using Pivot Table.

###### 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

###### 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 /

###### 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.

## Pivot Table Pro Course

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.

## Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

##### Subscribe to Blog

Join 1,811 other subscribers