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

# 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 need either Data Analysis ToolPak or Pivot Table to create a histogram. Have a look.

# 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 4: Histogram (any version of Excel)

Histogram is used to visualize the frequency with which data occurs. This is a good way of understanding data more than just sum and average. It is a good idea to look at each data set you get as a histogram. Here is how you do it in Excel.

# Happy Dussehra (and PowerPoint tutorial)

Today is an Indian festival called Dussehra which marks the beginning of harvesting season. It is customary to exchange leaves of the Piliostigma racemosum tree as a symbol of gold – wishing each other a prosperous new year.

Well, I cannot exchange leaves with all of you – but let me use this blog to wish all of you a great year ahead.

I created this graphic using the “gold” leaf image. Download this PPT file to understand how it was created using PowerPoint. Refer to the slide notes for details.

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

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

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

# How to succeed in office politics using Office

Here is the recording of my session in Pune DevCon – a gathering of developers in Pune, India. Please pardon me for using Hindi language intermittently. I needed to use local language for maximum impact.

Thanks to Mahesh Mitkari, Mayur Tendulkar, Vikram Pendse and team for arranging a great event. Enjoy!

This is a live recording. Please pardon the background noise and poor video quality.