Do you remember when last time you used an Excel Pivot Chart? And, do you know pivot chart is a easiest way to create dynamic charts in excel? The bad news is, most […]
You know that Pivot Table is one the most important tools to analyze data. And, Conditional Formatting is useful to deliver a strong message to the user along with data. Ahead of this post, you will learn about how you can combine these two awesome tools. You will learn to apply conditional formatting in pivot table.
Today in this post, I will show you how to group dates in a pivot table in excel. Before using this technique I used to create columns for year, quarter and months in my source data. But, this technique of grouping dates in pivot table will allow you to combine dates in the form of months, quarters, year.
In our normal practice, we use a manual method for changing pivot table data source. Whenever we add data in our pivot table data source we have to increase pivot table data range to update the values in our pivot table. But from now you don’t have to do this. Here I have listed some very easy methods to automatically update pivot table range.