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 […]
Conditions are everywhere, in our work, day to day life, in our conversation, everywhere. And when it comes to VBA coding, conditions are one of the most important things.If you want to be advanced VBA user then an IF statement is must learn. And, I believe that you are already familiar with word IF and […]
Excel is extensively used by both business organizations and individuals for maintaining records or tasks. The most petrifying situation is when the file is corrupt, and the data becomes inaccessible. In this blog, we will be discussing the causes of corruption and five ways to repair a corrupt Excel File. Even a minor error can […]
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.
You know that pivot table is one of the most important tools to analyze and summarize data.You can create instant reports using pivot tables.And to make it more appealing to your users, you can apply conditional formatting to a pivot table.Just look at below where I have applied conditional formatting in a pivot table to […]