Microsoft added a bunch of useful capabilities to Excel this month, including one that was highly requested by customers.

Pareto analysis states that 80% of a project’s results are due to 20% of the inputs, and 80% of problems can be traced to 20% of the causes.

A dot plot or dot chart consists of data points plotted on a graph. The Federal Reserve uses dot plots to show its predicted interest rate outlook.

The chart is intuitive yet powerful, customize the chart type to view candlestick patterns, area, line graph style, bar chart or Heiken Ashi.