PivotTable is a powerful feature offered by Microsoft Excel. It helps extracting important details from detailed and large data sets. While creating a new PivotTable or refreshing data in the existing PivotTable, you may...
Here is another installment of Do It In Excel series. I call this data visualization Brazil vs Germany Chart. Let’s see how can you build this nice chart in Excel.
Here is a quick tip about how to change shapes on charts. If you ever wondered how can you build a chart like those fancy colorful charts that has columns with pointy edges, here...
Often times you need list unique values in a column to summarize, check or compile results. I will show you three ways to do it fast and easy.
Treemap is an easy and beautiful way of visualizing layered data. It represents your data set in a way that is visually pleasing and easy to understand. This post will show you how to...
Microsoft finally included sunburst chart into Excel and made it easy to make a sunburst chart with Excel 2016. How to create a sunburst chart with Excel versions prior to 2016 is explained in...
