By using a pivot table, you can summarize your data in an understandable manner. And, that summary can help you to analyze data on category wise, product wise, month wise, etc.One of the common practices for analyzing data is by ranking them. Ranking categories and products can help you to compare them with each other.The […]
If you use pivot tables in your work frequently, I am sure you face the problem to update its source data range manually.Every time when you add new data in the source sheet you need to update the source range for the pivot table before you refresh your pivot table.Now, just imagine if you add […]
With a pivot table, you summarize your data within a few seconds. You can create reports, analyze data, and easily share with others.That’s the beauty of pivot tables.But here is a twist:Normally when you create a pivot table you can select source data from a single table in a worksheet as Excel doesn’t allow you […]
Pivot tables are close to my heart. I love to use them. But apart from this, there is one thing which I love to use.That’s ==> Pivot ChartYes, a pivot chart.And, do you know a pivot chart is the easiest way to create a dynamic chart.Today, in this post, I’d like to share with you […]
In this tutorial, I will show you how to add a running total in a pivot table. You will also learn about different situations in which you can use it.